public ActionResult STakeAwayBill(SearchReportsModel model)
{
try
{
var from = Convert.ToDateTime(model.FromDate);
DateTime to = Convert.ToDateTime(model.ToDate);
int OutletId = getOutletId();
SearchReportsModel m = new SearchReportsModel();
List <tblBillMaster> list = new List <tblBillMaster>();
if (model.TokenNo == null)
{
list = db.tblBillMasters.Where(a => EntityFunctions.TruncateTime(a.BillDate) >= from.Date && EntityFunctions.TruncateTime(a.BillDate) <= to.Date && a.OutletId == OutletId && a.BillingType == "Take Away Hall").ToList();
}
else
{
list = db.tblBillMasters.Where(a => EntityFunctions.TruncateTime(a.BillDate) >= from.Date &&
EntityFunctions.TruncateTime(a.BillDate) <= to.Date &&
a.OutletId == OutletId &&
a.TokenNo == model.TokenNo &&
a.BillingType == "Take Away Hall").ToList();
}
m.getbills = list;
return(View(m));
}
catch
{
ModelState.AddModelError("", "Error Occured");
}
return(View());
}
public ActionResult Report(SearchReportsModel model)
{
try
{
var from = Convert.ToDateTime(model.FromDate);
DateTime to = Convert.ToDateTime(model.ToDate);
// var abc = model.FromDate.Date;
var loginname = WebSecurity.CurrentUserName;
var Outletids = WebSecurity.CurrentUserId;
//var Billdata = (from p in db.tblBillMasters where p.BillDate.Date >= model.FromDate && p.BillDate.Date <= model.ToDate && p.OutletId == Outletids && p.BillingType == "R" select p).ToList();
//var Billdata = db.tblBillMasters.Where(a => EntityFunctions.TruncateTime(a.BillDate) >= from.Date && EntityFunctions.TruncateTime(a.BillDate) <= to.Date && a.OutletId == Outletids && a.BillingType == "R").ToList();
SearchReportsModel m = new SearchReportsModel();
List <tblBillMaster> list = db.tblBillMasters.Where(a => System.Data.Entity.DbFunctions.TruncateTime(a.BillDate) >= from.Date && System.Data.Entity.DbFunctions.TruncateTime(a.BillDate) <= to.Date && a.OutletId == Outletids && (a.BillingType == "Ac Hall" || a.BillingType == "Dine In Hall")).ToList();
m.getbills = list;
return(View(m));
}
catch
{
ModelState.AddModelError("", "Error Occured");
}
return(View());
}
