/// <summary>
/// Declaration add employee data method
/// </summary>
/// <param name="employeeModel">passing registration model object</param>
/// <returns>return bool</returns>
public UserResponseModel AddEmployeeData(RUserModel UserModel)
{
try
{
if (UserModel != null)
{
if (UserModel.Firstname == "" || UserModel.Lastname == "" || UserModel.CurrentAddress == "" || UserModel.EmailId == "" || UserModel.MobileNumber == "" || UserModel.Gender == "" || UserModel.UserPassword == "")
{
throw new CustomeException(CustomeException.ExceptionType.EMPTY_FIELD_EXCEPTION, "Empty Variable Field");
}
else if (UserModel.Firstname == null || UserModel.Lastname == null || UserModel.CurrentAddress == null || UserModel.EmailId == null)
{
throw new CustomeException(CustomeException.ExceptionType.NULL_FIELD_EXCEPTION, "Null Variable Field");
}
var response = this.employeeRepositoryL.AddEmployeeData(UserModel);
if (response != null)
{
return(response);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public IActionResult DeleteUserData([FromRoute] int UserId)
{
try
{
RUserModel responseUser = null;
if (UserId > 0)
{
responseUser = userBL.DeleteUserData(UserId);
}
else
{
throw new Exception(UserExceptions.ExceptionType.INVALID_ROLE_EXCEPTION.ToString());
}
if (responseUser != null)
{
bool Success = true;
var Message = "User Deletion is Successfull";
return(Ok(new { Success, Message, Data = responseUser }));
}
else
{
bool Success = false;
var Message = "User Deletion Failed";
return(Conflict(new { Success, Message }));
}
}
catch (Exception exception)
{
bool Success = false;
return(BadRequest(new { Success, Message = exception.Message }));
}
}
public IActionResult RegisterUser([FromBody] RegistrationUserModel user)
{
try
{
RUserModel responseUser = null;
if (!user.Equals(null))
{
responseUser = userBL.RegisterUser(user);
}
else
{
throw new Exception(UserExceptions.ExceptionType.INVALID_ROLE_EXCEPTION.ToString());
}
if (responseUser != null)
{
bool Success = true;
var Message = "Registration Successfull";
return(Ok(new { Success, Message, Data = responseUser }));
}
else
{
bool Success = false;
var Message = "User Already Exists";
return(Conflict(new { Success, Message }));
}
}
catch (Exception exception)
{
bool Success = false;
return(BadRequest(new { Success, Message = exception.Message }));
}
}
/// <summary>
/// Declaration of get all employee method
/// </summary>
/// <returns>return list</returns>
public List <RUserModel> GetAllUser()
{
try
{
List <RUserModel> employeeModelsList = new List <RUserModel>();
SqlCommand sqlCommand = new SqlCommand("spGetAllUser", this.sqlConnectionVariable);
sqlCommand.CommandType = CommandType.StoredProcedure;
this.sqlConnectionVariable.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
RUserModel userModel = new RUserModel();
if (Convert.ToInt32(sqlDataReader["PresentState"]) == 1)
{
userModel.UserId = Convert.ToInt32(sqlDataReader["UserId"]);
userModel.FirstName = sqlDataReader["FirstName"].ToString();
userModel.LastName = sqlDataReader["LastName"].ToString();
userModel.EmailId = sqlDataReader["EmailId"].ToString();
userModel.MobileNumber = sqlDataReader["MobileNumber"].ToString();
userModel.LocalAddress = sqlDataReader["LocalAddress"].ToString();
userModel.Gender = sqlDataReader["Gender"].ToString();
userModel.Role = sqlDataReader["Role"].ToString();
userModel.DateAndTime = sqlDataReader["ModificationDate"].ToString();
employeeModelsList.Add(userModel);
}
}
this.sqlConnectionVariable.Close();
return(employeeModelsList);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public ActionResult GetUserDetail([FromRoute] int UserId)
{
try
{
RUserModel responseUser = null;
if (!UserId.Equals(null))
{
responseUser = userBL.GetUserDetail(UserId);
}
else
{
throw new Exception(UserExceptions.ExceptionType.INVALID_ROLE_EXCEPTION.ToString());
}
if (responseUser != null)
{
bool Success = true;
var Message = "User Data Found";
return(Ok(new { Success, Message, Data = responseUser }));
}
else
{
bool Success = false;
var Message = "User Data Not Found";
return(Conflict(new { Success, Message }));
}
}
catch (Exception exception)
{
bool Success = false;
return(BadRequest(new { Success, Message = exception.Message }));
}
}
private RUserModel DataCopy(RUserModel usermodel, RegistrationUserModel user)
{
usermodel.FirstName = user.FirstName;
usermodel.LastName = user.LastName;
usermodel.EmailId = user.EmailId;
usermodel.Gender = user.Gender;
usermodel.LocalAddress = user.LocalAddress;
usermodel.MobileNumber = user.MobileNumber;
usermodel.Role = user.Role;
return(usermodel);
}
public RUserModel DeleteUserData(int UserId)
{
try
{
int status = 0;
int FlagsAttribute = 1;
if (UserId == 0)
{
throw new Exception(UserExceptions.ExceptionType.NULL_EXCEPTION.ToString());
}
SqlCommand sqlCommand = new SqlCommand("spDeleteUser", this.sqlConnectionVariable);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@UserID", UserId);
this.sqlConnectionVariable.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
RUserModel usermodel = new RUserModel();
while (sqlDataReader.Read())
{
status = sqlDataReader.GetInt32(0);
if (status == UserId)
{
usermodel.UserId = Convert.ToInt32(sqlDataReader["UserId"]);
usermodel.FirstName = sqlDataReader["FirstName"].ToString();
usermodel.LastName = sqlDataReader["LastName"].ToString();
usermodel.EmailId = sqlDataReader["EmailId"].ToString();
usermodel.LocalAddress = sqlDataReader["LocalAddress"].ToString();
usermodel.MobileNumber = sqlDataReader["MobileNumber"].ToString();
usermodel.Gender = sqlDataReader["Gender"].ToString();
usermodel.Role = sqlDataReader["Role"].ToString();
usermodel.DateAndTime = sqlDataReader["ModificationDate"].ToString();
FlagsAttribute = 0;
break;
}
break;
}
this.sqlConnectionVariable.Close();
if (FlagsAttribute == 0)
{
return(usermodel);
}
usermodel = null;
return(usermodel);
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// Declaration of employee details method
/// </summary>
/// <param name="Id">passing id</param>
/// <returns>return employee model object</returns>
public RUserModel GetUserDetail(int Id)
{
try
{
RUserModel userModel = new RUserModel();
SqlCommand sqlCommand = new SqlCommand("spGetUserDetailById", this.sqlConnectionVariable);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@UserId", Id);
this.sqlConnectionVariable.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
int status = 0;
while (sqlDataReader.Read())
{
status = sqlDataReader.GetInt32(0);
//EmployeeModel userModel = new EmployeeModel();
if (Id == status)
{
userModel.UserId = Convert.ToInt32(sqlDataReader["UserId"]);
userModel.FirstName = sqlDataReader["FirstName"].ToString();
userModel.LastName = sqlDataReader["LastName"].ToString();
userModel.EmailId = sqlDataReader["EmailId"].ToString();
userModel.MobileNumber = sqlDataReader["MobileNumber"].ToString();
userModel.LocalAddress = sqlDataReader["LocalAddress"].ToString();
userModel.Gender = sqlDataReader["Gender"].ToString();
userModel.Role = sqlDataReader["Role"].ToString();
userModel.DateAndTime = sqlDataReader["ModificationDate"].ToString();
break;
}
break;
}
if (status == 0)
{
return(null);
}
return(userModel);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
this.sqlConnectionVariable.Close();
}
}
public void GivenTestCase_WhenAllEmptyFields_ShouldReturnBadRequest()
{
try
{
RUserModel UserModel = new RUserModel();
UserModel.Firstname = "";
UserModel.Lastname = "";
UserModel.EmailId = "";
UserModel.CurrentAddress = "";
UserModel.Gender = "";
UserModel.MobileNumber = "";
UserModel.UserPassword = "";
var response = userController.AddUser(UserModel);
Assert.IsType <BadRequestObjectResult>(response);
}
catch (Exception exception)
{
Assert.IsType <BadRequestObjectResult>(exception);
}
}
public void GivenTestCase_WhenAllValidFields_ShouldReturnOkRequest()
{
try
{
RUserModel UserModel = new RUserModel();
UserModel.Firstname = "Vishal";
UserModel.Lastname = "Wamankar";
UserModel.EmailId = "*****@*****.**";
UserModel.CurrentAddress = "Kondhwa";
UserModel.Gender = "male";
UserModel.MobileNumber = "7758039722";
UserModel.UserPassword = "******";
var response = userController.AddUser(UserModel);
Assert.IsType <OkObjectResult>(response);
}
catch (Exception exception)
{
Assert.IsType <BadRequestObjectResult>(exception);
}
}
public void GivenTestCase_WhenLastNameEmptyFields_ShouldReturnBadRequest()
{
try
{
RUserModel UserModel = new RUserModel();
UserModel.Firstname = "vishal";
UserModel.Lastname = "";
UserModel.EmailId = "*****@*****.**";
UserModel.CurrentAddress = "kondhwa";
UserModel.Gender = "male";
UserModel.MobileNumber = "7758039722";
UserModel.UserPassword = "******";
var response = userController.AddUser(UserModel);
Assert.IsType <BadRequestObjectResult>(response);
}
catch (Exception exception)
{
Assert.IsType <BadRequestObjectResult>(exception);
}
}
/// <summary>
/// Declaration of add UserInstance data method
/// </summary>
/// <param name="employeeModel">Passing UserInstance model object</param>
/// <returns>return boolean value</returns>
public UserResponseModel AddEmployeeData(RUserModel UserModel)
{
try
{
if (EmailChecking(UserModel.EmailId))
{
UserModel.UserPassword = Encrypt(UserModel.UserPassword).ToString();
SqlCommand sqlCommand = new SqlCommand("spUserRegistrationData", this.sqlConnectionVariable);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Firstname", UserModel.Firstname);
sqlCommand.Parameters.AddWithValue("@Lastname", UserModel.Lastname);
sqlCommand.Parameters.AddWithValue("@EmailID", UserModel.EmailId);
sqlCommand.Parameters.AddWithValue("@UserPassword", UserModel.UserPassword);
sqlCommand.Parameters.AddWithValue("@CurrentAddress", UserModel.CurrentAddress);
sqlCommand.Parameters.AddWithValue("@MobileNumber", UserModel.MobileNumber);
sqlCommand.Parameters.AddWithValue("@Gender", UserModel.Gender);
this.sqlConnectionVariable.Open();
var response = sqlCommand.ExecuteNonQuery();
this.sqlConnectionVariable.Close();
if (response == 1)
{
return(GetSpecificEmployeeAllDetailes(UserModel.EmailId));
}
else
{
return(null);
}
}
return(null);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
}
public IActionResult AddUser(RUserModel UserModel)
{
try
{
var responseMessage = this.employeeBusiness.AddEmployeeData(UserModel);
if (responseMessage != null)
{
//Message For MSMQ.
/*string message = " Hello " + Convert.ToString(UserModel.Firstname) + " " + Convert.ToString(UserModel.Lastname) +
* "\n Your " + "Registration Succesful" +
* "\n Email :" + Convert.ToString(UserModel.EmailId) +
* "\n MobileNumber: " + Convert.ToString(UserModel.MobileNumber) +
* "\n CurrentAddress: " + Convert.ToString(UserModel.CurrentAddress) +
* "\n Gender : " + Convert.ToString(UserModel.Gender);
*
* //Sending Message To MSMQ.
* senderObject.Send(message);*/
bool Success = true;
var Message = "User Registration SuccessFull";
return(this.Ok(new { Success, Message, Data = responseMessage }));
}
else
{
bool Success = false;
var Message = "User Registration Failed";
return(this.BadRequest(new { Success, Message }));
}
}
catch (Exception e)
{
bool Success = false;
return(this.BadRequest(new { Success, message = e.Message }));
}
}
/// <summary>
/// Function For Register User.
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public RUserModel RegisterUser(RegistrationUserModel user)
{
try
{
//Throws Custom Exception When Fields are Null.
if (user.FirstName == null || user.Role == null || user.Password == null || user.EmailId == null || user.LastName == null || user.Gender == null || user.LocalAddress == null || user.Password == null || user.MobileNumber == null)
{
throw new Exception(UserExceptions.ExceptionType.NULL_EXCEPTION.ToString());
}
//Throws Custom Exception When Fields are Empty Strings.
if (user.FirstName == "" || user.Role == "" || user.Password == "" || user.EmailId == "" || user.LastName == "" || user.Gender == "" || user.LocalAddress == "" || user.Password == "" || user.MobileNumber == "")
{
throw new Exception(UserExceptions.ExceptionType.EMPTY_EXCEPTION.ToString());
}
if ((user.Role.Equals(Roles.Admin.ToString()) || user.Role.Equals(Roles.Driver.ToString()) ||
user.Role.Equals(Roles.Police.ToString()) || user.Role.Equals(Roles.Security.ToString()) ||
user.Role.Equals(Roles.Owner.ToString()) || user.Role.Equals(Roles.Attendant.ToString())))
{
if (!EmailChecking(user.EmailId))
{
return(null);
}
int status = 0;
RUserModel usermodel = new RUserModel();
user.Password = Encrypt(user.Password).ToString();
SqlCommand sqlCommand = new SqlCommand("spUserRegistration", this.sqlConnectionVariable);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Firstname", user.FirstName);
sqlCommand.Parameters.AddWithValue("@Lastname", user.LastName);
sqlCommand.Parameters.AddWithValue("@EmailID", user.EmailId);
sqlCommand.Parameters.AddWithValue("@Role", user.Role);
sqlCommand.Parameters.AddWithValue("@UserPassword", user.Password);
sqlCommand.Parameters.AddWithValue("@CurrentAddress", user.LocalAddress);
sqlCommand.Parameters.AddWithValue("@MobileNumber", user.MobileNumber);
sqlCommand.Parameters.AddWithValue("@Gender", user.Gender);
this.sqlConnectionVariable.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
status = sqlDataReader.GetInt32(0);
usermodel.UserId = Convert.ToInt32(sqlDataReader["UserId"]);
usermodel.DateAndTime = sqlDataReader["ModificationDate"].ToString();
if (status > 0)
{
return(DataCopy(usermodel, user));
}
else
{
return(null);
}
}
}
else
{
throw new Exception(UserExceptions.ExceptionType.INVALID_ROLE_EXCEPTION.ToString());
}
return(null);
}
catch (Exception exception)
{
throw exception;
}
}
