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"));
}
