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>());
            }
        }
Пример #2
0
        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);
            }
        }
Пример #3
0
 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);
        }
Пример #5
0
        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());
            }
        }
Пример #7
0
 private void LoadTicketPriceConfig()
 {
     using (ThanhVanTranSysEntities context = new ThanhVanTranSysEntities())
     {
         dgvItemsList.DataSource = context.TicketPriceConfigurations.ToList();
     }
 }
Пример #8
0
        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();
            }
        }
Пример #16
0
        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);
            }
        }
Пример #17
0
        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));
        }
Пример #18
0
        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));
        }
Пример #19
0
        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);
            }
        }
Пример #21
0
        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);
        }
Пример #22
0
        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());
        }
Пример #24
0
        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);
        }
Пример #25
0
        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);
        }
Пример #26
0
        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;
 }