public async Task <SnglRslt <LblModel> > Get(int id)
{
DataTable lxDT = new DataTable();
string lxQry =
"SELECT LblId, Lbl, BkClr, Clr " +
" FROM [Lbl]" +
" WHERE LblId = @LblId";
try {
using (SqlConnection cnx = new SqlConnection(GetCnxStr())) {
using (SqlCommand cmd = new SqlCommand(lxQry, cnx)) {
cmd.Parameters.AddWithValue("LblId", id);
SqlDataAdapter lxDA = new SqlDataAdapter(cmd);
lxDA.Fill(lxDT);
lxDT.TableName = "Lbl";
}
}
if (lxDT.Rows.Count > 0)
{
LblModel lxLbl = lxDT.Rows[0].ToRow <LblModel>();
var lxRslt = new SnglRslt <LblModel>(lxLbl);
return(await Task.FromResult(lxRslt));
}
else
{
return(new SnglRslt <LblModel>(new LblModel()));
}
} catch (Exception ex) {
return(new SnglRslt <LblModel>(new LblModel(), ex));
}
}
public async Task <SnglRslt <IssuModel> > Get(int id)
{
DataSet lxDS = new DataSet();
string lxQryI =
"SELECT IssuId, Tit, Txt, St, StmCre, StmMdf " +
" FROM [Issu] I" +
" WHERE IssuId = @IssuId";
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 " +
"WHERE IssuId = @IssuId";
try {
using (SqlConnection cnx = new SqlConnection(GetCnxStr())) {
using (SqlCommand cmd = new SqlCommand(lxQryI, cnx)) {
cmd.Parameters.AddWithValue("@IssuId", id);
SqlDataAdapter lxDA = new SqlDataAdapter(cmd);
lxDA.Fill(lxDS, "Issu");
}
using (SqlCommand cmd = new SqlCommand(lxQryLxI, cnx)) {
cmd.Parameters.AddWithValue("@IssuId", id);
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 SnglRslt <IssuModel>();
if (lxDS.Tables["Issu"].Rows.Count > 0)
{
IssuModel lxIssu = lxDS.Tables["Issu"].Rows[0].ToRow <IssuModel>();
FillLbl(ref lxIssu, lxDS.Tables["LblxIssu"]);
lxRslt = new SnglRslt <IssuModel>(lxIssu);
}
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 SnglRslt <IssuModel>(new IssuModel(), ex));
}
}
