public async Task <LstRslt <LblModel> > GetAllLbl()
{
DataTable lxDT = new DataTable();
string lxQry =
"SELECT LblId, Lbl, BkClr, Clr " +
" FROM [Lbl]";
try {
using (SqlConnection cnx = new SqlConnection(GetCnxStr())) {
using (SqlCommand cmd = new SqlCommand(lxQry, cnx)) {
SqlDataAdapter lxDA = new SqlDataAdapter(cmd);
lxDA.Fill(lxDT);
lxDT.TableName = "Lbl";
}
}
if (lxDT.Rows.Count > 0)
{
List <LblModel> lxLbls = lxDT.ToList <LblModel>();
var lxRslt = new LstRslt <LblModel>(lxLbls);
return(await Task.FromResult(lxRslt));
}
else
{
return(new LstRslt <LblModel>(new List <LblModel>()));
}
} catch (Exception ex) {
ex.Data.Add("Qry", lxQry);
ex.Data.Add("Method", Ext.GetCaller());
return(new LstRslt <LblModel>(new List <LblModel>(), ex));
}
}
public async Task <LstRslt <IssuModel> > GetAll()
{
DataSet lxDS = new DataSet();
string lxQryI =
"SELECT IssuId, Tit, Txt, St, StmCre, StmMdf " +
" FROM [Issu] I" +
" ORDER BY StmMdf DESC";
string lxQryLxI =
"SELECT LxI.IssuId, LxI.LblId, L.Lbl, L.BkClr, L.Clr " +
" FROM [LblxIssu] LxI " +
" LEFT JOIN [Lbl] L " +
" ON L.LblId = LxI.LblId";
try {
using (SqlConnection cnx = new SqlConnection(GetCnxStr())) {
using (SqlCommand cmd = new SqlCommand(lxQryI, cnx)) {
SqlDataAdapter lxDA = new SqlDataAdapter(cmd);
lxDA.Fill(lxDS, "Issu");
}
using (SqlCommand cmd = new SqlCommand(lxQryLxI, cnx)) {
SqlDataAdapter lxDA = new SqlDataAdapter(cmd);
lxDA.Fill(lxDS, "LblxIssu");
}
DataColumn lxColIssuIdM = lxDS.Tables["Issu"].Columns["IssuId"];
DataColumn lxColIssuIdD = lxDS.Tables["LblxIssu"].Columns["IssuId"];
DataRelation lxI_LxI = new DataRelation("Issu_LblxIssu", lxColIssuIdM, lxColIssuIdD);
lxDS.Relations.Add(lxI_LxI);
}
var lxRslt = new LstRslt <IssuModel>();
if (lxDS.Tables["Issu"].Rows.Count > 0)
{
List <IssuModel> lxIssus = lxDS.Tables["Issu"].ToList <IssuModel>();
FillLbls(ref lxIssus, lxDS);
lxRslt = new LstRslt <IssuModel>(lxIssus);
}
return(await Task.FromResult(lxRslt));
} catch (Exception ex) {
ex.Data.Add("QryI", lxQryI);
ex.Data.Add("QryLxI", lxQryLxI);
ex.Data.Add("Method", Ext.GetCaller());
return(new LstRslt <IssuModel>(new List <IssuModel>(), ex));
}
}
