public async Task <IActionResult> PutChuongTrinh(int id, ChuongTrinh chuongTrinh)
{
if (id != chuongTrinh.MaChuongTrinh)
{
return(BadRequest());
}
_context.Entry(chuongTrinh).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChuongTrinhExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <ChuongTrinh> > PostChuongTrinh(ChuongTrinh chuongTrinh)
{
_context.ChuongTrinh.Add(chuongTrinh);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetChuongTrinh", new { id = chuongTrinh.MaChuongTrinh }, chuongTrinh));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,TenChuongTrinh,TiLeThayDoiGia,IsTang")] ChuongTrinh chuongTrinh)
{
if (id != chuongTrinh.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(chuongTrinh);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChuongTrinhExists(chuongTrinh.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(chuongTrinh));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,ChuongTrinhName,TiLeThayDoiGia,IsTang")] ChuongTrinh chuongTrinh)
{
if (id != chuongTrinh.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
var tenct = new SqlParameter("@Ten", chuongTrinh.ChuongTrinhName);
var ctId = new SqlParameter("@id", chuongTrinh.Id);
var tile = new SqlParameter("@Tile", chuongTrinh.TiLeThayDoiGia);
var tang = new SqlParameter("@Tang", chuongTrinh.IsTang);
_context.Database.ExecuteSqlRaw("EXEC dbo.spEditChuongTrinh @id,@Ten,@Tile,@Tang", ctId, tenct, tile, tang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ChuongTrinhExists(chuongTrinh.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(chuongTrinh));
}
public async Task <IActionResult> Create([Bind("Id,TenChuongTrinh,TiLeThayDoiGia,IsTang")] ChuongTrinh chuongTrinh)
{
if (ModelState.IsValid)
{
_context.Add(chuongTrinh);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(chuongTrinh));
}
public ChuongTrinh LayChuongTrinh(String ma)
{
DataTable tbl = new DataTable();
ChuongTrinh ct = null;
if (tbl.Rows.Count > 0)
{
ct = new ChuongTrinh(Convert.ToString(tbl.Rows[0]["MaChuongTrinh"]), Convert.ToString(tbl.Rows[0]["TenChuongTrinh"]));
}
return(ct);
}
public IActionResult Create([Bind("Id,ChuongTrinhName,TiLeThayDoiGia,IsTang")] ChuongTrinh chuongTrinh)
{
if (ModelState.IsValid)
{
var tenchuongtrinh = new SqlParameter("@Name", chuongTrinh.ChuongTrinhName);
var tile = new SqlParameter("@Tile", chuongTrinh.TiLeThayDoiGia);
var tang = new SqlParameter("@Tang", chuongTrinh.IsTang);
_context.Database.ExecuteSqlRaw("EXEC dbo.spAddChuongTrinh @Name,@Tile,@Tang", tenchuongtrinh, tile, tang);
return(RedirectToAction(nameof(Index)));
}
return(View(chuongTrinh));
}
