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