public IActionResult UpdateUserData([FromBody] UUserModel user)
{
try
{
UUserModel responseUser = null;
if (!user.Equals(null))
{
responseUser = userBL.UpdateUserData(user);
}
else
{
throw new Exception(UserExceptions.ExceptionType.INVALID_ROLE_EXCEPTION.ToString());
}
if (responseUser != null)
{
bool Success = true;
var Message = "User Updation is Successfull";
return(Ok(new { Success, Message, Data = responseUser }));
}
else
{
bool Success = false;
var Message = "User Updation Failed";
return(Conflict(new { Success, Message }));
}
}
catch (Exception exception)
{
bool Success = false;
return(BadRequest(new { Success, Message = exception.Message }));
}
}
public UUserModel UpdateUserData(UUserModel user)
{
try
{
return(this.userRL.UpdateUserData(user));
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// Declaration update employee method
/// </summary>
/// <param name="userModel">employee model object passing</param>
/// <returns>Return boolean value</returns>
public UUserModel UpdateUserData(UUserModel userModel)
{
try
{
if (!EmailChecking(userModel.EmailId))
{
SqlCommand sqlCommand = new SqlCommand("spUpdateUserData", this.sqlConnectionVariable);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@UserId", userModel.UserId);
sqlCommand.Parameters.AddWithValue("@FirstName", userModel.FirstName);
sqlCommand.Parameters.AddWithValue("@LastName", userModel.LastName);
sqlCommand.Parameters.AddWithValue("@EmailId", userModel.EmailId);
sqlCommand.Parameters.AddWithValue("@MobileNumber", userModel.MobileNumber);
sqlCommand.Parameters.AddWithValue("@CurrentAddress", userModel.LocalAddress);
sqlCommand.Parameters.AddWithValue("@Gender", userModel.Gender);
sqlCommand.Parameters.AddWithValue("@Role", userModel.Role);
this.sqlConnectionVariable.Open();
//var response = sqlCommand.ExecuteNonQuery();
int status = 0;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
status = sqlDataReader.GetInt32(0);
if (status == 1)
{
this.sqlConnectionVariable.Close();
return(userModel);
}
else
{
return(null);
}
}
}
this.sqlConnectionVariable.Close();
return(null);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
