Wednesday 30 September 2015
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 ;
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();
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();
}
}
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();
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();
Subscribe to:
Posts (Atom)
SqlDataBaseLibrary
using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using AOS.Repository.Infrastructure; using S...
-
string header = Server.MapPath("~/bin/PrintHeader.html");//Path of PrintHeader.html File string footer = Server.MapPath("~/...
-
if (!String.IsNullOrEmpty(this.txtPhoneNumber.Text)) { try { this.number = ...
-
Exec master.dbo.xp_cmdshell 'rename C:\OldFileName.* NewFileName.*' Exec master.dbo.xp_cmdshell 'rename C:\MasterFolderNam...