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