private void ConfirmButton_Click(object sender, RoutedEventArgs e) { OwnerModel owner = (OwnerModel)OwnerList.SelectedItem; if (owner != null) { Revenue = new RevenueModel(); Revenue.Staff = PublicVariables.Staff; Revenue.Store = PublicVariables.Store; Revenue.Date = DateTime.Now; Revenue.TotalMoney = (decimal)RevenueValue.Value; GlobalConfig.RevenueValidator = new RevenueValidator(); ValidationResult result = GlobalConfig.RevenueValidator.Validate(Revenue); if (result.IsValid == false) { MessageBox.Show(result.Errors[0].ErrorMessage); } else { GlobalConfig.Connection.AddRevenueToTheDatabase(Revenue, owner); SetInitialValues(); } } else { MessageBox.Show("Select Owner Please"); } }
public IActionResult Index() { var model = new RevenueModel(); var now = DateTime.Now; var orders = dataContext.Orders.Where(x => x.Status == "đã giao hàng" && x.DateTime >= now.AddDays(-7)).ToList(); model.Total = orders.Sum(x => x.TotalPrice); var dayofweek = new List <DayOfWeek>(new DayOfWeek[] { DayOfWeek.Monday, DayOfWeek.Tuesday, DayOfWeek.Wednesday, DayOfWeek.Thursday, DayOfWeek.Friday, DayOfWeek.Saturday, DayOfWeek.Sunday }); model.Labels = new List <string>(new string[] { "Thứ 2", "Thứ 3", "Thứ 4", "Thứ 5", "Thứ 6", "Thứ 7", "CN" }); model.Values = new List <double>(); foreach (var i in dayofweek) { var ordersInDay = orders != null?orders.Where(x => x.DateTime.DayOfWeek == i).ToList() : null; double sum = ordersInDay != null?ordersInDay.Sum(x => x.TotalPrice) : 0; model.Values.Add(sum); model.MaxValue = sum > model.MaxValue ? sum : model.MaxValue; } return(View(model)); }
/// <summary> /// Fügt dem Datagrid eine neue Zeile mit einem Einkommen hinzu, welches editiert werden kann. /// Anschließend erfolgt ein Commit und ein Refresh. /// /// Author: Antonios Fesenmeier /// </summary> private void addNewRev() { IEnumerable <DB.RevenueType> revTypes = DB.RevenueType.GetRevenueTypes(); var types = revTypes.ToList(); var cbItems = types.ToList().Select(n => new CBItem { Name = n.Name }); List <CBItem> tmpRevTypes = new List <CBItem>(); tmpRevTypes.Add(null); foreach (CBItem cI in cbItems) { tmpRevTypes.Add(cI); } DateTime defaultDate = DateTime.Today; RevenueModel newRev = new RevenueModel(); newRev.revType = tmpRevTypes; newRev.revDescription = ""; newRev.revStartDate = defaultDate; newRev.revEndDate = defaultDate; newRev.revAmount = "0"; newRev.isAdded = false; this._Revenues.Add(newRev); dtgRevenue2.ItemsSource = this._Revenues; dtgRevenue2.CommitEdit(); dtgRevenue2.Items.Refresh(); }
private RevenueModel GetRevenueModel(List <Products> productsList, string month, string year) { int revenue = CalculateRevenuePerMonth(productsList); RevenueModel rm = new RevenueModel { Revenue = revenue, Month = month, Year = year }; return(rm); }
public static RevenueModel ConvertToRevenueModel(UserEventHistory revenue) { RevenueModel revenueModel = new RevenueModel(); revenueModel.EventId = revenue.Event.Id; revenueModel.EndDate = revenue.Event.EndDate.ToString("dd-MM-yyyy"); revenueModel.StartDate = revenue.Event.StartDate.ToString("dd-MM-yyyy"); revenueModel.EventName = revenue.Event.Name; revenueModel.Revenues = revenue.Revenues; revenueModel.NoOfParticipants = revenue.NoOfPersons; return(revenueModel); }
//Get the revenue per month and put it in a list of RevenueModel public List <RevenueModel> GetRevenuePerMonthList() { List <RevenueModel> revenueList = new List <RevenueModel>(); var dates = _productsList.OrderBy(x => x.Date.Month).GroupBy(y => new { y.Date.Month, y.Date.Year }).ToList(); foreach (var date in dates) { List <Products> products = GetProducts(date.Key.Month, date.Key.Year); RevenueModel rm = GetRevenueModel(products, GetMonth(products), GetYear(products)); revenueList.Add(rm); } return(revenueList); }
// GET: Admin/Home public IEnumerable <RevenueModel> GetRevenue() { var revenueList = new List <RevenueModel>(); var listOrderDetail = from orderDetail in _orderDetail.GetAll() join order in _order.GetAll() on orderDetail.OrderId equals order.Id where order.Status == true select new OrderDetailModel { Id = orderDetail.Id, CreateAt = orderDetail.CreateAt, CreateBy = orderDetail.CreateBy.ToString(), OrderId = orderDetail.OrderId, ProductId = orderDetail.ProductId.ToString(), Quantity = orderDetail.Quantity, Status = orderDetail.Status, Price = orderDetail.Price }; var cont = listOrderDetail.Count(); foreach (var item in listOrderDetail) { if (revenueList.Any(x => x.Date.Date == item.CreateAt.Date)) { var revenue = revenueList.Find(x => x.Date.Date == item.CreateAt.Date); revenue.Money += item.Price; } else { var reveneList = new RevenueModel { Date = item.CreateAt, Money = item.Price }; revenueList.Add(reveneList); } } return(revenueList.OrderBy(x => x.Date).ToList()); }
public ActionResult Index() { if (Session["user"] == null) { return(null); } UserModel user = (UserModel)Session["user"]; if (user.Role.IdUserRole == 1) { return(null); } List <RevenueModel> listEventRevenues = new List <RevenueModel>(); List <RevenueModel> listRevenues = new List <RevenueModel>(_iEventBus.GetAllRevenues()); List <EventModel> listEvents = _iEventBus.GetAllEvents(); foreach (EventModel item in listEvents) { RevenueModel itemRevenu = new RevenueModel() { EventId = item.EventId, Revenues = listRevenues.Where(x => x.EventId == item.EventId).Sum(y => y.Revenues), StartDate = item.StartDate, EndDate = item.EndDate, NoOfParticipants = listRevenues.Where(x => x.EventId == item.EventId).Sum(y => y.NoOfParticipants), EventName = item.EventName, Category = item.Category.Name }; listEventRevenues.Add(itemRevenu); } return(View("Index", listEventRevenues)); }
// GET: Revenue public ActionResult Revenue() { if (Session["S_ID"] != null && Session["Role"].ToString() != "Staff") { var revenueDao = new RevenueDao(); //var labels = new List<string>() { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Sep", "Oct", "Nov", "Dec" }; var labels = new List <string>() { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; var labels1 = new List <string>() { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }; var labelsPie = new List <string>() { "Standard", "VIP", "Luxury" }; //test numguest //var data = new List<int>() { 500, 320, 132, 346, 567, 621, 712, 811, 818, 902, 985 }; var data = new List <int>(); var data1 = new List <int>(); var dataPie = new List <int>(); for (int x = 0; x < 12; x++) { data1.Add(revenueDao.GetTotal(x + 1)); } var doanhthu = new BarChart() { Labels = labels, Data = revenueDao.GetNumBook(), max = revenueDao.GetMax(), }; var totaldt = new LineChart() { Labels1 = labels1, Data1 = data1 }; var typeRoom = new PieChart() { LabelsPie = labelsPie, DataPie = revenueDao.GetTRoom(), }; ViewBag.TotalYear = revenueDao.GetTotalYear(); var model = new RevenueModel() { DoanhThuChart = doanhthu, TotalDT = totaldt, TypeRoom = typeRoom }; return(View(model)); } else if (Session["S_ID"] != null) { TempData["ErrorMessage"] = "You are not authorized to access this page"; return(RedirectToAction("Admin_index", "Home")); } else { return(RedirectToAction("Login", "Home")); } }
public ActionResult CreateShippmet(long id) { try { var link = "N/A"; var existShipment = shipmentServices.GetShipmentByOrder(id); var order = salesServices.GetModelById(id); if (existShipment != null) { var statusviews = this.RenderPartialView("_StatusView", order); link = string.Format("<a href=\"/Shipment/Edit/{0}\" target=\"_bank\">{0}</a>", existShipment.Id); return(Json(new { Error = false, RefId = link, view = statusviews }, JsonRequestBehavior.AllowGet)); } var ship = new ShipmentModel() { QtyNumber = 1, QtyUnit = "ship(s)", ServiceName = "Trading", CarrierAirId = 360, Dateshp = order.VoucherDate.ToString(), CneeId = order.Customer.Id, DepartmentId = order.UserCreated.DeptId ?? 0, SaleId = order.UserCreated.Id, CompanyId = order.UserCreated.ComId ?? 0, IsTrading = true, AgentId = 141, VoucherId = id, SaleType = ShipmentModel.SaleTypes.Handle.ToString(),//"Sales", RevenueStatus = ShipmentModel.RevenueStatusCollec.Pending.ToString(), CountryDeparture = 126, DepartureId = 2, CountryDestination = 126, DestinationId = 2, ShipperId = 1754, ServiceId = servicesType.GetId("Trading") }; if (shipmentServices.InsertShipment(ship)) { try { var newShip = shipmentServices.GetShipmentByOrder(id); var amount = (double)order.SumTotal; var funds = (double)order.Amount0; var revenus = new RevenueModel() { INAutoValue1 = amount, INVI = amount, Income = amount, EXManualValue1 = funds, EXVI = funds, Expense = funds, EarningVI = amount - funds, Earning = amount - funds, Id = newShip.Id, InvCurrency1 = order.Curency.Code, InvCurrency2 = order.Curency.Code, InvType1 = "AgentDebit", InvType2 = "AgentCredit", InvAgentId1 = 141, InvAgentId2 = 141, PaidToCarrier = 126, BonRequest = GetBonRequest(newShip.SaleType), SaleType = newShip.SaleType, AutoName1 = "Total exork amount", EXManualName1 = "Cost of sales" }; revenus.AmountBonus2 = Convert.ToDecimal(revenus.BonRequest * revenus.Earning / 100); if (!shipmentServices.UpdateRevenue(revenus)) { shipmentServices.DeleteShipment(newShip.Id); throw new Exception("Not Create Revenue"); } link = string.Format("<a href=\"/Shipment/Edit/{0}\" target=\"_bank\">{0}</a>", newShip.Id); } catch (Exception ex) { Logger.LogError(ex); throw ex; } } else { return(Json(new { Message = "Có lỗi trong lúc tạo shipment lòng liên hệ người quản trị", Error = true })); } var model = salesServices.GetModelById(id); var statusview = this.RenderPartialView("_StatusView", model); return(Json(new { Error = false, RefId = link, view = statusview }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var newShip = shipmentServices.GetShipmentByOrder(id); shipmentServices.DeleteShipment(newShip.Id); Logger.LogError(ex); return(Json(new { Message = ex.Message, Error = true })); } }
public RevenueViewModel() { _data = new RevenueModel(); }
public void fillRevenuesDataGrid(IEnumerable <Revenue> revenues) { //Bisheriger Gesamtbetrag double amount = 0; IEnumerable <DB.RevenueType> revTypes = DB.RevenueType.GetRevenueTypes(); // Combobox mit den RevenueTypes befüllen! var types = revTypes.ToList(); var cbItems = types.ToList().Select(n => new CBItem { Name = n.Name }); List <CBItem> tmpRevTypes = new List <CBItem>(); tmpRevTypes.Add(null); foreach (CBItem cI in cbItems) { tmpRevTypes.Add(cI); } DateTime defaultDate = DateTime.Today; //DB.RevenueDetail revDetail = new RevenueDetail(); //revDetail.Amount = 0; //revDetail.EndDate = defaultDate; //revDetail.StartDate = defaultDate; //vorhandene Revenues eintragen foreach (Revenue rev in revenues) { //Combobox individuell füllen Selektiertes zuerst. List <CBItem> existingRevType = new List <CBItem>(); foreach (CBItem cI in cbItems) { if (cI.Name == rev.RevenueType.Name) { existingRevType.Add(cI); } } foreach (CBItem cI in cbItems) { if (cI.Name != rev.RevenueType.Name) { existingRevType.Add(cI); } } RevenueModel existingRev = new RevenueModel(); existingRev.revType = existingRevType; existingRev.revDescription = rev.Description; existingRev.revAmount = rev.Amount.ToString(); amount += rev.Amount; existingRev.isAdded = true; existingRev.revStartDate = rev.StartDate; existingRev.revEndDate = (DateTime)rev.EndDate; existingRev.revenueID = rev.RevenueID; this._Revenues.Add(existingRev); } //eine Neue Zeile hinzufügen RevenueModel newRev = new RevenueModel(); newRev.revType = tmpRevTypes; newRev.revDescription = ""; newRev.revStartDate = defaultDate; newRev.revEndDate = defaultDate; newRev.revenueID = 0; newRev.revAmount = "0"; newRev.isAdded = false; this._Revenues.Add(newRev); dtgRevenue2.Items.Refresh(); dtgRevenue2.ItemsSource = this._Revenues; dtgRevenue2.Items.Refresh(); //Gesamtbetrag vorbelegen lblAmount.Content = SafeStringParser.safeParseToMoney(amount, true); }