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