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