public ActionResult Registration(Entities.Models.AccessCode obj) { try { // log active Models.LogModels.CreateUserLog("Registration_Registration", (int)Session["UID"], Request.UserHostAddress); var r = objUserAccess.Update(obj); return(Content(r)); } catch (Exception exception) { return(Content(exception.Message)); } }
public string Update(Entities.Models.AccessCode obj) { var result = ""; try { using (var scope = new TransactionScope()) { SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@AccessCode", obj.Code.ToUpper()); parameters[1] = new SqlParameter("@ZipCode", obj.ZipCode); Rent.DataAccess.SqlDataAccess.ISqlDbHelper _iSqlDbHelper = new SqlDbHelper(); var x = _iSqlDbHelper.ExecuteScalar("UsersAccess_Update", CommandType.StoredProcedure, parameters); if (x > 0) { // send email with username and password Rent.Business.Interfaces.IEmail objEmail = new Email(); result = objEmail.UserAccessRegistrationEmail(x); scope.Complete(); } else { result = "Incorrect access code. Please try again."; } } } catch (Exception exception) { Business.Services.LogError.Insert(exception, 0); result = "Error: " + exception.Message; } return(result); }