public JsonResult Get_Produced_Rice_id(int id) { try { Rice_Production_ProductWorth worth = db.Rice_Production_ProductWorths.Find(id); Rice_Produce_Bag bagid = db.Rice_Produce_Bags.Find(worth.Rice_Produce_Bags_id); int Rice_Production_id = bagid.Rice_Production_id; decimal qty = worth.Rice_Production_ProductWorth_Qty; decimal Soldqty = worth.Rice_Production_ProductWorth_SoldQty; decimal PBP = worth.Rice_Production_ProductWorth_PBA; int Rice_Production_ProductWorth_id = id; string bprsc_title = worth.Rice_Production_ProductWorth_name; int worthid = worth.Rice_Production_ProductWorth_id; Tuple <decimal, int, decimal, string, decimal, int, int> tpl = new Tuple <decimal, int, decimal, string, decimal, int, int> ( qty, Rice_Production_ProductWorth_id, Soldqty, bprsc_title, PBP, worthid, Rice_Production_id ); return(Json(tpl, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(null, JsonRequestBehavior.AllowGet)); } }
public ActionResult PreviousRice(FormCollection form, Rice_Production Rice, Rice_Produce_Bag Rice_Produce_Bag) { string idd = Convert.ToString(Session["UserId"]); var RiceName = Convert.ToString(form["RiceName"]); Rice.Rice_Production_name = RiceName; Rice.Rice_Production_Code = Convert.ToString(form["RiceCode"]); Rice.Packing_Id = Convert.ToInt32(form["packing"]); Rice.Rice_Production_Date = DateTime.Now; Rice.Id = idd; Rice.Status = true; db.Rice_Productions.Add(Rice); db.SaveChanges(); var Rice_Production_id = db.Rice_Productions.Max(m => m.Rice_Production_id); Rice_Produce_Bag.Rice_Production_id = Rice_Production_id; Rice_Produce_Bag.Rice_Produce_TotalBagsProduce = Convert.ToInt32(form["BAgs"]); Rice_Produce_Bag.Rice_Produce_Bag_PerBagMarketPrice = Convert.ToDecimal(form["Price"]); Rice_Produce_Bag.Status = true; Rice_Produce_Bag.Rice_Produce_Bag_Date = DateTime.Now; db.Rice_Produce_Bags.Add(Rice_Produce_Bag); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult RiceStockEdit(FormCollection form, Rice_Production Ricee, Rice_Produce_Bag Rice_Produce_Bag) { string idd = Convert.ToString(Session["UserId"]); int Rice_Production_id = Convert.ToInt32(form["Rice_Production_id"]); var RiceName = Convert.ToString(form["RiceName"]); Rice_Production rice = db.Rice_Productions.Find(Rice_Production_id); rice.Rice_Production_name = RiceName; rice.Rice_Production_Code = Convert.ToString(form["RiceCode"]); rice.Packing_Id = Convert.ToInt32(form["packing"]); rice.Rice_Production_Date = DateTime.Now; rice.Id = idd; rice.Status = true; db.Entry(rice).State = EntityState.Modified; db.SaveChanges(); var price = db.Rice_Produce_Bags.Where(p => p.Rice_Production_id == Rice_Production_id).SingleOrDefault(); price.Rice_Production_id = Rice_Production_id; price.Rice_Produce_TotalBagsProduce = Convert.ToInt32(form["BAgs"]); price.Rice_Produce_Bag_PerBagMarketPrice = Convert.ToDecimal(form["Price"]); price.Status = true; price.Rice_Produce_Bag_Date = DateTime.Now; db.Entry(price).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult IncreaseRicee(Rice_Production Rice_Production, Rice_Produce_Bag Rice_Produce_Bag, List <Rice_Production_ShortFall> Rice_Production_ShortFall, List <Production_Rice> Production_Rice, List <Rice_Production_Expense> Rice_Production_Expense, List <Rice_Production_ProductWorth> Rice_Production_ProductWorth, Pricing pricing, Production_Extra_Rice Extra_Rice, FormCollection form) { int Rice_Production_id = Convert.ToInt32(form["Rice_Production_id"]); var Rice_Production_Ream = db.Rice_Productions.Find(Rice_Production_id); int Remaining = Rice_Production_Ream.Rice_Production_RemainingBags; Rice_Produce_Bag.Rice_Production_id = Rice_Production_id; Rice_Produce_Bag.Rice_Produce_Bag_TotalRawRate = Convert.ToDecimal(form["Rice_Production_TotalRate"]); Rice_Produce_Bag.Rice_Produce_TotalBags = Convert.ToInt32(form["Rice_Production_TotalBags"]); Rice_Produce_Bag.Rice_Produce_TotalBagsProduce = Convert.ToInt32(form["Rice_Production_TotalBags"]); Rice_Produce_Bag.Rice_Produce_RemainingBags = Rice_Produce_Bag.Rice_Produce_TotalBagsProduce; Rice_Produce_Bag.Rice_Produce_Bag_TotalWeight = Convert.ToDecimal(form["Rice_Production_TotalWieght"]); Rice_Produce_Bag.Rice_Produce_Bag_Average = Convert.ToDecimal(form["Rice_Production_Average"]); Rice_Produce_Bag.Rice_Produce_Bag_TotalWorth = Convert.ToDecimal(form["Rice_Production_TotalWorth"]); Rice_Produce_Bag.Rice_Produce_Bag_ShortFall_total = Convert.ToDecimal(form["Rice_Production_ShortFall_total"]); Rice_Produce_Bag.Rice_Produce_Bag_TotalExpenses = Convert.ToDecimal(form["Rice_Production_TotalExpense"]); Rice_Produce_Bag.Rice_Produce_Bag_StockWorth = Convert.ToDecimal(form["Rice_Production_StockWorth"]); Rice_Produce_Bag.Rice_Produce_Bag_TotalBPW = Convert.ToDecimal(form["Rice_Production_TotalByProductWorth"]); Rice_Produce_Bag.Rice_Produce_Bag_FactoryCost = Convert.ToDecimal(form["FactoryCost"]); Rice_Produce_Bag.Rice_Produce_Bag_MarketAverage = Convert.ToDecimal(form["Rice_Produce_Bag_MarketAverage"]); Rice_Produce_Bag.Rice_Produce_Bag_MarketStockWorth = Convert.ToDecimal(form["Rice_Produce_Bag_MarketStockWorth"]); Rice_Produce_Bag.Rice_Produce_Bag_MarketFactoryCost = Convert.ToDecimal(form["Rice_Produce_Bag_MarketFactoryCost"]); Rice_Produce_Bag.Rice_Produce_Bag_PerBagPrice = Convert.ToDecimal(form["Rice_Production_perBagPrice"]); Rice_Produce_Bag.Rice_Produce_Bag_PerBagMarketPrice = Convert.ToDecimal(form["MNewPerBagPrice"]); Rice_Produce_Bag.Status = true; Rice_Produce_Bag.Rice_Produce_Bag_Date = DateTime.Now; db.Rice_Produce_Bags.Add(Rice_Produce_Bag); db.SaveChanges(); int TotalBags = Remaining + Rice_Produce_Bag.Rice_Produce_TotalBagsProduce; Rice_Production_Ream.Rice_Production_RemainingBags = TotalBags; db.Entry(Rice_Production_Ream).State = EntityState.Modified; db.SaveChanges(); var Rice_Produce_Bags_id = db.Rice_Produce_Bags.Max(m => m.Rice_Produce_Bags_id); //pricing.item_id = Rice_Production_id; //pricing.item_Type = "Rice Production"; //pricing.PerBagMarketPrice = Convert.ToDecimal(form["MNewPerBagPrice"]); //pricing.PerBagPrice = Convert.ToDecimal(form["Rice_Production_perBagPrice"]); //pricing.Pricing_Date = DateTime.Now; //pricing.Status = true; //db.Pricing.Add(pricing); //db.SaveChanges(); Extra_Rice.Rice_Produce_Bags_id = Rice_Produce_Bags_id; Extra_Rice.Extra_Rice = Convert.ToDecimal(form["ExtraRice"]); db.Production_Extra_Rice.Add(Extra_Rice); db.SaveChanges(); foreach (var item in Production_Rice) { item.Rice_Produce_Bags_id = Rice_Produce_Bags_id; db.Production_Rices.Add(item); db.SaveChanges(); var rawrice = db.RarRices.Find(item.RawRice_id); rawrice.Bags_Sold_qty += item.Purchase_Rice_BagsUsed; db.Entry(rawrice).State = EntityState.Modified; db.SaveChanges(); } foreach (var item in Rice_Production_Expense) { item.Rice_Produce_Bags_id = Rice_Produce_Bags_id; db.Rice_Production_Expenses.Add(item); db.SaveChanges(); } foreach (var item in Rice_Production_ProductWorth) { item.Rice_Produce_Bags_id = Rice_Produce_Bags_id; db.Rice_Production_ProductWorths.Add(item); db.SaveChanges(); } foreach (var item in Rice_Production_ShortFall) { item.Rice_Produce_Bags_id = Rice_Produce_Bags_id; db.Rice_Production_ShortFalls.Add(item); db.SaveChanges(); } db.SaveChanges(); return(RedirectToAction("Index")); }