public ToaNha Laytoanhatheoma(string maTN)
{
DataTable dt = TNDAL.LayTNTheoMa(maTN);
ToaNha tn = new ToaNha();
tn.Mantoanha = dt.Rows[0][0].ToString();
tn.Tentoanha = dt.Rows[0][1].ToString();
tn.Sophong = dt.Rows[0][2].ToString();
tn.Tienphong = dt.Rows[0][3].ToString();
tn.Manhanvien = dt.Rows[0][4].ToString();
tn.Ghichu = dt.Rows[0][5].ToString();
return(tn);
}
public async Task <IActionResult> PostToaNha([FromBody] ToaNha toanha)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = User.Identity.Name;
var userId = Utilities.GetUserId(this.User);
toanha.NgayNhap = DateTime.Now;
toanha.NguoiNhap = user;
_context.ToaNhas.Add(toanha);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetToaNha", new { id = toanha.ToaNhaId }, toanha));
}
public async Task <IActionResult> PutToaNha([FromRoute] int id, [FromBody] ToaNha toanha)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != toanha.ToaNhaId)
{
return(BadRequest());
}
var user = this.User.Identity.Name;
var userId = Utilities.GetUserId(this.User);
toanha.NgaySua = DateTime.Now;
toanha.NguoiSua = user;
_context.Entry(toanha).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ToaNhaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Xoatoanha(ToaNha tn)
{
strSQL = "Delete ToaNha where MaTN='" + tn.Mantoanha + "'";
helper.ThucThiKN(strSQL);
}
public void Suatoanha(ToaNha tn)
{
strSQL = "Update ToaNha set TenTN=N'" + tn.Tentoanha + "',SoPhong='" + tn.Sophong + "',TienPhong='" + tn.Tienphong + "',MaNV='" + tn.Manhanvien + "',GhiChu=N'" + tn.Ghichu + "' where MaTN='" + tn.Mantoanha + "'";
helper.ThucThiKN(strSQL);
}
public void Themtoanha(ToaNha tn)
{
strSQL = "Insert into ToaNha values('" + tn.Mantoanha + "',N'" + tn.Tentoanha + "','" + tn.Sophong + "','" + tn.Tienphong + "','" + tn.Manhanvien + "',N'" + tn.Ghichu + "')";
helper.ThucThiKN(strSQL);
}
public void XoaToaNha(string MaTN)
{
TN = new ToaNha(MaTN, "", "", "", "", "");
TNDAL.Xoatoanha(TN);
}
public void SuaToaNha(string matn, string tentn, string sophong, string tienphong, string manv, string ghichu)
{
TN = new ToaNha(matn, Chuanhoaxau(tentn), sophong, tienphong, manv, Chuanhoaxau(ghichu));
TNDAL.Suatoanha(TN);
}
