public bool xoakhoanchi(KhoanChiDTO kc)
{
string sql = "delete from KhoanChi where MaKC='" + kc.MaKC + "'";
bool kq = con.query(sql);
return(kq);
}
public bool suakhoanchi(KhoanChiDTO kc)
{
string sql = "update KhoanChi set TenKC = N'" + kc.TenKC + "',MoTa = N'" + kc.MoTa + "'where MaKC = '" + kc.MaKC + "'";
bool kq = con.query(sql);
return(kq);
}
public DataTable kttrungten(KhoanChiDTO kc)
{
string sql = "select*from KhoanChi where TenKC='" + kc.TenKC + "'";
DataTable da = con.table(sql);
return(da);
}
public bool themkhoanchi(KhoanChiDTO kc)
{
kc.MaKC = matutang();
string sql = "insert into KhoanChi values('" + kc.MaKC + "',N'" + kc.TenKC + "',N'" + kc.MoTa + "')";
bool kq = con.query(sql);
return(kq);
}
public async Task <IActionResult> Post([FromBody] KhoanChiDTO model)
{
using (var context = new UserProfileDbContext())
{
context.KhoanChis.Add(new KhoanChi
{
Id = model.Id,
TenKhoanChi = model.TenKhoanChi,
ThuTu = model.ThuTu,
SuDung = model.SuDung,
IdLoaiKhoanChi = model.IdLoaiKhoanChi
});
//context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON");
return(Ok(await context.SaveChangesAsync()));
}
}
public async Task <IActionResult> Put(int id, [FromBody] KhoanChiDTO model)
{
using (var context = new UserProfileDbContext())
{
var user = await context.KhoanChis.FirstOrDefaultAsync(x => x.Id.Equals(id));
if (user == null)
{
return(NotFound());
}
user.Id = model.Id;
user.TenKhoanChi = model.TenKhoanChi;
user.ThuTu = model.ThuTu;
user.SuDung = model.SuDung;
user.IdLoaiKhoanChi = model.IdLoaiKhoanChi;
return(Ok(await context.SaveChangesAsync()));
}
}
public bool xoakhoanchi(KhoanChiDTO kc)
{
bool kq = kcd.xoakhoanchi(kc);
return(kq);
}
public bool themkhoanchi(KhoanChiDTO kc)
{
bool kq = kcd.themkhoanchi(kc);
return(kq);
}
public DataTable kttrungten(KhoanChiDTO kc)
{
DataTable da = kcd.kttrungten(kc);
return(da);
}
