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