public JsonResult GetCODItems(decimal?amountreceived, int RecPayId = 0) { var codcust = db.CustomerMasters.Where(cc => cc.CustomerName == "Cod Customer").FirstOrDefault(); var salesinvoice = new List <CustomerTradeReceiptVM>(); if (codcust != null) { int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); salesinvoice = ReceiptDAO.GetCODPending(fyearid, RecPayId); Session["CODAWBList"] = salesinvoice; return(Json(salesinvoice, JsonRequestBehavior.AllowGet)); } else { return(Json(salesinvoice, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create(int id = 0) { int FyearId = Convert.ToInt32(Session["fyearid"]); CustomerRcieptVM cust = new CustomerRcieptVM(); cust.CustomerRcieptChildVM = new List <CustomerRcieptChildVM>(); List <CurrencyMaster> Currencys = new List <CurrencyMaster>(); Currencys = MM.GetCurrency(); ViewBag.Currency = new SelectList(Currencys, "CurrencyID", "CurrencyName"); if (Session["UserID"] != null) { var branchid = Convert.ToInt32(Session["CurrentBranchID"]); if (id > 0) { ViewBag.Title = "COD Receipt - Modify"; cust = RP.GetRecPayByRecpayID(id); var acheadforcash = (from c in db.AcHeads join g in db.AcGroups on c.AcGroupID equals g.AcGroupID where g.AcGroup1 == "Cash" select new { AcHeadID = c.AcHeadID, AcHead = c.AcHead1 }).ToList(); var acheadforbank = (from c in db.AcHeads join g in db.AcGroups on c.AcGroupID equals g.AcGroupID where g.AcGroup1 == "Bank" select new { AcHeadID = c.AcHeadID, AcHead = c.AcHead1 }).ToList(); ViewBag.achead = acheadforcash; ViewBag.acheadbank = acheadforbank; cust.recPayDetail = db.RecPayDetails.Where(item => item.RecPayID == id).ToList(); int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); var salesinvoice = new List <CustomerTradeReceiptVM>(); salesinvoice = ReceiptDAO.GetCODPending(fyearid, id); Session["CODAWBList"] = salesinvoice; cust.CustomerRcieptChildVM = new List <CustomerRcieptChildVM>(); foreach (var item in cust.recPayDetail) { if (item.InScanID > 0) { if (salesinvoice.Count > 0) { CustomerTradeReceiptVM sales = salesinvoice.Where(cc => cc.InScanID == Convert.ToInt32(item.InScanID)).FirstOrDefault(); decimal invoicetotal = Convert.ToDecimal(sales.InvoiceAmount); decimal received = Convert.ToDecimal(sales.AmountReceived); var allrecpay = (from d in db.RecPayDetails where d.InScanID == item.InScanID select d).ToList(); var totamtpaid = allrecpay.Sum(d => d.Amount) * -1; var totadjust = allrecpay.Sum(d => d.AdjustmentAmount); var customerinvoice = new CustomerRcieptChildVM(); customerinvoice.InvoiceType = "D"; var inscan = db.InScanMasters.Find(item.InScanID); if (inscan != null) { customerinvoice.InScanID = inscan.InScanID; customerinvoice.ConsignmentNo = inscan.ConsignmentNo; customerinvoice.strDate = Convert.ToDateTime(inscan.TransactionDate).ToString("dd/MM/yyyy"); } customerinvoice.AmountToBeRecieved = invoicetotal; customerinvoice.AmountToBePaid = received; customerinvoice.Amount = Convert.ToDecimal(item.Amount) * -1; customerinvoice.Balance = invoicetotal - received; customerinvoice.RecPayDetailID = item.RecPayDetailID; customerinvoice.RecPayID = Convert.ToInt32(item.RecPayID); customerinvoice.AdjustmentAmount = 0; cust.CustomerRcieptChildVM.Add(customerinvoice); } } } Session["AWBAllocation"] = cust.AWBAllocation; } else { ViewBag.Title = "COD Receipt - Create"; var codcust = db.CustomerMasters.Where(cc => cc.CustomerName == "Cod Customer").FirstOrDefault(); var acheadforcash = (from c in db.AcHeads join g in db.AcGroups on c.AcGroupID equals g.AcGroupID where g.AcGroup1 == "Cash" select new { AcHeadID = c.AcHeadID, AcHead = c.AcHead1 }).ToList(); var acheadforbank = (from c in db.AcHeads join g in db.AcGroups on c.AcGroupID equals g.AcGroupID where g.AcGroup1 == "Bank" select new { AcHeadID = c.AcHeadID, AcHead = c.AcHead1 }).ToList(); ViewBag.achead = acheadforcash; ViewBag.acheadbank = acheadforbank; DateTime pFromDate = AccountsDAO.CheckParamDate(DateTime.Now, FyearId).Date; cust.RecPayDate = pFromDate; cust.RecPayID = 0; cust.CustomerID = codcust.CustomerID; cust.DocumentNo = ReceiptDAO.SP_GetMaxCODID(); cust.CurrencyId = Convert.ToInt32(Session["CurrencyId"].ToString()); var salesinvoice = new List <CustomerTradeReceiptVM>(); if (codcust != null) { int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); salesinvoice = ReceiptDAO.GetCODPending(fyearid, 0); Session["CODAWBList"] = salesinvoice; } } } else { return(RedirectToAction("Login", "Login")); } var StaffNotes = (from d in db.StaffNotes where d.PageTypeId == 2 orderby d.NotesId descending select d).ToList(); var users = (from d in db.UserRegistrations select d).ToList(); 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; var customerdetails = (from d in db.CustomerMasters where d.CustomerID == cust.CustomerID && d.CustomerType == "CS" select d).FirstOrDefault(); if (customerdetails == null) { customerdetails = new CustomerMaster(); } ViewBag.CustomerDetail = customerdetails; var CustomerNotification = (from d in db.CustomerNotifications where d.RecPayID == id && d.PageTypeId == 2 orderby d.NotificationId descending select d).ToList(); var customernotification = new List <CustomerNotificationModel>(); foreach (var item in CustomerNotification) { var model = new CustomerNotificationModel(); model.id = item.NotificationId; model.employeeid = item.UserId; model.jobid = item.RecPayID; model.Message = item.MessageText; model.Datetime = item.EntryDate; model.IsEmail = item.NotifyByEmail; model.IsSms = item.NotifyBySMS; model.IsWhatsapp = item.NotifyByWhatsApp; model.EmpName = users.Where(d => d.UserID == item.UserId).FirstOrDefault().UserName; customernotification.Add(model); } cust.AWBAllocation = new List <ReceiptAllocationDetailVM>(); ViewBag.CustomerNotification = customernotification; return(View(cust)); }