public ActionResult DeleteReviewAccountSite(int?user, int accountID, int?reviewSiteID, string reviewURL, bool isActive) { try { string strMessage = ""; bool _success = false; SMIM_ReviewAccountSite_ST Reviewact = new SMIM_ReviewAccountSite_ST(); utility.IsSpecifed <SMIM_ReviewAccountSite_ST>(Reviewact); var respReview = dbUser.GetAllReviewActSiteById(accountID); var respActsiteid = respReview.ReviewActsites.Where(x => x.ReviewSiteID == reviewSiteID).FirstOrDefault(); Reviewact.AccountSiteID = respActsiteid.AccountSiteID; Reviewact.AccountID = respActsiteid.AccountID; Reviewact.ReviewSiteID = respActsiteid.ReviewSiteID; Reviewact.ReviewURL = respActsiteid.ReviewURL; Reviewact.IsActive = respActsiteid.IsActive; int maxValue = dbUser.DeleteReviewAct(Reviewact); if (maxValue > 0) { strMessage = "Record successfully deleted."; _success = true; } else { strMessage = "Application server error."; } return(Json(new { success = _success, response = strMessage })); } catch (Exception ex) { Log.LogWrite(ex.Message, "Review Account Sites Delete", ex); return(Json(new { success = false, response = ex.Message.ToString() })); } }
public int InsertReviewAct(SMIM_ReviewAccountSite_ST InsReview) { try { dbUser.Timeout = System.Threading.Timeout.Infinite; int _AccountSiteID = 0; bool specified = false; Utility util = new Utility(); util.IsSpecifed <SMIM_ReviewAccountSite_ST>(InsReview); dbUser.InsertReviewAct(InsReview, out _AccountSiteID, out specified); //out _Bankid, dbUser.Dispose(); dbUser.Abort(); return(_AccountSiteID); } 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 ActionResult ReviewAccountSite(int?user, int accountID, int reviewSiteID, string reviewURL, bool?isActive) { try { string strMessage = ""; bool _success = false; //SMIM_ReviewAccountSite_ST Reviewact = new SMIM_ReviewAccountSite_ST(); var Reviewact = new SMIM_ReviewAccountSite_ST(); var respReview = dbUser.GetAllReviewActSiteById(accountID); var respActsiteid = respReview.ReviewActsites.Where(x => x.ReviewSiteID == reviewSiteID).FirstOrDefault(); // Select(x => x.AccountSiteID).FirstOrDefault(); if (respActsiteid != null && respActsiteid.AccountSiteID > 0) { utility.IsSpecifed <SMIM_ReviewAccountSite_ST>(Reviewact); Reviewact.AccountSiteID = respActsiteid.AccountSiteID; //Convert.ToInt32(respActsiteid); Reviewact.AccountID = accountID; Reviewact.ReviewSiteID = reviewSiteID; Reviewact.ReviewURL = reviewURL; Reviewact.IsActive = isActive; int maxValue = dbUser.UpdateReviewAct(Reviewact); if (maxValue > 0) { strMessage = "Record successfully updated."; _success = true; } else { strMessage = "Application server error."; } } else { utility.IsSpecifed <SMIM_ReviewAccountSite_ST>(Reviewact); Reviewact.AccountID = accountID; Reviewact.ReviewSiteID = reviewSiteID; Reviewact.ReviewURL = reviewURL; Reviewact.IsActive = isActive; int maxValue = dbUser.InsertReviewAct(Reviewact); Reviewact.AccountSiteID = maxValue; if (maxValue > 0) { strMessage = "Record successfully saved."; _success = true; } else { strMessage = "Application server error."; } } //return Json(new { success = _success, response = strMessage }); return(Json(new { success = _success, response = strMessage })); } catch (Exception ex) { Log.LogWrite(ex.Message, "Review Account Sites Insert/Edit", ex); return(Json(new { success = false, response = ex.Message.ToString() })); } }
public int DeleteReviewAct(SMIM_ReviewAccountSite_ST viewAct) { try { db.Configuration.ProxyCreationEnabled = false; db.Entry(viewAct).State = EntityState.Deleted; db.SaveChanges(); return(Convert.ToInt32(viewAct.AccountSiteID)); } catch (Exception ex) { throw ex; //return 0; } }
public int DeleteReviewAct(SMIM_ReviewAccountSite_ST InsReview) { try { dbUser.Timeout = System.Threading.Timeout.Infinite; int _AccountSiteID = 0; bool specified = false; dbUser.DeleteReviewAct(InsReview, out _AccountSiteID, out specified); dbUser.Dispose(); dbUser.Abort(); return(Convert.ToInt32(InsReview.AccountSiteID)); } catch (Exception ex) { dbUser.Dispose(); dbUser.Abort(); throw ex; } }
public int InsertReviewAct(SMIM_ReviewAccountSite_ST viewAct) { try { db.Configuration.ProxyCreationEnabled = false; int maxActSiteID = 0; if (db.SMIM_ReviewAccountSite_ST.Count() > 0) { maxActSiteID = db.SMIM_ReviewAccountSite_ST.Select(x => x.AccountSiteID).Max(); } maxActSiteID = maxActSiteID + 1; viewAct.AccountSiteID = maxActSiteID; db.SMIM_ReviewAccountSite_ST.Add(viewAct); db.SaveChanges(); return(viewAct.AccountSiteID); } catch (Exception ex) { throw ex; //return 0; } }