public int InsertReviewSites(SMAM_ReviewSites_ST viewSite)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
int _SiteID = 0;
bool specified = false;
Utility util = new Utility();
util.IsSpecifed <SMAM_ReviewSites_ST>(viewSite);
dbUser.InsertReviewSites(viewSite, out _SiteID, out specified); //out _siteID,
dbUser.Dispose();
dbUser.Abort();
return(_SiteID);
}
catch (DbEntityValidationException ex)
{
dbUser.Dispose();
dbUser.Abort();
StringBuilder sb = new StringBuilder();
foreach (var eve in ex.EntityValidationErrors)
{
sb.AppendLine(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name,
eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
sb.AppendLine(string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName,
ve.ErrorMessage));
}
}
throw new DbEntityValidationException(sb.ToString(), ex);
}
}
public int DeleteReviewSites(SMAM_ReviewSites_ST viewSite)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
db.Entry(viewSite).State = EntityState.Deleted;
db.SaveChanges();
return(Convert.ToInt32(viewSite.SiteID));
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
public ActionResult ReviewSites(int?user, SMAM_ReviewSites_ST viewSite)
{
try
{
string strMessage = "";
bool _success = false;
if (viewSite.SiteID > 0)
{
utility.IsSpecifed <SMAM_ReviewSites_ST>(viewSite);
int maxValue = dbUser.UpdateReviewSites(viewSite);
if (maxValue > 0)
{
strMessage = "Record successfully updated.";
_success = true;
}
else
{
strMessage = "Application server error.";
}
}
else
{
utility.IsSpecifed <SMAM_ReviewSites_ST>(viewSite);
int maxValue = dbUser.InsertReviewSites(viewSite);
viewSite.SiteID = maxValue;
if (maxValue > 0)
{
strMessage = "Record successfully saved.";
_success = true;
}
else
{
strMessage = "Application server error.";
}
}
return(Json(new { success = _success, response = strMessage }));
}
catch (Exception ex)
{
Log.LogWrite(ex.Message, "Review Sites Insert/Edit", ex);
return(Json(new { success = false, response = ex.Message.ToString() }));
}
}
public int DeleteReviewSites(SMAM_ReviewSites_ST viewSite)
{
try
{
dbUser.Timeout = System.Threading.Timeout.Infinite;
int _SiteID = 0;
bool specified = false;
dbUser.DeleteReviewSites(viewSite, out _SiteID, out specified);
dbUser.Dispose();
dbUser.Abort();
return(Convert.ToInt32(viewSite.SiteID));
}
catch (Exception ex)
{
dbUser.Dispose();
dbUser.Abort();
throw ex;
}
}
public int InsertReviewSites(SMAM_ReviewSites_ST viewSite)
{
try
{
db.Configuration.ProxyCreationEnabled = false;
int maxSiteID = 0;
if (db.SMAM_ReviewSites_ST.Count() > 0)
{
maxSiteID = db.SMAM_ReviewSites_ST.Select(x => x.SiteID).Max();
}
maxSiteID = maxSiteID + 1;
viewSite.SiteID = maxSiteID;
db.SMAM_ReviewSites_ST.Add(viewSite);
db.SaveChanges();
return(viewSite.SiteID);
}
catch (Exception ex)
{
throw ex;
//return 0;
}
}
