// GET: CODReceipt public ActionResult Index() { DatePicker datePicker = SessionDataModel.GetTableVariable(); DatePicker model = new DatePicker(); //string tz = "Arabian Standard Time"; //DateTime now = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, tz); if (datePicker == null) { model = new DatePicker { FromDate = CommanFunctions.GetFirstDayofMonth().Date, ToDate = CommanFunctions.GetLastDayofMonth().Date //DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59).AddHours(8) // Delete = (bool)Token.Permissions.Deletion, // Update = (bool)Token.Permissions.Updation, // Create = (bool)Token.Permissions.Creation }; } else { model.FromDate = datePicker.FromDate; model.ToDate = datePicker.ToDate; } ViewBag.Token = model; SessionDataModel.SetTableVariable(model); return(View(model)); }
// GET: TruckAssign public ActionResult Index(string TDHNo, string FromDate, string ToDate) { SessionDataModel.ClearTableVariable(); int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); int yearid = Convert.ToInt32(Session["fyearid"].ToString()); DateTime pFromDate; DateTime pToDate; string pTDHNo = ""; if (TDHNo == null) { pTDHNo = ""; } else { pTDHNo = TDHNo; } if (FromDate == null || ToDate == null) { DateTime localDateTime1 = CommanFunctions.GetCurrentDateTime(); pFromDate = localDateTime1.Date; // DateTimeOffset.Now.Date;// CommanFunctions.GetFirstDayofMonth().Date; // DateTime.Now.Date; //.AddDays(-1) ; // FromDate = DateTime.Now; pToDate = CommanFunctions.GetLastDayofMonth().Date.AddDays(1); // DateTime.Now.Date.AddDays(1); // // ToDate = DateTime.Now; } else { pFromDate = Convert.ToDateTime(FromDate); //.AddDays(-1); pToDate = Convert.ToDateTime(ToDate).AddDays(1); } //List<TruckAssignVM> lst = (from truck in db.TruckDetails // join c in db.InScanMasters on truck.TruckDetailID equals c.TruckDetailId // where c.BranchID == branchid && c.DepotID == depotId // && (truck.TDDate >= pFromDate && c.TransactionDate < pToDate) // && (c.CourierStatusID == pStatusId || (pStatusId == 0)) //&& c.CourierStatusID >= 4) // && c.IsDeleted == false // orderby truck.TDDate descending, truck.ReceiptNo descending // select new TruckAssignVM { TruckDetailId = truck.TruckDetailID, TDDate = truck.TDDate, ReceiptNo = truck.ReceiptNo, VechileRegistrationNo = truck.RegNo, ConsignmentNo = c.ConsignmentNo, Consignor = c.Consignor, Consignee = c.Consignee, ConsignorCountryName = c.ConsignorCountryName, ConsigneeCountry = c.ConsigneeCountryName, InScanId = c.InScanID, InScanDate = c.TransactionDate }).ToList(); //, requestsource=subpet3.RequestTypeName List <TruckAssignVM> lst = RevenueDAO.GetTruckDetailConsignments(pTDHNo, "", pFromDate, pToDate); ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); ViewBag.CourierStatus = db.CourierStatus.Where(cc => cc.CourierStatusID >= 4).ToList(); ViewBag.CourierStatusList = db.CourierStatus.Where(cc => cc.CourierStatusID >= 4).ToList(); ViewBag.StatusTypeList = db.tblStatusTypes.ToList(); ViewBag.CourierStatusId = 0; ViewBag.StatusId = pTDHNo; return(View(lst)); }
// GET: SupplierInvoice public ActionResult Index(int?id, string FromDate, string ToDate) { int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); DateTime pFromDate; DateTime pToDate; int suppliertypeid = 0; if (id == null | id == 0) { suppliertypeid = 4; } else { suppliertypeid = Convert.ToInt32(id); } if (FromDate == null || ToDate == null) { pFromDate = CommanFunctions.GetFirstDayofMonth().Date; //.AddDays(-1); // FromDate = DateTime.Now; pToDate = CommanFunctions.GetLastDayofMonth().Date.AddDays(1); // // ToDate = DateTime.Now; } else { pFromDate = Convert.ToDateTime(FromDate); //.AddDays(-1); pToDate = Convert.ToDateTime(ToDate).AddDays(1); } var lst = (from c in db.SupplierInvoices join s in db.SupplierMasters on c.SupplierID equals s.SupplierID orderby c.InvoiceDate descending where s.SupplierTypeID == suppliertypeid where c.InvoiceDate >= pFromDate && c.InvoiceDate < pToDate select new SupplierInvoiceVM { SupplierInvoiceID = c.SupplierInvoiceID, InvoiceNo = c.InvoiceNo, InvoiceDate = c.InvoiceDate, SupplierName = s.SupplierName, Amount = 0, SupplierType = s.SupplierType.SupplierType1, Remarks = s.Remarks }).ToList(); lst.ForEach(d => d.Amount = (from s in db.SupplierInvoiceDetails where s.SupplierInvoiceID == d.SupplierInvoiceID select s).ToList().Sum(a => a.Value)); ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); ViewBag.SupplierType = db.SupplierTypes.ToList(); ViewBag.SupplierTypeId = suppliertypeid; return(View(lst)); }
public ActionResult Index() { CustomerInvoiceSearch obj = (CustomerInvoiceSearch)Session["CustomerInvoiceSearch"]; CustomerInvoiceSearch model = new CustomerInvoiceSearch(); int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); int yearid = Convert.ToInt32(Session["fyearid"].ToString()); if (obj == null) { DateTime pFromDate; DateTime pToDate; //int pStatusId = 0; pFromDate = CommanFunctions.GetFirstDayofMonth().Date; pToDate = CommanFunctions.GetLastDayofMonth().Date; obj = new CustomerInvoiceSearch(); obj.FromDate = pFromDate; obj.ToDate = pToDate; obj.InvoiceNo = ""; Session["CustomerInvoiceSearch"] = obj; model.FromDate = pFromDate; model.ToDate = pToDate; model.InvoiceNo = ""; } else { model = obj; } List <CustomerInvoiceVM> lst = PickupRequestDAO.GetInvoiceList(obj.FromDate, obj.ToDate, model.InvoiceNo, yearid); if (lst != null) { model.InvoiceTotal = Convert.ToDecimal(lst.Sum(cc => cc.InvoiceTotal).ToString()); // ReceiptDAO.GetCustomerInvoiceTotal(obj.FromDate, obj.ToDate); } model.Details = lst; return(View(model)); }
public ActionResult Create(int id = 0) { //List<Invoices> lst = new List<Invoices>(); //ViewBag.Supplier = db.SupplierMasters.OrderBy(x => x.SupplierName).ToList(); //ViewBag.AcHead = db.AcHeads.OrderBy(x => x.AcHead1).ToList(); //ViewBag.Invoice = lst; //return View(); int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); ViewBag.Supplier = db.SupplierMasters.OrderBy(x => x.SupplierName).ToList(); ViewBag.AcHead = db.AcHeads.OrderBy(x => x.AcHead1).ToList(); if (id == 0) { ViewBag.Title = "DEBIT NOTE/SUPPLIER JOURNAL"; DebitNoteVM vm = new DebitNoteVM(); vm.DebitNoteNo = AccountsDAO.GetMaxDebiteNoteNo(fyearid); vm.Date = CommanFunctions.GetLastDayofMonth().Date; vm.AcHeadID = 337; vm.TransType = ""; //vm.AmountType = "1"; //vm.AcDetailAmountType = "0"; List <DebitNoteDetailVM> list = new List <DebitNoteDetailVM>(); vm.Details = list; Session["DebitNoteDetail"] = list; return(View(vm)); } else { ViewBag.Title = "DEBIT NOTE/SUPPLIER JOURNAL - Modify"; DebitNoteVM vm = new DebitNoteVM(); var v = db.DebitNotes.Find(id); vm.DebitNoteId = v.DebitNoteID; vm.Date = v.DebitNoteDate; vm.AcJournalID = Convert.ToInt32(v.AcJournalID); vm.DebitNoteNo = v.DebitNoteNo; vm.SupplierID = Convert.ToInt32(v.SupplierID); vm.AcHeadID = Convert.ToInt32(v.AcHeadID); vm.Amount = Convert.ToDecimal(v.Amount); vm.InvoiceType = v.InvoiceType; vm.Remarks = v.Remarks; vm.TransType = v.TransType; vm.InvoiceID = Convert.ToInt32(v.InvoiceID); if (v.RecPayID != null && v.RecPayID != 0) { vm.RecPayID = Convert.ToInt32(v.RecPayID); } else { vm.RecPayID = 0; } var detaillist = (from c in db.DebitNoteDetails join d in db.AcHeads on c.AcHeadID equals d.AcHeadID where c.DebitNoteID == v.DebitNoteID select new DebitNoteDetailVM { AcHeadID = c.AcHeadID, AcHeadName = d.AcHead1, Amount = c.Amount, Remarks = c.Remarks }).ToList(); vm.Details = detaillist; Session["DebitNoteDetail"] = detaillist; SetTradeInvoiceOfSupplier(vm.SupplierID, 0, vm.DebitNoteId, vm.TransType); List <CustomerTradeReceiptVM> lst = (List <CustomerTradeReceiptVM>)Session["SupplierInvoice"]; if (v.TransType == "DN") { if (v.InvoiceType == "TR") { var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "TR").FirstOrDefault(); //var invoice = db.SupplierInvoices.Find(vm.InvoiceID); if (invoice != null) { vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.AmountPaid = Convert.ToDecimal(invoice.AmountReceived); } } else if (v.InvoiceType == "OP") { var invoice1 = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "OP").FirstOrDefault(); //var invoice1 = db.AcOPInvoiceDetails.Where(cc => cc.AcOPInvoiceDetailID == vm.InvoiceID).FirstOrDefault(); if (invoice1 != null) { vm.InvoiceNo = invoice1.InvoiceNo; vm.InvoiceDate = invoice1.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice1.InvoiceAmount); vm.AmountPaid = Convert.ToDecimal(invoice1.AmountReceived); } } } else if (v.RecPayID != null && v.RecPayID != 0 && v.TransType == "SJ") { vm.InvoiceID = Convert.ToInt32(v.RecPayID); vm.InvoiceType = v.InvoiceType; vm.ForInvoice = true; if (v.InvoiceType == "TR") { var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "TR").FirstOrDefault(); if (invoice != null) { vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.AmountPaid = Convert.ToDecimal(invoice.AmountReceived); } } else if (v.InvoiceType == "OP") { var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "OP").FirstOrDefault(); vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.AmountPaid = Convert.ToDecimal(invoice.AmountReceived); } } else { vm.ForInvoice = false; } //SetTradeInvoiceOfCustomer(vm.CustomerID, 0, vm.CreditNoteID); vm.Date = Convert.ToDateTime(v.DebitNoteDate); return(View(vm)); } }
public ActionResult Create(int id = 0) { int fyearid = Convert.ToInt32(Session["fyearid"].ToString()); //ViewBag.customer = db.CustomerMasters.Where(d => d.CustomerType == "CR").OrderBy(x => x.CustomerName).ToList(); ViewBag.achead = db.AcHeads.ToList(); if (id == 0) { ViewBag.Title = "CREDIT NOTE/CUSTOMER JOURNAL"; CreditNoteVM vm = new CreditNoteVM(); vm.CreditNoteNo = AccountsDAO.GetMaxCreditNoteNo(fyearid); vm.Date = CommanFunctions.GetLastDayofMonth().Date; vm.TransType = ""; vm.AcHeadID = 52; //Customer control account vm.AmountType = "0"; vm.AcDetailAmountType = "1"; List <CreditNoteDetailVM> list = new List <CreditNoteDetailVM>(); vm.Details = list; Session["CreditNoteDetail"] = list; return(View(vm)); } else { ViewBag.Title = "CREDIT NOTE/CUSTOMER JOURNAL - Modify"; CreditNoteVM vm = new CreditNoteVM(); var v = db.CreditNotes.Find(id); vm.CreditNoteID = v.CreditNoteID; vm.CreditNoteNo = v.CreditNoteNo; vm.Date = Convert.ToDateTime(v.CreditNoteDate); vm.AcJournalID = Convert.ToInt32(v.AcJournalID); vm.CustomerID = Convert.ToInt32(v.CustomerID); var customer = db.CustomerMasters.Find(v.CustomerID).CustomerName; if (customer != null) { vm.CustomerName = customer; } vm.AcHeadID = Convert.ToInt32(v.AcHeadID); vm.Amount = Convert.ToDecimal(v.Amount); vm.Description = v.Description; vm.TransType = v.TransType; if (v.RecPayID != null && v.RecPayID != 0) { vm.RecPayID = Convert.ToInt32(v.RecPayID); } else { vm.RecPayID = 0; } var detaillist = (from c in db.CreditNoteDetails join d in db.AcHeads on c.AcHeadID equals d.AcHeadID where c.CreditNoteID == v.CreditNoteID select new CreditNoteDetailVM { AcHeadID = c.AcHeadID, AcHeadName = d.AcHead1, Amount = c.Amount, Remarks = c.Remarks }).ToList(); vm.Details = detaillist; Session["CreditNoteDetail"] = detaillist; if (v.InvoiceID != null && v.InvoiceID != 0 && v.TransType == "CN") { vm.InvoiceID = Convert.ToInt32(v.InvoiceID); vm.InvoiceType = v.InvoiceType; vm.ForInvoice = true; SetTradeInvoiceOfCustomer(vm.CustomerID, 0, vm.CreditNoteID, vm.TransType); List <CustomerTradeReceiptVM> lst = (List <CustomerTradeReceiptVM>)Session["CustomerInvoice"]; if (v.InvoiceType == "TR") { var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "TR").FirstOrDefault(); if (invoice != null) { vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.ReceivedAmount = Convert.ToDecimal(invoice.AmountReceived); } } else if (v.InvoiceType == "OP") { //var invoice1 = db.AcOPInvoiceDetails.Where(cc=>cc.AcOPInvoiceDetailID ==vm.InvoiceID).FirstOrDefault(); //if (invoice1 != null) //{ // vm.InvoiceNo = invoice1.InvoiceNo; // vm.InvoiceDate = Convert.ToDateTime(invoice1.InvoiceDate).ToString("dd/MM/yyyy"); // vm.InvoiceAmount = Convert.ToDecimal(invoice1.Amount); //} var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "OP").FirstOrDefault(); vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.ReceivedAmount = Convert.ToDecimal(invoice.AmountReceived); } } else if (v.RecPayID != null && v.RecPayID != 0 && v.TransType == "CJ") { vm.InvoiceID = Convert.ToInt32(v.RecPayID); vm.InvoiceType = v.InvoiceType; vm.ForInvoice = true; SetTradeInvoiceOfCustomer(vm.CustomerID, 0, vm.CreditNoteID, vm.TransType); List <CustomerTradeReceiptVM> lst = (List <CustomerTradeReceiptVM>)Session["CustomerInvoice"]; if (v.InvoiceType == "TR") { var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "TR").FirstOrDefault(); if (invoice != null) { vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.ReceivedAmount = Convert.ToDecimal(invoice.AmountReceived); } } else if (v.InvoiceType == "OP") { var invoice = lst.Where(cc => cc.SalesInvoiceID == vm.InvoiceID && cc.InvoiceType == "OP").FirstOrDefault(); vm.InvoiceNo = invoice.InvoiceNo; vm.InvoiceDate = invoice.DateTime; vm.InvoiceAmount = Convert.ToDecimal(invoice.InvoiceAmount); vm.ReceivedAmount = Convert.ToDecimal(invoice.AmountReceived); } } else { vm.ForInvoice = false; } vm.Date = Convert.ToDateTime(v.CreditNoteDate); //vm. return(View(vm)); } }
public ActionResult Index(int?StatusId, string FromDate, string ToDate) { ViewBag.Employee = db.EmployeeMasters.ToList(); ViewBag.PickupRequestStatus = db.PickUpRequestStatus.ToList(); int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); DateTime pFromDate; DateTime pToDate; int pStatusId = 0; if (StatusId == null) { pStatusId = 0; } else { pStatusId = Convert.ToInt32(StatusId); } if (FromDate == null || ToDate == null) { pFromDate = CommanFunctions.GetFirstDayofMonth().Date; //.AddDays(-1); // FromDate = DateTime.Now; pToDate = CommanFunctions.GetLastDayofMonth().Date.AddDays(1); // // ToDate = DateTime.Now; } else { pFromDate = Convert.ToDateTime(FromDate);//.AddDays(-1); pToDate = Convert.ToDateTime(ToDate).AddDays(1); } // List<PickupRequestVM> lst = (from c in db.CustomerEnquiries join t1 in db.EmployeeMasters on c.CollectedEmpID equals t1.EmployeeID join t2 in db.EmployeeMasters on c.EmployeeID equals t2.EmployeeID select new PickupRequestVM { EnquiryID = c.EnquiryID, EnquiryDate = c.EnquiryDate, Consignor = c.Consignor, Consignee = c.Consignee, eCollectedBy = t1.EmployeeName, eAssignedTo = t2.EmployeeName,AWBNo=c.AWBNo }).ToList(); //List<PickupRequestVM> lst = (from c in db.CustomerEnquiries // join status in db.PickUpRequestStatus on c.PickupRequestStatusId equals status.Id // join pet in db.EmployeeMasters on c.CollectedEmpID equals pet.EmployeeID into gj // from subpet in gj.DefaultIfEmpty() // join pet1 in db.EmployeeMasters on c.EmployeeID equals pet1.EmployeeID into gj1 // from subpet1 in gj1.DefaultIfEmpty() // where c.EnquiryDate >=pFromDate && c.EnquiryDate <=pToDate // select new PickupRequestVM { EnquiryID = c.EnquiryID, EnquiryNo=c.EnquiryNo, EnquiryDate = c.EnquiryDate, Consignor = c.Consignor, Consignee = c.Consignee, eCollectedBy =subpet.EmployeeName ?? string.Empty, eAssignedTo = subpet1.EmployeeName ?? string.Empty , AWBNo = c.AWBNo ,PickupRequestStatus=status.PickRequestStatus }).ToList(); int Customerid = 0; if (Session["UserType"].ToString() == "Customer") { Customerid = Convert.ToInt32(Session["CustomerId"].ToString()); } List <PickupRequestVM> lst = (from c in db.InScanMasters join statustype in db.tblStatusTypes on c.StatusTypeId equals statustype.ID join status in db.CourierStatus on c.CourierStatusID equals status.CourierStatusID join pet in db.EmployeeMasters on c.PickedUpEmpID equals pet.EmployeeID into gj from subpet in gj.DefaultIfEmpty() join pet1 in db.EmployeeMasters on c.AssignedEmployeeID equals pet1.EmployeeID into gj1 from subpet1 in gj1.DefaultIfEmpty() where c.BranchID == branchid && c.IsEnquiry == true && (c.PickupRequestDate >= pFromDate && c.PickupRequestDate < pToDate) && (c.CourierStatusID == pStatusId || pStatusId == 0) && c.IsDeleted == false && (c.CustomerID == Customerid || Customerid == 0) orderby c.PickupRequestDate descending select new PickupRequestVM { PickupRequestStatusId = c.CourierStatusID, EnquiryID = c.InScanID, EnquiryNo = c.EnquiryNo, EnquiryDate = c.PickupRequestDate, Consignor = c.Consignor, Consignee = c.Consignee, eCollectedBy = subpet.EmployeeName ?? string.Empty, eAssignedTo = subpet1.EmployeeName ?? string.Empty, AWBNo = c.ConsignmentNo, PickupRequestStatus = status.CourierStatus, ShipmentType = statustype.Name }).ToList(); //ViewBag.FromDate = pFromDate.Date.AddDays(1).ToString("dd-MM-yyyy"); ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); ViewBag.PickupRequestStatus = db.CourierStatus.Where(cc => cc.StatusTypeID == 1).ToList(); ViewBag.StatusId = StatusId; return(View(lst)); }
public ActionResult Index(string VehicleType, string FromDate, string ToDate) { ViewBag.Employee = db.EmployeeMasters.ToList(); ViewBag.PickupRequestStatus = db.PickUpRequestStatus.ToList(); int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); DateTime pFromDate; DateTime pToDate; int pStatusId = 0; if (FromDate == null || ToDate == null) { pFromDate = CommanFunctions.GetFirstDayofMonth().Date; //.AddDays(-1); // FromDate = DateTime.Now; pToDate = CommanFunctions.GetLastDayofMonth().Date.AddDays(1); // // ToDate = DateTime.Now; } else { pFromDate = Convert.ToDateTime(FromDate);//.AddDays(-1); pToDate = Convert.ToDateTime(ToDate).AddDays(1); } // List<PickupRequestVM> lst = (from c in db.CustomerEnquiries join t1 in db.EmployeeMasters on c.CollectedEmpID equals t1.EmployeeID join t2 in db.EmployeeMasters on c.EmployeeID equals t2.EmployeeID select new PickupRequestVM { EnquiryID = c.EnquiryID, EnquiryDate = c.EnquiryDate, Consignor = c.Consignor, Consignee = c.Consignee, eCollectedBy = t1.EmployeeName, eAssignedTo = t2.EmployeeName,AWBNo=c.AWBNo }).ToList(); //List<PickupRequestVM> lst = (from c in db.CustomerEnquiries // join status in db.PickUpRequestStatus on c.PickupRequestStatusId equals status.Id // join pet in db.EmployeeMasters on c.CollectedEmpID equals pet.EmployeeID into gj // from subpet in gj.DefaultIfEmpty() // join pet1 in db.EmployeeMasters on c.EmployeeID equals pet1.EmployeeID into gj1 // from subpet1 in gj1.DefaultIfEmpty() // where c.EnquiryDate >=pFromDate && c.EnquiryDate <=pToDate // select new PickupRequestVM { EnquiryID = c.EnquiryID, EnquiryNo=c.EnquiryNo, EnquiryDate = c.EnquiryDate, Consignor = c.Consignor, Consignee = c.Consignee, eCollectedBy =subpet.EmployeeName ?? string.Empty, eAssignedTo = subpet1.EmployeeName ?? string.Empty , AWBNo = c.AWBNo ,PickupRequestStatus=status.PickRequestStatus }).ToList(); int Customerid = 0; if (Session["UserType"].ToString() == "Customer") { Customerid = Convert.ToInt32(Session["CustomerId"].ToString()); } List <TruckDetailVM> lst = (from c in db.TruckDetails //join d in db.DriverMasters on c.DriverID equals d.DriverID //join o in db.LocationMasters on c.OriginName equals o.LocationID //join de in db.LocationMasters on c.DestinationName equals de.LocationID where c.BranchID == branchid && (c.TDDate >= pFromDate && c.TDDate < pToDate) && (c.IsDeleted == false || c.IsDeleted == null) orderby c.TDDate descending select new TruckDetailVM { TruckDetailID = c.TruckDetailID, ReceiptNo = c.ReceiptNo, //DriverName=d.DriverName, Origin = c.OriginName, Destination = c.DestinationName, VehicleType = c.VehicleType, TDDate = c.TDDate, RegNo = c.RegNo, DriverID = c.DriverID, Rent = c.Rent, OtherCharges = c.OtherCharges, TotalCharge = c.Rent + c.OtherCharges }).ToList(); if (!String.IsNullOrEmpty(VehicleType)) { lst = lst.Where(d => d.VehicleType == VehicleType).ToList(); } lst.ForEach(d => d.DriverName = (from s in db.DriverMasters where s.DriverID == d.DriverID select s).FirstOrDefault() == null ? "" : (from s in db.DriverMasters where s.DriverID == d.DriverID select s).FirstOrDefault().DriverName); ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); ViewBag.StatusId = VehicleType; return(View(lst)); }
// GET: RevenueUpdate public ActionResult Index(string pTDNo, string FromDate, string ToDate) { ViewBag.Employee = db.EmployeeMasters.ToList(); ViewBag.PickupRequestStatus = db.PickUpRequestStatus.ToList(); int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); DateTime pFromDate; DateTime pToDate; string TDNo = ""; if (TDNo == null) { TDNo = ""; } else { TDNo = pTDNo; } if (FromDate == null || ToDate == null) { pFromDate = CommanFunctions.GetFirstDayofMonth().Date; //.AddDays(-1); // FromDate = DateTime.Now; pToDate = CommanFunctions.GetLastDayofMonth().Date.AddDays(1); // // ToDate = DateTime.Now; } else { pFromDate = Convert.ToDateTime(FromDate);//.AddDays(-1); pToDate = Convert.ToDateTime(ToDate).AddDays(1); } List <CostUpdateMasterVM> lst = new List <CostUpdateMasterVM>(); if (TDNo == "" || TDNo == null) { lst = (from d in db.CostUpdateMasters join c in db.TruckDetails on d.TruckDetailID equals c.TruckDetailID where (d.EntryDate >= pFromDate && d.EntryDate < pToDate) select new CostUpdateMasterVM { ID = d.ID, EntryDate = d.EntryDate, TDDate = c.TDDate, TDNo = c.ReceiptNo, DriverName = c.DriverName, RegNo = c.RegNo }).ToList(); } else { lst = (from d in db.CostUpdateMasters join c in db.TruckDetails on d.TruckDetailID equals c.TruckDetailID where (c.ReceiptNo == TDNo) select new CostUpdateMasterVM { ID = d.ID, EntryDate = d.EntryDate, TDDate = c.TDDate, TDNo = c.ReceiptNo, DriverName = c.DriverName, RegNo = c.RegNo }).ToList(); } lst.ForEach(d => d.Amount = (from s in db.CostUpdateDetails where s.MasterID == d.ID select s).ToList().Sum(a => a.Amount)); lst = lst.OrderByDescending(cc => cc.TDDate).ToList(); ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); ViewBag.TDNo = TDNo; ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); return(View(lst)); }
// GET: RevenueUpdate public ActionResult Index(string pConsignmentNo, string FromDate, string ToDate) { int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString()); DateTime pFromDate; DateTime pToDate; string ConsignmentNo = ""; if (ConsignmentNo == null) { ConsignmentNo = ""; } else { ConsignmentNo = pConsignmentNo; } if (FromDate == null || ToDate == null) { pFromDate = CommanFunctions.GetFirstDayofMonth().Date; //.AddDays(-1); // FromDate = DateTime.Now; pToDate = CommanFunctions.GetLastDayofMonth().Date.AddDays(1); // // ToDate = DateTime.Now; } else { pFromDate = Convert.ToDateTime(FromDate);//.AddDays(-1); pToDate = Convert.ToDateTime(ToDate).AddDays(1); } int Customerid = 0; if (Session["UserType"].ToString() == "Customer") { Customerid = Convert.ToInt32(Session["CustomerId"].ToString()); } List <RevenueUpdateMasterVM> lst = new List <RevenueUpdateMasterVM>(); //List<RevenueUpdateMasterVM> lst = RevenueDAO.GetRevenueUpdateList(ConsignmentNo, pFromDate, pToDate); if (ConsignmentNo == "" || ConsignmentNo == null) { lst = (from d in db.RevenueUpdateMasters join c in db.InScanMasters on d.InScanID equals c.InScanID where (d.EntryDate >= pFromDate && d.EntryDate < pToDate) select new RevenueUpdateMasterVM { ID = d.ID, ConsignmentDate = d.EntryDate, ConsignmentNo = c.ConsignmentNo, ConsignorName = c.Consignor, ConsigneeName = c.Consignee }).ToList(); } else { lst = (from d in db.RevenueUpdateMasters join c in db.InScanMasters on d.InScanID equals c.InScanID where (c.ConsignmentNo == ConsignmentNo) select new RevenueUpdateMasterVM { ID = d.ID, ConsignmentDate = d.EntryDate, ConsignmentNo = c.ConsignmentNo, ConsignorName = c.Consignor, ConsigneeName = c.Consignee }).ToList(); } lst.ForEach(d => d.Amount = (from s in db.RevenueUpdateDetails where s.MasterID == d.ID select s).ToList().Sum(a => a.Amount)); lst = lst.OrderByDescending(cc => cc.ConsignmentDate).ToList(); ViewBag.FromDate = pFromDate.Date.ToString("dd-MM-yyyy"); ViewBag.ToDate = pToDate.Date.AddDays(-1).ToString("dd-MM-yyyy"); ViewBag.ConsignmentNo = ConsignmentNo; return(View(lst)); }