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