public List <TRegularOrder> LoadRegularOrder() { try { using (RegularOrderBusiness business = new RegularOrderBusiness()) { return(business.GetAll().ToList().Select(i => ThriftUtil.ConvertToThriftObject(i) as TRegularOrder).ToList()); } } catch (Exception exc) { ServerLogger.logError("[LoadRegularOrder]", exc); return(new List <TRegularOrder>()); } }
public List <TRegularOrder> SyncRegularOrder() { try { IEnumerable <OrderHistory> changedOrderIds; using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) using (RegularOrderBusiness business = new RegularOrderBusiness()) { //insert/update records changedOrderIds = context.OrderHistories .Where(i => i.date_time.Year == DateTime.Now.Year && i.date_time.Month == DateTime.Now.Month && i.date_time.Day == DateTime.Now.Day) .OrderBy(i => i.order_id).ThenBy(i => i.date_time); var orders = (from io in business.GetAll() join co in changedOrderIds on io.id equals co.order_id select ThriftUtil.ConvertToTRegularOrder(io, co.action == Constants.DELETE_ACTION)).ToList(); //deleted records orders.AddRange((from o in changedOrderIds where o.action == Constants.DELETE_ACTION select new TRegularOrder() { OrderId = o.order_id, IsDeleted = true, CloseDate = DateTime.Now.ToString(), CreateBy = string.Empty, CreateDate = DateTime.Now.ToString(), Destination = string.Empty, OrderStaus = string.Empty, PaymentStatus = string.Empty, RecipientId = string.Empty, SenderId = string.Empty, TotalCost = 0, TotalQuantity = 0, TotalValue = 0, })); return(orders); } } catch (Exception exc) { ServerLogger.logError("[LoadRegularOrder]", exc); return(new List <TRegularOrder>()); } }