public ActionResult EditDataLink(SDR_QFS_Data data)
{
if (!ModelState.IsValid)
{
return((ActionResult)this.View("MenuItem", (object)data));
}
ViewBag.Message = "EditDataLink";
if (!string.IsNullOrEmpty(data.Data))
{
SDR_QFS_Data sdrQfsData = this._context.SDR_QFS_Data.Find(data.TID);
sdrQfsData.TID = data.TID;
sdrQfsData.GroupID = data.GroupID;
sdrQfsData.TopicID = data.TopicID;
sdrQfsData.Topic = data.Topic;
sdrQfsData.Type = data.Type;
sdrQfsData.SortOrder = data.SortOrder;
sdrQfsData.Description = data.Description;
sdrQfsData.Data = data.Data;
sdrQfsData.Location = data.Location;
sdrQfsData.Format = data.Format;
sdrQfsData.Detail = data.Detail;
this._context.SaveChanges();
}
return(RedirectToAction("MenuItem", new { sortOrder = "", currentFilter = data.Description, searchString = data.Description, page = 1 }));
}
public ActionResult AddItem(DTO_MenuItem newMenuitem, string Hsearch, string Hsortname, string Hsortdata, int Hpage)
{
SDR_QFS_Data sdrQfsData1 = new SDR_QFS_Data();
if (!string.IsNullOrEmpty(newMenuitem.TopicID.ToString()))
{
sdrQfsData1.TopicID = newMenuitem.TopicID;
sdrQfsData1.Description = newMenuitem.Description;
sdrQfsData1.Type = newMenuitem.Type;
sdrQfsData1.Location = newMenuitem.Location;
sdrQfsData1.Data = newMenuitem.Data;
sdrQfsData1.Format = newMenuitem.Format;
sdrQfsData1.Detail = newMenuitem.Detail;
SDR_QFS_Data sdrQfsData2 = sdrQfsData1;
int? sortOrder = newMenuitem.sortOrder;
Decimal? nullable = sortOrder.HasValue ? new Decimal?((Decimal)sortOrder.GetValueOrDefault()) : new Decimal?();
sdrQfsData2.SortOrder = nullable;
this._context.SDR_QFS_Data.Add(sdrQfsData1);
try
{
this._context.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
return(RedirectToAction("MenuItem", new { sortOrder = Hsortname, currentFilter = newMenuitem.Description }));
}
public JsonResult GetSingleLink(SDR_QFS_Data data)
{
if (data.TID <= 0)
{
return(this.Json(null));
}
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@TopicFilter", data.TID) };
var list = RDFacadeExtensions.GetModelFromQuery <SDR_QFS_Data>(_context, "Exec dbo.SDR_QFS_Topic @TopicFilter", parms);
return(Json(list));
}
