public async Task <ApiResponse> OperatorLogin(LoginVM objLoginModel) { ApiResponse apiResponse = new ApiResponse(); LoginRepo _loginRepo = new LoginRepo(); try { OperatorDetail objUserDetail = await _loginRepo.OperatorLogin(objLoginModel); if (objUserDetail.OperatorId > 0) { apiResponse = TaskUTL.GenerateApiResponse(true, 1, "Login succeessful", objUserDetail); } else { apiResponse = TaskUTL.GenerateApiResponse(false, 0, "Login failed. Please check your UserName and/or Password.", null); } return(apiResponse); } catch (Exception ex) { apiResponse = TaskUTL.GenerateExceptionResponse(ex, _pageName, true); return(apiResponse); } }
public async Task <OperatorDetail> OperatorLogin(LoginVM objLoginModel) { try { OperatorDetail objUserDetail = new OperatorDetail(); using (SqlCommand dataCmd = new SqlCommand("Operator_Login", objCommonDB.con)) { dataCmd.CommandType = CommandType.StoredProcedure; dataCmd.Parameters.AddWithValue("@UserName", objLoginModel.UserName); dataCmd.Parameters.AddWithValue("@Password", objLoginModel.Password); if (objCommonDB.con.State == ConnectionState.Closed) { objCommonDB.con.Open(); } //await dataCmd.ExecuteNonQueryAsync(); var reader = await dataCmd.ExecuteReaderAsync(); while (reader.Read()) { objUserDetail.OperatorId = Convert.ToInt32(reader["OperatorId"].ToString()); objUserDetail.DisplayName = reader["DisplayName"].ToString(); objUserDetail.OperatorMaxUserConnectionLimit = reader["OperatorMaxUserConnectionLimit"].ToString(); objUserDetail.OnHoldDefaultMessage = reader["OnHoldDefaultMessage"].ToString(); } return(objUserDetail); } } catch (Exception ex) { throw; } finally { if (objCommonDB.con.State == ConnectionState.Open) { objCommonDB.con.Close(); } } }