public void Edit(DiscountGroupModel model)
{
string commandText =
@"UPDATE DISCOUNT_GROUP
SET DG_NAME = " + SQLString(model.Name) + @"
WHERE ID = " + SQLInt(model.DiscountGroupId);
ExecuteNonQuery(commandText);
}
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");
}
}
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 ActionResult NewGroup()
{
DiscountGroupModel model = new DiscountGroupModel()
{
DiscountGroupId = 0,
Name = "",
DiscountList = ","
};
return View("EditGroup", model);
}
