public List <TOrderItem> SyncOrderItem() { try { IEnumerable <OrderHistory> changedOrderIds; using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) using (OrderItemBusiness business = new OrderItemBusiness()) { 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 orderItems = (from oi in business.GetAll() join co in changedOrderIds on oi.order_id equals co.order_id select ThriftUtil.ConvertToTOrderItem(oi, co.action == Constants.DELETE_ACTION)).ToList(); return(orderItems); } } catch (Exception exc) { ServerLogger.logError("[SyncOrderItem]", exc); return(new List <TOrderItem>()); } }
protected override void btnSave_Click(object sender, EventArgs e) { try { base.btnSave_Click(sender, e); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { var config = context.Configurations.SingleOrDefault(i => i.id == tbID.Text.Trim()); if (config == null) { return; } config.name = tbName.Text.Trim(); config.value = tbValue.Text.Trim(); config.description = tbRemark.Text.Trim(); context.SaveChanges(); } ChangeViewStatus(false); LoadConfiguration(); } catch (Exception exc) { AppLogger.logError("btnSave_Click", exc); } }
protected void LoadConfiguration() { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { dgvItemsList.DataSource = context.Configurations; } }
public virtual List <User> GetAll(bool ignoreDeleted = true) { List <User> users = new List <User>(); try { AppLogger.logInfo(this.ToString(), string.Format("Begin getting users. Ignore deleted: {0}.", ignoreDeleted.ToString().ToUpperInvariant())); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { users = new List <User>(context.Users.ToList()); users.Sort(delegate(User userA, User userB) { return(userA.user_name.CompareTo(userB.user_name)); }); if (ignoreDeleted) { users = users.Where(user => user.deleted == false).ToList(); } } AppLogger.logInfo(this.ToString(), string.Format("Finish getting users. Found: {0}.", users.Count)); } catch (Exception ex) { AppLogger.logError(this.ToString(), ex); System.Windows.Forms.MessageBox.Show(Constants.Messages.ERROR_OPERATION_NOT_PERFORMED, Constants.Messages.ERROR_CAPTION, System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } return(users); }
protected string InsertObject <T, E>(List <T> TObjectList) where T : TBase where E : EntityObject { string errorMessage = string.Empty; try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { var objectSet = context.CreateObjectSet <E>(); foreach (var tobj in TObjectList) { objectSet.AddObject((E)ThriftUtil.ConvertToEntityObject(tobj)); } context.SaveChanges(); } } catch (Exception exc) { AppLogger.logError("InsertObject", exc); return(exc.Message); } return(errorMessage); }
/// <remarks>must get config follow each role</remarks> public TSystemConfig LoadSystemConfig() { try { TSystemConfig systemConfig = new TSystemConfig(); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { systemConfig.Configurations = context.Configurations.ToList().Select(i => ThriftUtil.ConvertToTConfiguration(i)).ToList(); systemConfig.SaleTicketDates = context.TicketSaleDates.ToList().Select(i => ThriftUtil.ConvertToTSaleTicketDate(i)).ToList(); systemConfig.TicketPrices = context.TicketPriceConfigurations.ToList().Select(i => ThriftUtil.ConvertToTTicketPrice(i)).ToList(); systemConfig.TransportPrices = context.TransportPriceConfigurations.ToList().Select(i => ThriftUtil.ConvertToTTransportPrice(i)).ToList(); systemConfig.GuaranteeFees = context.GuaranteeFeeConfigurations.ToList().Select(i => ThriftUtil.ConvertToTGuaranteeFee(i)).ToList(); systemConfig.Buses = context.Buses.ToList().Select(i => ThriftUtil.ConvertToTBus(i)).ToList(); systemConfig.Tours = context.Tours.ToList().Select(i => ThriftUtil.ConvertToTTour(i)).ToList(); } return(systemConfig); } catch (Exception exc) { ServerLogger.logError("[LoadSystemConfig]", exc); return(new TSystemConfig()); } }
private void LoadTicketPriceConfig() { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { dgvItemsList.DataSource = context.TicketPriceConfigurations.ToList(); } }
protected override void btnDelete_Click(object sender, EventArgs e) { try { base.btnDelete_Click(sender, e); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { TicketPriceConfiguration priceConfig = context.TicketPriceConfigurations.SingleOrDefault(i => i.id == _selectedId && i.seat_class == _selectedClass.ToString()); AppLogger.logInfo("btnDelete_Click", "DELETE", priceConfig); if (priceConfig == null) { return; } context.TicketPriceConfigurations.DeleteObject(priceConfig); LoadTicketPriceConfig(); } } catch (Exception exc) { AppLogger.logError("btnDelete_Click", exc); } }
protected override void btnDelete_Click(object sender, EventArgs e) { try { base.btnDelete_Click(sender, e); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { RevenueDetail revenueDetail = context.RevenueDetails.SingleOrDefault(i => i.id == tbId.Text.Trim()); AppLogger.logInfo("btnSave_Click", "DELETE", revenueDetail); if (revenueDetail != null) { return; } context.RevenueDetails.DeleteObject(revenueDetail); } LoadExpenseDetail(); } catch (Exception exc) { AppLogger.logError("btnDelete_Click", exc); } }
public static string GetConfig(string configId) { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { var config = context.Configurations.SingleOrDefault(i => i.id == configId); return(config == null ? "" : config.value); } }
protected override void btnSave_Click(object sender, EventArgs e) { try { string errorMessage = ValidInput(); if (string.IsNullOrEmpty(errorMessage) == false) { MessageBox.Show(errorMessage, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (MessageBox.Show("Thay đổi thông tin chi tiết của Doanh thu có thể làm thay đổi tổng doanh thu.\r\n Bạn có chắc chắn muốn thay đổi không?" , "Chú ý" , MessageBoxButtons.YesNo , MessageBoxIcon.Warning , MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.No) { return; } base.btnSave_Click(sender, e); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { RevenueDetail expenseDetail = _isUpdating ? context.RevenueDetails.SingleOrDefault(i => i.id == tbId.Text.Trim()) : new RevenueDetail(); expenseDetail.id = IsUpdating ? tbId.Text : IDGenerator.ExpenseId(); expenseDetail.object_id = tbObjectId.Text; expenseDetail.revenue_id = _revenueId; expenseDetail.amount = CurrencyUtil.ToDecimal(tbAmount.Text); expenseDetail.created_by = _isUpdating ? expenseDetail.created_by : SystemParam.CurrentUser.id; expenseDetail.created_date = _isUpdating ? expenseDetail.created_date : dtpCreateDate.Value; expenseDetail.description = tbRemark.Text; expenseDetail.type = cbType.SelectedValue.ToString(); expenseDetail.title = string.Empty; AppLogger.logInfo("btnSave_Click", IsUpdating ? "UPDATE" : "INSERT", expenseDetail); if (IsUpdating == false) { context.RevenueDetails.AddObject(expenseDetail); } context.SaveChanges(); ChangeViewStatus(false); } UpdateExpenseAmount(); LoadExpenseDetail(); } catch (Exception exc) { AppLogger.logError("btnSave_Click", exc); } }
private void LoadExpenseDetail() { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { var RevenueDetails = context.RevenueDetails.Where(i => i.revenue_id == _revenueId).ToList(); dgvFinacial.DataSource = RevenueDetails; tbTotalAmount.Text = CurrencyUtil.ToString(RevenueDetails.Sum(i => i.amount)); } }
public List <TIrregularOrder> SyncIrregularOrder() { try { IEnumerable <OrderHistory> changedOrderIds; using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) using (IrregularOrderBusiness business = new IrregularOrderBusiness()) { //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.ConvertToTIrregularOrder(io, co.action == Constants.DELETE_ACTION)).ToList(); //deleted records orders.AddRange((from o in changedOrderIds where o.action == Constants.DELETE_ACTION select new TIrregularOrder() { 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, RecipientIdNo = string.Empty, RecipientName = string.Empty, RecipientPhone = string.Empty, SenderIdNo = string.Empty, SenderName = string.Empty, SenderPhone = string.Empty, UserReponsitory = string.Empty, TotalCost = 0, TotalQuantity = 0, TotalValue = 0, })); return(orders); } } catch (Exception exc) { ServerLogger.logError("[LoadIrregularOrder]", exc); return(new List <TIrregularOrder>()); } }
public List <TTicket> SyncTicket() { try { IEnumerable <TicketHistory> changedTicketId; using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) using (TicketBusiness business = new TicketBusiness()) { changedTicketId = context.TicketHistories .Where(i => i.changed_date.Year == DateTime.Now.Year && i.changed_date.Month == DateTime.Now.Month && i.changed_date.Day == DateTime.Now.Day) .OrderBy(i => i.ticket_id).ThenBy(i => i.changed_date); //insert/update records var tickets = (from t in business.GetAll() join th in changedTicketId on t.id equals th.ticket_id where t.departure_time >= DateTime.Now select ThriftUtil.ConvertToTTicket(t, th.action == Constants.DELETE_ACTION)).ToList(); //deleted records tickets.AddRange((from th in changedTicketId where th.action == Constants.DELETE_ACTION select new TTicket { TicketId = th.ticket_id, BusId = string.Empty, CusIdNo = string.Empty, CusName = string.Empty, CusPhone = string.Empty, DepartTime = DateTime.Now.ToString(), IsDeleted = true, SeatNo = 0, SeatType = string.Empty, Status = string.Empty, TicketPrice = 0, TourId = string.Empty, UserId = string.Empty })); return(tickets); } } catch (Exception exc) { ServerLogger.logError("[LoadTicket]", exc); return(new List <TTicket>()); } }
protected void UpdateExpenseAmount() { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { Revenue revenue = context.Revenues.SingleOrDefault(i => i.id == _revenueId); if (revenue == null) { throw new Exception("Revenue is not exist: Id = " + _revenueId); } revenue.amount = context.RevenueDetails.Where(i => i.revenue_id == revenue.id).Sum(i => i.amount); context.SaveChanges(); } }
protected override void btnSave_Click(object sender, EventArgs e) { try { string errorMessage = ValidInput(); if (string.IsNullOrEmpty(errorMessage) == false) { MessageBox.Show(errorMessage, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } base.btnSave_Click(sender, e); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { TicketPriceConfiguration priceConfig = context.TicketPriceConfigurations.SingleOrDefault(i => i.id == _selectedId && i.seat_class == _selectedClass); IsUpdating = priceConfig != null; if (priceConfig == null) { priceConfig = new TicketPriceConfiguration(); } priceConfig.id = IsUpdating ? _selectedId : IDGenerator.TicketPriceConfigId(); priceConfig.price = CurrencyUtil.ToDecimal(tbPrice.Text); priceConfig.seat_class = _selectedClass.ToString(); priceConfig.description = tbRemark.Text.Trim(); AppLogger.logInfo("btnSave_Click", IsUpdating ? "UPDATE" : "INSERT", priceConfig); if (IsUpdating == false) { context.TicketPriceConfigurations.AddObject(priceConfig); } context.SaveChanges(); ChangeViewStatus(false); LoadTicketPriceConfig(); } } catch (Exception exc) { AppLogger.logError("btnSave_Click", exc); } }
private decimal LoadRevenues(string year, string month) { List <Revenue> revenues = new List <Revenue>(); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { int tempYear = string.IsNullOrEmpty(year) == false?int.Parse(year) : 0; int tempMonth = string.IsNullOrEmpty(month) == false?int.Parse(month) : 0; revenues = context.Revenues .Where(i => i.created_date.Year == tempYear || string.IsNullOrEmpty(year)) .Where(i => i.created_date.Month == tempMonth || string.IsNullOrEmpty(month)) .ToList(); } dgvRevenue.DataSource = revenues; return(revenues.Sum(i => i.amount)); }
private decimal LoadExpenses(string year, string month) { List <Expense> expenses = new List <Expense>(); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { int tempYear = string.IsNullOrEmpty(year) == false?int.Parse(year) : 0; int tempMonth = string.IsNullOrEmpty(month) == false?int.Parse(month) : 0; expenses = context.Expenses .Where(i => (i.created_date.Year == tempYear || string.IsNullOrEmpty(year) && i.created_date.Month == tempMonth || string.IsNullOrEmpty(month))) .ToList(); } dgvExpenes.DataSource = expenses; return(expenses.Sum(i => i.amount)); }
protected string SyncObject <T, E>(List <T> TObjectList) where T : TBase where E : EntityObject { string errorMessage = string.Empty; try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { var objectSet = context.CreateObjectSet <E>(); foreach (var tobj in TObjectList) { E changeObj = (E)ThriftUtil.ConvertToEntityObject(tobj); string id = typeof(E).GetProperty("id").GetValue(changeObj, null).ToString(); bool isDeleted = bool.Parse(typeof(T).GetProperty("IsDeleted").GetValue(tobj, null).ToString()); E existedEntity = objectSet.ToList().FirstOrDefault(e => typeof(E).GetProperty("id").GetValue(e, null).ToString().Equals(id)); if (existedEntity != null) { objectSet.DeleteObject(existedEntity); } if (isDeleted == false) { objectSet.AddObject(changeObj); } context.SaveChanges(); } } } catch (Exception exc) { AppLogger.logError("SyncObject", exc); return(exc.Message); } return(errorMessage); }
public string UpdateTicket(TTicket tticket, string userId) { try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { DateTime departTime = DateTime.Parse(tticket.DepartTime); var existedTicket = context.Tickets.FirstOrDefault(t => t.bus_id == tticket.BusId && t.departure_time == departTime && t.seat_number == tticket.SeatNo && t.seat_class == tticket.SeatType && t.tour_id == tticket.TourId); if (existedTicket == null || (existedTicket != null && existedTicket.status == Constants.TicketStatus.Cancel.ToString())) { return(Constants.SERVER_ERROR_CODE_SINGLE_DATA_NOT_SYNC + " Vé đã bị xóa!"); } } if (CheckUserPermission(userId, tticket.UserId) == false) { return(Constants.Messages.MSG_TICKET_INSUFFICIENT_PERMISSION); } TicketBusiness business = new TicketBusiness(); Ticket ticket = ThriftUtil.ConvertToEntityObject(tticket) as Ticket; string resultMsg = business.Update(ticket); //notify to the others client station //BroadcastToClient(ClientAction.UpdateTicket,ticket); return(resultMsg); } catch (Exception exc) { ServerLogger.logError("[UpdateTicket]", exc); return(exc.Message); } }
public string InitTickets() { string errorMessage = string.Empty; try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_TICKET); } List <TTicket> ttickets = ServerConnector.GetInstance().LoadTicketRequest(); //TTicket AppLogger.logInfo("InitTickets", "[ttickets]"); errorMessage = InsertObject <TTicket, Ticket>(ttickets); } catch (Exception exc) { AppLogger.logError("InitTickets", exc); return(exc.Message); } return(errorMessage); }
public string InitCustomers() { string errorMessage = string.Empty; try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_CUSTOMER); } List <TCustomer> tcustomers = ServerConnector.GetInstance().LoadCustomerRequest(); //TCustomer AppLogger.logInfo("InitCustomers", "[TCustomer]"); errorMessage = InsertObject <TCustomer, Customer>(tcustomers); } catch (Exception exc) { AppLogger.logError("InitCustomers", exc); return(exc.Message); } return(errorMessage); }
protected string CheckTicketInfo(Ticket ticket) { StringBuilder errorMessage = new StringBuilder(); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { if (context.Buses.Any(i => i.id == ticket.bus_id) == false) { errorMessage.AppendLine(string.Format("Số xe không hợp lệ, mã xe:{0}", ticket.bus_id)).AppendLine("\r\n"); } if ((ticket.seat_number <= Constants.VALUE_SEAT_NUMBER_MAX && ticket.seat_number >= Constants.VALUE_SEAT_NUMBER_MIN) && (ticket.seat_class == Constants.SeatClass.A.ToString() || ticket.seat_class == Constants.SeatClass.B.ToString() || ticket.seat_class == Constants.SeatClass.S.ToString()) == false) { errorMessage.AppendLine(string.Format("Số ghế không hợp lệ, số ghế:{0} - loại:{1}", ticket.seat_number, ticket.seat_class)).AppendLine("\r\n"); } if (ticket.departure_time < DateTime.Now) { errorMessage.AppendLine(string.Format("Ngày đi không được nhỏ hơn ngày hiện tại, Ngày đi:{0}", ticket.departure_time)).AppendLine("\r\n"); } if (context.Buses.Any(i => i.id == ticket.bus_id) == false) { errorMessage.AppendLine(string.Format("Số xe không tồn tại, mã xe:{0}", ticket.bus_id)); } TicketPriceConfigurationBusiness priceBusiness = new TicketPriceConfigurationBusiness(); var priceConfig = priceBusiness.GetBySeatClass(ticket.seat_class); if (priceConfig.price != ticket.cost) { errorMessage.AppendLine(string.Format("{0}Giá vé không phù hợp. Xin thử lại!", Constants.SERVER_ERROR_CODE_CONFIG_DATA_NOT_SYNC)); } } return(errorMessage.ToString()); }
public string InitRegularOrders() { string errorMessage = string.Empty; try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_REGULAR_ORDER); } List <TRegularOrder> tregular = ServerConnector.GetInstance().LoadRegularOrderRequest(); //TransportPrices AppLogger.logInfo("InitRegularOrders", "[TRegularOrder]"); errorMessage = InsertObject <TRegularOrder, RegularOrder>(tregular); } catch (Exception exc) { AppLogger.logError("InitRegularOrders", exc); return(exc.Message); } return(errorMessage); }
public string InitOrderItems() { string errorMessage = string.Empty; try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_ORDER_ITEMS); } List <TOrderItem> torderitem = ServerConnector.GetInstance().LoadOrderItemRequest(); //TOrderItem AppLogger.logInfo("InitOrderItems", "[TOrderItem]"); errorMessage = InsertObject <TOrderItem, OrderItem>(torderitem); } catch (Exception exc) { AppLogger.logError("InitOrderItems", exc); return(exc.Message); } return(errorMessage); }
protected string ClearConfigData() { StringBuilder errorMessage = new StringBuilder(); try { using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_BUS); context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_CONFIGURATION); context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_GUARANTEE_FEE); context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_SALE_TICKET_DATE); context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_TICKET_PRICE); context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_TOUR); context.ExecuteStoreCommand(SqlCommands.QUERY_DELETE_ALL_TRANSPORT_PRICE); } } catch (Exception exc) { AppLogger.logError("ClearData", exc); return(exc.Message); } return(errorMessage.ToString()); }
protected override void btnSave_Click(object sender, EventArgs e) { try { string errorMessage = ValidInput(); if (string.IsNullOrEmpty(errorMessage) == false) { MessageBox.Show(errorMessage, "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } base.btnSave_Click(sender, e); using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities()) { if (_isRevenue) { Revenue revenue = IsUpdating ? context.Revenues.SingleOrDefault(i => i.id == tbId.Text.Trim()) : new Revenue(); revenue.id = IsUpdating ? tbId.Text : IDGenerator.RevenueId(); revenue.name = tbName.Text; revenue.amount = CurrencyUtil.ToDecimal(tbAmount.Text); revenue.created_by = _isUpdating ? revenue.created_by : SystemParam.CurrentUser.id; revenue.created_date = _isUpdating ? revenue.created_date : dtpCreateDate.Value; revenue.description = tbRemark.Text; revenue.type = Constants.RevenueType.Other.ToString(); AppLogger.logInfo("btnSave_Click", IsUpdating ? "UPDATE" : "INSERT", revenue); if (IsUpdating == false) { context.Revenues.AddObject(revenue); } } else { Expense expense = IsUpdating ? context.Expenses.SingleOrDefault(i => i.id == tbId.Text.Trim()) : new Expense(); expense.id = IsUpdating ? tbId.Text : IDGenerator.ExpenseId(); expense.name = tbName.Text; expense.amount = CurrencyUtil.ToDecimal(tbAmount.Text); expense.created_by = _isUpdating ? expense.created_by : SystemParam.CurrentUser.id; expense.created_date = _isUpdating ? expense.created_date : dtpCreateDate.Value; expense.description = tbRemark.Text; expense.type = string.Empty; AppLogger.logInfo("btnSave_Click", IsUpdating ? "UPDATE" : "INSERT", expense); if (IsUpdating == false) { context.Expenses.AddObject(expense); } } context.SaveChanges(); ChangeViewStatus(false); btnSearch_Click(sender, e); } } catch (Exception exc) { AppLogger.logError("btnSave_Click", exc); } }
public GenericRepository(ThanhVanTranSysEntities context) { AppLogger.logDebug(this.ToString(), string.Format("Initializes {0} with context.", this.GetType().ToString())); _context = context; }