public ActionResult Edit(EditCouponModel edtCoupon) { string strPdtNames = Request["PDT_Names"]; string strPdtdiscnt = Request["PDT_Discnt"]; string strPdtofrtype = Request["PDT_OFRTYPE"]; string ImageName, physicalPath, targetPath; // var errors = ModelState //.Where(x => x.Value.Errors.Count > 0) //.Select(x => new { x.Key, x.Value.Errors }) //.ToArray(); if (ModelState.IsValid) { try { var userToUpdateproducts = db.Coupon_Code.SingleOrDefault(u => u.Cupn_Id == edtCoupon.Couponid); if (userToUpdateproducts != null) { // userToUpdateproducts.Coupon_Code = edtCoupon.Coupon_Code; userToUpdateproducts.Cupn_Name = edtCoupon.Coupon_Name; userToUpdateproducts.Description = edtCoupon.Description; userToUpdateproducts.MinQty = Convert.ToInt32(edtCoupon.MinQty); userToUpdateproducts.MaxQty = Convert.ToInt32(edtCoupon.MaxQty); userToUpdateproducts.StartDate = edtCoupon.StartDate; userToUpdateproducts.EndDate = edtCoupon.EndDate; userToUpdateproducts.ModifiedUser = WebSecurity.CurrentUserId; userToUpdateproducts.ModifiedDate = System.DateTime.Now; userToUpdateproducts.user_id = edtCoupon.userid; db.SaveChanges(); } IList<CouponProduct> tvItem = (from p in db.CouponProducts where p.CupnID == edtCoupon.Couponid select p).ToList(); foreach (CouponProduct s in tvItem) { db.CouponProducts.Remove(s); } db.SaveChanges(); foreach (var m in strPdtNames.Split('{')) { if (m != "[") { if (!string.IsNullOrEmpty(m.Split(',')[1].Split(':')[1].ToString().Replace("\"", ""))) { CouponProduct objcupnPdt = new CouponProduct(); objcupnPdt.cupn_No = (db.CouponProducts.Max(i => (int?)i.cupn_No) ?? 0) + 1; objcupnPdt.CupnID = edtCoupon.Couponid; objcupnPdt.DiscountPct = Convert.ToInt32(m.Split(',')[1].Split(':')[1].ToString().Replace("\"", "")); objcupnPdt.OFR_VAL_TYPE = Convert.ToInt32(m.Split(',')[2].Split(':')[1].ToString().Replace("\"", "")); objcupnPdt.ProductID = Convert.ToInt32(m.Split(',')[3].Split(':')[1].ToString().Replace("\"", "")); objcupnPdt.PDT_TYPE = m.Split(',')[4].Split(':')[1].ToString().Replace("\"", "").Replace("}", "").Replace("]", ""); objcupnPdt.Adduser = WebSecurity.CurrentUserId; objcupnPdt.ModifiedUser = WebSecurity.CurrentUserId; objcupnPdt.AddDatetime = System.DateTime.Now; objcupnPdt.ModifiedDate = System.DateTime.Now; db.CouponProducts.Add(objcupnPdt); db.SaveChanges(); } } } TempData["Coupon_Message"] = ConfigurationManager.AppSettings["EDT_SUC"]; return RedirectToAction("Index"); } catch { ViewBag.offers = new SelectList(db.OFFER_VALUE_TYPE, "OFR_VAl_Type_Id", "Ofr_Value_type"); var stands = db.User_Info.ToList().Select(s => new { ID = s.UidNo, Name = string.Format("{0}, {1}", s.First_name, s.Last_name) }); ViewBag.users = new SelectList(stands, "ID", "Name"); return View(); } } ViewBag.offers = new SelectList(db.OFFER_VALUE_TYPE, "OFR_VAl_Type_Id", "Ofr_Value_type"); var stands1 = db.User_Info.ToList().Select(s => new { ID = s.UidNo, Name = string.Format("{0}, {1}", s.First_name, s.Last_name) }); ViewBag.users = new SelectList(stands1, "ID", "Name"); return View(); }
private void EditSetChildren(EditCouponModel model, List<EditCouponModel> userList, int Couponid) { var childs = userList. Where(x => x.parent_name == model.Item_Name).ToList(); if (childs.Count > 0) { foreach (var child in childs) { EditSetChildren(child, userList, Couponid); model.tvlists.Add(child); } } }
public ActionResult Edit(int id = 0) { EditCouponModel editCoupondetails = new EditCouponModel(); var treeview = db.GetTreeView(); List<EditCouponModel> userList=new List<EditCouponModel>(); //userList = (from t in db.TreeviewLists // join S in db.CouponProducts.Where(x => x.CupnID == id) on new { a = t.menu_id, b = t.origin } equals new { a = S.ProductID, b = S.PDT_TYPE } // into tvGroup // from p in tvGroup.DefaultIfEmpty() // //where itemOffer.Cupn_Id == id // select new EditCouponModel // { // id = t.id, // menu_id = t.menu_id, // Parent_Menuid = t.Parent_Menuid, // origin = t.origin, // Item_Name = t.Item_Name, // parent_name = t.parent_name, // Discountpct = (p.DiscountPct == null ? null : p.DiscountPct), // offer_id= (p.OFR_VAL_TYPE == null ? null : p.OFR_VAL_TYPE) // }).ToList(); editCoupondetails = userList. Where(x => x.parent_name == "XYA").FirstOrDefault(); EditSetChildren(editCoupondetails, userList, id); ViewBag.offers = new SelectList(db.OFFER_VALUE_TYPE, "OFR_VAl_Type_Id", "Ofr_Value_type"); var model = from p in db.Coupon_Code where p.Cupn_Id == id select new { p.Cupn_Code, p.Cupn_Name, p.Cupn_Id, p.MinQty, p.MaxQty, p.StartDate, p.EndDate, p.user_id, p.Description }; foreach (var m in model) { // editCoupondetails = new EditCouponModel(); editCoupondetails.Coupon_Code = m.Cupn_Code; editCoupondetails.Coupon_Name = m.Cupn_Name; editCoupondetails.Couponid = m.Cupn_Id; editCoupondetails.MinQty = m.MinQty; editCoupondetails.MaxQty = m.MaxQty; editCoupondetails.StartDate = m.StartDate; editCoupondetails.EndDate = m.EndDate; editCoupondetails.userid = m.user_id; editCoupondetails.Description = m.Description; } var stands = db.User_Info.ToList().Select(s => new { ID = s.UidNo, Name = string.Format("{0}, {1}", s.First_name, s.Last_name) }); ViewBag.users = new SelectList(stands, "ID", "Name", editCoupondetails.userid); return View(editCoupondetails); }