public List <tblLogisticsSentItems> GetLogisticsReleaselist(tblLogisticsSentItems tblLogisticsSentItems)
{
List <tblLogisticsSentItems> list;
try
{
if (tblLogisticsSentItems.AddedDate != null)
{
var startDate = DateTime.Today;
var endDate = startDate.AddDays(1).AddTicks(-1);
list = _wcmsEntities.tblLogisticsSentItems.Where(a => a.AddedDate >= startDate && a.AddedDate <= endDate).ToList();
}
else
{
list = _wcmsEntities.tblLogisticsSentItems
.WhereIf(tblLogisticsSentItems.BoxCode != null, x => x.BoxCode == tblLogisticsSentItems.BoxCode)
.WhereIf(tblLogisticsSentItems.Imei1 != null, x => x.Imei1 == tblLogisticsSentItems.Imei1)
.WhereIf(tblLogisticsSentItems.Imei2 != null, x => x.Imei2 == tblLogisticsSentItems.Imei2)
.AsNoTracking().ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public bool InsertLogisticsSendData(List <tblLogisticsSentItems> logisticsSendList)
{
try
{
foreach (var tblLogisticsSentItemse in logisticsSendList)
{
//var logisticsSendItems = new tblLogisticsSentItems();
var logisticsSendItems = new tblLogisticsSentItems
{
BoxCode = tblLogisticsSentItemse.BoxCode,
Imei1 = tblLogisticsSentItemse.Imei1,
Imei2 = tblLogisticsSentItemse.Imei2,
Color = tblLogisticsSentItemse.Color,
Model = tblLogisticsSentItemse.Model,
AddedBy = tblLogisticsSentItemse.AddedBy,
AddedDate = tblLogisticsSentItemse.AddedDate
};
_entity.tblLogisticsSentItems.Add(logisticsSendItems);
_entity.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(true);
}
public List <tblLogisticsSentItems> GetLogisticsReleaselist(tblLogisticsSentItems tblLogisticsSentItems)
{
try
{
ISelectingCommon iDataAccessSelect = new DALGetCommonSelecting();
return(iDataAccessSelect.GetLogisticsReleaselist(tblLogisticsSentItems));
}
catch (Exception ex)
{
throw ex;
}
}
