public ActionResult QLCongviec(string submitButton, string showButton, CONGVIEC congviec, FormCollection collection) { var id = collection["jobID"]; var idCD = collection["campaignID"]; var name = collection["jobName"]; var place = collection["jobPlace"]; var detail = collection["jobDetails"]; var pneed = collection["jobPneeded"]; var reservation = collection["reservation"]; var startday = reservation.Split('-')[0]; var endday = reservation.Split('-')[1]; var time = DateTime.Parse(endday) - DateTime.Parse(startday); var cost = collection["jobCost"]; var moreinfo = collection["jobMoreinfo"]; var numofteam = (int)(int.Parse(pneed) / 10); var totalFee = (float)(int.Parse(pneed) * float.Parse(cost)); switch (submitButton) { case "Add": if (ModelState.IsValid) { congviec.Id = id; congviec.IdCD = idCD; congviec.TenCV = name; congviec.DiaDiem = place; congviec.SoLuongNguoi = int.Parse(pneed); congviec.NgayBatDau = DateTime.Parse(startday); congviec.ThoiGian = time.Days; congviec.ChiPhiMotNguoi = decimal.Parse(cost); congviec.MoreInfo = moreinfo; congviec.NoiDung = detail; db.CONGVIECs.InsertOnSubmit(congviec); db.SubmitChanges(); for (int i = 1; i <= numofteam; i++) { DOI doi = new DOI(); doi.Id = id + "-" + i.ToString(); doi.IdCD = idCD; doi.SoLuongThanhVienThamGia = 0; if (i == numofteam) { doi.SoLuongThanhVien = int.Parse(pneed) - (10 * numofteam) + 10; } else { doi.SoLuongThanhVien = 10; } db.DOIs.InsertOnSubmit(doi); db.SubmitChanges(); CTCONGVIEC ctcv = new CTCONGVIEC(); ctcv.IdCV = id; ctcv.IdDoi = id + "-" + i.ToString(); ctcv.KetQuaCV = '0'; db.CTCONGVIECs.InsertOnSubmit(ctcv); db.SubmitChanges(); } PHIEUTHANHTOAN ptt = db.PHIEUTHANHTOANs.FirstOrDefault(n => n.IdCD == idCD); ptt.ChiPhiDuDinh += totalFee; ptt.TongChiPhi = ptt.ChiPhiDuDinh + ptt.CHiPhiPhatSinh; UpdateModel(ptt); db.SubmitChanges(); } return(RedirectToAction("QLCongviec")); case "Edit": var cv = db.CONGVIECs.SingleOrDefault(n => n.Id == id); if (ModelState.IsValid) { cv.IdCD = idCD; cv.TenCV = name; cv.DiaDiem = place; cv.SoLuongNguoi = int.Parse(pneed); cv.NgayBatDau = DateTime.Parse(startday); cv.ThoiGian = time.Days; cv.ChiPhiMotNguoi = decimal.Parse(cost); cv.MoreInfo = moreinfo; cv.NoiDung = detail; UpdateModel(cv); db.SubmitChanges(); } return(RedirectToAction("QLCongviec")); case "Delete": var cvDel = db.CONGVIECs.SingleOrDefault(n => n.Id == id); db.CONGVIECs.DeleteOnSubmit(cvDel); db.SubmitChanges(); return(RedirectToAction("QLCongviec")); default: return(RedirectToAction("QLCongviec")); } }
public ActionResult TinhChiPhi(string submitButton, FormCollection collection) { var id = collection["feeID"]; var idCV = collection["jobID"]; var idCD = collection["campaignID"]; var name = collection["feeName"]; var meaning = collection["feeMeaning"]; var certificate = collection["feeCertificate"]; var price = collection["feePrice"]; switch (submitButton) { case "Add": if (ModelState.IsValid) { PHIEUTHANHTOAN ptt = db.PHIEUTHANHTOANs.FirstOrDefault(n => n.IdCD == idCD); CHIPHIPHATSINH cpps = new CHIPHIPHATSINH(); cpps.IdCV = idCV; cpps.IdPhieuThanhToan = ptt.Id; cpps.Ten = name; cpps.LyDo = meaning; cpps.ChungTu = certificate; cpps.DonGia = double.Parse(price); db.CHIPHIPHATSINHs.InsertOnSubmit(cpps); db.SubmitChanges(); ptt.CHiPhiPhatSinh += double.Parse(price); ptt.TongChiPhi = ptt.ChiPhiDuDinh + ptt.CHiPhiPhatSinh; UpdateModel(ptt); db.SubmitChanges(); } return(RedirectToAction("TinhChiPhi")); case "Edit": var cppsedit = db.CHIPHIPHATSINHs.SingleOrDefault(n => n.Id == int.Parse(id)); if (ModelState.IsValid) { PHIEUTHANHTOAN ptt = db.PHIEUTHANHTOANs.FirstOrDefault(n => n.IdCD == idCD); cppsedit.IdCV = idCV; cppsedit.IdPhieuThanhToan = ptt.Id; cppsedit.Ten = name; cppsedit.LyDo = meaning; cppsedit.ChungTu = certificate; cppsedit.DonGia = double.Parse(price); UpdateModel(cppsedit); db.SubmitChanges(); ptt.CHiPhiPhatSinh += double.Parse(price); ptt.TongChiPhi = ptt.ChiPhiDuDinh + ptt.CHiPhiPhatSinh; UpdateModel(ptt); db.SubmitChanges(); } return(RedirectToAction("TinhChiPhi")); case "Delete": var cppsdel = db.CHIPHIPHATSINHs.SingleOrDefault(n => n.Id == int.Parse(id)); db.CHIPHIPHATSINHs.DeleteOnSubmit(cppsdel); db.SubmitChanges(); return(RedirectToAction("TinhChiPhi")); default: return(RedirectToAction("TinhChiPhi")); } }
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")); } }