public async Task <IEnumerable <ComponentBugModel> > GetComponentBugFilterBy(int pBugId = -1, string pAssigneeId = null)
{
var result = await _sqlDataAccess.LoadDataAsync <ComponentBugModel, dynamic>(DataAccessConstant.SP_ComponentBug_GetFilterBy,
new { Id = pBugId, AssigneeId = pAssigneeId },
DataAccessConstant.HandiBugTrackerConn);
return(result);
}
public async Task <List <BarangModel> > GetBarangsAsync(string top)
{
var p = new
{
top = Int16.Parse(top)
};
string sql = @"select top(@Top) kdBarang, namaBarang, satuan from barang_m ";
return(await _db.LoadDataAsync <BarangModel, dynamic>(sql, p));
}
public async Task <List <PenerimaanViewModel> > GetPenerimaanAsync(string top, string namaBarang)
{
var p = new
{
top = Int16.Parse(top),
namaBarang = namaBarang
};
string sql = @"select top(@Top) noPenerimaan, noFaktur, kdBarang, namaBarang, jmlTerima, harga
from v_penerimaan where namaBarang like '%' + @NamaBarang + '%' ";
return(await _db.LoadDataAsync <PenerimaanViewModel, dynamic>(sql, p));
}
public async Task <IEnumerable <ComponentModel> > GetComponentByProductId(int pProductId)
{
var result = await _sqlDataAccess.LoadDataAsync <ComponentModel, dynamic>(DataAccessConstant.SP_Component_GetByProduct, new { ProductId = pProductId }, DataAccessConstant.HandiBugTrackerConn);
return(result);
}
public Task <List <ContactModel> > GetAllContacts()
{
return(_dataAccess.LoadDataAsync <ContactModel, dynamic>("dbo.spContact_All",
new { },
_connectionString.SqlConnectionName));
}
public async Task <IEnumerable <ProductOSModel> > GetProductOSes()
{
var result = await _sqlDataAccess.LoadDataAsync <ProductOSModel, dynamic>(DataAccessConstant.SP_ProductOS_GetAll, new { }, DataAccessConstant.HandiBugTrackerConn);
return(result);
}
public async Task <IEnumerable <BugStatusModel> > GetBugStatuses()
{
var result = await _sqlDataAccess.LoadDataAsync <BugStatusModel, dynamic>(DataAccessConstant.SP_BugStatus_GetAll, new { }, DataAccessConstant.HandiBugTrackerConn);
return(result);
}
public async Task <IEnumerable <ProductVersionModel> > GetProductVersionsByProduct(int pProductId)
{
var result = await _sqlDataAccess.LoadDataAsync <ProductVersionModel, dynamic>(DataAccessConstant.SP_ProductVersion_GetByProduct, new { ProductId = pProductId }, DataAccessConstant.HandiBugTrackerConn);
return(result);
}
public async Task <IEnumerable <BugCommentModel> > GetBugCommentByBugId(int pBugId)
{
var result = await _sqlDataAccess.LoadDataAsync <BugCommentModel, dynamic>(DataAccessConstant.SP_BugComment_GetByBug, new { BugId = pBugId }, DataAccessConstant.HandiBugTrackerConn);
return(result);
}