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); }