public async Task <ActionResult> DeleteData(string name, string requestingControl, string data) { try { if (!await DWKitRuntime.Security.CheckFormPermissionAsync(name, "Edit")) { throw new Exception("Access denied!"); } var deleteRequest = new ChangeDataRequest(name, data, requestingControl) { BaseUrl = $"{Request.Scheme}://{Request.Host.Value}", GetHeadersForLocalRequest = () => { var dataUrlParameters = new Dictionary <string, string>(); dataUrlParameters.Add("Cookie", string.Join(";", Request.Cookies.Select(c => $"{c.Key}={c.Value}"))); return(dataUrlParameters); } }; var res = await DataSource.DeleteData(deleteRequest); if (res.success != null) { return(Json(res.success)); } return(Json(res.fail)); } catch (Exception e) { return(Json(new FailResponse(e))); } }
ChangeDataRequest IUsersMapper.GetChangeDataRequest(UserProfile user) { var request = new ChangeDataRequest { UserData = user, ActionType = DataBaseCommunication.Mappers.Requests.ActionType.Update }; return(request); }
public async Task <ActionResult> ChangeData(string name, string data, bool mobile = false, string schemeName = null) { try { if (!await DWKitRuntime.Security.CheckFormPermissionAsync(name, "Edit")) { return(new JsonResult(new FailResponse("Access denied!")) { StatusCode = 401 }); } var postRequest = new ChangeDataRequest(name, data) { Mobile = mobile, SchemeName = schemeName, BaseUrl = $"{Request.Scheme}://{Request.Host.Value}", GetHeadersForLocalRequest = () => { var dataUrlParameters = new Dictionary <string, string>(); dataUrlParameters.Add("Cookie", string.Join(";", Request.Cookies.Select(c => $"{c.Key}={c.Value}"))); Request.Headers.Where(c => c.Key == "Authorization") .ForEach(c => dataUrlParameters.Add(c.Key, c.Value)); return(dataUrlParameters); } }; var res = await DataSource.ChangeData(postRequest); if (res.success != null) { return(Json(res.success)); } return(Json(res.fail)); } catch (Exception e) { return(Json(new FailResponse(e))); } }
public bool ChangeUserData(ChangeDataRequest request) { var conn = GetConnection(ConnectionNames.CSPSqlDatabase); var commandWrapper = GetStoredProcCommand("dbo.Update_User_Data", conn); AddInParameter(commandWrapper, "@UserId", DbType.Int16, request.UserData.Id); AddInParameter(commandWrapper, "@FirstName", DbType.String, request.UserData.FirstName); AddInParameter(commandWrapper, "@LastName", DbType.String, request.UserData.LastName); AddInParameter(commandWrapper, "@BirthDate", DbType.DateTime, request.UserData.BirthDate); AddInParameter(commandWrapper, "@Address", DbType.String, request.UserData.Address); AddInParameter(commandWrapper, "@City", DbType.String, request.UserData.City); AddInParameter(commandWrapper, "@Gender", DbType.String, request.UserData.Gender); AddInParameter(commandWrapper, "@Email", DbType.String, request.UserData.Email); AddInParameter(commandWrapper, "@Slava", DbType.String, request.UserData.Slava); AddInParameter(commandWrapper, "@Password", DbType.String, request.UserData.Password); AddInParameter(commandWrapper, "@Role", DbType.Int16, request.UserData.Role); AddInParameter(commandWrapper, "@TeamId", DbType.Int16, request.UserData.Team.Id); AddInParameter(commandWrapper, "@ERROR", DbType.String, 1000); AddInParameter(commandWrapper, "@ERROR_CODE", DbType.String, 4); try { conn.Open(); int results = commandWrapper.ExecuteNonQuery(); var isProcedureSucced = Convert.ToBoolean(results); MakeDboLog(request.ToString(), isProcedureSucced.ToString(), "dbo.Update_User_Data"); var errorObject = GetParameterValue(commandWrapper, "@ERROR"); var errorCodeObject = GetParameterValue(commandWrapper, "@ERROR_CODE"); return Convert.ToBoolean(results); } finally { commandWrapper.Dispose(); conn.Close(); } }
ChangeDataResponse IUserService.UpdateData(ChangeDataRequest request) { var response = new ChangeDataResponse { ResponseStatus = ResponseStatus.Success }; var usersProvider = new UsersProvider(); try { if (request.ActionType == ActionType.Update) { response.isSuccessful = usersProvider.ChangeUserData(request); if (response.isSuccessful) { var refreshUserRequest = new UserRequest { ActionType = ActionType.Select, UserName = request.UserData.UserName, Password = request.UserData.Password }; var newUserResponse = Login(refreshUserRequest); response.NewUser = newUserResponse.User; } } else { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = "Not update action"; } } catch (Exception ex) { response.ResponseStatus = ResponseStatus.Failure; response.ResponseDescription = ex.Message; } return(response); }