public ActionResult DaySales(ReportLocal model)
{
var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity;
List <ReportLocalResult> resultArray = new List <ReportLocalResult>();
foreach (var tmp in db.PR_BestSalesDaysReport(model.RestaurantId, DateTime.Parse(model.DateStart), DateTime.Parse(model.DateEnd).AddDays(1), model.Top))
{
ReportLocalResult resultTmp = new ReportLocalResult
{
LocalResult = db.Local.Find(tmp.LocalId),
DayResult = (DateTime)tmp.Day,
TotalResult = (decimal)tmp.Total
};
resultArray.Add(resultTmp);
}
var newModel = new ReportLocal
{
Restaurants = new SelectList(db.PR_RestaurantInfo(identity.User.IdCard).ToList(), "IdRestaurant", "Name"),
RestaurantId = model.RestaurantId,
DateStart = model.DateStart,
DateEnd = model.DateEnd,
Top = model.Top,
Result = resultArray
};
return(View(newModel));
}
public ActionResult AgeSales(ReportLocal model)
{
var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity;
List <ReportLocalResult> resultArray = new List <ReportLocalResult>();
foreach (var tmp in db.PR_SalesAge(model.RestaurantId))
{
ReportLocalResult resultTmp = new ReportLocalResult
{
AgeRange = tmp.AgeRange,
Gender = (tmp.Gender == "M") ? "Male" : "Female",
TotalResult = (decimal)tmp.Total_Sales
};
resultArray.Add(resultTmp);
}
var newModel = new ReportLocal
{
Restaurants = new SelectList(db.PR_LocalRestaurantInfo(identity.User.IdCard).ToList(), "IdLocal", "Name"),
RestaurantId = model.RestaurantId,
Result = resultArray
};
return(View(newModel));
}
public ActionResult SalesDish(ReportLocal model)
{
var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity;
List <ReportLocalResult> resultArray = new List <ReportLocalResult>();
foreach (var tmp in db.PR_DishSalesReport(model.RestaurantId, DateTime.Parse(model.DateStart), DateTime.Parse(model.DateEnd).AddDays(1)))
{
ReportLocalResult resultTmp = new ReportLocalResult
{
DishResult = db.Dish.Find(tmp.ID),
SalesResult = (int)tmp.Quantity,
TotalResult = (decimal)tmp.Total
};
resultArray.Add(resultTmp);
}
var newModel = new ReportLocal
{
Restaurants = new SelectList(db.PR_LocalRestaurantInfo(identity.User.IdCard).ToList(), "IdLocal", "Name"),
RestaurantId = model.RestaurantId,
DateStart = model.DateStart,
DateEnd = model.DateEnd,
Top = model.Top,
Result = resultArray,
Types = db.PR_DishTypes().ToList()
};
return(View(newModel));
}
// GET: Report
public ActionResult AgeSales()
{
var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity;
ReportLocal model = new ReportLocal
{
Restaurants = new SelectList(db.PR_LocalRestaurantInfo(identity.User.IdCard).ToList(), "IdLocal", "Name"),
Result = new List <ReportLocalResult>()
};
return(View(model));
}
// GET: Report
public ActionResult Local()
{
var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity;
ReportLocal model = new ReportLocal();
model.Restaurants = new SelectList(db.PR_RestaurantInfo(identity.User.IdCard).ToList(), "IdRestaurant", "Name");
model.DateStart = DateTime.Now.AddMonths(-1).ToString("yyyy-M-d");
model.DateEnd = DateTime.Now.ToString("yyyy-M-d");
model.Result = new List <ReportLocalResult>();
return(View(model));
}
