public DataTable getBundleData(DateTime date)
{
UnbundleBL unbundlebl = new UnbundleBL();
BundleBL bundlebl = new BundleBL();
List <Unbundle> unbundleList = unbundlebl.FilterActive().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
List <Bundle> bundleList = bundlebl.FilterActive().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
List <UnbundleViewModel> modelList = Match(unbundleList, bundleList);
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("No", typeof(string)));
dt.Columns.Add(new DataColumn("Sack No", typeof(string)));
dt.Columns.Add(new DataColumn("Total Pieces", typeof(string)));
dt.Columns.Add(new DataColumn("Scanned Pieces", typeof(string)));
dt.Columns.Add(new DataColumn("Discrepancy Pieces", typeof(string)));
dt.Columns.Add(new DataColumn("Origin", typeof(string)));
dt.Columns.Add(new DataColumn("Weight", typeof(string)));
dt.Columns.Add(new DataColumn("AWB", typeof(string)));
dt.Columns.Add(new DataColumn("CreatedDate", typeof(string)));
dt.Columns.Add(new DataColumn("Branch", typeof(string)));
dt.Columns.Add(new DataColumn("ScannedBy", typeof(string)));
dt.BeginLoadData();
int ctr = 1;
foreach (UnbundleViewModel item in modelList)
{
DataRow row = dt.NewRow();
row[0] = "" + ctr++;
row[1] = item.SackNo;
row[2] = item.TotalPcs;
row[3] = item.ScannedPcs;
row[4] = item.TotalDiscrepency;
row[5] = item.Origin;
row[6] = item.Weight;
row[7] = item.AirwayBillNo;
row[8] = item.CreatedDate;
row[9] = item.Branch;
row[10] = item.ScannedBy;
dt.Rows.Add(row);
}
dt.EndLoadData();
return(dt);
}
public DataTable getBundleData(DateTime date)
{
BundleBL bundleBl = new BundleBL();
List <Bundle> list = bundleBl.FilterActive().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
List <BundleViewModel> bundleList = Match(list);
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("No", typeof(string)));
dt.Columns.Add(new DataColumn("AWB", typeof(string)));
dt.Columns.Add(new DataColumn("Shipper", typeof(string)));
dt.Columns.Add(new DataColumn("Consignee", typeof(string)));
dt.Columns.Add(new DataColumn("Address", typeof(string)));
dt.Columns.Add(new DataColumn("Commodity Type", typeof(string)));
dt.Columns.Add(new DataColumn("Commodity", typeof(string)));
dt.Columns.Add(new DataColumn("Qty", typeof(string)));
dt.Columns.Add(new DataColumn("AGW", typeof(string)));
dt.Columns.Add(new DataColumn("Service Mode", typeof(string)));
dt.Columns.Add(new DataColumn("Payment Mode", typeof(string)));
dt.Columns.Add(new DataColumn("Area", typeof(string)));
dt.Columns.Add(new DataColumn("SackNo", typeof(string)));
dt.Columns.Add(new DataColumn("CreatedDate", typeof(string)));
dt.Columns.Add(new DataColumn("Destination", 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.BeginLoadData();
int ctr = 1;
foreach (BundleViewModel item in bundleList)
{
DataRow row = dt.NewRow();
row[0] = "" + ctr++;
row[1] = item.AirwayBillNo;
row[2] = item.Shipper;
row[3] = item.Consignee;
row[4] = item.Address;
row[5] = item.CommodityType;
row[6] = item.Commodity;
row[7] = item.Qty.ToString();
row[8] = item.AGW.ToString();
row[9] = item.ServiceMode;
row[10] = item.PaymendMode;
row[11] = item.Area;
row[12] = item.SackNo;
row[13] = item.CreatedDate.ToShortDateString();
row[14] = item.Destination;
row[15] = item.BCO;
row[16] = item.BSO;
row[17] = item.Scannedby;
dt.Rows.Add(row);
}
dt.EndLoadData();
return(dt);
}
public List <GatewayTransmitalViewModel> Match(List <GatewayTransmittal> _transmital)
{
List <GatewayTransmitalViewModel> _results = new List <GatewayTransmitalViewModel>();
CommodityBL commodityService = new CommodityBL();
GatewayTransmittalBL transmitalService = new GatewayTransmittalBL();
ShipmentBL shipmentService = new ShipmentBL();
PackageNumberBL _packageNumberService = new PackageNumberBL();
BundleBL bundleService = new BundleBL();
UserStore _userService = new UserStore();
foreach (GatewayTransmittal transmital in _transmital)
{
GatewayTransmitalViewModel model = new GatewayTransmitalViewModel();
Shipment _shipment = new Shipment();
string _airwaybill = "";
//List<string> listCargo = new List<string>();
//List<string> listAirwayBill = new List<string>();
List <Tuple <string, decimal> > listofSack = new List <Tuple <string, decimal> >();
int numberOfCargo = 0;
decimal WeightOfCargo = 0;
decimal totalWeightOfCargo = 0;
_shipment = shipmentService.FilterActive().Where(x => x.AirwayBillNo == transmital.AirwayBillNo).FirstOrDefault();
// _shipment = shipmentService.FilterActive().Where(x => x.AirwayBillNo == transmital.AirwayBillNo && x.Booking.BookedBy.AssignedToArea.City.BranchCorpOffice.BranchCorpOfficeId == GlobalVars.DeviceBcoId).FirstOrDefault();
if (_shipment == null)
{
listofSack = bundleService.FilterActive().Where(x => x.SackNo == transmital.AirwayBillNo).Select(x => new Tuple <string, decimal>(x.Cargo, x.Weight)).ToList();
if (listofSack != null)
{
for (int i = 0; i < listofSack.Count; i++)
{
WeightOfCargo = listofSack[i].Item2;
totalWeightOfCargo += WeightOfCargo;
numberOfCargo++;
}
GatewayTransmitalViewModel model1 = new GatewayTransmitalViewModel();
GatewayTransmitalViewModel isExistSackNo = _results.Find(x => x.AirwayBillNo == transmital.AirwayBillNo);
if (isExistSackNo != null)
{
isExistSackNo.QTY++;
isExistSackNo.AGW += Convert.ToDecimal(totalWeightOfCargo);
}
else
{
model1.AirwayBillNo = transmital.AirwayBillNo;
model1.Shipper = "N/A";
model1.Consignee = "N/A";
model1.Address = "N/A";
model1.CommodityType = transmital.CommodityType.CommodityTypeName;
model1.Commodity = "N/A";
model1.QTY = listofSack.Count;
model1.AGW = Convert.ToDecimal(totalWeightOfCargo);
model1.ServiceMode = "N/A";
model1.PaymentMode = "N/A";
model1.Gateway = transmital.Gateway;
model1.Destination = transmital.BranchCorpOffice.BranchCorpOfficeName;
model1.Batch = transmital.Batch.BatchName;
model1.CreatedDate = transmital.CreatedDate;
model1.PlateNo = transmital.PlateNo;
model1.MAWB = transmital.MasterAirwayBillNo;
//model1.ScannedBy = AppUser.User.Employee.FullName;
model1.ScannedBy = "N/A";
//string employee = _userService.FilterActive().Find(x => x.UserId == _bundle.CreatedBy).Employee.FullName;
string employee = _userService.FindById(transmital.CreatedBy).Employee.FullName;
if (employee != "")
{
model1.ScannedBy = employee;
}
_results.Add(model1);
}
}
}
else
{
_airwaybill = _shipment.AirwayBillNo;
GatewayTransmitalViewModel isExist = _results.Find(x => x.AirwayBillNo == _airwaybill);
if (isExist != null)
{
isExist.QTY++;
isExist.AGW += Convert.ToDecimal(shipmentService.FilterActive().Find(x => x.AirwayBillNo == transmital.AirwayBillNo).Weight);
}
else
{
model.AirwayBillNo = transmital.AirwayBillNo;
model.Shipper = _shipment.Shipper.FullName;
model.Consignee = _shipment.Consignee.FullName;
model.Address = _shipment.Consignee.Address1;
model.CommodityType = transmital.CommodityType.CommodityTypeName;
model.Commodity = _shipment.Commodity.CommodityName;
model.QTY++;
model.AGW = _shipment.Weight;
model.ServiceMode = _shipment.ServiceMode.ServiceModeName;
model.PaymentMode = _shipment.PaymentMode.PaymentModeName;
model.Gateway = transmital.Gateway;
model.Destination = transmital.BranchCorpOffice.BranchCorpOfficeName;
model.Batch = transmital.Batch.BatchName;
model.CreatedDate = transmital.CreatedDate;
model.PlateNo = transmital.PlateNo;
model.MAWB = transmital.MasterAirwayBillNo;
//model.ScannedBy = AppUser.User.Employee.FullName;
model.ScannedBy = "N/A";
//string employee = _userService.FilterActive().Find(x => x.UserId == _bundle.CreatedBy).Employee.FullName;
string employee = _userService.FindById(transmital.CreatedBy).Employee.FullName;
if (employee != "")
{
model.ScannedBy = employee;
}
_results.Add(model);
}
}
}
return(_results);
}
public DataTable getUnbundleDataByFilter(DateTime date, Guid?bcoid, string sackNo, int num)
{
UnbundleBL unbundlebl = new UnbundleBL();
BundleBL bundlebl = new BundleBL();
BranchCorpOfficeBL bcoService = new BranchCorpOfficeBL();
List <Unbundle> unbundleList = new List <Unbundle>();
List <Bundle> bundleList = bundlebl.FilterActive().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
List <UnbundleViewModel> modelList = new List <UnbundleViewModel>();
string sackNum = "";
sackNum = sackNo;
string bcoName = "";
if (bcoid != null && bcoid != Guid.Empty)
{
bcoName = bcoService.FilterActive().Find(x => x.BranchCorpOfficeId == bcoid).BranchCorpOfficeName;
}
if (num == 0)
{
//unbundleList = unbundlebl.GetAll().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString() && x.SackNo == sackNo).ToList();
unbundleList = unbundlebl.FilterActive().Where(x => x.RecordStatus == 1 && x.SackNo == sackNo).ToList();
modelList = Match(unbundleList, bundleList).FindAll(x => x.SackNo == sackNum);
//bundleList = bundlebl.GetAll().Where(x => x.RecordStatus == 1 && x.BranchCorpOfficeID == GlobalVars.DeviceBcoId && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
}
else if (num == 1)
{
unbundleList = unbundlebl.FilterActive().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
modelList = Match(unbundleList, bundleList);
}
else if (num == 2)
{
unbundleList = unbundlebl.FilterActive().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
modelList = Match(unbundleList, bundleList).FindAll(x => x.Branch == bcoName);
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("No", typeof(string)));
dt.Columns.Add(new DataColumn("Sack No", typeof(string)));
dt.Columns.Add(new DataColumn("Total Pieces", typeof(string)));
dt.Columns.Add(new DataColumn("Scanned Pieces", typeof(string)));
dt.Columns.Add(new DataColumn("Discrepancy Pieces", typeof(string)));
dt.Columns.Add(new DataColumn("Origin", typeof(string)));
dt.Columns.Add(new DataColumn("Weight", typeof(string)));
dt.Columns.Add(new DataColumn("AWB", typeof(string)));
dt.Columns.Add(new DataColumn("CreatedDate", typeof(string)));
dt.Columns.Add(new DataColumn("Branch", typeof(string)));
dt.Columns.Add(new DataColumn("ScannedBy", typeof(string)));
dt.BeginLoadData();
int ctr = 1;
foreach (UnbundleViewModel item in modelList)
{
DataRow row = dt.NewRow();
row[0] = "" + ctr++;
row[1] = item.SackNo;
row[2] = item.TotalPcs;
row[3] = item.ScannedPcs;
row[4] = item.TotalDiscrepency;
row[5] = item.Origin;
row[6] = item.Weight;
row[7] = item.AirwayBillNo;
row[8] = item.CreatedDate;
row[9] = item.Branch;
row[10] = item.ScannedBy;
dt.Rows.Add(row);
}
dt.EndLoadData();
return(dt);
}
