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; } }