private static void InsertEmployee(
ref int ID,
string Name,
string Title,
string Address,
decimal Salary,
DateTime JoinedDate,
byte?Children)
{
try
{
string str = "CREATE PROCEDURE [dbo].[sp_InsertEmp](";
str += "@ID int OUTPUT," + "@Name nvarchar(30),";
str += "@Title varchar(20)," + "@Address varchar(30),";
str += "@Salary money," + "@JoinedDate datetime,";
str += "@Children tinyint)";
// Parse the stored procedure signature
SPSignature signature = new SPSignature(str);
SPCaller caller = new SPCaller(signature);
caller.ConnectionStr = ConnectionStr;
Output outputID = new Output(ID);
caller.CallVoidProc("[dbo].[sp_InsertEmp]",
outputID, Name, Title, Address, Salary, JoinedDate, Children);
ID = outputID.GetInt();
}
catch (System.Exception ex)
{
Debug.Print(ex.Message);
}
}
public static void InsertEmployee(
ref int ID,
string Name,
string Title,
string Address,
decimal Salary,
DateTime JoinedDate,
byte?Children)
{
try
{
string str = "CREATE PROCEDURE [dbo].[sp_InsertEmp](";
str += "@ID int OUTPUT," + "@Name nvarchar(30),";
str += "@Title varchar(20)," + "@Address varchar(30),";
str += "@Salary money," + "@JoinedDate datetime,";
str += "@Children tinyint)";
// Parse the stored procedure signature
SPSignature signature = new SPSignature(str);
string location = System.Reflection.Assembly.GetExecutingAssembly().Location;
string dir = System.IO.Path.GetDirectoryName(location);
string xmlPath = System.IO.Path.Combine(dir, "signature.xml");
signature.Save(xmlPath);
SPSignature signature2 = new SPSignature();
signature2.Load(xmlPath);
SPCaller caller = new SPCaller(signature2);
caller.ConnectionStr = ConnectionStr;
Output outputID = new Output(ID);
caller.CallVoidProc("[dbo].[sp_InsertEmp]",
outputID, Name, Title, Address, Salary, JoinedDate, Children);
ID = outputID.GetInt();
}
catch (System.Exception ex)
{
Debug.Print(ex.Message);
}
}
