public ActionResult QLNguoithamgia(string submitButton, SINHVIEN sinhvien, GIANGVIEN giangvien, FormCollection collection) { var id = collection["participaterID"]; var campaignid = collection["campaignID"]; CHIENDICH cd = db.CHIENDICHes.FirstOrDefault(n => n.Id == campaignid); var sumofteam = (int)(cd.SoLuongNguoiCan / 10); var chucvu = collection["positionSelect"]; var reservation = collection["reservation"]; var name = collection["participaterName"]; var birthday = collection["participaterBirthday"]; var gender = collection["gender"]; var phone = collection["participaterPhone"]; var teacherFaculty = collection["facultySelect"]; var teachertest = collection["teachertest"]; var studentclass = collection["studentClass"]; var studentPjoin = collection["studentPartyJoinDay"]; var studentdtb = collection["studentMark"]; ViewBag.ThongBao = gender + " " + chucvu; switch (submitButton) { case "Add": if (ModelState.IsValid) { if (chucvu == "Giáo viên") { giangvien.Id = id; giangvien.IdCD = campaignid; giangvien.IdDoi = campaignid + "0"; giangvien.Ten = name; giangvien.NgaySinh = DateTime.Parse(birthday); giangvien.GioiTinh = char.Parse(gender); giangvien.SDT = phone; giangvien.Khoa = teacherFaculty; db.GIANGVIENs.InsertOnSubmit(giangvien); db.SubmitChanges(); } if (chucvu == "Sinh viên") { sinhvien.Id = id; sinhvien.IdCD = campaignid; sinhvien.IdDoi = campaignid + "0"; sinhvien.Ten = name; sinhvien.NgaySinh = DateTime.Parse(birthday); sinhvien.GioiTinh = char.Parse(gender); sinhvien.SDT = phone; sinhvien.Lop = studentclass; sinhvien.NgayVaoDoan = DateTime.Parse(studentPjoin); sinhvien.DiemTB = float.Parse(studentdtb); db.SINHVIENs.InsertOnSubmit(sinhvien); db.SubmitChanges(); } } return(RedirectToAction("QLNguoithamgia")); case "Edit": if (ModelState.IsValid) { if (chucvu == "Giáo viên") { var gv = db.GIANGVIENs.SingleOrDefault(n => n.Id == id); gv.Ten = name; gv.NgaySinh = DateTime.Parse(birthday); gv.GioiTinh = char.Parse(gender); gv.SDT = phone; gv.Khoa = teacherFaculty; UpdateModel(gv); db.SubmitChanges(); return(RedirectToAction("QLNguoithamgia")); } if (chucvu == "Sinh viên") { var sv = db.SINHVIENs.SingleOrDefault(n => n.Id == id); sv.Ten = name; sv.NgaySinh = DateTime.Parse(birthday); sv.GioiTinh = char.Parse(gender); sv.SDT = phone; sv.Lop = studentclass; sv.NgayVaoDoan = DateTime.Parse(studentPjoin); sv.DiemTB = float.Parse(studentdtb); UpdateModel(sv); db.SubmitChanges(); return(RedirectToAction("QLNguoithamgia")); } } return(RedirectToAction("QLNguoithamgia")); case "Delete": if (chucvu == "Giáo viên") { var gvdel = db.GIANGVIENs.SingleOrDefault(n => n.Id == id); db.GIANGVIENs.DeleteOnSubmit(gvdel); db.SubmitChanges(); return(RedirectToAction("QLNguoithamgia")); } if (chucvu == "Sinh viên") { var svDel = db.SINHVIENs.SingleOrDefault(n => n.Id == id); db.SINHVIENs.DeleteOnSubmit(svDel); db.SubmitChanges(); return(RedirectToAction("QLNguoithamgia")); } return(RedirectToAction("QLNguoithamgia")); default: return(View("QLNguoithamgia")); } }
public ActionResult QLGiangvien(string submitButton, GIANGVIEN giangvien, FormCollection collection) { var id = collection["participaterID"]; var campaignid = collection["campaignID"]; CHIENDICH cd = db.CHIENDICHes.FirstOrDefault(n => n.Id == campaignid); var sumofteam = (int)(cd.SoLuongNguoiCan / 10); var reservation = collection["reservation"]; var name = collection["participaterName"]; var birthday = collection["participaterBirthday"]; var gender = collection["gender"]; var phone = collection["participaterPhone"]; var teacherFaculty = collection["facultySelect"]; var teachertest = collection["teachertest"]; var chiendich = db.CHIENDICHes.SingleOrDefault(n => n.Id == campaignid); switch (submitButton) { case "Add": if (ModelState.IsValid) { giangvien.Id = id; giangvien.IdCD = campaignid; giangvien.IdDoi = campaignid + "0"; giangvien.Ten = name; giangvien.NgaySinh = DateTime.Parse(birthday); giangvien.GioiTinh = char.Parse(gender); giangvien.SDT = phone; giangvien.Khoa = teacherFaculty; db.GIANGVIENs.InsertOnSubmit(giangvien); db.SubmitChanges(); chiendich.SoLuongNguoiThamGia += 1; UpdateModel(chiendich); db.SubmitChanges(); } return(RedirectToAction("QLGiangvien")); case "Edit": if (ModelState.IsValid) { var gv = db.GIANGVIENs.SingleOrDefault(n => n.Id == id); gv.Ten = name; gv.NgaySinh = DateTime.Parse(birthday); gv.GioiTinh = char.Parse(gender); gv.SDT = phone; gv.Khoa = teacherFaculty; UpdateModel(gv); db.SubmitChanges(); return(RedirectToAction("QLGiangvien")); } return(RedirectToAction("QLGiangvien")); case "Delete": var gvdel = db.GIANGVIENs.SingleOrDefault(n => n.Id == id); db.GIANGVIENs.DeleteOnSubmit(gvdel); db.SubmitChanges(); chiendich.SoLuongNguoiThamGia -= 1; UpdateModel(chiendich); db.SubmitChanges(); return(RedirectToAction("QLGiangvien")); default: return(RedirectToAction("QLGiangvien")); } }
public ActionResult QLSinhvien(string submitButton, SINHVIEN sinhvien, FormCollection collection) { var id = collection["participaterID"]; var campaignid = collection["campaignID"]; CHIENDICH cd = db.CHIENDICHes.FirstOrDefault(n => n.Id == campaignid); var sumofteam = (int)(cd.SoLuongNguoiCan / 10); var reservation = collection["reservation"]; var name = collection["participaterName"]; var birthday = collection["participaterBirthday"]; var gender = collection["gender"]; var phone = collection["participaterPhone"]; var studentclass = collection["studentClass"]; var studentPjoin = collection["studentPartyJoinDay"]; var studentdtb = collection["studentMark"]; switch (submitButton) { case "Add": if (ModelState.IsValid) { sinhvien.Id = id; sinhvien.IdCD = campaignid; sinhvien.IdDoi = campaignid + "0"; sinhvien.Ten = name; sinhvien.NgaySinh = DateTime.Parse(birthday); sinhvien.GioiTinh = char.Parse(gender); sinhvien.SDT = phone; sinhvien.Lop = studentclass; sinhvien.NgayVaoDoan = DateTime.Parse(studentPjoin); sinhvien.DiemTB = float.Parse(studentdtb); db.SINHVIENs.InsertOnSubmit(sinhvien); db.SubmitChanges(); } return(RedirectToAction("QLSinhvien")); case "Edit": if (ModelState.IsValid) { var sv = db.SINHVIENs.SingleOrDefault(n => n.Id == id); sv.Ten = name; sv.NgaySinh = DateTime.Parse(birthday); sv.GioiTinh = char.Parse(gender); sv.SDT = phone; sv.Lop = studentclass; sv.NgayVaoDoan = DateTime.Parse(studentPjoin); sv.DiemTB = float.Parse(studentdtb); UpdateModel(sv); db.SubmitChanges(); return(RedirectToAction("QLSinhvien")); } return(RedirectToAction("QLSinhvien")); case "Delete": var svDel = db.SINHVIENs.SingleOrDefault(n => n.Id == id); db.SINHVIENs.DeleteOnSubmit(svDel); db.SubmitChanges(); return(RedirectToAction("QLSinhvien")); default: return(RedirectToAction("QLSinhvien")); } }
public ActionResult QLChiendich(string submitButton, CHIENDICH chiendich, FormCollection collection) { var id = collection["campaignID"]; var name = collection["campaignName"]; var reservation = collection["reservation"]; var startday = reservation.Split('-')[0]; var endday = reservation.Split('-')[1]; var time = DateTime.Parse(endday) - DateTime.Parse(startday); var pneed = collection["campaignPneeded"]; var pjoin = collection["campaignPjoined"]; var meaning = collection["campaignMeaning"]; var moreinfo = collection["campaignMoreinfo"]; var numofteam = (int)(int.Parse(pneed) / 10); switch (submitButton) { case "Add": if (ModelState.IsValid) { chiendich.Id = id; chiendich.Ten = name; chiendich.SoLuongNguoiCan = int.Parse(pneed); chiendich.SoLuongNguoiThamGia = int.Parse(pjoin); chiendich.NgayBatDau = DateTime.Parse(startday); chiendich.ThoiGian = time.Days; chiendich.YNghia = meaning; chiendich.MoreInfo = moreinfo; db.CHIENDICHes.InsertOnSubmit(chiendich); db.SubmitChanges(); DOI doi = new DOI(); doi.Id = id + "0"; doi.IdCD = id; doi.SoLuongThanhVien = 0; doi.SoLuongThanhVienThamGia = 0; db.DOIs.InsertOnSubmit(doi); db.SubmitChanges(); PHIEUTHANHTOAN ptt = new PHIEUTHANHTOAN(); ptt.IdCD = id; ptt.TongChiPhi = 0; ptt.CHiPhiPhatSinh = 0; ptt.ChiPhiDuDinh = 0; db.PHIEUTHANHTOANs.InsertOnSubmit(ptt); db.SubmitChanges(); } return(RedirectToAction("QLChiendich")); case "Edit": var cd = db.CHIENDICHes.SingleOrDefault(n => n.Id == id); if (ModelState.IsValid) { cd.Ten = name; cd.SoLuongNguoiCan = int.Parse(pneed); cd.SoLuongNguoiThamGia = int.Parse(pjoin); cd.NgayBatDau = DateTime.Parse(startday); cd.ThoiGian = time.Days; cd.YNghia = meaning; cd.MoreInfo = moreinfo; UpdateModel(cd); db.SubmitChanges(); } return(RedirectToAction("QLChiendich")); case "Delete": var cdDel = db.CHIENDICHes.SingleOrDefault(n => n.Id == id); db.CHIENDICHes.DeleteOnSubmit(cdDel); db.SubmitChanges(); return(RedirectToAction("QLChiendich")); default: return(View("QLChiendich")); } }