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 <ActionResult <LblModel> > Put(int id, [FromBody] LblModel lbl) { var lxRslt = await LblBO.Update(id, lbl); if (lxRslt.Err != null) { return(BadRequest(lxRslt)); } return(CreatedAtAction(nameof(Get), new { id = lbl.LblId }, lbl)); }
public async Task <ActionResult> OnGet(int id) { var lxRslt = await LblBO.Get(id); if (lxRslt.Err != null) { TempData["ExErr"] = lxRslt.Err; return(Page()); } Lbl = lxRslt.Sngl; return(Page()); }
public async Task <ExeRslt> Create(LblModel Lbl) { SqlTransaction trns = null; string lxQry = "INSERT INTO [Lbl] " + "(Lbl, BkClr, Clr) " + "OUTPUT Inserted.LblId " + "VALUES " + "(@Lbl, @BkClr, @Clr) "; try { using (SqlConnection cnx = new SqlConnection(GetCnxStr())) { await cnx.OpenAsync(); trns = cnx.BeginTransaction(); using (SqlCommand cmd = new SqlCommand(lxQry, cnx, trns)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Lbl", Lbl.Lbl); cmd.Parameters.AddWithValue("@BkClr", Lbl.BkClr); cmd.Parameters.AddWithValue("@Clr", Lbl.Clr); var id = await cmd.ExecuteScalarAsync(); Lbl.LblId = Convert.ToInt32(id); trns.Commit(); return(new ExeRslt(Lbl.LblId)); } } } catch (Exception ex) { try { trns.Rollback(); } catch (Exception exr) { ex.Data.Add("Rollback", exr.Message); } ex.Data.Add("Qry", lxQry); ex.Data.Add("Method", Ext.GetCaller()); return(new ExeRslt(-1, ex)); } }
public async Task <ExeRslt> Update(int id, LblModel Lbl) { SqlTransaction trns = null; string lxQry = "UPDATE [Lbl] " + " SET " + " Lbl = @Lbl," + " BkClr = @BkClr, " + " Clr = @Clr " + " WHERE LblId = @LblId"; try { using (SqlConnection cnx = new SqlConnection(GetCnxStr())) { await cnx.OpenAsync(); trns = cnx.BeginTransaction(); using (SqlCommand cmd = new SqlCommand(lxQry, cnx, trns)) { cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Lbl", Lbl.Lbl); cmd.Parameters.AddWithValue("@BkClr", Lbl.BkClr); cmd.Parameters.AddWithValue("@Clr", Lbl.Clr); cmd.Parameters.AddWithValue("@LblId", id); await cmd.ExecuteNonQueryAsync(); trns.Commit(); return(new ExeRslt(Lbl.LblId)); } } } catch (Exception ex) { try { trns.Rollback(); } catch (Exception exr) { ex.Data.Add("Rollback", exr.Message); } ex.Data.Add("Qry", lxQry); ex.Data.Add("Method", Ext.GetCaller()); return(new ExeRslt(-1, ex)); } }
public Task <ExeRslt> Update(int id, LblModel Lbl) { return(LblDM.Update(id, Lbl)); }
public Task <ExeRslt> Create(LblModel Lbl) { return(LblDM.Create(Lbl)); }