public int?AddSupplier(Supplier supplier, List <ValidationMessage> validationMessages) { try { using (IDbConnection conn = OpenConnection()) { var parameters = new DynamicParameters(); parameters.Add("@Id", supplier.Id); parameters.Add("@StationId", supplier.StationId); parameters.Add("@UserId", supplier.UserId); parameters.Add("@Address", supplier.Address); parameters.Add("@MobileNumber", supplier.MobileNumber); parameters.Add("@LogNumber", supplier.LogNumber); parameters.Add("@FirstName", supplier.FirstName); parameters.Add("@LastName", supplier.LastName); parameters.Add("@IsActive", supplier.IsActive); return(conn.Query <int?>("USP_UpsertSupplier", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault()); } } catch (SqlException sqlException) { SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin"); return(null); } }
public int?AddUser(UserDetails userDetails, List <ValidationMessage> validationMessages) { try { using (IDbConnection conn = OpenConnection()) { byte[] encData_byte; encData_byte = System.Text.Encoding.UTF8.GetBytes(userDetails.Password); string encodedData = Convert.ToBase64String(encData_byte); var parameters = new DynamicParameters(); parameters.Add("@Id", userDetails.Id); parameters.Add("@UserName", userDetails.Username); parameters.Add("@Email", userDetails.Email); parameters.Add("@Password", encodedData); parameters.Add("@IsActive", userDetails.IsActive); parameters.Add("@IsAdmin", userDetails.IsAdmin); return(conn.Query <int?>("USP_UpsertUser", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault()); } } catch (SqlException sqlException) { SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to create the user, please contact Admin"); return(null); } }
public List <Station> GetStationsList(List <ValidationMessage> validationMessages) { try { using (IDbConnection conn = OpenConnection()) { return(conn.Query <Station>("USP_GetStationsList").ToList()); } } catch (SqlException sqlException) { SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin"); return(new List <Station>()); } }
public List <Supplier> GetSuppliersList(int stationId, List <ValidationMessage> validationMessages) { try { using (IDbConnection conn = OpenConnection()) { var parameters = new DynamicParameters(); parameters.Add("@StationId", stationId); return(conn.Query <Supplier>("USP_GetSuppliers", parameters, commandType: CommandType.StoredProcedure).ToList()); } } catch (SqlException sqlException) { SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin"); return(new List <Supplier>()); } }
public bool?DeleteSupplier(int suplierId, List <ValidationMessage> validationMessages) { try { using (IDbConnection conn = OpenConnection()) { var parameters = new DynamicParameters(); parameters.Add("@SuplierId", suplierId); parameters.Add("@IsActive", false); conn.Query <bool?>("USP_DeleteSuplier", parameters, commandType: CommandType.StoredProcedure).FirstOrDefault(); return(true); } } catch (SqlException sqlException) { SqlValidationHelper.ValidateGetAllSqlExceptions(validationMessages, sqlException, "Unable to Get stations list please contact Admin"); return(false); } }