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