public static List <RevenueUpdateMasterVM> GetRevenueUpdateList(string ConsignmentNote, DateTime FromDate, DateTime ToDate) { SqlCommand cmd = new SqlCommand(); cmd.Connection = new SqlConnection(CommanFunctions.GetConnectionString); cmd.CommandText = "SP_GetRevenueUpdateList"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FromDate", SqlDbType.VarChar); cmd.Parameters["@FromDate"].Value = FromDate.ToString("MM/dd/yyyy"); cmd.Parameters.Add("@ToDate", SqlDbType.VarChar); cmd.Parameters["@ToDate"].Value = ToDate.ToString("MM/dd/yyyy"); cmd.Parameters.Add("@ConsignmentNo", SqlDbType.VarChar); if (ConsignmentNote == null) { ConsignmentNote = ""; } cmd.Parameters["@ConsignmentNo"].Value = ConsignmentNote; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); List <RevenueUpdateMasterVM> objList = new List <RevenueUpdateMasterVM>(); if (ds != null && ds.Tables.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { RevenueUpdateMasterVM obj = new RevenueUpdateMasterVM(); obj.ID = CommanFunctions.ParseInt(ds.Tables[0].Rows[i]["ID"].ToString()); obj.ConsignmentNo = ds.Tables[0].Rows[i]["ConsignmentNo"].ToString(); obj.ConsignmentDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ConsignmentDate"].ToString()); // CommanFunctions.ParseDate(ds.Tables[0].Rows[i]["RecPayDate"].ToString()); obj.Currency = ds.Tables[0].Rows[i]["CurrencyName"].ToString(); obj.PaymentType = ds.Tables[0].Rows[i]["PaymentType"].ToString(); obj.InvoiceTo = ds.Tables[0].Rows[i]["InvoiceTo"].ToString(); obj.DebitAccountName = ds.Tables[0].Rows[i]["DebitAccountHead"].ToString(); obj.CreditAccountName = ds.Tables[0].Rows[i]["CreditAccountHead"].ToString(); obj.CustomerName = ds.Tables[0].Rows[i]["CustomerName"].ToString(); if (ds.Tables[0].Rows[i]["Amount"] == DBNull.Value) { obj.Amount = 0; } else { obj.Amount = CommanFunctions.ParseDecimal(ds.Tables[0].Rows[i]["Amount"].ToString()); } objList.Add(obj); } } return(objList); }
public JsonResult GetConsignmentDetail(int id) { RevenueUpdateMasterVM vm = (RevenueUpdateMasterVM)Session["CreateRevenueUpdate"]; var inscan = db.InScanMasters.Find(id); int paymentModeid = Convert.ToInt32(inscan.PaymentModeId); string InvoiceTo = inscan.InvoiceTo; var cust = (from c in db.CustomerMasters where c.CustomerName == inscan.Consignor select c).FirstOrDefault(); var receiver = (from c in db.CustomerMasters where c.CustomerName == inscan.Consignee select c).FirstOrDefault(); var customer = (from c in db.CustomerMasters where c.CustomerType == "PKP" select c).FirstOrDefault(); int consignorid = 0; string consignorname = ""; int consigneeid = 0; string consigneename = ""; string errormessage = ""; bool status = true; if (cust != null) { consignorid = cust.CustomerID; consignorname = cust.CustomerName; if (paymentModeid == 3 && InvoiceTo == "Shipper" && cust.CustomerType != "CR") { status = false; errormessage = "Invoiced Customer is not a Credit Customer"; } } if (receiver != null) { consigneeid = receiver.CustomerID; consigneename = receiver.CustomerName; if (paymentModeid == 3 && InvoiceTo == "Consignee" && receiver.CustomerType != "CR") { status = false; errormessage = "Invoiced Customer is not a Credit Customer"; } } if (paymentModeid == 1 && customer != null) { consignorid = customer.CustomerID; consigneeid = customer.CustomerID; consignorname = customer.CustomerName; consigneename = customer.CustomerName; } List <RevenueUpdateDetailVM> list = new List <RevenueUpdateDetailVM>(); if (vm != null) { list = vm.DetailVM; for (int i = 0; i < list.Count; i++) { list[i].Currency = db.CurrencyMasters.Find(list[i].CurrencyId).CurrencyName; if (list[i].AcHeadDebitId != null) { list[i].DebitAccountName = db.AcHeads.Find(list[i].AcHeadDebitId).AcHead1; } if (list[i].AcHeadCreditId != null) { list[i].CreditAccountName = db.AcHeads.Find(list[i].AcHeadCreditId).AcHead1; } var customer1 = db.CustomerMasters.Find(list[i].CustomerId); if (customer1 != null) { list[i].CustomerName = customer1.CustomerName + "(" + customer.CustomerType + ")"; } if (list[i].RevenueCost != null) { list[i].RevenueCost = db.RevenueCostMasters.Find(list[i].RevenueCostMasterID).RevenueComponent; } } } else { list = RevenueDAO.GetMandatoryRevenueUpdateDetail(id); } Session["CreateRevenueUpdate"] = null; return(Json(new { Remarks = inscan.Remarks, PaymentModeId = paymentModeid, InvoiceTo = InvoiceTo, ConsignorId = consignorid, ConsignorName = consignorname, ConsigneeId = consigneeid, ConsigneeName = consigneename, Status = status, Errormessage = errormessage, revenuedetail = list }, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(int id = 0) { int userId = Convert.ToInt32(Session["UserID"].ToString()); ViewBag.Title = "Revenue Update - Create"; ViewBag.employee = db.EmployeeMasters.ToList(); ViewBag.PaymentType = db.tblPaymentModes.ToList(); ViewBag.Currency = db.CurrencyMasters.ToList(); ViewBag.Consignment = db.InScanMasters.ToList(); List <VoucherTypeVM> lsttype = new List <VoucherTypeVM>(); //lsttype.Add(new VoucherTypeVM { TypeName = "All" }); lsttype.Add(new VoucherTypeVM { TypeName = "Shipper" }); lsttype.Add(new VoucherTypeVM { TypeName = "Consignee" }); ViewBag.InvoiceTo = lsttype; RevenueUpdateMasterVM vm = new RevenueUpdateMasterVM(); if (id == 0) { vm.ID = 0; vm.DetailVM = new List <RevenueUpdateDetailVM>(); vm.EntryDate = DateTime.Now; var acc = db.AcHeads.Where(cc => cc.AcHead1 == "Un-invoiced Consignment Note").FirstOrDefault(); if (acc != null) { vm.DebitAccountName = acc.AcHead1; vm.DebitAccountId = acc.AcHeadID; } var pacc = db.AcHeads.Where(cc => cc.AcHead1 == "Pickup Cash Control Account").FirstOrDefault(); if (pacc != null) { vm.DebitCashAccountName = pacc.AcHead1; vm.DebitCashAccountId = pacc.AcHeadID; } var customer = db.CustomerMasters.Where(cc => cc.CustomerType == "COD").FirstOrDefault(); if (customer != null) { vm.DebitCODCustomerId = customer.CustomerID; vm.DebitCODCustomer = customer.CustomerName; } var codacc = db.AcHeads.Where(cc => cc.AcHead1 == "Cod Control A/c.").FirstOrDefault(); if (codacc != null) { vm.DebitCODAccountName = codacc.AcHead1; vm.DebitCODAccountId = codacc.AcHeadID; } vm.CurrencyId = Convert.ToInt32(Session["CurrencyId"].ToString()); var emp = db.EmployeeMasters.Where(cc => cc.UserID == userId).FirstOrDefault(); if (emp != null) { vm.EmployeeID = emp.EmployeeID; } ViewBag.EditMode = "false"; } else { ViewBag.Title = "Revenue Update - Modify"; RevenueUpdateMaster v = db.RevenueUpdateMasters.Find(id); vm.ID = v.ID; vm.EntryDate = v.EntryDate; vm.EmployeeID = v.EmployeeID; vm.InScanID = v.InScanID; vm.BranchID = v.BranchID; vm.CurrencyId = Convert.ToInt32(Session["CurrencyId"].ToString()); vm.AcFinancialYearID = v.AcFinancialYearID; var acc = db.AcHeads.Where(cc => cc.AcHead1 == "Un-invoiced Consignment Note").FirstOrDefault(); if (acc != null) { vm.DebitAccountName = acc.AcHead1; vm.DebitAccountId = acc.AcHeadID; } var pacc = db.AcHeads.Where(cc => cc.AcHead1 == "Pickup Cash Control Account").FirstOrDefault(); if (pacc != null) { vm.DebitCashAccountName = pacc.AcHead1; vm.DebitCashAccountId = pacc.AcHeadID; } var codacc = db.AcHeads.Where(cc => cc.AcHead1 == "Cod Control A/c.").FirstOrDefault(); if (codacc != null) { vm.DebitCODAccountName = codacc.AcHead1; vm.DebitCODAccountId = codacc.AcHeadID; } vm.ConsignmentNo = db.InScanMasters.Find(v.InScanID).ConsignmentNo; ViewBag.EditMode = "true"; } //vm.PickupCashHeadId = db.AcHeads.Where(cc => cc.AcHead1 == "Main Cash Account").FirstOrDefault().AcHead1; return(View(vm)); }
public ActionResult Create(RevenueUpdateMasterVM vm) { ViewBag.Title = "Revenue Update - Create"; int userId = Convert.ToInt32(Session["UserID"].ToString()); ViewBag.employee = db.EmployeeMasters.ToList(); ViewBag.PaymentType = db.tblPaymentModes.ToList(); ViewBag.Currency = db.CurrencyMasters.ToList(); ViewBag.Consignment = db.InScanMasters.ToList(); List <VoucherTypeVM> lsttype = new List <VoucherTypeVM>(); //lsttype.Add(new VoucherTypeVM { TypeName = "All" }); lsttype.Add(new VoucherTypeVM { TypeName = "Shipper" }); lsttype.Add(new VoucherTypeVM { TypeName = "Consignee" }); ViewBag.InvoiceTo = lsttype; int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); RevenueUpdateMaster v = new RevenueUpdateMaster(); bool duplicatecost = false; for (int i = 0; i < vm.DetailVM.Count; i++) { if (vm.DetailVM[i].IsDeleted != true) { for (int j = i + 1; j < vm.DetailVM.Count; j++) { if (vm.DetailVM[i].RevenueCostMasterID == vm.DetailVM[j].RevenueCostMasterID && vm.DetailVM[j].IsDeleted != true) { duplicatecost = true; TempData["ErrorMsg"] = "Revenue Component should not be Duplicated!"; Session["CreateRevenueUpdate"] = vm; ViewBag.Title = "Revenue Update - Modify"; return(View(vm)); } } } } if (vm.ID == 0) { ViewBag.Title = "Revenue Update - Create"; v.EntryDate = vm.EntryDate; v.EmployeeID = vm.EmployeeID; v.InScanID = vm.InScanID; v.BranchID = branchid; v.AcFinancialYearID = fyearid; v.CreatedBy = userId; v.CreatedDate = CommanFunctions.GetCurrentDateTime(); v.ModifiedBy = userId; v.ModifiedDate = CommanFunctions.GetCurrentDateTime(); db.RevenueUpdateMasters.Add(v); db.SaveChanges(); } else { ViewBag.Title = "Revenue Update - Modify"; v = db.RevenueUpdateMasters.Find(vm.ID); v.EntryDate = vm.EntryDate; v.EmployeeID = vm.EmployeeID; v.InScanID = vm.InScanID; v.BranchID = branchid; v.AcFinancialYearID = fyearid; v.ModifiedBy = userId; v.ModifiedDate = CommanFunctions.GetCurrentDateTime(); db.Entry(v).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } for (int i = 0; i < vm.DetailVM.Count; i++) { if (vm.DetailVM[i].IsDeleted != true) { if (vm.DetailVM[i].ID == 0) { RevenueUpdateDetail detail = new RevenueUpdateDetail(); detail.MasterID = v.ID; detail.RevenueCostMasterID = vm.DetailVM[i].RevenueCostMasterID; detail.AcHeadCreditId = vm.DetailVM[i].AcHeadCreditId; detail.AcHeadDebitId = vm.DetailVM[i].AcHeadDebitId; detail.Amount = vm.DetailVM[i].Amount; detail.CurrencyId = vm.DetailVM[i].CurrencyId; detail.CustomerId = vm.DetailVM[i].CustomerId; detail.ExchangeRate = vm.DetailVM[i].ExchangeRate; detail.TaxPercent = vm.DetailVM[i].TaxPercent; detail.TaxAmount = vm.DetailVM[i].TaxAmount; detail.TotalCharge = vm.DetailVM[i].TotalCharge; detail.PaymentModeId = vm.DetailVM[i].PaymentModeId; detail.InvoiceTo = vm.DetailVM[i].InvoiceTo; db.RevenueUpdateDetails.Add(detail); db.SaveChanges(); } else { RevenueUpdateDetail detail = db.RevenueUpdateDetails.Find(vm.DetailVM[i].ID); if (detail != null) { detail.MasterID = v.ID; detail.RevenueCostMasterID = vm.DetailVM[i].RevenueCostMasterID; detail.AcHeadCreditId = vm.DetailVM[i].AcHeadCreditId; detail.AcHeadDebitId = vm.DetailVM[i].AcHeadDebitId; detail.Amount = vm.DetailVM[i].Amount; detail.CurrencyId = vm.DetailVM[i].CurrencyId; detail.CustomerId = vm.DetailVM[i].CustomerId; detail.ExchangeRate = vm.DetailVM[i].ExchangeRate; detail.PaymentModeId = vm.DetailVM[i].PaymentModeId; detail.InvoiceTo = vm.DetailVM[i].InvoiceTo; db.Entry(detail).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } } else { if (vm.DetailVM[i].ID > 0) { RevenueUpdateDetail detail = db.RevenueUpdateDetails.Find(vm.DetailVM[i].ID); db.RevenueUpdateDetails.Remove(detail); db.SaveChanges(); } } } //update inscan revenue update status var inscan = db.InScanMasters.Find(vm.InScanID); inscan.Remarks = vm.Remarks; inscan.RevenueUpdate = true; db.Entry(inscan).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); PickupRequestDAO _dao = new PickupRequestDAO(); _dao.GenerateRevenueUpdatePosting(v.ID); Session["CreateRevenueUpdate"] = null; TempData["SuccessMsg"] = "Revenue of Consignment Updated Successfully!"; return(RedirectToAction("Index")); //ViewBag.Title = "Revenue Update - Create"; //ViewBag.employee = db.EmployeeMasters.ToList(); //List<VoucherTypeVM> lsttype = new List<VoucherTypeVM>(); //lsttype.Add(new VoucherTypeVM { TypeName = "Pickup Cash" }); //lsttype.Add(new VoucherTypeVM { TypeName = "Customer" }); //lsttype.Add(new VoucherTypeVM { TypeName = "Shipper" }); //ViewBag.PaymentType = lsttype; //ViewBag.Currency = db.CurrencyMasters.ToList(); //return View(); }