/// <summary> /// Gets the vehicle types. /// </summary> /// <returns></returns> public async Task <IEnumerable <string> > GetVehicleTypes() { using IDbConnection con = _dbConnectionProvider.GetConnectionInstance(); IEnumerable <string> values = await con.QueryAsync <string>(StoredProcedureName.GetVehicleTypes); return(values); }
/// <summary> /// Changes the password. /// </summary> /// <param name="changePassData">The change pass data.</param> /// <returns></returns> public async Task <bool> ChangePassword(ChangePasswordViewModel changePassData) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Username", changePassData.Username); parameters.Add("@CurrentPassword", changePassData.CurentPassword); parameters.Add("@NewPassword", changePassData.NewPassword); parameters.Add("@Result", dbType: DbType.Int32, direction: ParameterDirection.Output); using IDbConnection con = _dbConnectionProvider.GetConnectionInstance(); await con.ExecuteAsync(StoredProcedureName.ChangePassword, parameters, commandType : CommandType.StoredProcedure); int result = parameters.Get <int>("@Result"); if (result == 1) { return(true); } return(false); }