public ActionResult WorthRiceSellingInvoice(int?id, int In) { BpRiceSales_pt pt = db.BpRiceSales_pts.Find(id); ViewBag.InoviceNum = In; ViewBag.Date = pt.bprsp_date; return(View(pt)); }
public JsonResult Return(int prsp_id) { BpRiceSales_pt mProducedRiceSales_pt = db.BpRiceSales_pts.Where(m => m.bprsp_id == prsp_id && m.bprsp_status).SingleOrDefault(); if (mProducedRiceSales_pt != null) { foreach (var item in db.BpRiceSales_chs.Where(m => m.bprsp_id == mProducedRiceSales_pt.bprsp_id && m.bprsc_status).ToList()) { //Again add in stock var Rice_Produce_Bags = db.Rice_Production_ProductWorths.Where(m => m.Rice_Production_ProductWorth_id == item.Rice_Production_ProductWorth_id).OrderByDescending(m => m.Rice_Produce_Bag.Rice_Produce_Bag_Date).ToList(); foreach (var obj1 in Rice_Produce_Bags) { if (item.bprsc_qty >= obj1.Rice_Production_ProductWorth_SoldQty && item.bprsc_qty > 0) { decimal diff1 = item.bprsc_qty - obj1.Rice_Production_ProductWorth_SoldQty; obj1.Rice_Production_ProductWorth_SoldQty -= Convert.ToInt32(obj1.Rice_Production_ProductWorth_SoldQty); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else if (item.bprsc_qty < obj1.Rice_Production_ProductWorth_SoldQty && item.bprsc_qty > 0) { decimal diff1 = item.bprsc_qty - obj1.Rice_Production_ProductWorth_SoldQty; obj1.Rice_Production_ProductWorth_SoldQty -= Convert.ToInt32(item.bprsc_qty); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } } var Receivedtrans = db.Transaction.Where( m => m.status && m.Transaction_item_id == mProducedRiceSales_pt.bprsp_id && (m.Transaction_item_type == SellingCategory.Worth_Rice_Sales || m.Transaction_item_type == SellingCategory.Worth_Rice_Sales_Remaining) ).SingleOrDefault(); decimal recieved = (Receivedtrans != null) ? Receivedtrans.Credit : 0; Transaction trans = new Transaction(); trans.isByCash = true; trans.BankAccountNo = ""; foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed) { trans.Opening_ClosingDays_id = item.Opening_ClosingDays_id; break; } } trans.Transaction_DateTime = DateTime.Now; trans.Transaction_Description = "Worth Return from " + db.Parties.Find(mProducedRiceSales_pt.Party_Id).Party_Name; trans.Transaction_item_id = prsp_id; trans.Transaction_item_type = SellingCategory.Worth_Rice_Sales_Return; trans.Debit = recieved; trans.Credit = 0; trans.status = (recieved > 0) ? true : false; db.Transaction.Add(trans); db.SaveChanges(); } return(Json(1, JsonRequestBehavior.AllowGet)); }
public void Update_sales(FormCollection form) { var js = new JavaScriptSerializer(); decimal Recieved_Amount = Convert.ToDecimal(form["RecievedAmount"]); try { List <int> remaining_prsp_id = js.Deserialize <List <int> >(form["remaining_prsp_id"]); for (int i = 0; i < remaining_prsp_id.Count; i++) { var ProducedRiceSales_pt1 = db.ProducedRiceSales_pt.Find(remaining_prsp_id[i]); decimal rec = db.Transaction.Where(m => m.status && m.Transaction_item_id == ProducedRiceSales_pt1.prsp_id && m.Transaction_item_type == SellingCategory.Produced_Rice_Sales || m.Transaction_item_type == SellingCategory.Produced_Rice_Sales_Remaining ).Sum(m => m.Credit); var Remaining = ProducedRiceSales_pt1.prsp_Total_Amount - rec; Transaction trans = new Transaction(); if (form["isBankAccount"] == "true") { trans.BankAccountNo = form["BankAccountNo"]; } else if (form["isCheckbook"] == "true") { trans.checkno = Convert.ToInt32(form["CheckNo"]); trans.BankAccountNo = form["BankAccountNo"]; } else if (form["isCash"] == "true") { trans.isByCash = true; trans.BankAccountNo = ""; } foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed) { trans.Opening_ClosingDays_id = item.Opening_ClosingDays_id; break; } } trans.Transaction_DateTime = DateTime.Now; trans.Transaction_Description = "Received Remaining from " + db.Parties.Find(ProducedRiceSales_pt1.Party_Id).Party_Name; trans.Transaction_item_id = remaining_prsp_id[i]; trans.Transaction_item_type = SellingCategory.Produced_Rice_Sales_Remaining; trans.Debit = 0; trans.Credit = Remaining; trans.status = true; db.Transaction.Add(trans); db.SaveChanges(); Recieved_Amount -= Remaining; } } catch (Exception ex) { } BpRiceSales_pt ProducedRiceSales_pt_view = js.Deserialize <BpRiceSales_pt>(form["ProducedRiceSales_pt"]); var ProducedRiceSales_pt = db.BpRiceSales_pts.Find(ProducedRiceSales_pt_view.bprsp_id); if (ProducedRiceSales_pt_view.Party.Party_Id > 0) { ProducedRiceSales_pt.Party_Id = ProducedRiceSales_pt_view.Party.Party_Id; ProducedRiceSales_pt.Party = db.Parties.Find(ProducedRiceSales_pt.Party_Id); } else { var mParty = ProducedRiceSales_pt_view.Party; //string idd = Convert.ToString(Session["UserId"]); string idd = User.Identity.GetUserId(); mParty.Id = idd; mParty.Status = true; db.Parties.Add(mParty); db.SaveChanges(); ProducedRiceSales_pt.Party_Id = db.Parties.Max(m => m.Party_Id); ProducedRiceSales_pt.Party = db.Parties.Find(ProducedRiceSales_pt.Party_Id); } // ProducedRiceSales_pt.Party_Id = ProducedRiceSales_pt_view.Party_Id; ProducedRiceSales_pt.bprsp_Total_Amount = ProducedRiceSales_pt_view.bprsp_Total_Amount; ProducedRiceSales_pt.bprsp_Title = ProducedRiceSales_pt_view.bprsp_Title + " to Party " + db.Parties.Find(ProducedRiceSales_pt_view.Party_Id).Party_Name; ProducedRiceSales_pt.bprsp_status = true; ProducedRiceSales_pt.bprsp_date = DateTime.Now; db.Entry(ProducedRiceSales_pt).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); int prsp_id = ProducedRiceSales_pt.bprsp_id; var obj = js.DeserializeObject(form["ProducedRiceSales_ch"].ToString()); List <BpRiceSales_ch> ProducedRiceSales_ch = js.Deserialize <BpRiceSales_ch[]>(form["ProducedRiceSales_ch"].ToString()).ToList(); foreach (var item in ProducedRiceSales_ch) { var rsc = db.BpRiceSales_chs.Find(item.bprsc_id); if (rsc == null) { rsc = new BpRiceSales_ch(); } rsc.bprsc_price = item.bprsc_price; rsc.bprsc_qty = item.bprsc_qty; rsc.bprsc_status = item.bprsc_status; rsc.bprsc_title = item.bprsc_title; rsc.bprsp_id = prsp_id; rsc.bprsc_status = true; if (item.bprsc_id == 0) { db.BpRiceSales_chs.Add(rsc); db.SaveChanges(); var Rice_Produce_Bags = db.Rice_Production_ProductWorths.Where(m => m.Rice_Production_ProductWorth_id == item.Rice_Production_ProductWorth_id).ToList(); decimal qty = item.bprsc_qty; foreach (var obj1 in Rice_Produce_Bags) { decimal diff = obj1.Rice_Production_ProductWorth_Qty - obj1.Rice_Production_ProductWorth_SoldQty; if (diff > qty && qty > 0) { obj1.Rice_Production_ProductWorth_SoldQty += Convert.ToInt32(qty); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); qty = 0; } else if (diff <= qty && qty > 0 && diff != 0) { obj1.Rice_Production_ProductWorth_SoldQty += Convert.ToInt32(diff); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); qty -= diff; } } } else { int prsc_qty = 0; using (var newdb = new ApplicationDbContext()) { prsc_qty = newdb.BpRiceSales_chs.Where(m => m.bprsc_id == item.bprsc_id).First().bprsc_qty; } var Rice_Produce_Bags = db.Rice_Production_ProductWorths.Where(m => m.Rice_Production_ProductWorth_id == item.Rice_Production_ProductWorth_id).OrderByDescending(m => m.Rice_Produce_Bag.Rice_Produce_Bag_Date).ToList(); foreach (var obj_new in Rice_Produce_Bags) { if (prsc_qty >= obj_new.Rice_Production_ProductWorth_SoldQty && prsc_qty > 0) { decimal diff1 = prsc_qty - obj_new.Rice_Production_ProductWorth_SoldQty; obj_new.Rice_Production_ProductWorth_SoldQty -= Convert.ToInt32(obj_new.Rice_Production_ProductWorth_SoldQty); //obj_new.Rice_Produce_RemainingBags = obj_new.Rice_Produce_TotalBagsProduce - obj_new.Rice_Produce_BagsSold; db.Entry(obj_new).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); prsc_qty = (int)diff1; } else if (prsc_qty < obj_new.Rice_Production_ProductWorth_SoldQty && prsc_qty > 0) { decimal diff1 = prsc_qty - obj_new.Rice_Production_ProductWorth_SoldQty; obj_new.Rice_Production_ProductWorth_SoldQty -= Convert.ToInt32(prsc_qty); //obj_new.Rice_Produce_RemainingBags = obj_new.Rice_Produce_TotalBagsProduce - obj_new.Rice_Produce_BagsSold; db.Entry(obj_new).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); prsc_qty = (int)diff1; } } db.Entry(rsc).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); Rice_Produce_Bags = db.Rice_Production_ProductWorths.Where(m => m.Rice_Production_ProductWorth_id == item.Rice_Production_ProductWorth_id).ToList(); decimal qty = item.bprsc_qty; foreach (var obj1 in Rice_Produce_Bags) { decimal diff = obj1.Rice_Production_ProductWorth_Qty - obj1.Rice_Production_ProductWorth_SoldQty; if (diff > qty && qty > 0) { obj1.Rice_Production_ProductWorth_SoldQty += Convert.ToInt32(qty); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); qty = 0; } else if (diff <= qty && qty > 0 && diff != 0) { obj1.Rice_Production_ProductWorth_SoldQty += Convert.ToInt32(diff); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); qty -= diff; } } } } List <BpRiceSales_ch> Deleted_RawRice_Sales_ch = js.Deserialize <BpRiceSales_ch[]>(form["Deleted_ProducedRiceSales_ch"].ToString()).ToList(); foreach (var item in Deleted_RawRice_Sales_ch) { var Rice_Produce_Bags = db.Rice_Production_ProductWorths.Where(m => m.Rice_Production_ProductWorth_id == item.Rice_Production_ProductWorth_id).OrderByDescending(m => m.Rice_Produce_Bag.Rice_Produce_Bag_Date).ToList(); foreach (var obj1 in Rice_Produce_Bags) { if (item.bprsc_qty >= obj1.Rice_Production_ProductWorth_SoldQty && item.bprsc_qty > 0) { decimal diff1 = item.bprsc_qty - obj1.Rice_Production_ProductWorth_SoldQty; obj1.Rice_Production_ProductWorth_SoldQty -= Convert.ToInt32(obj1.Rice_Production_ProductWorth_SoldQty); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); item.bprsc_qty = (int)diff1; } else if (item.bprsc_qty < obj1.Rice_Production_ProductWorth_SoldQty && item.bprsc_qty > 0) { decimal diff1 = item.bprsc_qty - obj1.Rice_Production_ProductWorth_SoldQty; obj1.Rice_Production_ProductWorth_SoldQty -= Convert.ToInt32(item.bprsc_qty); //obj1.Rice_Produce_RemainingBags = obj1.Rice_Produce_TotalBagsProduce - obj1.Rice_Produce_BagsSold; db.Entry(obj1).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); item.bprsc_qty = (int)diff1; } } var prsc = db.BpRiceSales_chs.Find(item.bprsc_id); prsc.bprsc_status = false; db.Entry(prsc).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } foreach (var item in db.Transaction.Where(m => m.status && m.Transaction_item_id == ProducedRiceSales_pt.bprsp_id && m.Transaction_item_type == SellingCategory.Worth_Rice_Sales ).ToList()) { db.Transaction.Remove(item); } db.SaveChanges(); Transaction trans_this = new Transaction(); if (form["isBankAccount"] == "true") { trans_this.BankAccountNo = form["BankAccountNo"]; } else if (form["isCheckbook"] == "true") { trans_this.checkno = Convert.ToInt32(form["CheckNo"]); trans_this.BankAccountNo = form["BankAccountNo"]; } else if (form["isCash"] == "true") { trans_this.isByCash = true; trans_this.BankAccountNo = ""; } foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed) { trans_this.Opening_ClosingDays_id = item.Opening_ClosingDays_id; break; } } trans_this.Transaction_DateTime = DateTime.Now; trans_this.Transaction_Description = ProducedRiceSales_pt.bprsp_Title; trans_this.Transaction_item_id = prsp_id; trans_this.Transaction_item_type = SellingCategory.Worth_Rice_Sales; trans_this.Debit = 0; trans_this.Credit = Recieved_Amount; trans_this.status = true; db.Transaction.Add(trans_this); db.SaveChanges(); }
public void Insert_sales(FormCollection form) { var js = new JavaScriptSerializer(); decimal Recieved_Amount = Convert.ToDecimal(form["RecievedAmount"]); decimal NetTotal = Convert.ToDecimal(form["NetTotal"]); try { List <int> remaining_rsp_id = js.Deserialize <List <int> >(form["remaining_prsp_id"]); for (int i = 0; i < remaining_rsp_id.Count; i++) { var RawRice_Sales_pt = db.ProducedRiceSales_pt.Find(remaining_rsp_id[i]); decimal rec = db.Transaction.Where(m => m.status && m.Transaction_item_id == RawRice_Sales_pt.prsp_id && m.Transaction_item_type == SellingCategory.Worth_Rice_Sales || m.Transaction_item_type == SellingCategory.Worth_Rice_Sales_Remaining ).Sum(m => m.Credit); var Remaining = RawRice_Sales_pt.prsp_Total_Amount - rec; Transaction trans = new Transaction(); if (form["isBankAccount"] == "true") { trans.BankAccountNo = form["BankAccountNo"]; } else if (form["isCheckbook"] == "true") { trans.checkno = Convert.ToInt32(form["CheckNo"]); trans.BankAccountNo = form["BankAccountNo"]; } else if (form["isCash"] == "true") { trans.isByCash = true; trans.BankAccountNo = ""; } foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed) { trans.Opening_ClosingDays_id = item.Opening_ClosingDays_id; break; } } trans.Transaction_DateTime = DateTime.Now; trans.Transaction_Description = "Received Remaining from " + db.Parties.Find(RawRice_Sales_pt.Party_Id).Party_Name; trans.Transaction_item_id = remaining_rsp_id[i]; trans.Transaction_item_type = SellingCategory.Worth_Rice_Sales_Remaining; trans.Debit = 0; trans.Credit = Remaining; trans.status = true; db.Transaction.Add(trans); db.SaveChanges(); Recieved_Amount -= Remaining; } } catch (Exception ex) { } BpRiceSales_pt ProducedRiceSales_pt = js.Deserialize <BpRiceSales_pt>(form["ProducedRiceSales_pt"]); ProducedRiceSales_pt.bprsp_Total_Amount = NetTotal; if (ProducedRiceSales_pt.Party.Party_Id > 0) { ProducedRiceSales_pt.Party_Id = ProducedRiceSales_pt.Party.Party_Id; ProducedRiceSales_pt.Party = null; } else { //string idd = Convert.ToString(Session["UserId"]); string idd = User.Identity.GetUserId(); ProducedRiceSales_pt.Party.Id = idd; ProducedRiceSales_pt.Party.Status = true; db.Parties.Add(ProducedRiceSales_pt.Party); db.SaveChanges(); ProducedRiceSales_pt.Party_Id = db.Parties.Max(m => m.Party_Id); ProducedRiceSales_pt.Party = null; } ProducedRiceSales_pt.bprsp_Title = ProducedRiceSales_pt.bprsp_Title + " to Party " + db.Parties.Find(ProducedRiceSales_pt.Party_Id).Party_Name; ProducedRiceSales_pt.bprsp_status = true; ProducedRiceSales_pt.bprsp_date = DateTime.Now; db.BpRiceSales_pts.Add(ProducedRiceSales_pt); db.SaveChanges(); int prsp_id = db.BpRiceSales_pts.Max(m => m.bprsp_id); List <BpRiceSales_ch> ProducedRiceSales_ch = js.Deserialize <BpRiceSales_ch[]>(form["ProducedRiceSales_ch"].ToString()).ToList(); foreach (var item in ProducedRiceSales_ch) { item.bprsp_id = prsp_id; item.bprsc_status = true; db.BpRiceSales_chs.Add(item); db.SaveChanges(); var Rice_Produce_Bags = db.Rice_Production_ProductWorths.Where(m => m.Rice_Production_ProductWorth_id == item.Rice_Production_ProductWorth_id).ToList(); decimal qty = item.bprsc_qty; foreach (var obj in Rice_Produce_Bags) { decimal diff = obj.Rice_Production_ProductWorth_Qty - obj.Rice_Production_ProductWorth_SoldQty; if (diff > qty && qty > 0) { obj.Rice_Production_ProductWorth_SoldQty += Convert.ToInt32(qty); //obj.Rice_Produce_RemainingBags = obj.Rice_Production_ProductWorth_Qty - obj.Rice_Production_ProductWorth_SoldQty; db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); qty = 0; } else if (diff <= qty && qty > 0 && diff != 0) { obj.Rice_Production_ProductWorth_SoldQty += Convert.ToInt32(diff); //obj.Rice_Produce_RemainingBags = obj.Rice_Produce_TotalBagsProduce - obj.Rice_Produce_BagsSold; db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); qty -= diff; } } } Transaction trans_this = new Transaction(); if (form["isBankAccount"] == "true") { trans_this.BankAccountNo = form["BankAccountNo"]; } else if (form["isCheckbook"] == "true") { trans_this.checkno = Convert.ToInt32(form["CheckNo"]); trans_this.BankAccountNo = form["BankAccountNo"]; } else if (form["isCash"] == "true") { trans_this.isByCash = true; trans_this.BankAccountNo = ""; } foreach (var item in db.Opening_ClosingDays) { if (item.Date.ToShortDateString() == DateTime.Now.ToShortDateString() && !item.isClosed) { trans_this.Opening_ClosingDays_id = item.Opening_ClosingDays_id; break; } } trans_this.Transaction_DateTime = DateTime.Now; trans_this.Transaction_Description = ProducedRiceSales_pt.bprsp_Title; trans_this.Transaction_item_id = prsp_id; trans_this.Transaction_item_type = SellingCategory.Worth_Rice_Sales; trans_this.Debit = 0; trans_this.Credit = Recieved_Amount; trans_this.status = true; db.Transaction.Add(trans_this); db.SaveChanges(); SaleInvoiceType mSaleInvoiceType = new SaleInvoiceType(); SaleInvoice saleInvoice = new SaleInvoice() { SaleInvoice_no = mSaleInvoiceType.GenerateInvoiceNo(SaleInvoiceType.FactoryRiceSales), SaleInvoice_type = SaleInvoiceType.FactoryRiceSales, Sale_id = db.BpRiceSales_pts.Max(m => m.bprsp_id) }; db.SaleInvoice.Add(saleInvoice); db.SaveChanges(); }