public override void OnException(ExceptionContext filterContext) { base.OnException(filterContext); //if (filterContext.ExceptionHandled) //{ try { SemplestEntities _dbContext = new SemplestEntities(); _dbContext.Errors.Add(new Error { ErrorMessage = filterContext.Exception.ToString() }); _dbContext.SaveChanges(); //send email } catch (Exception ex) { Console.WriteLine(ex.ToString()); } // Log filterContext.Exception in some way. //} }
public ActionResult Edit(CustomerAccountWithEmployeeModel m) { SemplestEntities dbcontext = new SemplestEntities(); var user = dbcontext.Users.ToList().Find(p => p.UserPK == m.CustomerAccount.UserPK); user.FirstName = m.CustomerAccount.FirstName; user.LastName = m.CustomerAccount.LastName; user.Email = m.CustomerAccount.Email; user.EditedDate = DateTime.Now; UpdateModel(user); var customer = dbcontext.Customers.ToList().Find(p => p.CustomerPK == m.CustomerAccount.AccountNumber); var customeraddressassociation = dbcontext.CustomerAddressAssociations.ToList().Find(p => p.CustomerFK == customer.CustomerPK); var address = dbcontext.Addresses.ToList().Find(p => p.AddressPK == customeraddressassociation.AddressFK ); address.Address1 = m.CustomerAccount.Address1; address.Address2 = m.CustomerAccount.Address2; address.City = m.CustomerAccount.City; address.ZipCode = m.CustomerAccount.Zip; address.EditedDate = DateTime.Now; address.StateAbbrFK = m.SelectedStateID; UpdateModel(address); dbcontext.SaveChanges(); //Role ro = _dbContext.Roles.Add(new Role { RoleName = f["roleName"].ToString() }); //_dbContext.SaveChanges(); //foreach (sp_GetRigtsRolesInteraction_Result s in userRights) //{ // RolesRightsAssociation ra = new RolesRightsAssociation // { // IsReadonly = s.IsReadonly ==null ? false : bool.Parse(s.IsReadonly.ToString()), IsVisible = s.IsVisible == null ? false : bool.Parse(s.IsVisible.ToString()), RightsFK = s.RightsPK, RolesFK = ro.RolePK // }; // _dbContext.RolesRightsAssociations.Add(ra); //} //_dbContext.SaveChanges(); ////repopulate states ddl //var states = (from sc in dbcontext.StateCodes select sc).ToList(); //m.States = states.Select(r => new SelectListItem // { // Value = r.StateAbbrPK.ToString(), // Text = r.StateAbbr.ToString() // }); ////repopulate reps ddl //var allreps = from e in dbcontext.Employees // join eca in dbcontext.EmployeeCustomerAssociations on e.EmployeePK equals eca.EmployeeFK // join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID // join u in dbcontext.Users on e.UsersFK equals u.UserPK // where (et.EmployeeType1 == "Rep") // select new EmployeeCustomerAssociaitionModel // { // AccountNumber = eca.CustomerFK, // employeePK = e.EmployeePK, // EmployeeType = et.EmployeeType1, // EmployeeUserPK = u.UserPK, // FirstName = u.FirstName, // LastName = u.LastName // }; //List<EmployeeCustomerAssociaitionModel> ll1 = allreps.ToList(); //List<SelectListItem> sl1 = new List<SelectListItem>(); //foreach (EmployeeCustomerAssociaitionModel s in ll1) //{ // SelectListItem mylistitem = new SelectListItem(); // mylistitem.Text = s.FirstName + " " + s.LastName; // mylistitem.Value = s.EmployeeUserPK.ToString(); // sl1.Add(mylistitem); //} //m.Reps = sl1; ////repopulate salepersons ddl ////for reps dropdown //var allsalespersons = from e in dbcontext.Employees // join eca in dbcontext.EmployeeCustomerAssociations on e.EmployeePK equals eca.EmployeeFK // join et in dbcontext.EmployeeTypes on e.EmployeeTypeFK equals et.EmployeeTypeID // join u in dbcontext.Users on e.UsersFK equals u.UserPK // where (et.EmployeeType1 == "Sales") // select new EmployeeCustomerAssociaitionModel // { // AccountNumber = eca.CustomerFK, // employeePK = e.EmployeePK, // EmployeeType = et.EmployeeType1, // EmployeeUserPK = u.UserPK, // FirstName = u.FirstName, // LastName = u.LastName // }; //List<EmployeeCustomerAssociaitionModel> ll2 = allsalespersons.ToList(); //List<SelectListItem> sl2 = new List<SelectListItem>(); //foreach (EmployeeCustomerAssociaitionModel s in ll2) //{ // SelectListItem mylistitem = new SelectListItem(); // mylistitem.Text = s.FirstName + " " + s.LastName; // mylistitem.Value = s.EmployeeUserPK.ToString(); // sl2.Add(mylistitem); //} //m.SalesPersons = sl2; return RedirectToAction("Index"); //return View("index"); //return View(m); }