private static int DoRegisterWellWisherInDb(WellWisherInfo wellWisherDetails) { 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 well_wisher(well_wisher_id,well_wisher_name,well_wisher_address,well_wisher_doj,well_wisher_contact,well_wisher_remarks) " + "VALUES(@well_wisher_id,@well_wisher_name,@well_wisher_address,@well_wisher_doj,@well_wisher_contact,@well_wisher_remarks)"; msqlCommand.Parameters.AddWithValue("@well_wisher_id", wellWisherDetails.id); msqlCommand.Parameters.AddWithValue("@well_wisher_name", wellWisherDetails.name); msqlCommand.Parameters.AddWithValue("@well_wisher_address", wellWisherDetails.address); msqlCommand.Parameters.AddWithValue("@well_wisher_doj", wellWisherDetails.doj); msqlCommand.Parameters.AddWithValue("@well_wisher_contact", wellWisherDetails.phone); msqlCommand.Parameters.AddWithValue("@well_wisher_remarks", wellWisherDetails.remarks); msqlCommand.ExecuteNonQuery(); returnVal = 1; } catch (Exception ex) { returnVal = 0; } finally { //always close the connection msqlConnection.Close(); } return returnVal; }
public static void EditWellWisher(WellWisherInfo wellWisherToEdit) { 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 well_wisher SET well_wisher_name=@well_wisher_name,well_wisher_address=@well_wisher_address,well_wisher_doj=@well_wisher_doj,well_wisher_contact=@well_wisher_contact,well_wisher_remarks=@well_wisher_remarks WHERE well_wisher_id=@well_wisher_id"; msqlCommand.Parameters.AddWithValue("@well_wisher_name", wellWisherToEdit.name); msqlCommand.Parameters.AddWithValue("@well_wisher_address", wellWisherToEdit.address); msqlCommand.Parameters.AddWithValue("@well_wisher_doj", wellWisherToEdit.doj); msqlCommand.Parameters.AddWithValue("@well_wisher_contact", wellWisherToEdit.phone); msqlCommand.Parameters.AddWithValue("@well_wisher_remarks", wellWisherToEdit.remarks); msqlCommand.Parameters.AddWithValue("@well_wisher_id", wellWisherToEdit.id); msqlCommand.ExecuteNonQuery(); } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } }
public static int DoRegisterWellWisher(WellWisherInfo wellWisherDetails) { return DoRegisterWellWisherInDb(wellWisherDetails); }
private static List<WellWisherInfo> QueryAllWellWisherList() { List<WellWisherInfo> WellWisherList = new List<WellWisherInfo>(); 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 well_wisher;"; MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { WellWisherInfo WellWisher = new WellWisherInfo(); WellWisher.id = msqlReader.GetString("well_wisher_id"); WellWisher.name = msqlReader.GetString("well_wisher_name"); WellWisher.address = msqlReader.GetString("well_wisher_address"); WellWisher.doj = msqlReader.GetDateTime("well_wisher_doj"); WellWisher.phone = msqlReader.GetString("well_wisher_contact"); WellWisher.remarks = msqlReader.GetString("well_wisher_remarks"); WellWisherList.Add(WellWisher); } } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return WellWisherList; }
public static List<WellWisherInfo> SearchAllWellWisherList(WellWisherInfo wellWisherInfoObj) { List<WellWisherInfo> WellWisherList = new List<WellWisherInfo>(); 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 well_wisher where well_wisher_name = @input or well_wisher_address = @input or well_wisher_doj = @input or well_wisher_contact = @input or well_wisher_remarks = @input;"; msqlCommand.Parameters.AddWithValue("@input", wellWisherInfoObj.name); MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { WellWisherInfo WellWisher = new WellWisherInfo(); WellWisher.id = msqlReader.GetString("well_wisher_id"); WellWisher.name = msqlReader.GetString("well_wisher_name"); WellWisher.address = msqlReader.GetString("well_wisher_address"); WellWisher.doj = msqlReader.GetDateTime("well_wisher_doj"); WellWisher.phone = msqlReader.GetString("well_wisher_contact"); WellWisher.remarks = msqlReader.GetString("well_wisher_remarks"); WellWisherList.Add(WellWisher); } } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return WellWisherList; }
private void searchBtn_Click(object sender, RoutedEventArgs e) { WellWisherInfo wellWisherInfoObj = new WellWisherInfo(); wellWisherInfoObj.name = searchTxtBlck.Text; List<WellWisherInfo> wellWishers = BDMSDb.DbInteraction.SearchAllWellWisherList(wellWisherInfoObj); _WellWisherCollection.Clear(); foreach (WellWisherInfo wellWisr in wellWishers) { _WellWisherCollection.Add(wellWisr); } }