public ActionResult Add() { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); ViewBag.Coupons = coupon.GetRecpientCouponForGroup(); return(View()); }
public ActionResult CouponAdd(int coupontypeid = 0) { ViewBag.coupontypeid = coupontypeid; ViewBag.coupontype = null; if (coupontypeid > 0) { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); ViewBag.coupontype = (coupon.GetCouponType().data as List <ShowCouponTypeInfo>).SingleOrDefault(t => t.ct_coupontypeid == coupontypeid); } ProductCache productCache = RemotingHelp.GetModelObject <ProductCache>(); ViewBag.products = productCache.GetNoRepeatProducts(); return(View()); }
/// <summary> /// 获取用户可用的优惠券列表,前端发起创建订单请求时判断优惠券使用逻辑 /// </summary> /// <param name="uid"></param> /// <returns></returns> public List <ShowCouponInfo> GetCanUseCoupons(int uid) { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); return(coupon.GetCanUseCoupons(uid)); }
/// <summary> /// 用户领用优惠券接口 /// </summary> /// <param name="uid"></param> /// <param name="couponTypeid"></param> public ResultModel RecpientCoupon(int uid, int couponTypeid) { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); return(coupon.RecpientCoupon(uid, couponTypeid)); }
/// <summary> /// 获取首页可领用优惠券列表 /// </summary> /// <returns></returns> public List <ShowCouponTypeInfo> GetRecpientCoupon(int uid) { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); return(coupon.GetRecpientCoupon(uid)); }
public string SaveDataRation(DataTable dt) { string result = "SUCCESS"; using (SEDESOLEntities db = new SEDESOLEntities()) { foreach (DataRow item in dt.Rows) { try { string folio = item["Folio_Comedor"].ToString(); SOUP_KITCHEN sk = db.SOUP_KITCHEN.FirstOrDefault(x => x.Folio == folio); if (sk != null) { int year = Convert.ToInt32(item["Year"].ToString()); int month = Convert.ToInt32(item["Month"].ToString()); // save ration table RATION rat = new RATION(); rat.Description = "carga de excel"; rat.IsActive = true; rat.Id_SoupKitchen = sk.Id; rat.Id_Month = Convert.ToInt32(item["Month"].ToString()); rat.Id_Year = Convert.ToInt32(item["Year"].ToString()); rat.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); rat.CreateUser = "******"; rat.CreateDate = DateTime.Now; rat.HasCoupon = false; db.RATIONs.Add(rat); db.SaveChanges(); var coupList = db.COUPONs.Where(v => v.Id_Year == year && v.Id_Month == month && v.Id_SoupKitchen == sk.Id).ToList(); var yearDto = db.YEARs.FirstOrDefault(v => v.Id == year); int count; if (coupList != null) { count = coupList.Count() + 1; } else { count = 1; } string monthS = string.Empty; //string yearS = string.Empty; if (month.ToString().Count() == 1) { monthS = "0" + month.ToString(); } else { monthS = month.ToString(); } string sequential = sk.Folio + "-" + monthS + yearDto.Description.ToString().Substring(2, 2) + "-" + count.ToString(); COUPON cou = new COUPON(); cou.Description = "carga de excel"; cou.IsActive = true; cou.Id_SoupKitchen = sk.Id; cou.Id_Month = Convert.ToInt32(item["Month"].ToString()); cou.Id_Year = Convert.ToInt32(item["Year"].ToString()); cou.Id_Ration = rat.Id; cou.Sequential = sequential; cou.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); cou.CreateUser = "******"; cou.CreateDate = DateTime.Now; db.COUPONs.Add(cou); db.SaveChanges(); #region Commented update option //RATION rat = db.RATIONs.FirstOrDefault(v => v.Id_Year == year && v.Id_Month == month && v.Id_SoupKitchen == sk.Id); //if (rat != null) //{ // rat.Description = "carga de excel"; // rat.IsActive = true; // rat.Id_SoupKitchen = sk.Id; // rat.Id_Month = Convert.ToInt32(item["Month"].ToString()); // rat.Id_Year = Convert.ToInt32(item["Year"].ToString()); // rat.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // rat.CreateUser = "******"; // rat.CreateDate = DateTime.Now; // rat.HasCoupon = false; // db.SaveChanges(); //} //else //{ // rat = new RATION(); // rat.Description = "carga de excel"; // rat.IsActive = true; // rat.Id_SoupKitchen = sk.Id; // rat.Id_Month = Convert.ToInt32(item["Month"].ToString()); // rat.Id_Year = Convert.ToInt32(item["Year"].ToString()); // rat.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // rat.CreateUser = "******"; // rat.CreateDate = DateTime.Now; // rat.HasCoupon = false; // db.RATIONs.Add(rat); // db.SaveChanges(); //} //COUPON cou = db.COUPONs.FirstOrDefault(v => v.Id_Year == year && v.Id_Month == month && v.Id_SoupKitchen == sk.Id); //COUPON cou = db.COUPONs.FirstOrDefault(v => v.Id_Ration == rat.Id); //if (cou != null) //{ // cou.Description = "carga de excel"; // cou.IsActive = true; // cou.Id_SoupKitchen = sk.Id; // cou.Id_Month = Convert.ToInt32(item["Month"].ToString()); // cou.Id_Year = Convert.ToInt32(item["Year"].ToString()); // cou.Id_Ration = rat.Id; // cou.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // cou.CreateUser = "******"; // cou.CreateDate = DateTime.Now; // //cou.HasCoupon = false; // db.SaveChanges(); //} //else //{ // cou = new COUPON(); // cou.Description = "carga de excel"; // cou.IsActive = true; // cou.Id_SoupKitchen = sk.Id; // cou.Id_Month = Convert.ToInt32(item["Month"].ToString()); // cou.Id_Year = Convert.ToInt32(item["Year"].ToString()); // cou.Id_Ration = rat.Id; // cou.RationQuantity = Convert.ToDecimal(item["Raciones"].ToString()); // cou.CreateUser = "******"; // cou.CreateDate = DateTime.Now; // db.COUPONs.Add(cou); // db.SaveChanges(); //} #endregion } } catch (Exception ex) { return(ex.Message); } } } return(result); }
/// <summary> /// 新增优惠券(后台) /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult AddCouponType(ShowCouponTypeInfo model) { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); return(Json(coupon.AddCouponType(model), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 结束发放优惠券 /// </summary> /// <param name="coupontypeids"></param> /// <returns></returns> public ActionResult StopCoupon(int[] coupontypeids) { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); return(Json(coupon.StopCoupon(coupontypeids), JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取所有的优惠券类型(用于后台配置) /// </summary> /// <returns></returns> public ActionResult GetCouponType() { COUPON coupon = RemotingHelp.GetModelObject <COUPON>(); return(Json(coupon.GetCouponType(), JsonRequestBehavior.AllowGet)); }