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