private void addSecurityGuardBtn_Click(object sender, RoutedEventArgs e)
{
SecurityManagementSystemEngine.SecurityInformation newSecurity = new SecurityManagementSystemEngine.SecurityInformation();
newSecurity.id = GenerateId();
newSecurity.name = securityNameTxtbox.Text;
newSecurity.addres = AddressNameTxtbox.Text;
newSecurity.contact = contactTxtbox.Text;
newSecurity.email = emailTxtbox.Text;
newSecurity.homeNumber = homeNumberTxtbox.Text;
newSecurity.joiningdate = joiningdateP.SelectedDate.Value;
newSecurity.remark = remarkTxtbox.Text;
SecurityManagementSystemStorage.SecurityManagementSystemStorageInteraction.DoEnterSecurity(newSecurity);
securityTC.SelectedIndex = 0;
clearSecurityFields();
}
private static List<SecurityInformation> QueryAllSecurityList()
{
List<SecurityInformation> SecurityList = new List<SecurityInformation>();
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "Select * From security ;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
SecurityInformation Security = new SecurityInformation();
Security.id = msqlReader.GetString("id");
Security.name = msqlReader.GetString("name");
Security.addres = msqlReader.GetString("address");
Security.contact = msqlReader.GetString("contact");
Security.joiningdate = msqlReader.GetDateTime("joiningdate");
Security.email = msqlReader.GetString("email");
Security.homeNumber = msqlReader.GetString("homenumber");
Security.remark = msqlReader.GetString("remark");
SecurityList.Add(Security);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return SecurityList;
}
public static void EditSecurity(SecurityInformation newUpdateSecurity)
{
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "UPDATE security SET name=@name,address=@address,contact=@contact,joiningdate=@joiningdate,email=@email,homenumber=@homenumber,remark=@remark WHERE id=@id";
msqlCommand.Parameters.AddWithValue("@name", newUpdateSecurity.name);
msqlCommand.Parameters.AddWithValue("@address", newUpdateSecurity.addres);
msqlCommand.Parameters.AddWithValue("@contact", newUpdateSecurity.contact);
msqlCommand.Parameters.AddWithValue("@joiningdate", newUpdateSecurity.joiningdate);
msqlCommand.Parameters.AddWithValue("@email", newUpdateSecurity.email);
msqlCommand.Parameters.AddWithValue("@homenumber", newUpdateSecurity.homeNumber);
msqlCommand.Parameters.AddWithValue("@remark", newUpdateSecurity.remark);
msqlCommand.Parameters.AddWithValue("@id", newUpdateSecurity.id);
msqlCommand.ExecuteNonQuery();
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
}
private static int DoRegisterNewSecurityindb(SecurityInformation Newsecurity)
{
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 security(id,name,address,contact,joiningdate,email,homenumber,remark) "
+ "VALUES(@id,@name,@address,@contact,@joiningdate,@email,@homenumber,@remark)";
msqlCommand.Parameters.AddWithValue("@id", Newsecurity.id);
msqlCommand.Parameters.AddWithValue("@name", Newsecurity.name);
msqlCommand.Parameters.AddWithValue("@address", Newsecurity.addres);
msqlCommand.Parameters.AddWithValue("@contact", Newsecurity.contact);
msqlCommand.Parameters.AddWithValue("@joiningdate", Newsecurity.joiningdate);
msqlCommand.Parameters.AddWithValue("@email", Newsecurity.email);
msqlCommand.Parameters.AddWithValue("@homenumber", Newsecurity.homeNumber);
msqlCommand.Parameters.AddWithValue("@remark", Newsecurity.remark);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}
public static int DoEnterSecurity(SecurityInformation NewSecurity)
{
return DoRegisterNewSecurityindb(NewSecurity);
}