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