public DiscountGroupModel GetDiscountGroup(int id) { DiscountGroupModel model = null; string commandText = @"SELECT dg.ID AS DISCOUNT_GROUP_ID , dg.DG_NAME , (SELECT ',' + cast(sgi.DISCOUNT_ID AS nvarchar(MAX)) AS [text()] FROM DISCOUNT_GROUP_ITEM sgi WHERE sgi.DISCOUNT_GROUP_ID = dg.ID For XML PATH ('') ) + ',' AS DISCOUNT_LIST FROM DISCOUNT_GROUP dg WHERE dg.ID = " + SQLInt(id); using (DataTable dtDiscounts = FillDataTable(commandText)) { if (dtDiscounts.Rows.Count > 0) { DataRow drDiscount = dtDiscounts.Rows[0]; model = new DiscountGroupModel() { DiscountGroupId = TryParse.ToInt32(drDiscount["DISCOUNT_GROUP_ID"]), Name = TryParse.ToString(drDiscount["DG_NAME"]), DiscountList = TryParse.ToString(drDiscount["DISCOUNT_LIST"]) }; } } return(model); }
public void Edit(DiscountGroupModel model) { string commandText = @"UPDATE DISCOUNT_GROUP SET DG_NAME = " + SQLString(model.Name) + @" WHERE ID = " + SQLInt(model.DiscountGroupId); ExecuteNonQuery(commandText); }
public ActionResult JDiscountGroup(int id = 0) { DiscountGroupModel model = null; using (DiscountContext context = new DiscountContext()) { model = context.GetDiscountGroup(id); } return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult EditGroup(int id = 0) { DiscountGroupModel model = null; using (DiscountContext context = new DiscountContext()) { model = context.GetDiscountGroup(id); } return(View("EditGroup", model)); }
public ActionResult NewGroup() { DiscountGroupModel model = new DiscountGroupModel() { DiscountGroupId = 0, Name = "", DiscountList = "," }; return(View("EditGroup", model)); }
public int Add(DiscountGroupModel model) { string commandText = @"INSERT INTO DISCOUNT_GROUP ( DG_NAME ) VALUES (" + SQLString(model.Name) + @") SELECT @@IDENTITY"; model.DiscountGroupId = TryParse.ToInt32(ExecuteScalar(commandText)); return(model.DiscountGroupId); }
public ActionResult EditGroup(DiscountGroupModel model) { if (!ModelState.IsValid) { return(View("EditGroup", model)); } else { using (DiscountContext context = new DiscountContext()) { context.Edit(model); context.SetGroupItems(model.DiscountGroupId, model.DiscountList.Trim(',')); } return(RedirectToAction("Groups")); } }