public DataTable getData(DateTime date)
{
DeliveryBL deliveryStatusBL = new DeliveryBL();
List <Delivery> list = deliveryStatusBL.GetAll().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
List <DeliveryStatusViewModel> modelList = 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("QTY", typeof(string)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
dt.Columns.Add(new DataColumn("Remarks", typeof(string)));
dt.Columns.Add(new DataColumn("Area", typeof(string)));
dt.Columns.Add(new DataColumn("Driver", typeof(string)));
dt.Columns.Add(new DataColumn("Checker", typeof(string)));
dt.Columns.Add(new DataColumn("Plate No", typeof(string)));
dt.Columns.Add(new DataColumn("Batch", typeof(string)));
dt.Columns.Add(new DataColumn("BCO", typeof(string)));
dt.Columns.Add(new DataColumn("ScannedBy", typeof(string)));
dt.BeginLoadData();
int ctr = 1;
foreach (DeliveryStatusViewModel item in modelList)
{
DataRow row = dt.NewRow();
row[0] = (ctr++).ToString();
row[1] = item.AirwayBillNo;
row[2] = item.QTY.ToString();
row[3] = item.Status;
row[4] = item.Remarks;
row[5] = item.Area;
row[6] = item.Driver;
row[7] = item.Checker;
row[8] = item.PlateNo;
row[9] = item.Batch;
row[10] = item.BCO;
row[11] = item.ScannedBy;
dt.Rows.Add(row);
}
dt.EndLoadData();
return(dt);
}
public DataTable getDataByAllFilter(DateTime date, string revenueUnitName, Guid?deliveredById, Guid?statusId)
{
DeliveryBL deliveryStatusBL = new DeliveryBL();
List <DeliveryStatusViewModel> resultList = new List <DeliveryStatusViewModel>();
List <DeliveryStatusViewModel> modelList = new List <DeliveryStatusViewModel>();
List <Delivery> list = deliveryStatusBL.GetAll().Where
(x => x.RecordStatus == 1 &&
((x.DeliveredBy.EmployeeId == deliveredById && x.DeliveredBy.EmployeeId != Guid.Empty) || (x.DeliveredBy.EmployeeId == x.DeliveredBy.EmployeeId && deliveredById == Guid.Empty)) &&
((x.DeliveryStatus.DeliveryStatusId == statusId && x.DeliveryStatus.DeliveryStatusId != Guid.Empty) || (x.DeliveryStatus.DeliveryStatusId == x.DeliveryStatus.DeliveryStatusId && statusId == Guid.Empty)) &&
x.CreatedDate.ToShortDateString() == date.ToShortDateString()
).ToList();
if (revenueUnitName != "All")
{
modelList = Match(list).FindAll(x => x.Area == revenueUnitName);
}
else
{
modelList = Match(list);
}
//if (num == 1)
//{
// list = deliveryStatusBL.GetAll().Where
// (x => x.RecordStatus == 1
// && x.DeliveredBy.EmployeeId == deliveredById
// && x.DeliveryStatus.DeliveryStatusId == statusId
// //&& x.DeliveredBy.AssignedToArea.RevenueUnitName == revenueUnitName
// && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
// List<DeliveryStatusViewModel> modelList = Match(list);
// resultList = modelList.FindAll(x => x.Area == revenueUnitName);
//}
//else if(num == 2)
//{
// list = deliveryStatusBL.GetAll().Where(x => x.RecordStatus == 1 && x.DeliveryStatus.DeliveryStatusId == statusId && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
// List<DeliveryStatusViewModel> modelList = Match(list);
// resultList = modelList.FindAll(x => x.Area == revenueUnitName);
//}
//else if (num == 3)
//{
// list = deliveryStatusBL.GetAll().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
// List<DeliveryStatusViewModel> modelList = Match(list);
// resultList = modelList.FindAll(x => x.Area == revenueUnitName);
//}
//else if (num == 4)
//{
// list = deliveryStatusBL.GetAll().Where(x => x.RecordStatus == 1 && x.DeliveredBy.EmployeeId == deliveredById && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
// List<DeliveryStatusViewModel> modelList = Match(list);
// resultList = modelList.FindAll(x => x.Area == revenueUnitName);
//}
//else if (num == 5)
//{
// list = deliveryStatusBL.GetAll().Where(x => x.RecordStatus == 1 && x.CreatedDate.ToShortDateString() == date.ToShortDateString()).ToList();
// List<DeliveryStatusViewModel> modelList = Match(list);
// resultList = modelList;
//}
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("QTY", typeof(string)));
dt.Columns.Add(new DataColumn("Status", typeof(string)));
dt.Columns.Add(new DataColumn("Remarks", typeof(string)));
dt.Columns.Add(new DataColumn("Area", typeof(string)));
dt.Columns.Add(new DataColumn("Driver", typeof(string)));
dt.Columns.Add(new DataColumn("Checker", typeof(string)));
dt.Columns.Add(new DataColumn("Plate No", typeof(string)));
dt.Columns.Add(new DataColumn("Batch", typeof(string)));
dt.Columns.Add(new DataColumn("BCO", typeof(string)));
dt.Columns.Add(new DataColumn("ScannedBy", typeof(string)));
dt.Columns.Add(new DataColumn("DeliveredBy", typeof(string)));
dt.Columns.Add(new DataColumn("ReceivedBy", typeof(string)));
dt.BeginLoadData();
int ctr = 1;
//foreach (DeliveryStatusViewModel item in resultList)
foreach (DeliveryStatusViewModel item in modelList)
{
DataRow row = dt.NewRow();
row[0] = (ctr++).ToString();
row[1] = item.AirwayBillNo;
row[2] = item.QTY.ToString();
row[3] = item.Status;
row[4] = item.Remarks;
row[5] = item.Area;
row[6] = item.Driver;
row[7] = item.Checker;
row[8] = item.PlateNo;
row[9] = item.Batch;
row[10] = item.BCO;
row[11] = item.ScannedBy;
row[12] = item.DeliveredBy;
row[13] = item.ReceivedBy;
dt.Rows.Add(row);
}
dt.EndLoadData();
return(dt);
}
