public int SaveLink(LinkSetup_InsertModel LI) { DataSet ds = new DataSet(); try { using (QuickCheck_AngularEntities Dc = new QuickCheck_AngularEntities()) { if (LI.LinkID == 0) { Tbl_Links TL = new Tbl_Links(); TL.LinkName = LI.LinkName; TL.IsActive = LI.IsActive; TL.IconName = LI.IconName; TL.OrderNo = LI.OrderNo; TL.Purpose = LI.Purpose; TL.url = LI.url; TL.ParetmenuID = LI.ParentMenuID; TL.IsDeleted = !LI.IsActive; TL.CreatedOn = DateTime.Now; TL.ModifiedOn = new DateTime(1900, 1, 1); Dc.Tbl_Links.Add(TL); Dc.SaveChanges(); } else { var _R = Dc.Tbl_Links.Where(d => d.LinkID == LI.LinkID); foreach (var k in _R) { k.LinkName = LI.LinkName; k.IsActive = LI.IsActive; k.IconName = LI.IconName; k.OrderNo = LI.OrderNo; k.Purpose = LI.Purpose; k.url = LI.url; k.ParetmenuID = LI.ParentMenuID; k.IsDeleted = !LI.IsActive; // k.CreatedOn = DateTime.Now; k.ModifiedOn = DateTime.Now; } Dc.SaveChanges(); } } return(1); } catch (Exception ex) { return(0); } }
public Dictionary <string, object> SaveParentmenuItem(string ParentmenuItem) { try { using (QuickCheck_AngularEntities Dc = new QuickCheck_AngularEntities()) { var _ParentName = (from p in Dc.TblParentMenus where p.ParentMenuName == ParentmenuItem select ParentmenuItem).ToList(); if (_ParentName.Count == 0 && (ParentmenuItem != null || ParentmenuItem != "")) { TblParentMenu TP = new TblParentMenu(); TP.CreatedBy = 2; TP.CreatedOn = DateTime.Now; TP.IsActive = true; TP.IsDeleted = false; TP.OrderNo = (Dc.TblParentMenus.DefaultIfEmpty().Max(p => p == null ? 0 : p.OrderNo) + 1);// (Dc.TblParentMenus.Select(x => x.OrderNo == null ? 0 : x.OrderNo).Max() + 1); TP.ParentMenuName = ParentmenuItem; Dc.TblParentMenus.Add(TP); Dc.SaveChanges(); } var _Parent = (from LS in Dc.TblParentMenus where LS.IsActive == true select new { LS.ParentID, LS.ParentMenuName }); DataTable dtParent = Common.LINQResultToDataTable(_Parent); dtParent.TableName = "Table"; return(ClsJson.JsonMethods.ToJson(dtParent)); } } catch (Exception ex) { return(null); } }