private static int DoRegisterNewTechnicianindb(TechnicianInfo NewTechnician)
{
int returnVal = 0;
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "INSERT INTO technician(id,name,contact,email,homenumber,address,joiningdate,salary,remark) "
+ "VALUES(@id,@name,@contact,@email,@homenumber,@address,@joiningdate,@salary,@remark)";
msqlCommand.Parameters.AddWithValue("@id", NewTechnician.id);
msqlCommand.Parameters.AddWithValue("@name", NewTechnician.name);
msqlCommand.Parameters.AddWithValue("@contact", NewTechnician.contact);
msqlCommand.Parameters.AddWithValue("@email", NewTechnician.email);
msqlCommand.Parameters.AddWithValue("@homenumber", NewTechnician.homenumber);
msqlCommand.Parameters.AddWithValue("@address", NewTechnician.address);
msqlCommand.Parameters.AddWithValue("@joiningdate", NewTechnician.joiningdate);
msqlCommand.Parameters.AddWithValue("@salary", NewTechnician.salary);
msqlCommand.Parameters.AddWithValue("@remark", NewTechnician.remark);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}
public static int DoRegisterNewTechnician(TechnicianInfo NewTechnician)
{
return DoRegisterNewTechnicianindb(NewTechnician);
}