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