public ActionResult create(string Nam, string NamHoc, string tuNgay, string denNgay, bool NamHienTai)
{
if (String.IsNullOrEmpty(NamHoc))
{
return(Json(new ResultInfo()
{
error = 1, msg = "Missing info"
}, JsonRequestBehavior.AllowGet));
}
DateTime dateFrom = DateTime.Parse(tuNgay);
DateTime dateTo = DateTime.Parse(denNgay);
var check = db.DM_NamHoc.Where(p => p.MaTruong == MaTruong && p.NamHoc == NamHoc).FirstOrDefault();
if (check != null)
{
return(Json(new ResultInfo()
{
error = 1, msg = "Đã tồn tại"
}, JsonRequestBehavior.AllowGet));
}
//kiem tra neu la nam hoc hien tai thi xoa nhưng cai con lai
if (NamHienTai == true)
{
db.DM_NamHoc.Where(x => x.MaTruong == MaTruong && x.NamHoc != NamHoc).ToList().ForEach(x =>
{
x.NamHienTai = false;
});
db.SaveChanges();
}
var insData = new DM_NamHoc()
{
Nam = Nam,
NamHoc = NamHoc,
TuNgay = dateFrom,
DenNgay = dateTo,
MaTruong = MaTruong,
NamHienTai = NamHienTai
};
db.DM_NamHoc.Add(insData);
db.SaveChanges();
return(Json(new ResultInfo()
{
error = 0, msg = "", data = insData
}, JsonRequestBehavior.AllowGet));
}
public ActionResult edit(DM_NamHoc namhoc, string tuNgay, string denNgay)
{
if (String.IsNullOrEmpty(namhoc.NamHoc))
{
return(Json(new ResultInfo()
{
error = 1, msg = "Missing info"
}, JsonRequestBehavior.AllowGet));
}
DateTime dateFrom = DateTime.Parse(tuNgay);
DateTime dateTo = DateTime.Parse(denNgay);
var check = db.DM_NamHoc.Where(p => p.MaTruong == MaTruong && p.NamHoc == namhoc.NamHoc).FirstOrDefault();
if (check == null)
{
return(Json(new ResultInfo()
{
error = 1, msg = "Không tìm thấy thông tin"
}, JsonRequestBehavior.AllowGet));
}
if (namhoc.NamHienTai == true)
{
db.DM_NamHoc.Where(x => x.MaTruong == MaTruong && x.NamHoc != namhoc.NamHoc).ToList().ForEach(x =>
{
x.NamHienTai = false;
});
// db.SaveChanges();
}
check.Nam = namhoc.Nam;
check.MaTruong = MaTruong;
namhoc.TuNgay = dateFrom;
namhoc.DenNgay = dateTo;
check.DenNgay = namhoc.DenNgay;
check.NamHienTai = namhoc.NamHienTai;
db.Entry(check).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(new ResultInfo()
{
error = 0, msg = "", data = check
}, JsonRequestBehavior.AllowGet));
}
public ActionResult create(DM_NamHoc nh)
{
if (String.IsNullOrEmpty(nh.NamHoc))
{
return(Json(new ResultInfo()
{
error = 1, msg = "Chưa nhập thông tin năm học"
}, JsonRequestBehavior.AllowGet));
}
// 20/12/2018
db.DM_NamHoc.Add(nh);
db.SaveChanges();
return(Json(new ResultInfo()
{
error = 0, msg = "", data = nh
}, JsonRequestBehavior.AllowGet));
}
public ActionResult edit(DM_NamHoc nh)
{
if (String.IsNullOrEmpty(nh.NamHoc))
{
return(Json(new ResultInfo()
{
error = 1, msg = "Chưa nhập năm học"
}, JsonRequestBehavior.AllowGet));
}
var check = db.DM_NamHoc.Where(p => p.MaDonVi == MaDonVi && p.NamHoc == nh.NamHoc).FirstOrDefault();
check.NamHoc = nh.NamHoc;
db.Entry(check).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(new ResultInfo()
{
error = 0, msg = "", data = check
}, JsonRequestBehavior.AllowGet));
}
public ActionResult create(string NamHoc, string NienKhoa, string tuNgay, string denNgay, bool HienTai)
{
if (String.IsNullOrEmpty(NamHoc))
{
return(Json(new ResultInfo()
{
error = 1, msg = "Missing info"
}, JsonRequestBehavior.AllowGet));
}
// 20/12/2018
string tngay = tuNgay.Substring(0, 2);
string tthang = tuNgay.Substring(3, 2);
string tnam = tuNgay.Substring(6, 4);
string dngay = denNgay.Substring(0, 2);
string dthang = denNgay.Substring(3, 2);
string dnam = denNgay.Substring(6, 4);
string sysFormat = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern;
//format sever M/d/yyyy
DateTime dateFrom;
DateTime dateTo;
if (sysFormat == "M/d/yyyy")
{
dateFrom = DateTime.Parse(tthang + '/' + tngay + '/' + tnam);
dateTo = DateTime.Parse(dthang + '/' + dngay + '/' + dnam);
}
else
{
dateFrom = DateTime.Parse(tuNgay);
dateTo = DateTime.Parse(denNgay);
}
var check = db.DM_NamHoc.Where(p => p.MaTruong == MaDonVi && p.NamHoc == NamHoc).FirstOrDefault();
if (check != null)
{
return(Json(new ResultInfo()
{
error = 1, msg = "Đã tồn tại"
}, JsonRequestBehavior.AllowGet));
}
//kiem tra neu la nam hoc hien tai thi xoa nhưng cai con lai
if (HienTai == true)
{
db.DM_NamHoc.Where(x => x.MaTruong == MaDonVi && x.NamHoc != NamHoc).ToList().ForEach(x =>
{
x.HienTai = false;
});
db.SaveChanges();
}
var insData = new DM_NamHoc()
{
NamHoc = NamHoc,
TuNgay = dateFrom,
DenNgay = dateTo,
MaTruong = MaDonVi,
NienKhoa = NienKhoa,
HienTai = HienTai
};
db.DM_NamHoc.Add(insData);
db.SaveChanges();
return(Json(new ResultInfo()
{
error = 0, msg = "", data = sysFormat
}, JsonRequestBehavior.AllowGet));
}
public ActionResult edit(DM_NamHoc namhoc, string tuNgay, string denNgay)
{
if (String.IsNullOrEmpty(namhoc.NamHoc))
{
return(Json(new ResultInfo()
{
error = 1, msg = "Missing info"
}, JsonRequestBehavior.AllowGet));
}
string tngay = tuNgay.Substring(0, 2);
string tthang = tuNgay.Substring(3, 2);
string tnam = tuNgay.Substring(6, 4);
string dngay = denNgay.Substring(0, 2);
string dthang = denNgay.Substring(3, 2);
string dnam = denNgay.Substring(6, 4);
string sysFormat = CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern;
//format sever M/d/yyyy
DateTime dateFrom;
DateTime dateTo;
if (sysFormat == "M/d/yyyy")
{
dateFrom = DateTime.Parse(tthang + '/' + tngay + '/' + tnam);
dateTo = DateTime.Parse(dthang + '/' + dngay + '/' + dnam);
}
else
{
dateFrom = DateTime.Parse(tuNgay);
dateTo = DateTime.Parse(denNgay);
}
var check = db.DM_NamHoc.Where(p => p.MaTruong == MaDonVi && p.NamHoc == namhoc.NamHoc).FirstOrDefault();
if (check == null)
{
return(Json(new ResultInfo()
{
error = 1, msg = "Không tìm thấy thông tin"
}, JsonRequestBehavior.AllowGet));
}
if (namhoc.HienTai == true)
{
db.DM_NamHoc.Where(x => x.MaTruong == MaDonVi && x.NamHoc != namhoc.NamHoc).ToList().ForEach(x =>
{
x.HienTai = false;
});
// db.SaveChanges();
}
check.NamHoc = namhoc.NamHoc;
check.MaTruong = MaDonVi;
namhoc.TuNgay = dateFrom;
namhoc.DenNgay = dateTo;
check.DenNgay = namhoc.DenNgay;
check.HienTai = namhoc.HienTai;
check.NienKhoa = namhoc.NamHoc;
db.Entry(check).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(new ResultInfo()
{
error = 0, msg = "", data = check
}, JsonRequestBehavior.AllowGet));
}
