public int EditSupplierRecieptDetails(List <RecPayDetail> rpayDetails, int recpayID) { //code for edit try { foreach (var CU in rpayDetails) { if (recpayID > 0) { RecPayDetail objrpayDetails = Context1.RecPayDetails.Where(item => item.RecPayDetailID == CU.RecPayDetailID).FirstOrDefault(); objrpayDetails.Amount = CU.Amount; objrpayDetails.CurrencyID = CU.CurrencyID; objrpayDetails.InvDate = CU.InvDate; objrpayDetails.InvNo = CU.InvNo; objrpayDetails.InvoiceID = CU.InvoiceID; objrpayDetails.Remarks = CU.Remarks; Context1.Entry(objrpayDetails).State = EntityState.Modified; } Context1.SaveChanges(); } return(1); } catch (Exception) { return(0); } }
public int EditRecpayDetailsCustR(int recpayid, decimal amount) { using (SHIPPING_FinalEntities Context1 = new SHIPPING_FinalEntities()) { var obj = (from t in Context1.RecPayDetails where t.RecPayID == recpayid && t.InvoiceID == 0 select t).FirstOrDefault(); //var obj = Context1.RecPayDetails.Find(recpayid,0); if (obj != null) { RecPayDetail recpdetail = new RecPayDetail(); recpdetail.RecPayDetailID = obj.RecPayDetailID; recpdetail.Amount = -(amount); // recpdetail.CurrencyID = cueencyid; //recpd.InvDate = item.InvoiceDate.Value; recpdetail.RecPayID = obj.RecPayID; // recpdetail.Remarks = remark; recpdetail.InvoiceID = 0; recpdetail.StatusInvoice = obj.StatusInvoice; recpdetail.InvDate = obj.InvDate; recpdetail.InvNo = obj.InvNo; recpdetail.Lock = false; Context1.Entry(obj).CurrentValues.SetValues(recpdetail); // Context1.Entry(recpdetail).State = EntityState.Modified; Context1.SaveChanges(); return(1); } else { return(0); } } }
public ActionResult Create(CustomerRcieptVM RecP, string Command, string Currency) { int RPID = 0; int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); int i = 0; RecP.FYearID = Convert.ToInt32(Session["fyearid"]); RecP.UserID = Convert.ToInt32(Session["UserID"]); var StaffNotes = (from d in db.StaffNotes where d.RecPayID == RecP.RecPayID && d.PageTypeId == 2 orderby d.NotesId descending select d).ToList(); var branchid = Convert.ToInt32(Session["CurrentBranchID"]); var users = (from d in db.UserRegistrations select d).ToList(); List <ReceiptAllocationDetailVM> AWBAllocationall = (List <ReceiptAllocationDetailVM>)Session["AWBAllocation"]; var staffnotemodel = new List <StaffNoteModel>(); foreach (var item in StaffNotes) { var model = new StaffNoteModel(); model.id = item.NotesId; model.employeeid = item.EmployeeId; //model.jobid = item.JobId; model.TaskDetails = item.Notes; model.Datetime = item.EntryDate; model.EmpName = users.Where(d => d.UserID == item.EmployeeId).FirstOrDefault().UserName; staffnotemodel.Add(model); } ViewBag.StaffNoteModel = staffnotemodel; //if (RecP.RecPayID > 0) //{ // RP.EditCustomerRecPay(RecP, Session["UserID"].ToString()); // RP.EditCustomerRecieptDetails(RecP.recPayDetail, RecP.RecPayID); //} if (RecP.CashBank != null) { RecP.StatusEntry = "CS"; int acheadid = Convert.ToInt32(RecP.CashBank); var achead = (from t in db.AcHeads where t.AcHeadID == acheadid select t.AcHead1).FirstOrDefault(); RecP.BankName = achead; } else { RecP.StatusEntry = "BK"; int acheadid = Convert.ToInt32(RecP.ChequeBank); var achead = (from t in db.AcHeads where t.AcHeadID == acheadid select t.AcHead1).FirstOrDefault(); RecP.BankName = achead; } if (RecP.CustomerRcieptChildVM == null) { RecP.CustomerRcieptChildVM = new List <CustomerRcieptChildVM>(); } //Adding Entry in Rec PAY ///Insert Entry For RecPay Details /// if (RecP.RecPayID <= 0) { decimal Fmoney = 0; //for (int j = 0; j < RecP.CustomerRcieptChildVM.Count; j++) //{ // Fmoney = Fmoney + Convert.ToDecimal(RecP.CustomerRcieptChildVM[j].Amount); //} //if (Fmoney > 0) //{ // RecP.FMoney = Fmoney; //} RecP.AcCompanyID = branchid; RPID = ReceiptDAO.AddCustomerRecieptPayment(RecP, Session["UserID"].ToString()); //.AddCustomerRecieptPayment(RecP, Session["UserID"].ToString()); RecP.RecPayID = (from c in db.RecPays orderby c.RecPayID descending select c.RecPayID).FirstOrDefault(); decimal TotalAmount = 0; foreach (var item in RecP.CustomerRcieptChildVM) { if (item.Amount > 0) { RecPayDetail recpd = new RecPayDetail(); int? maxrecpaydetailid = (from c in db.RecPayDetails orderby c.RecPayDetailID descending select c.RecPayDetailID).FirstOrDefault(); if (maxrecpaydetailid == null) { maxrecpaydetailid = 1; } else { maxrecpaydetailid = maxrecpaydetailid + 1; } recpd.RecPayDetailID = Convert.ToInt32(maxrecpaydetailid); recpd.Amount = -(item.Amount); recpd.CurrencyID = item.CurrencyId; recpd.AdjustmentAmount = 0; recpd.InvDate = item.InvoiceDate.Value; recpd.RecPayID = RecP.RecPayID; recpd.Remarks = item.Remarks; recpd.InvoiceID = 0; recpd.InScanID = item.InScanID; recpd.AcOPInvoiceDetailID = 0; recpd.StatusInvoice = "D"; db.RecPayDetails.Add(recpd); db.SaveChanges(); } } //To Balance Invoice AMount if (RecP.FMoney > 0) { //int l = ReceiptDAO.InsertRecpayDetailsForCust(RecP.RecPayID, 0, 0, Convert.ToDecimal(RecP.FMoney), null, "D", false, null, null, null, Convert.ToInt32(RecP.CurrencyId), 4, 0); int fyaerId = Convert.ToInt32(Session["fyearid"].ToString()); ReceiptDAO.InsertJournalOfCustomer(RecP.RecPayID, fyaerId); } // var Recpaydata = (from d in db.RecPays where d.RecPayID == RecP.RecPayID select d).FirstOrDefault(); //Recpaydata.RecPayID = RecP.RecPayID; //Recpaydata.IsTradingReceipt = true; //db.Entry(Recpaydata).State = EntityState.Modified; //db.SaveChanges(); } else //edit mode { var details = (from d in db.RecPayDetails where d.RecPayID == RecP.RecPayID select d).ToList(); if (details != null) { db.RecPayDetails.RemoveRange(details); db.SaveChanges(); } RecPay recpay = new RecPay(); recpay = db.RecPays.Find(RecP.RecPayID); recpay.RecPayDate = RecP.RecPayDate; recpay.RecPayID = RecP.RecPayID; recpay.AcJournalID = RecP.AcJournalID; recpay.BankName = RecP.BankName; recpay.ChequeDate = RecP.ChequeDate; recpay.ChequeNo = RecP.ChequeNo; recpay.CustomerID = RecP.CustomerID; recpay.DocumentNo = RecP.DocumentNo; recpay.EXRate = RecP.EXRate; recpay.FYearID = RecP.FYearID; recpay.FMoney = RecP.FMoney; recpay.StatusEntry = RecP.StatusEntry; recpay.IsTradingReceipt = true; recpay.FMoney = RecP.FMoney; recpay.Remarks = RecP.Remarks; recpay.ModifiedBy = RecP.UserID; recpay.ModifiedDate = DateTime.Now; db.Entry(recpay).State = EntityState.Modified; db.SaveChanges(); foreach (var item in RecP.CustomerRcieptChildVM) { if (item.Amount > 0) { RecPayDetail recpd = new RecPayDetail(); int?maxrecpaydetailid = (from c in db.RecPayDetails orderby c.RecPayDetailID descending select c.RecPayDetailID).FirstOrDefault(); if (maxrecpaydetailid == null) { maxrecpaydetailid = 1; } else { maxrecpaydetailid = maxrecpaydetailid + 1; } recpd.RecPayDetailID = Convert.ToInt32(maxrecpaydetailid); recpd.Amount = -(item.Amount); recpd.CurrencyID = item.CurrencyId; recpd.AdjustmentAmount = 0; if (item.InvoiceDate != null) { recpd.InvDate = item.InvoiceDate.Value; } recpd.RecPayID = RecP.RecPayID; recpd.Remarks = item.Remarks; recpd.InvoiceID = 0; recpd.InScanID = item.InScanID; recpd.AcOPInvoiceDetailID = 0; recpd.StatusInvoice = "D"; db.RecPayDetails.Add(recpd); db.SaveChanges(); } } //int editrecPay = 0; //var sumOfAmount = db.RecPayDetails.Where(m => m.RecPayID == RecP.RecPayID && m.InvoiceID != 0).Sum(c => c.Amount); //editrecPay = editfu.EditRecpayDetailsCustR(RecP.RecPayID, Convert.ToInt32(sumOfAmount)); if (RecP.AcJournalID == null) { ReceiptDAO.InsertJournalOfCustomer(RecP.RecPayID, fyearid); } else { int editAcJdetails = editfu.EditAcJDetails(RecP.AcJournalID.Value, Convert.ToDecimal(RecP.FMoney)); } } return(RedirectToAction("Index", "CODReceipt")); }