public string Delete(ThongBao position)
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null)
{
HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == position.IdHoatDong);
hd.SLDaDangKi = hd.SLDaDangKi - 1;
DangKiThamGiaHD p = db.DangKiThamGiaHDs.SingleOrDefault(n => n.IdDangKiHD == position.IdDangKiHD);
p.XoaTam = true;
try
{
UpdateModel(hd);
db.SubmitChanges();
UpdateModel(p);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
}
return("Bạn không có quyền xóa");
}
public ActionResult InChungNhan(int id)
{
if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "")
{
return(RedirectToAction("Index", "Login"));
}
else
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
if (nd != null)
{
DangKiThamGiaHD ds = db.DangKiThamGiaHDs.SingleOrDefault(n => n.IdDangKiHD == id);
var a = ds.HoatDong.ThoiGianBD;
DateTime aDateTime = Convert.ToDateTime(a);
ViewBag.day = aDateTime.Day;
ViewBag.month = aDateTime.Month;
ViewBag.year = aDateTime.Year;
ViewBag.scn = ds.IdDangKiHD;
if (ds == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ds));
}
else
{
return(RedirectToAction("Index", "Main"));
}
}
}
public string Add(DangKiThamGiaHD position, HoatDong hd, int id = 0)
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null)
{
hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == id);
hd.SLDaDangKi = hd.SLDaDangKi + 1;
try
{
UpdateModel(hd);
db.SubmitChanges();
position.IdHoatDong = id;
position.XoaTam = false;
position.TrangThai = false;
db.DangKiThamGiaHDs.InsertOnSubmit(position);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
}
return("Bạn không có quyền thêm");
}
public string Delete(DangKiThamGiaHD position)
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null && a.Quyen.MoTa == "xsvthd")
{
DangKiThamGiaHD p = db.DangKiThamGiaHDs.SingleOrDefault(n => n.IdDangKiHD == position.IdDangKiHD);
try
{
p.XoaTam = true;
UpdateModel(p);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
}
return("Bạn không có quyền xóa");
}
public string Delete(NguoiDung position, HoatDong hd, DangKiThamGiaHD dk)
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null && a.Quyen.MoTa == "xsvthd")
{
NguoiDung p = db.NguoiDungs.SingleOrDefault(n => n.IdInfo == position.IdInfo);
p.XoaTam = true;
try
{
List <DangKiThamGiaHD> lstdk = db.DangKiThamGiaHDs.OrderBy(n => n.IdDangKiHD).Where(n => n.IdInfo == position.IdInfo).ToList();
foreach (var a1 in lstdk)
{
List <HoatDong> lsthd = db.HoatDongs.OrderBy(n => n.IdHoatDong).Where(n => n.IdHoatDong == a1.IdHoatDong).ToList();
foreach (var a2 in lsthd)
{
a2.SLDaDangKi = a2.SLDaDangKi - 1;
UpdateModel(a2);
db.SubmitChanges();
}
a1.XoaTam = true;
UpdateModel(a1);
db.SubmitChanges();
}
UpdateModel(p);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
}
return("Bạn không có quyền xóa");
}
public string Add(HoatDong hd)
{
if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "")
{
return("Bạn phải đăng nhập");
}
else
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null)
{
//int id = Convert.ToInt32(Request.Form["idlop"]);
hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == hd.IdHoatDong);
hd.SLDaDangKi = hd.SLDaDangKi + 1;
DangKiThamGiaHD dk = new DangKiThamGiaHD();
try
{
UpdateModel(hd);
db.SubmitChanges();
dk.IdHoatDong = hd.IdHoatDong;
dk.IdInfo = nd.IdInfo;
dk.TrangThai = false;
dk.XoaTam = false;
db.DangKiThamGiaHDs.InsertOnSubmit(dk);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
}
}
return("Lỗi đăng ký");
}
public string Xacnhanthamgia(DangKiThamGiaHD position)
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null)
{
DangKiThamGiaHD p = db.DangKiThamGiaHDs.SingleOrDefault(n => n.IdDangKiHD == position.IdDangKiHD);
if (p.TrangThai == true)
{
try
{
p.TrangThai = false;
UpdateModel(p);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
else if (p.TrangThai == false)
{
try
{
p.TrangThai = true;
UpdateModel(p);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
}
}
return("Bạn không có quyền này");
}
public string LayCn(DangKiThamGiaHD position)
{
DangKiThamGiaHD p = db.DangKiThamGiaHDs.SingleOrDefault(n => n.IdDangKiHD == position.IdDangKiHD);
if (p.LayCn == false)
{
try
{
p.LayCn = true;
UpdateModel(p);
db.SubmitChanges();
}
catch (Exception ex)
{
return(ex.Message);
}
return("ok");
}
return("ko");
}
public ActionResult Index(int id, HttpPostedFileBase fileUpload, HttpPostedFileBase excelfile)
{
if (Session["Taikhoan"] == null || Session["Taikhoan"].ToString() == "")
{
return(RedirectToAction("Index", "Login"));
}
else
{
NguoiDung nd = (NguoiDung)Session["Taikhoan"];
List <Rel_CV_Q> re = db.Rel_CV_Qs.OrderBy(n => n.IdChucVu).Where(n => n.IdChucVu == nd.IdChucVu).ToList();
foreach (var a in re)
{
if (nd != null && a.Quyen.MoTa == "xdssvthd" && fileUpload == null && excelfile == null)
{
HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == id);
List <DangKiThamGiaHD> lstdk = db.DangKiThamGiaHDs.OrderBy(n => n.IdDangKiHD).ToList();
ViewBag.tenhd = hd.TenHoatDong;
ViewBag.bg = hd.Background;
ViewBag.idhd = id;
ViewBag.tgkt = hd.ThoiGianKT;
ViewBag.tgbd = hd.ThoiGianBD;
return(View(lstdk.Where(n => (n.IdHoatDong == hd.IdHoatDong) && (n.XoaTam == false)).ToList()));
}
if (nd != null && a.Quyen.MoTa == "tbgcn" && fileUpload != null)
{
HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == id);
List <DangKiThamGiaHD> lstdk = db.DangKiThamGiaHDs.OrderBy(n => n.IdDangKiHD).ToList();
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/images"), fileName);
ViewBag.chucvu = nd.ChucVu.MoTa;
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
hd.Background = fileName;
UpdateModel(hd);
db.SubmitChanges();
ViewBag.tenhd = hd.TenHoatDong;
ViewBag.bg = hd.Background;
ViewBag.idhd = id;
ViewBag.tgkt = hd.ThoiGianKT;
ViewBag.tgbd = hd.ThoiGianBD;
return(View(lstdk.Where(n => (n.IdHoatDong == hd.IdHoatDong) && (n.XoaTam == false)).ToList()));
}
if (nd != null && excelfile != null)
{
HoatDong hd = db.HoatDongs.SingleOrDefault(n => n.IdHoatDong == id);
List <DangKiThamGiaHD> lstdk = db.DangKiThamGiaHDs.OrderBy(n => n.IdDangKiHD).ToList();
ViewBag.tenhd = hd.TenHoatDong;
ViewBag.bg = hd.Background;
ViewBag.idhd = id;
ViewBag.tgkt = hd.ThoiGianKT;
ViewBag.tgbd = hd.ThoiGianBD;
if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
int tong = 0;
string path = Server.MapPath("~/Excel/" + excelfile.FileName);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
excelfile.SaveAs(path);
// đọc dữ liệu từ file excel
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
try
{
Excel.Range range = worksheet.UsedRange;
List <DangKiThamGiaHD> listds = new List <DangKiThamGiaHD>();
for (int row = 2; row <= range.Rows.Count; row++)
{
DangKiThamGiaHD ds = new DangKiThamGiaHD();
var mssv = string.Concat(((Excel.Range)range.Cells[row, 2]).Text);
List <NguoiDung> lstsv = db.NguoiDungs.ToList();
foreach (var fi in lstsv)
{
if (fi.SoId.Trim() == mssv)
{
ds.IdInfo = fi.IdInfo;
}
}
ds.IdHoatDong = id;
ds.TrangThai = Boolean.Parse(((Excel.Range)range.Cells[row, 4]).Text);
ds.XoaTam = false;
listds.Add(ds);
}
workbook.Close(0);
application.Quit();
try
{
if (ModelState.IsValid)
{
HoatDong hdz = db.HoatDongs.Where(n => n.IdHoatDong == id).SingleOrDefault();
hdz.SLDaDangKi = hdz.SLDaDangKi + listds.Count();
UpdateModel(hdz);
db.SubmitChanges();
foreach (var c in lstdk)
{
foreach (var d in listds)
{
List <DangKiThamGiaHD> lstdk2 = db.DangKiThamGiaHDs.Where(n => (n.IdInfo == d.IdInfo) && (n.IdHoatDong == id)).OrderBy(n => n.IdDangKiHD).ToList();
if (lstdk2.Count == 0)
{
d.LayCn = false;
db.DangKiThamGiaHDs.InsertOnSubmit(d);
UpdateModel(hdz);
db.SubmitChanges();
}
foreach (var y in lstdk2)
{
List <DangKiThamGiaHD> lstdk1 = db.DangKiThamGiaHDs.Where(n => (n.IdDangKiHD == y.IdDangKiHD) && (n.IdInfo == d.IdInfo) && (n.IdHoatDong == id)).OrderBy(n => n.IdDangKiHD).ToList();
if (lstdk1.Count == 1)
{
foreach (var t in lstdk1)
{
t.TrangThai = d.TrangThai;
t.XoaTam = d.XoaTam;
t.LayCn = false;
UpdateModel(t);
db.SubmitChanges();
}
}
}
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
db.SubmitChanges();
}
}
catch (Exception ex)
{
workbook.Close(0);
application.Quit();
}
//return View(lstdk.Where(n => (n.IdHoatDong == hd.IdHoatDong) && (n.XoaTam == false)).ToList());
return(RedirectToAction("Index", "DsSinhvienTheohd", id));
}
else
{
ViewBag.Error = "Bạn chưa chọn file đúng !";
return(View(lstdk.Where(n => (n.IdHoatDong == hd.IdHoatDong) && (n.XoaTam == false)).ToList()));
}
}
}
return(Content("Bạn không có quyền này"));
}
}
