public ActionResult DichVu(SDDV sDDV, FormCollection collection)
{
if (ModelState.IsValid)
{
int num2;
int.TryParse(collection["var2"], out num2);
sDDV.IDDV = num2;
if (cc.Create(sDDV))
{
return(RedirectToAction("DetailPhong", new { id = sDDV.IDCT }));
}
else
{
ModelState.AddModelError("", "Lỗi khi thêm");
}
}
return(View());
}
public bool Insert(ref string error, string MaHD, string MaDV, int SoLuong)
{
try
{
SDDV dv = new SDDV()
{
MaHD = Convert.ToInt32(MaHD),
MaDV = Convert.ToInt32(MaDV),
SoLuong = (byte)SoLuong
};
entities.SDDVs.Add(dv);
entities.SaveChanges();
error = "";
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public ActionResult Create(FormCollection collection, SDDV sddv)
{
if (ModelState.IsValid)
{
int num, num2;
int.TryParse(collection["var1"], out num);
sddv.IDCT = num;
int.TryParse(collection["var2"], out num2);
sddv.IDDV = num2;
if (cc.Create(sddv))
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Lỗi khi thêm");
}
}
ViewBag.var1 = new SelectList(cc.LoadThuePhong(), "ID", "PHONG");
ViewBag.var2 = new SelectList(cc.LoadDichVu(), "ID", "TEN");
return(View());
}
private bool Delete_SDDV(ref string error, string MaHD, string MaDV)
{
try
{
int mahd = Convert.ToInt32(MaHD);
int madv = Convert.ToInt32(MaDV);
SDDV sddv = new SDDV()
{
MaDV = madv, MaHD = mahd
};
entities.SDDVs.Attach(sddv);
entities.SDDVs.Remove(sddv);
entities.SaveChanges();
error = "";
return(true);
}
catch (Exception ex)
{
error = ex.Message;
return(false);
}
}
public bool Create(SDDV sddv)
{
return(DataProvider.Instance.ExcuteNonQuery("exec pCreateSDDV @idDV , @idCT , @SoLuong ", new object[] { sddv.IDDV, sddv.IDCT, sddv.SOLUONG }) > 0);
}
