//Filter By BCOID and Driver and ALl batch public DataTable getBranchAcceptanceData1(DateTime date, Guid revenueUnitId, string driver) { BranchAcceptanceBL branchAcceptanceBl = new BranchAcceptanceBL(); ShipmentBL shipmentService = new ShipmentBL(); //List<Shipment> shipments = shipmentService.FilterActive().Where(x => x.AcceptedBy.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList(); //List<BranchAcceptance> branchAcceptance = branchAcceptanceBl.GetAll().Where(x => x.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.RecordStatus == 1 && x.BatchID == batchId).ToList(); List <Shipment> shipments = shipmentService.FilterActive().Where(x => x.AcceptedBy.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.RecordStatus == 1 && x.Booking.BookingStatus.BookingStatusName == "Picked-up").ToList(); //List<BranchAcceptance> branchAcceptance = branchAcceptanceBl.GetAll().Where(x => x.RecordStatus == 1 && x.Users.Employee.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.Users.Employee.AssignedToArea.RevenueUnitId == revenueUnitId && x.Driver == driver && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).Distinct().ToList(); List <BranchAcceptance> branchAcceptance = branchAcceptanceBl.FilterActive().Where(x => x.RecordStatus == 1 && x.Users.Employee.AssignedToArea.RevenueUnitId == revenueUnitId && x.Driver == driver && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).Distinct().ToList(); List <BranchAcceptanceViewModel> list = Match(branchAcceptance, shipments).FindAll(x => x.Area != "N/A" && !x.Area.Contains("Walk-in")); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("No", typeof(string))); dt.Columns.Add(new DataColumn("Area/Branch", typeof(string))); dt.Columns.Add(new DataColumn("Driver", typeof(string))); dt.Columns.Add(new DataColumn("Checker", typeof(string))); dt.Columns.Add(new DataColumn("Plate #", typeof(string))); dt.Columns.Add(new DataColumn("Batch", typeof(string))); dt.Columns.Add(new DataColumn("AWB", typeof(string))); dt.Columns.Add(new DataColumn("Recieved(Qty)", typeof(string))); dt.Columns.Add(new DataColumn("Discrepancy(Qty)", typeof(string))); dt.Columns.Add(new DataColumn("Total Qty", typeof(string))); dt.Columns.Add(new DataColumn("BCO", typeof(string))); dt.Columns.Add(new DataColumn("BSO", typeof(string))); dt.Columns.Add(new DataColumn("ScannedBy", typeof(string))); dt.Columns.Add(new DataColumn("Remarks", typeof(string))); dt.Columns.Add(new DataColumn("Notes", typeof(string))); dt.BeginLoadData(); int ctr = 1; foreach (BranchAcceptanceViewModel item in list.Distinct()) { DataRow row = dt.NewRow(); row[0] = ctr++.ToString(); row[1] = item.Area.ToString(); row[2] = item.Driver.ToString(); row[3] = item.Checker.ToString(); row[4] = item.PlateNo.ToString(); row[5] = item.Batch.ToString(); row[6] = item.AirwayBillNo.ToString(); row[7] = item.TotalRecieved.ToString(); row[8] = item.TotalDiscrepency.ToString(); row[9] = item.Total.ToString(); row[10] = item.BCO; row[11] = item.BSO; row[12] = item.ScannedBy; row[13] = item.Remarks; row[14] = item.Notes; dt.Rows.Add(row); } dt.EndLoadData(); return(dt); }
public List <PickupCargoManifestViewModel> Match(List <Shipment> _shipment) { BranchAcceptanceBL branchAcceptanceBL = new BranchAcceptanceBL(); PackageNumberBL _packageNumberService = new PackageNumberBL(); List <PickupCargoManifestViewModel> _results = new List <PickupCargoManifestViewModel>(); List <PackageNumber> packageList = new List <PackageNumber>(); int numberOfPackage = 0; foreach (Shipment shipment in _shipment) { PickupCargoManifestViewModel model = new PickupCargoManifestViewModel(); try { packageList = _packageNumberService.FilterActive().Where(x => x.ShipmentId == shipment.ShipmentId).Distinct().ToList(); numberOfPackage = packageList.Count; } catch (Exception) { continue; } foreach (PackageNumber number in packageList) { List <BranchAcceptance> branchList = branchAcceptanceBL.FilterActive().Where(x => x.Cargo == number.PackageNo).Distinct().ToList(); foreach (BranchAcceptance branch in branchList) { model.Driver = (branch.Driver != null || branch.Driver != "") ? branch.Driver : "N/A"; model.Checker = (branch.Checker != null || branch.Checker != "") ? branch.Checker : "N/A"; } } PickupCargoManifestViewModel isExist = _results.Find(x => x.AirwayBillNo == shipment.AirwayBillNo); if (isExist != null) { isExist.QTY++; } else { model.AirwayBillNo = shipment.AirwayBillNo; model.Shipper = shipment.Shipper.FullName; model.Consignee = shipment.Consignee.FullName; model.ConsigneeAddress = shipment.Consignee.Address1 + " " + shipment.Consignee.Address2; model.ShipperAddress = shipment.Shipper.Address1 + " " + shipment.Shipper.Address2; model.Commodity = shipment.Commodity.CommodityName; // model.QTY++; model.QTY = numberOfPackage; model.AGW += shipment.Weight; model.ServiceMode = shipment.ServiceMode.ServiceModeName; model.PaymentMode = shipment.PaymentMode.PaymentModeName; model.Amount = shipment.TotalAmount.ToString(); model.ScannedBy = shipment.AcceptedBy.FullName; try { model.Area = (shipment.Booking.AssignedToArea != null) ? shipment.Booking.AssignedToArea.City.CityName : "N/A"; } catch (Exception) { model.Area = "N/A"; } _results.Add(model); } } return(_results); }
//Complete Filter public DataTable getBranchAcceptanceDataByFilter(DateTime date, Guid?revenueUnitId, string driver, Guid?batchId) { RevenueUnitBL revenueunitservice = new RevenueUnitBL(); BatchBL batchservice = new BatchBL(); BranchAcceptanceBL branchAcceptanceBl = new BranchAcceptanceBL(); ShipmentBL shipmentService = new ShipmentBL(); BranchCorpOfficeBL bcoService = new BranchCorpOfficeBL(); //List<Shipment> shipments = shipmentService.FilterActive().Where(x => x.AcceptedBy.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList(); List <Shipment> shipments = shipmentService.FilterActive().Where(x => x.AcceptedBy.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.RecordStatus == 1 && x.Booking.BookingStatus.BookingStatusName == "Picked-up" && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList(); // List<BranchAcceptance> branchAcceptance = branchAcceptanceBl.GetAll().Where(x => x.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.RecordStatus == 1 && x.BatchID == batchId && x.Driver == driver).ToList(); //List<BranchAcceptance> branchAcceptance = branchAcceptanceBl.GetAll().Where(x => x.Users.Employee.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId && x.Users.Employee.AssignedToArea.RevenueUnitId == revenueUnitId && x.RecordStatus == 1 && x.BatchID == batchId && x.Driver == driver && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList(); List <BranchAcceptanceViewModel> list = new List <BranchAcceptanceViewModel>(); List <BranchAcceptance> branchAcceptance = branchAcceptanceBl.FilterActive(). Where( x => x.RecordStatus == 1 //&& ((x.Users.Employee.AssignedToArea.RevenueUnitId == revenueUnitId && x.Users.Employee.AssignedToArea.RevenueUnitId != Guid.Empty) || (x.Users.Employee.AssignedToArea.RevenueUnitId == x.Users.Employee.AssignedToArea.RevenueUnitId && revenueUnitId == Guid.Empty)) && ((x.BatchID == batchId && x.BatchID != Guid.Empty) || (x.BatchID == x.BatchID && batchId == Guid.Empty)) && ((x.Driver == driver && x.Driver != "All") || (x.Driver == x.Driver && driver == "All")) && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList(); string revenueunitname = ""; string batchname = ""; string bcoName = ""; if (batchId != Guid.Empty) { batchname = batchservice.FilterActive().Find(x => x.BatchID == batchId).BatchName; } else { batchname = "All"; } if (revenueUnitId != Guid.Empty) { revenueunitname = revenueunitservice.FilterActive().Find(x => x.RevenueUnitId == revenueUnitId).RevenueUnitName; } else { revenueunitname = "All"; } bcoName = bcoService.FilterActive().Find(x => x.BranchCorpOfficeId == GlobalVars.DeviceBcoId).BranchCorpOfficeName; list = Match(branchAcceptance, shipments). FindAll (x => ((x.Area == revenueunitname && x.Area != "N/A") || (x.Area == x.Area && revenueunitname == "All")) && ((x.Driver == driver && x.Driver != "N/A") || (x.Driver == x.Driver && driver == "All")) && ((x.Batch == batchname && x.Batch != "N/A") || (x.Batch == x.Batch && batchname == "All")) && ((x.BCO == bcoName && x.BCO != "N/A") || (x.BCO == x.BCO && bcoName == "")) && !x.Area.Contains("Walk-in")); //if (revenueUnitId != Guid.Empty && batchId !=Guid.Empty) //{ // batchname = batchservice.GetAll().Find(x => x.BatchID == batchId).BatchName; // revenueunitname = revenueunitservice.GetAll().Find(x => x.RevenueUnitId == revenueUnitId).RevenueUnitName; // list = Match(branchAcceptance, shipments).FindAll(x => x.Area == revenueunitname && x.Batch == batchname); //} //else if (revenueUnitId == Guid.Empty && batchId != Guid.Empty) //{ // batchname = batchservice.GetAll().Find(x => x.BatchID == batchId).BatchName; // list = Match(branchAcceptance, shipments).FindAll(x => x.Batch == batchname && x.Area != "N/A"); //} //else if (revenueUnitId != Guid.Empty && batchId == Guid.Empty) //{ // revenueunitname = revenueunitservice.GetAll().Find(x => x.RevenueUnitId == revenueUnitId).RevenueUnitName; // list = Match(branchAcceptance, shipments).FindAll(x => x.Area == revenueunitname); //} //else //{ // bcoName = bcoService.GetAll().Find(x => x.BranchCorpOfficeId == GlobalVars.DeviceBcoId).BranchCorpOfficeName; // list = Match(branchAcceptance, shipments).FindAll(x => x.BCO == bcoName && x.Area != "N/A"); // //list = Match(branchAcceptance, shipments); //} DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("No", typeof(string))); dt.Columns.Add(new DataColumn("Area/Branch", typeof(string))); dt.Columns.Add(new DataColumn("Driver", typeof(string))); dt.Columns.Add(new DataColumn("Checker", typeof(string))); dt.Columns.Add(new DataColumn("Plate #", typeof(string))); dt.Columns.Add(new DataColumn("Batch", typeof(string))); dt.Columns.Add(new DataColumn("AWB", typeof(string))); dt.Columns.Add(new DataColumn("Recieved(Qty)", typeof(string))); dt.Columns.Add(new DataColumn("Discrepancy(Qty)", typeof(string))); dt.Columns.Add(new DataColumn("Total Qty", typeof(string))); dt.Columns.Add(new DataColumn("BCO", typeof(string))); dt.Columns.Add(new DataColumn("BSO", typeof(string))); dt.Columns.Add(new DataColumn("ScannedBy", typeof(string))); dt.Columns.Add(new DataColumn("Remarks", typeof(string))); dt.Columns.Add(new DataColumn("Notes", typeof(string))); dt.BeginLoadData(); int ctr = 1; foreach (BranchAcceptanceViewModel item in list) { DataRow row = dt.NewRow(); row[0] = ctr++.ToString(); row[1] = item.Area.ToString(); row[2] = item.Driver.ToString(); row[3] = item.Checker.ToString(); row[4] = item.PlateNo.ToString(); row[5] = item.Batch.ToString(); row[6] = item.AirwayBillNo.ToString(); row[7] = item.TotalRecieved.ToString(); row[8] = item.TotalDiscrepency.ToString(); row[9] = item.Total.ToString(); row[10] = item.BCO; row[11] = item.BSO; row[12] = item.ScannedBy; row[13] = item.Remarks; row[14] = item.Notes; dt.Rows.Add(row); } dt.EndLoadData(); return(dt); }