Ejemplo n.º 1
0
        public UserRegisterResponseModel registerEmployee(RegisterEmployeeRequestModel employeeRegisterModel, out ErrorModel errorModel)
        {
            errorModel = null;
            UserRegisterResponseModel userRegisterResponse = null;
            SqlConnection             connection           = null;

            try
            {
                using (connection = new SqlConnection(Database.getConnectionString()))
                {
                    SqlCommand command = new SqlCommand(SqlCommands.SP_registerEmployee, connection);
                    command.CommandType = System.Data.CommandType.StoredProcedure;

                    #region Commands Parameters
                    command.Parameters.AddWithValue("email", employeeRegisterModel.email);
                    command.Parameters.AddWithValue("password", employeeRegisterModel.email);
                    command.Parameters.AddWithValue("fname", employeeRegisterModel.firstName);
                    command.Parameters.AddWithValue("lname", employeeRegisterModel.lastName);
                    command.Parameters.AddWithValue("phone", employeeRegisterModel.phone);
                    command.Parameters.AddWithValue("userTypeId", employeeRegisterModel.userType);
                    command.Parameters.AddWithValue("gender", employeeRegisterModel.gender);

                    #endregion
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();

                    userRegisterResponse = new UserRegisterResponseModel();
                    if (reader.Read())
                    {
                        if (reader.isColumnExists("ErrorCode"))
                        {
                            errorModel              = new ErrorModel();
                            errorModel.ErrorCode    = reader["ErrorCode"].ToString();
                            errorModel.ErrorMessage = reader["ErrorMessage"].ToString();
                        }
                        else
                        {
                            userRegisterResponse.Email  = reader["email"].ToString();
                            userRegisterResponse.UserId = reader["userId"].ToString();
                        }
                    }
                    command.Dispose();
                    return(userRegisterResponse);
                }
            }
            catch (Exception exception)
            {
                errorModel = new ErrorModel();
                errorModel.ErrorMessage = exception.Message;
                return(null);
            }
            finally
            {
                if (connection != null)
                {
                    connection.Close();
                }
            }
        }
Ejemplo n.º 2
0
 public UserRegisterResponseModel registerEmployee(RegisterEmployeeRequestModel employeeRequestModel, out ErrorModel errorModel)
 {
     errorModel = null;
     try
     {
         Employee employeeHelper = new Employee();
         return(employeeHelper.registerEmployee(employeeRequestModel, out errorModel));
     }
     catch (Exception)
     {
         return(null);
     }
 }
Ejemplo n.º 3
0
        public HttpResponseMessage registerEmployee(RegisterEmployeeRequestModel employeeRequestModel)
        {
            EmployeeProvider employeeProvider = new EmployeeProvider();
            ErrorModel       errorModel       = null;
            var userRegisterResponse          = employeeProvider.registerEmployee(employeeRequestModel, out errorModel);

            APIResponseModel aPIResponseModel = new APIResponseModel();

            aPIResponseModel.Response = userRegisterResponse;
            aPIResponseModel.Error    = errorModel;

            return(Request.CreateResponse(HttpStatusCode.OK, aPIResponseModel));
        }