public dynamic AddVentilationEquipment(List <VentilationMonitor> veqObj) { var dynamicParameters = new DynamicParameters(); dynamicParameters.Add("@Objects", veqObj.AsTableValuedParameter("dbo.VentilationMonitorMain", new[] { "Id", "Unit", "DepartmentName", "Quantity" })); var data = _dapperManager.QueryAsync(sql: "InsertVentilationMonitorMain", param: dynamicParameters, commandType: CommandType.StoredProcedure); return(data.Result); }
public async Task <Users> GetLoginUser(Users entity) { var result = await _dapperManager.QueryAsync <Users>("SELECT * from Users WHERE UserName=@UserName OR ContactNumber=@UserName OR EmailAddress=@UserName", new { entity.UserName }); if (result.Count() == 0) { return(null); } string hashPassword = Web.Repositories.Utitlities.Security.GetMd5Sum(entity.Password); var loginUser = result.Where(a => a.Password.Trim() == hashPassword.Trim()); if (loginUser.Count() == 0) { return(null); } return(loginUser.FirstOrDefault()); }
public async Task <IEnumerable <DesignationDto> > GetAllDesignationAsync() { return(await _dapperManager.QueryAsync <DesignationDto>("SELECT * FROM Designation")); }
public async Task <IEnumerable <RoleDto> > GetActiveRoleAsync() { var roles = await _dapperManager.QueryAsync <RoleDto>("SELECT * FROM Role WHERE Status=1"); return(roles); }
public async Task <IEnumerable <CustomerQueryDto> > GetAllQueryAsync() { return(await _dapperManager.QueryAsync <CustomerQueryDto>("SELECT * FROM CustomerQuery")); }
public async Task <IEnumerable <ProductDto> > GetAllProductAsync() { return(await _dapperManager.QueryAsync <ProductDto>("SELECT * FROM ProductView")); }
public async Task <IEnumerable <UnitDto> > GetAllUnitAsync() { return(await _dapperManager.QueryAsync <UnitDto>("SELECT * FROM Unit")); }
public async Task <IEnumerable <MenusDto> > GetMenusAsync() { var result = await _dapperManager.QueryAsync <MenusDto>("SELECT * from MenuView"); return(result); }
public async Task <IEnumerable <FiscalYearDto> > GetAllFiscalYearAsync() { return(await _dapperManager.QueryAsync <FiscalYearDto>("SELECT * FROM FiscalYear")); }
public async Task <IEnumerable <RoleDto> > GetAllRolesAsync() { return(await _dapperManager.QueryAsync <RoleDto>("SELECT * FROM Role")); }
public async Task <IEnumerable <StaffsDto> > GetStaffListAsync() { var dto = await _dapperManager.QueryAsync <StaffsDto>("SELECT * FROM StaffsView"); return(dto); }
public IEnumerable <dynamic> GetVertexesDapper() { var data = _dapperManager.QueryAsync(sql: "usp_GetVertexes", commandType: CommandType.StoredProcedure); return(data.Result); }
public async Task <IEnumerable <AccountHeadDto> > GetAllAccountHeadAsync() { return(await _dapperManager.QueryAsync <AccountHeadDto>("SELECT * FROM AccountHead")); }
public async Task <IEnumerable <SupplierDto> > GetAllSupplierAsync() { return(await _dapperManager.QueryAsync <SupplierDto>("SELECT * FROM Supplier")); }
public async Task <IEnumerable <DepartmentDto> > GetAllDepartmentAsync() { return(await _dapperManager.QueryAsync <DepartmentDto>("SELECT * FROM Department")); }