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