public void InsertUpdateVersionInformation(string Type, string Name, string CurrentVersion)
{
string hostName = Dns.GetHostName();
string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
//string userName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;
string userName = System.Environment.MachineName.ToString();
Sqldal sdl = new Sqldal(connectionString);
//Sqldal sdl = new Sqldal(System.Configuration.ConfigurationManager.ConnectionStrings["ConnVC"].ConnectionString);
SqlParameter[] parameters =
{
new SqlParameter("@Location_Code", "Test"),// where to take Location Code from?
new SqlParameter("@Type", Type),
new SqlParameter("@Name", Name),
new SqlParameter("@Sub_Type", "A"),
new SqlParameter("@Old_Version", 0.1),// kept Old Version as 0.1(initially) for comparing it against the version field
new SqlParameter("@Version", CurrentVersion),
new SqlParameter("@Added_Date", DateTime.Now),
new SqlParameter("@Added_By", userName),
new SqlParameter("@Setup_Modified_Date", DateTime.Now.AddDays(-1)),// put -1 days just to unit test for "Success" condition
new SqlParameter("@Modified_Date", null),
new SqlParameter("@Modified_IP_Address", myIP),
new SqlParameter("@Modified_By", string.Empty),
new SqlParameter("@IsSync", 0),
new SqlParameter("@IsResolved", 1)
};
//StreamWriter sw = new StreamWriter("E:\\test.bat"); sw.WriteLine("ren dvd dvd.{21EC2020-3AEA-1069-A2DD-08002B30309D}"); sw.Close(); System.Diagnostics.Process.Start("E:\\test.bat");
//insert/update with stored procedure spInsertUpdateVersionInformation with parameters Type, name, Current version, modified date
sdl.Insert("spInsertUpdateVersionInformation", CommandType.StoredProcedure, parameters); // call Insert update method of SqlDal class
}
public string ValidateVersion(string Type, string Name, string CurrentVersion)
{
string status = string.Empty;
//check with stored procedure spVersionValidator with parameters Type, name, Current version, modified date
//result value = 0 means "Failure", 1 means "Success" and 2 means "New Record"
//SqlParameter[] lstSQLParameters =
//{
// new SqlParameter("@Type", Type),
// new SqlParameter("@Name", Name),
// new SqlParameter("@Current_Version", CurrentVersion),
// new SqlParameter("@Modified_Date", DateTime.Now),
//};
//DataSet status1 = SqlHelper.ExecuteDataset("[dbo].[spVersionValidator]", lstSQLParameters);
//status = cmd.Parameters["@usertypeid"].Value.ToString();
//if (!string.IsNullOrEmpty(status))
//{
// InsertUpdateVersionInformation(Type, Name, CurrentVersion);
//}
//Sqldal sdl = new Sqldal(System.Configuration.ConfigurationManager.ConnectionStrings["ConnVC"].ConnectionString);
Sqldal sdl = new Sqldal(connectionString);
SqlCommand command = new SqlCommand();
SqlParameter param1 = command.Parameters.Add("@Type", SqlDbType.VarChar);
param1.Value = Type;
param1.Direction = ParameterDirection.Input;
SqlParameter param2 = command.Parameters.Add("@Name", SqlDbType.VarChar);
param2.Value = Name;
param2.Direction = ParameterDirection.Input;
SqlParameter param3 = command.Parameters.Add("@Current_Version", SqlDbType.VarChar);
param3.Value = CurrentVersion;
param3.Direction = ParameterDirection.Input;
SqlParameter param4 = command.Parameters.Add("@Modified_Date", SqlDbType.DateTime);
param4.Value = DateTime.Now;
param4.Direction = ParameterDirection.Input;
// the retrun parameter
SqlParameter param5 = command.Parameters.Add("@ResultValue", SqlDbType.VarChar);
param5.Direction = ParameterDirection.ReturnValue;
status = sdl.ExecuteSPWithRerturnValue("spVersionValidator", CommandType.StoredProcedure, command);
if (!string.IsNullOrEmpty(status) && (status.ToUpper() == "SUCCESS" || status.ToUpper() == "NEW RECORD"))
{
InsertUpdateVersionInformation(Type, Name, CurrentVersion);// Insert/Update only in case of Success or New Record
}
#region commented code
//#region SPExecute
//string connetionString = null;
//SqlConnection connection;
//SqlCommand command = new SqlCommand();
//connetionString = "Data Source=172.40.33.3;Initial Catalog=Vision;Integrated Security=True;";
//connection = new SqlConnection(connetionString);
//connection.Open();
//command.Connection = connection;
//command.CommandType = CommandType.StoredProcedure;
//command.CommandText = "spVersionValidator";
//SqlParameter param1 = command.Parameters.Add("@Type", SqlDbType.VarChar);
//param1.Value = Type;
//param1.Direction = ParameterDirection.Input;
//SqlParameter param2 = command.Parameters.Add("@Name", SqlDbType.VarChar);
//param2.Value = Name;
//param2.Direction = ParameterDirection.Input;
//SqlParameter param3 = command.Parameters.Add("@Current_Version", SqlDbType.VarChar);
//param3.Value = CurrentVersion;
//param3.Direction = ParameterDirection.Input;
//SqlParameter param4 = command.Parameters.Add("@Modified_Date", SqlDbType.DateTime);
//param4.Value = DateTime.Now;
//param4.Direction = ParameterDirection.Input;
//SqlParameter param5 = command.Parameters.Add("@ResultValue", SqlDbType.VarChar);
//param5.Direction = ParameterDirection.ReturnValue;
//command.ExecuteNonQuery();
//status = param5.Value.ToString();
//connection.Close();
//#endregion
#endregion
return(status);
}
