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