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