public string SaveStock(AddExtraStock Model1) { tbl_KitchenStock tb = new tbl_KitchenStock(); var duplicate = _entities.tbl_KitchenStock.Where(o => o.RawMaterialId.Equals(Model1.RawId) && o.Quantity.Equals(Model1.currentstock)).SingleOrDefault(); if (duplicate == null) { try { if (Model1.RawMaterial != null) { tb = _entities.tbl_KitchenStock.Where(x => x.RawMaterialId == Model1.RawId).SingleOrDefault(); tb.Quantity = Model1.currentstock; _entities.SaveChanges(); return("Record Updated Successfully..."); } else { tb.Quantity = Model1.currentstock; _entities.tbl_KitchenStock.Add(tb); _entities.SaveChanges(); return("Record Saved Successfully..."); } } catch { return("something Wrong try Agian !"); } } else { return(Model1.RawId + " Already Exits"); } }
public ActionResult ExtraStock(AddExtraStock Model1) { con = new SqlConnection(webconnection); StringBuilder sb = new StringBuilder(); int rawid = Convert.ToInt32(Model1.RawMaterial); if (Model1.currentstock != null && Model1.currentvalue != null) { sb.Append("update tbl_KitchenStock set Quantity=" + Model1.currentstock + " where RawMaterialId=" + Model1.RawMaterial); if (db.tblOpStckRates.Where(p => p.MaterialId.Equals(rawid)).Count() > 0) { sb.Append(" update tblOpStckRate set Qty= " + Model1.currentstock + ", Rate=" + Model1.currentvalue + " , Date = '" + Model1.stockDate + "' where MaterialId=" + Model1.RawMaterial); } else { sb.Append(" insert into tblOpStckRate values(" + Model1.RawMaterial + ", " + Model1.currentvalue + " ,'" + Model1.stockDate + "'," + Model1.currentstock + " , 0,0)"); } } cmd = new SqlCommand(sb.ToString(), con); cmd.CommandType = CommandType.Text; con.Open(); cmd.ExecuteNonQuery(); con.Close(); return(RedirectToAction("CurrentStockReport", "KitchenStock")); }