private void addResidenceBtn_Click(object sender, RoutedEventArgs e)
{
SecurityManagementSystemEngine.ResidenceInformation newResidence = new SecurityManagementSystemEngine.ResidenceInformation();
newResidence.id = GenerateId();
newResidence.name = headsNameTxtbox.Text;
newResidence.houseNo = houseNoNameTxtbox.Text;
newResidence.roomNo = roomNoTxtbox.Text;
newResidence.contact = contactTxtbox.Text;
newResidence.email = emailTxtbox.Text;
newResidence.fmlyMbrs = fmlyMbrsTxtbox.Text;
newResidence.visitingHour = visitingHourTxtbox.Text;
newResidence.remark = remarkTxtbox.Text;
SecurityManagementSystemStorage.SecurityManagementSystemStorageInteraction.DoEnterResidence(newResidence);
residenceMainTC.SelectedIndex = 0;
clearResidenceFields();
}
private static List<ResidenceInformation> QueryAllResidenceList()
{
List<ResidenceInformation> ResidenceList = new List<ResidenceInformation>();
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 residence ;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
ResidenceInformation Residence = new ResidenceInformation();
Residence.id = msqlReader.GetString("id");
Residence.name = msqlReader.GetString("fmlyhadsname");
Residence.houseNo = msqlReader.GetString("houseno");
Residence.roomNo = msqlReader.GetString("roomno");
Residence.contact = msqlReader.GetString("contact");
Residence.email = msqlReader.GetString("emailaddrs");
Residence.fmlyMbrs = msqlReader.GetString("fmlymebrs");
Residence.visitingHour = msqlReader.GetString("visitinghrs");
Residence.remark = msqlReader.GetString("remark");
ResidenceList.Add(Residence);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return ResidenceList;
}
public static void EditResidence(ResidenceInformation newUpdateResidence)
{
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 residence SET fmlyhadsname=@fmlyhadsname,houseno=@houseno,roomno=@roomno,contact=@contact,emailaddrs=@emailaddrs,fmlymebrs=@fmlymebrs,visitinghrs=@visitinghrs,remark=@remark WHERE id=@id";
msqlCommand.Parameters.AddWithValue("@fmlyhadsname", newUpdateResidence.name);
msqlCommand.Parameters.AddWithValue("@houseno", newUpdateResidence.houseNo);
msqlCommand.Parameters.AddWithValue("@roomno", newUpdateResidence.roomNo);
msqlCommand.Parameters.AddWithValue("@contact", newUpdateResidence.contact);
msqlCommand.Parameters.AddWithValue("@emailaddrs", newUpdateResidence.email);
msqlCommand.Parameters.AddWithValue("@fmlymebrs", newUpdateResidence.fmlyMbrs);
msqlCommand.Parameters.AddWithValue("@visitinghrs", newUpdateResidence.visitingHour);
msqlCommand.Parameters.AddWithValue("@remark", newUpdateResidence.remark);
msqlCommand.Parameters.AddWithValue("@id", newUpdateResidence.id);
msqlCommand.ExecuteNonQuery();
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
}
private static int DoRegisterNewResidenceindb(ResidenceInformation NewResidence)
{
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 residence(id,fmlyhadsname,houseno,roomno,contact,emailaddrs,fmlymebrs,visitinghrs,remark) "
+ "VALUES(@id,@fmlyhadsname,@houseno,@roomno,@contact,@emailaddrs,@fmlymebrs,@visitinghrs,@remark)";
msqlCommand.Parameters.AddWithValue("@id", NewResidence.id);
msqlCommand.Parameters.AddWithValue("@fmlyhadsname", NewResidence.name);
msqlCommand.Parameters.AddWithValue("@houseno", NewResidence.houseNo);
msqlCommand.Parameters.AddWithValue("@roomno", NewResidence.roomNo);
msqlCommand.Parameters.AddWithValue("@contact", NewResidence.contact);
msqlCommand.Parameters.AddWithValue("@emailaddrs", NewResidence.email);
msqlCommand.Parameters.AddWithValue("@fmlymebrs", NewResidence.fmlyMbrs);
msqlCommand.Parameters.AddWithValue("@visitinghrs", NewResidence.visitingHour);
msqlCommand.Parameters.AddWithValue("@remark", NewResidence.remark);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}
public static int DoEnterResidence(ResidenceInformation Newresidence)
{
return DoRegisterNewResidenceindb(Newresidence);
}
