public bool UpdateSiteMap(sitemap siteMapInfo, ref int flag)
{
try
{
using (var db = new expensemanagerportaldbEntities())
{
db.sitemaps.Attach(siteMapInfo);
db.ObjectStateManager.ChangeObjectState(siteMapInfo, EntityState.Modified);
db.SaveChanges();
flag = 0;
return(true);
}
}
catch (Exception ex)
{
XPLUG.WEBTOOLS.ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
if (ex.Message.Contains("Duplicate entry") || ex.InnerException.Message.Contains("Duplicate entry"))
{
flag = -1;
return(false);
}
flag = 1;
return(false);
}
}
public long AddPortalUser(portaluser portaluserInfo)
{
try
{
using (var db = new expensemanagerportaldbEntities())
{
db.AddToportalusers(portaluserInfo);
db.SaveChanges();
return(portaluserInfo.PortalUserId);
}
}
catch (Exception ex)
{
XPLUG.WEBTOOLS.ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public int UpdatePortalUser(portaluser portaluserInfo)
{
try
{
using (var db = new expensemanagerportaldbEntities())
{
db.portalusers.Attach(portaluserInfo);
db.ObjectStateManager.ChangeObjectState(portaluserInfo, EntityState.Modified);
db.SaveChanges();
return(1);
}
}
catch (Exception ex)
{
XPLUG.WEBTOOLS.ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public long AddSiteMap(sitemap siteMapInfo)
{
try
{
using (var db = new expensemanagerportaldbEntities())
{
db.AddTositemaps(siteMapInfo);
db.SaveChanges();
return(siteMapInfo.ID);
}
}
catch (Exception ex)
{
XPLUG.WEBTOOLS.ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
if (ex.Message.Contains("Duplicate entry") || ex.InnerException.Message.Contains("Duplicate entry"))
{
return(-1);
}
return(0);
}
}
public bool DeleteSiteMap(int sitemapId)
{
try
{
using (var db = new expensemanagerportaldbEntities())
{
sitemap myObj = db.sitemaps.Single(s => s.ID == sitemapId);
if (myObj == null)
{
return(false);
}
db.sitemaps.DeleteObject(myObj);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
XPLUG.WEBTOOLS.ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(false);
}
}
public bool DeletePortalUser(long userId)
{
try
{
using (var db = new expensemanagerportaldbEntities())
{
portaluser myObj = db.portalusers.Single(s => s.PortalUserId == userId);
if (myObj == null)
{
return(false);
}
db.portalusers.DeleteObject(myObj);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
XPLUG.WEBTOOLS.ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
return(false);
}
}