public ActionResult ThemVPCT(FormCollection collection, VANPHONGCHOTHUE vp)
{
try
{
// TODO: Add insert logic here
vp.NGUOILAPPHIEU = int.Parse(collection["nlp12"]);
vp.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
var qh = collection["qqqq"];
vp.ID_QUANHUYEN = int.Parse(qh);
vp.ID_LOAIHINH = int.Parse(collection["loaihinh12"]);
vp.ID_LTT = int.Parse(collection["loaithongtin12"]);
vp.ID_CHITIETLOAI = int.Parse(collection["chitietloai12"]);
vp.SOHIEU = collection["SOHIEU"] + "/2016/PTT-CHCC";
vp.NGAYTAO = DateTime.Now;
vp.THANGTHAI = true;
data.VANPHONGCHOTHUEs.InsertOnSubmit(vp);
data.SubmitChanges();
return(RedirectToAction("Index"));
}
catch
{
ViewData["tp12"] = new SelectList(data.TINHTHANHs, "ID_TINHTHANH", "TEN");
ViewData["nlp12"] = new SelectList(data.NHANVIENs, "ID_NHANVIEN", "TENNV");
ViewData["nkd12"] = new SelectList(data.NHANVIENs, "ID_NHANVIEN", "TENNV");
ViewData["loaihinh12"] = new SelectList(data.LOAIHINHs, "ID_LOAIHINH", "TEN");
ViewData["loaithongtin12"] = new SelectList(data.LOAITHONGTINs.Where(s => s.ID_LOAITAISAN == 3), "ID_LTT", "TEN");
ViewData["chitietloai12"] = new SelectList(data.CHITIETLOAIs.Where(s => s.ID_LOAITAISAN == 3), "ID_CHITIETLOAI", "TEN");
ViewData["quanhuyen12"] = new SelectList(data.QUANHUYENs, "ID_QUANHUYEN", "TEN");
return(View());
}
}
public ActionResult SuaVPCT(int id, FormCollection collection)
{
VANPHONGCHOTHUE vp = data.VANPHONGCHOTHUEs.FirstOrDefault(s => s.ID_VPCT == id);
vp.NGUOILAPPHIEU = int.Parse(collection["nlp12"]);
vp.NGUOIKIEMDUYET = int.Parse(collection["nkd12"]);
var qh = collection["quanhuyen12"];
vp.ID_QUANHUYEN = int.Parse(qh);
vp.ID_LOAIHINH = int.Parse(collection["loaihinh12"]);
vp.ID_LTT = int.Parse(collection["loaithongtin12"]);
vp.ID_CHITIETLOAI = int.Parse(collection["chitietloai12"]);
vp.SOHIEU = collection["SOHIEU"] + "/2016/PTT-CHCC";
vp.NGAYTAO = DateTime.Now;
UpdateModel(vp);
data.SubmitChanges();
return(View(vp));
}
//sua VPCT
public ActionResult SuaVPCT(int id)
{
if (int.Parse(Session["Quyen"].ToString()) == 1)
{
VANPHONGCHOTHUE vp = data.VANPHONGCHOTHUEs.FirstOrDefault(s => s.ID_VPCT == id);
ViewData["ct"] = new SelectList(data.CHUNGTHUTDGs.Where(s => s.TRANGTHAI == true).ToList(), "ID_CHUNGTHU", "SOCHUNGTHU");
ViewData["tp12"] = new SelectList(data.TINHTHANHs, "ID_TINHTHANH", "TEN");
ViewData["nlp12"] = new SelectList(data.NHANVIENs, "ID_NHANVIEN", "TENNV");
ViewData["nkd12"] = new SelectList(data.NHANVIENs, "ID_NHANVIEN", "TENNV");
ViewData["loaihinh12"] = new SelectList(data.LOAIHINHs, "ID_LOAIHINH", "TEN");
ViewData["loaithongtin12"] = new SelectList(data.LOAITHONGTINs.Where(s => s.ID_LOAITAISAN == 3), "ID_LTT", "TEN");
ViewData["chitietloai12"] = new SelectList(data.CHITIETLOAIs.Where(s => s.ID_LOAITAISAN == 3), "ID_CHITIETLOAI", "TEN");
ViewData["quanhuyen12"] = new SelectList(data.QUANHUYENs, "ID_QUANHUYEN", "TEN");
return(View(vp));
}
else
{
Response.StatusCode = 403;
return(null);
}
}
