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