public IEnumerable <CouponInfo> GetCoupons(CouponModel model = null)
{
var roles = DbUtil.Db.CurrentUser.UserRoles.Select(uu => uu.Role.RoleName).ToArray();
var q = from c in DbUtil.Db.Coupons
let o = c.Organization
where o.LimitToRole == null || roles.Contains(o.LimitToRole)
where c.DivOrg == model.regidfilter || model.regidfilter == "0" || model.regidfilter == null
where c.UserId == model.useridfilter || model.useridfilter == 0
select c;
switch (model.usedfilter)
{
case "Used":
q = q.Where(c => c.Used != null && c.Canceled == null);
break;
case "UnUsed":
q = q.Where(c => c.Used == null && c.Canceled == null);
break;
case "Canceled":
q = q.Where(c => c.Canceled != null);
break;
}
if (model.name.HasValue())
{
q = q.Where(c => c.Name.Contains(model.name) || c.Person.Name.Contains(model.name));
}
if (model.startdate.HasValue() && model.enddate.HasValue())
{
DateTime bd;
DateTime ed;
if (DateTime.TryParse(model.startdate, out bd) && DateTime.TryParse(model.enddate, out ed))
{
q = q.Where(c => c.Created.Date >= bd && c.Created.Date <= ed);
}
}
var q2 = from c in q
orderby c.Created descending
select new CouponInfo
{
Amount = c.Amount,
Canceled = c.Canceled,
Code = c.Id,
Created = c.Created.FormatDateTm(),
OrgDivName = c.OrgId != null ? c.Organization.OrganizationName : c.Division.Name,
Used = c.Used.FormatDateTm(),
PeopleId = c.PeopleId,
Name = c.Name,
Person = c.Person.Name,
UserId = c.UserId,
UserName = c.User.Name,
RegAmt = c.RegAmount
};
return(q2.Take(200));
}
public ActionResult Create(CouponModel m)
{
if (m.couponcode.HasValue())
if (CouponModel.IsExisting(m.couponcode))
return Content("code already exists");
m.CreateCoupon();
return View(m);
}
public ActionResult Cancel(string id)
{
var c = DbUtil.Db.Coupons.SingleOrDefault(cp => cp.Id == id);
if (!c.Canceled.HasValue)
{
c.Canceled = DateTime.Now;
DbUtil.Db.SubmitChanges();
}
var m = new CouponModel();
return View("List", m);
}
public CouponExcelResult(CouponModel m)
{
this.m = m;
}
public ActionResult List(string submit, CouponModel m)
{
if (submit == "Excel")
return new CouponExcelResult(m);
return View(m);
}
public ActionResult List()
{
var m = new CouponModel();
return View(m);
}
public ActionResult List(string submit, CouponModel m)
{
if (submit == "Excel")
return m.CouponsAsDataTable().ToExcel("Coupons.xlsx");
return View(m);
}