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