public string InsertStockDetails(Stock_tbl StockInfo)
{
String message;
Stock_tbl sl = new Stock_tbl();
sl.Stock_Id = StockInfo.Stock_Id;
sl.Item_Id = StockInfo.Item_Id;
sl.Current_Stock_Level = StockInfo.Current_Stock_Level;
sl.Reorder_Limit = StockInfo.Reorder_Limit;
sl.Current_Stock_Level = StockInfo.Current_Stock_Level;
try
{
Namal_S.Stock_tbls.InsertOnSubmit(sl);
Namal_S.SubmitChanges();
message = "Details inserted Successfully";
}
catch
{
message = "Details not inserted Successfully";
}
return(message);
}
private void b_add_Click(object sender, RoutedEventArgs e) // changed Item_Id in to stock_Id & Item_Name in to Item_Id
{
{
String mesg;
Stock_tbl sld = new Stock_tbl();
sld.Stock_Id = Convert.ToInt32(txtslS_id.Text);
sld.Item_Id = int.Parse(txtsl_Id.Text);
sld.Reorder_Limit = int.Parse(txtsl_d.Text);
sld.Current_Stock_Level = Convert.ToInt32(txtcsl.Text);
sld.Current_Stock_Level = int.Parse(txtcsl.Text);
mesg = ServiceClientObject.InsertStockDetails(sld);
MessageBox.Show(mesg);
}
}
public string DeleteStockDetails(int Stock_id)
{
String message;
Stock_tbl Delete_stock = Namal_S.Stock_tbls.FirstOrDefault(a => a.Item_Id.Equals(Stock_id));
try
{
Namal_S.Stock_tbls.DeleteOnSubmit(Delete_stock);
Namal_S.SubmitChanges();
message = "Details Deleted successfully";
}
catch
{
message = "Details not Deleted successfully";
}
return(message);
}
public string UpdateStockDetails(Stock_tbl StockInfo)
{
String message;
Stock_tbl modify_stock = Namal_S.Stock_tbls.FirstOrDefault(a => a.Stock_Id.Equals(StockInfo.Stock_Id));
modify_stock.Item_Id = StockInfo.Item_Id;
modify_stock.Reorder_Limit = StockInfo.Reorder_Limit;
modify_stock.Current_Stock_Level += StockInfo.Current_Stock_Level;
try
{
Namal_S.SubmitChanges();
message = "Details Modified successfully";
}
catch
{
message = "Details not Modified successfully";
}
return(message);
}
