public bool AddMStockItemsReceipe(MStockItemsReceipe mstockitemsreceipe) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMStockItemsReceipe"; cmd.Parameters.AddWithValue("@PkSrNo", mstockitemsreceipe.PkSrNo); // cmd.Parameters.AddWithValue("@IngredientNo", mstockitemsreceipe.IngredientNo); cmd.Parameters.AddWithValue("@ReceipeDesc", mstockitemsreceipe.ReceipeDesc); cmd.Parameters.AddWithValue("@LangReceipeDesc", mstockitemsreceipe.LangReceipeDesc); cmd.Parameters.AddWithValue("@SequenceNo", mstockitemsreceipe.SequenceNo); cmd.Parameters.AddWithValue("@UserID", mstockitemsreceipe.UserID); cmd.Parameters.AddWithValue("@UserDate", mstockitemsreceipe.UserDate); cmd.Parameters.AddWithValue("@CompanyNo", mstockitemsreceipe.CompanyNo); commandcollection.Add(cmd); return(true); }
public bool DeleteMStockItemsReceipe(MStockItemsReceipe mstockitemsreceipe) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteMStockItemsReceipe"; cmd.Parameters.AddWithValue("@PkSrNo", mstockitemsreceipe.PkSrNo); commandcollection.Add(cmd); return(true); }