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