Wednesday 30 September 2015

Auto Response in WhatsApp using C#


Directory Inside View All Files Using Sql Server

 DECLARE @Dir VARCHAR(200)
 create   TABLE #tmpDir
                        (
                          subdirectory VARCHAR(MAX) ,
                          depth INT ,
                          [file] INT
                        )

 SET @Dir = FilePath
                    INSERT  #tmpDir
                            EXEC master.sys.xp_dirtree @Dir, 0, 1 ;

Tuesday 29 September 2015

Insert Table To Stored Procedure Return Multiple Recored


        SELECT  *
        INTO    #MyTable
        FROM    OPENROWSET('SQLNCLI',
                           'Server=ServerName;Database=DataBaseName;Uid=UserName;Pwd=Password;',
                           'StoreProcedureName ') ;

Monday 28 September 2015

Send Video and Image and Text Msg in Whatsapp

 WhatsUserManager manager = new WhatsUserManager();
            user = manager.CreateUser(txtphonenumber.Text, "Bhavdip Tala");
            var thread = new Thread(ThreadState =>
            {
                UpdateTextBox textbox = UpdateDataTextBox;

                WhatSocket.Create(txtphonenumber.Text, textBoxPass.Text, textBoxNick.Text, true);

                WhatSocket.Instance.OnConnectSuccess += () =>
                {
                    if (txtstatus.InvokeRequired)
                    {
                        Invoke(textbox, txtstatus, "connected...");
                    }

                    WhatSocket.Instance.OnLoginSuccess += (phone, data) =>
                    {
                        Invoke(textbox, txtstatus, "Login Success...");

                        //WhatSocket.Instance.SendDeleteAccount();
                        while (WhatSocket.Instance != null)
                        {
                            WhatSocket.Instance.pollMessage();
                            Thread.Sleep(200);
                            continue;
                        }

                    };

                    WhatSocket.Instance.OnGetMessage += (node, from, id, name, message, receipt_sent) =>
                    {
                        if (txtstatus.InvokeRequired)
                        {
                            string[] words = from.Split('@');

                            if (WhatSocket.Instance.ConnectionStatus == ApiBase.CONNECTION_STATUS.LOGGEDIN)
                            {
                                if (message.ToString().ToUpper().Contains("IMG"))
                                {
                                    byte[] img = File.ReadAllBytes(@"D:\P1.Jpg");
                                    WhatSocket.Instance.SendMessageImage(words[0] + "@s.whatsapp.net", img, ApiBase.ImageType.JPEG);
                                }
                                else if (message.ToString().ToUpper().Contains("VID"))
                                {
                                    byte[] img = File.ReadAllBytes(@"D:\EMERALD.mp4");
                                    WhatSocket.Instance.SendMessageVideo(words[0] + "@s.whatsapp.net", img, ApiBase.VideoType.MP4);
                                }
                                else
                                 {
                                    Invoke(textbox, txtstatus, string.Format("\r\n {0}:{1}", name + " : " + words[0], message));
                                }
                            }
                        }
                    };
                    WhatSocket.Instance.OnLoginFailed += (data) =>
                    {
                        if (txtstatus.InvokeRequired)
                        {
                            Invoke(textbox, txtstatus, string.Format("\r\n Login Failed : {0}", data));
                        }
                    };
                    WhatSocket.Instance.Login();
                };
                WhatSocket.Instance.OnConnectFailed += (ex) =>
                {
                    if (txtstatus.InvokeRequired)
                    {
                        Invoke(textbox, txtstatus, string.Format("\r\n Connect Failed : {0}", ex.StackTrace));
                    }
                };
                WhatSocket.Instance.Connect();
            }) { IsBackground = true };
            thread.Start();

Sunday 27 September 2015

Send MSG and Image Whatspp

 if (String.IsNullOrEmpty(txtMessage.Text))
                return;
            if (WhatSocket.Instance != null)
            {
                if (WhatSocket.Instance.ConnectionStatus == ApiBase.CONNECTION_STATUS.LOGGEDIN)
                {
                  
                 
                    if (txtMessage.Text == "Image")
                    {
                        byte[] img = File.ReadAllBytes(fileName);
                        WhatSocket.Instance.SendMessageImage(txtto.Text + "@s.whatsapp.net", img, ApiBase.ImageType.JPEG);
                    }
                    else {
                        WhatSocket.Instance.SendMessage(txtto.Text, txtMessage.Text);
                    }
                    txtstatus.Text += string.Format("\r\n {0}:{1}", user.Nickname, txtMessage.Text);
                    txtMessage.Clear();
                    txtMessage.Focus();
                }
            }

Wednesday 23 September 2015

Send WhatsApp Msg

WhatsApp wa = new WhatsApp("91********", "Your Password", "pankaj", true);

wa.OnConnectSuccess += () =>
{
MessageBox.Show("connect");
 wa.OnLoginSuccess += (phno, data) =>
{ wa.SendMessage("91********", "msg");
};
 wa.OnLoginFailed += (data) =>
 {
MessageBox.Show("login failed" + data);
}
; wa.Login();
};
wa.OnConnectFailed += (ex) =>
{
MessageBox.Show("connection failed");
}; wa.Connect();

SqlDataBaseLibrary

using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using AOS.Repository.Infrastructure; using S...