private void add_b_Click(object sender, RoutedEventArgs e)
{
String mesg;
Suppliers_tbl SupplierInfo = new Suppliers_tbl();
SupplierInfo.Supplier_Id = Convert.ToInt32(suplIDtxt.Text);
SupplierInfo.Supplier_Name = suplNametxt.Text;
SupplierInfo.Phone_No = Convert.ToInt32(suplTeletxt.Text);
mesg = ServiceClientObject.InsertSupplierDetails(SupplierInfo);
MessageBox.Show(mesg);
}
public string DeleteSupplierDetails(int Supplier_ID)
{
String message;
Suppliers_tbl Delete_supplier = Namal_S.Suppliers_tbls.FirstOrDefault(a => a.Supplier_Id.Equals(Supplier_ID));
try
{
Namal_S.Suppliers_tbls.DeleteOnSubmit(Delete_supplier);
Namal_S.SubmitChanges();
message = "Details Deleted successfully";
}
catch
{
message = "Details not Deleted successfully";
}
return(message);
}
public string UpdateSupplierDetails(Suppliers_tbl SupplierInfo)
{
String message;
//****
Suppliers_tbl modify_supplier = Namal_S.Suppliers_tbls.FirstOrDefault(a => a.Supplier_Id.Equals(SupplierInfo.Supplier_Id));
modify_supplier.Supplier_Name = SupplierInfo.Supplier_Name;
modify_supplier.Phone_No = SupplierInfo.Phone_No;
try
{
Namal_S.SubmitChanges();
message = "Details Modified successfully";
}
catch
{
message = "Details not Modified successfully";
}
return(message);
}
public String InsertSupplierDetails(Suppliers_tbl SupplierInfo)
{
String message;
Suppliers_tbl sD = new Suppliers_tbl();
sD.Supplier_Id = SupplierInfo.Supplier_Id;
sD.Supplier_Name = SupplierInfo.Supplier_Name;
sD.Phone_No = SupplierInfo.Phone_No;
try
{
Namal_S.Suppliers_tbls.InsertOnSubmit(sD);
Namal_S.SubmitChanges();
message = "Details inserted successfully";
}
catch (Exception ex)
{
message = "Details not inserted successfully";
}
return(message);
}
private void updt_b_Click(object sender, RoutedEventArgs e)
{
String mesg, mesg2;
mesg2 = ServiceClientObject.SupplierDetails(Convert.ToInt32(suplIDtxt.Text));
MessageBoxResult re = MessageBox.Show(mesg2, "You are going to Update Supplier", MessageBoxButton.OKCancel, MessageBoxImage.Information);
if (re.Equals(MessageBoxResult.OK))
{
Suppliers_tbl SupplierInfo = new Suppliers_tbl();
SupplierInfo.Supplier_Id = Convert.ToInt32(suplIDtxt.Text);
SupplierInfo.Supplier_Name = suplNametxt.Text;
SupplierInfo.Phone_No = Convert.ToInt32(suplTeletxt.Text);
mesg = ServiceClientObject.UpdateSupplierDetails(SupplierInfo);
MessageBox.Show(mesg);
}
else
{
cleartxt();
}
}
