public ActionResult Create([Bind(Include = "trinhDo,hoTen,soDT,ngaySinh,email,diaChi,gioiTinh,hinhAnh,maDanToc,maTonGiao")] Tbl_GiaoVien tbl_GiaoVien)
{
if (ModelState.IsValid)
{
//code create hình ảnh
var posted = Request.Files["hinhAnh"];
if (Request.Files != null)
{
const string pathStoredImage = "~/images/";
var imageName = Path.GetFileName(posted.FileName);
var filePath = pathStoredImage + imageName;
posted.SaveAs(Server.MapPath(filePath));
tbl_GiaoVien.hinhAnh = posted.FileName;
}
tbl_GiaoVien.maGV = "GV" + a.Next(100000);
TempData["magv"] = tbl_GiaoVien.maGV;
db.Tbl_GiaoVien.Add(tbl_GiaoVien);
db.SaveChanges();
ThemTaiKhoan();
return(RedirectToAction("Index"));
}
ViewBag.maDanToc = new SelectList(db.Tbl_DanToc, "maDanToc", "tenDanToc", tbl_GiaoVien.maDanToc);
ViewBag.maTonGiao = new SelectList(db.Tbl_TonGiao, "maTonGiao", "tenTonGiao", tbl_GiaoVien.maTonGiao);
return(View(tbl_GiaoVien));
}
public ActionResult Create([Bind(Include = "maHS,hoTenCha,hoTenMe,hoTen,soDTNha,ngaySinh,email,diaChi,gioiTinh,hinhAnh,maNgheNghiepMe,maNgheNghiepCha,maTonGiao,maDanToc")] Tbl_HocSinh tbl_HocSinh)
{
ViewBag.maDanToc = db.Tbl_DanToc.ToList();
ViewBag.maTonGiao = db.Tbl_TonGiao.ToList();
ViewBag.maNgheNghiepMe = db.Tbl_NgheNghiepMe.ToList();
ViewBag.maNgheNghiepCha = db.Tbl_NgheNghiepCha.ToList();
if (ModelState.IsValid)
{
if (tbl_HocSinh.ngaySinh == null)
{
tbl_HocSinh.maLoai = null;
}
else
{
if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 2 && GetTuoi(tbl_HocSinh.ngaySinh.Value) <= 3)
{
tbl_HocSinh.maLoai = "L01";
}
else if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 4 && GetTuoi(tbl_HocSinh.ngaySinh.Value) < 5)
{
tbl_HocSinh.maLoai = "L02";
}
else if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 5 && GetTuoi(tbl_HocSinh.ngaySinh.Value) <= 6)
{
tbl_HocSinh.maLoai = "L03";
}
}
db.Tbl_HocSinh.Add(tbl_HocSinh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_HocSinh));
}
public ActionResult TaoBangLuong(string maThang, string maNamHoc, int?sotienngay)
{
if (sotienngay == null)
{
TempData["sotien"] = "Nhập số tiền";
}
else
{
var tl = db.Tbl_TienLuong.Where(x => x.maThang == maThang && x.maNamHoc == maNamHoc).FirstOrDefault();
if (tl != null)
{
TempData["dd"] = "Tháng này đã tạo bảng lương";
}
else
{
Tbl_TienLuong tienluong = new Tbl_TienLuong();
tienluong.maNamHoc = maNamHoc;
tienluong.maThang = maThang;
tienluong.soTienNgay = sotienngay;
db.Tbl_TienLuong.Add(tienluong);
db.SaveChanges();
TaoLuong(maThang, maNamHoc, sotienngay);
}
}
return(RedirectToAction("Index"));
}
public ActionResult DiemDanhNgay(string ngaydiemdanh)
{
if (ngaydiemdanh == "")
{
TempData["tb"] = "Chọn ngày,tháng,năm";
}
else
{
string ngay = ngaydiemdanh.Substring(8);
string maThang = ngaydiemdanh.Substring(5, 2);
string maNamHoc = ngaydiemdanh.Substring(0, 4);
var dd = db.Tbl_DiemDanh.Where(x => x.ngayDiemDanh == ngay && x.maThang == maThang && x.maNamHoc == maNamHoc).FirstOrDefault();
if (dd != null)
{
TempData["dd"] = "Ngày Điểm Danh Đã Tạo";
}
else
{
TempData["ngay"] = ngay;
TempData["thang"] = maThang;
TempData["nam"] = maNamHoc;
Tbl_DiemDanh diemdanh = new Tbl_DiemDanh();
diemdanh.maNamHoc = maNamHoc;
diemdanh.maThang = maThang;
diemdanh.ngayDiemDanh = ngay;
db.Tbl_DiemDanh.Add(diemdanh);
db.SaveChanges();
TaoDiemDanh();
}
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "maDanToc,tenDanToc")] Tbl_DanToc tbl_DanToc)
{
if (ModelState.IsValid)
{
db.Tbl_DanToc.Add(tbl_DanToc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_DanToc));
}
public ActionResult Create([Bind(Include = "maTonGiao,tenTonGiao")] Tbl_TonGiao tbl_TonGiao)
{
if (ModelState.IsValid)
{
db.Tbl_TonGiao.Add(tbl_TonGiao);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_TonGiao));
}
public ActionResult Create([Bind(Include = "maNgheNghiepMe,tenNgheNghiepMe")] Tbl_NgheNghiepMe tbl_NgheNghiepMe)
{
if (ModelState.IsValid)
{
db.Tbl_NgheNghiepMe.Add(tbl_NgheNghiepMe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_NgheNghiepMe));
}
public ActionResult Create([Bind(Include = "maNamHoc,tenNamHoc,tienThang")] Tbl_NamHoc tbl_NamHoc)
{
if (ModelState.IsValid)
{
db.Tbl_NamHoc.Add(tbl_NamHoc);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(tbl_NamHoc);
}
public ActionResult Create([Bind(Include = "maBaiViet,tenBaiViet,noiDung,hinhBV,maLoai,ngayDang")] Tbl_BaiViet tbl_BaiViet)
{
if (ModelState.IsValid)
{
db.Tbl_BaiViet.Add(tbl_BaiViet);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.maLoai = new SelectList(db.Tbl_LoaiBaiViet, "maLoai", "TenLoai");
return(View(tbl_BaiViet));
}
public ActionResult Create([Bind(Include = "maLop,tenLop,soLuongHS,maLoai,maNamHoc")] Tbl_LopHoc tbl_LopHoc)
{
if (ModelState.IsValid)
{
tbl_LopHoc.maLop = "M" + a.Next(100000);
db.Tbl_LopHoc.Add(tbl_LopHoc);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.maLoai = new SelectList(db.Tbl_LoaiLop, "maLoai", "tenLoai", tbl_LopHoc.maLoai);
//ViewBag.maNamHoc = new SelectList(db.Tbl_NamHoc, "maNamHoc", "tenNamHoc", tbl_LopHoc.maNamHoc);
return(View(tbl_LopHoc));
}
// phân công 1 lớp chỉ có 1 giáo viên
public ActionResult PhanCong(string maLop, string maGV, string maNamHoc)
{
int dem = 0;
var lh = db.Tbl_LopHoc.Where(x => x.maLop == maLop).FirstOrDefault();
//var nh = db.Tbl_NamHoc.Where(x => x.maNamHoc == lh.maNamHoc).FirstOrDefault();
if (maGV == null || maLop == null)
{
TempData["loinull"] = "abc";
}
else
{
foreach (var item in db.Tbl_PhanCong)
{
if (item.maLop == maLop)
{
dem++;
}
}
if (dem == 2)
{
TempData["loi"] = "abc";
}
else
{
var pc = db.Tbl_PhanCong.Where(x => x.maGV == maGV).FirstOrDefault();
if (pc != null)
{
TempData["loipc"] = "Mỗi giáo viên chỉ được dạy 1 lớp";
}
else
{
var loai = db.Tbl_LopHoc.Where(x => x.maLop == maLop).FirstOrDefault();
Tbl_PhanCong phancong = new Tbl_PhanCong();
phancong.maLop = maLop;
phancong.maLoai = loai.maLoai;
phancong.maNamHoc = maNamHoc;
phancong.maGV = maGV;
db.Tbl_PhanCong.Add(phancong);
db.SaveChanges();
}
}
}
return(RedirectToAction("Indexpl"));
}
public ActionResult DoiMatKhau(string id, string matKhau, string loai)
{
var mk = db.Tbl_TaiKhoan.Where(x => x.maGV == id).FirstOrDefault();
mk.matKhau = matKhau;
db.SaveChanges();
TempData["mk"] = "abc";
return(Redirect(loai));
}
// GET: InBaoCaoHS
public ActionResult InDanhSachHSTheoLop(string malop, string manamhoc)
{
string a = Session["malopin"].ToString();
string b = Session["manamin"].ToString();
var pl = db.Tbl_PhanLop.Where(x => x.maNamHoc == b && x.maLop == a).ToList();
foreach (var item in pl)
{
Tbl_InDanhSachHS inpc = new Tbl_InDanhSachHS();
inpc.idPhanLop = item.idPhanLop;
inpc.maLop = item.maLop;
inpc.hoTenHS = item.Tbl_HocSinh.hoTen;
inpc.maNamHoc = item.maNamHoc;
inpc.tenLop = item.Tbl_LopHoc.tenLop;
inpc.tenNamHoc = item.Tbl_NamHoc.tenNamHoc;
inpc.ngaySinh = Convert.ToDateTime(item.Tbl_HocSinh.ngaySinh);
inpc.soDTNha = item.Tbl_HocSinh.soDTNha;
inpc.diaChi = item.Tbl_HocSinh.diaChi;
inpc.gioiTinh = item.Tbl_HocSinh.gioiTinh;
db.Tbl_InDanhSachHS.Add(inpc);
db.SaveChanges();
}
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports/InDanhSachHS.rpt")));
rd.Refresh();
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
foreach (var item in pl)
{
var dss = db.Tbl_InDanhSachHS.ToList().Where(x => x.maLop == a && x.maNamHoc == b).FirstOrDefault();
db.Tbl_InDanhSachHS.Remove(dss);
db.SaveChanges();
}
return(File(stream, "application/pdf", "InDanhSachHS.pdf"));
}
public ActionResult TaoBangHP(string maThang, string maNamHoc)
{
var tl = db.Tbl_HocPhi.Where(x => x.maThang == maThang && x.maNamHoc == maNamHoc).FirstOrDefault();
if (tl != null)
{
TempData["dd"] = "Tháng này đã tạo bảng học phí ";
}
else
{
Tbl_HocPhi tienHP = new Tbl_HocPhi();
tienHP.maNamHoc = maNamHoc;
tienHP.maThang = maThang;
db.Tbl_HocPhi.Add(tienHP);
db.SaveChanges();
TaoChiTietHP(maThang, maNamHoc);
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "idQLHP,tienThangHP,maLoai")] Tbl_QuanLyHocPhi tbl_QuanLyHocPhi)
{
if (ModelState.IsValid)
{
db.Tbl_QuanLyHocPhi.Add(tbl_QuanLyHocPhi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.maLoai = db.Tbl_LoaiLop.ToList();
return(View(tbl_QuanLyHocPhi));
}
public ActionResult LenLop()
{
string ab = (DateTime.Now.Year).ToString();
int n = DateTime.Now.Year;
var c = db.Tbl_PhanLop.Select(x => x.maNamHoc).Max();
if ((n + 1 == Convert.ToInt32(c)))
{
TempData["loi"] = "Bạn đã lên lớp cho những học sinh năm này rồi!";
}
else
{
var e = db.Tbl_PhanLop.ToList().Where(x => x.maNamHoc == ab);
foreach (var item in e)
{
int a = Convert.ToInt16(item.maNamHoc);
a = a + 1;
string b = Convert.ToString(a);
item.maNamHoc = b;
string abc = item.maLop.Substring(1);
if (item.maLoai == "L01")
{
item.maLoai = "L02";
item.maLop = "C" + abc;
}
else if (item.maLoai == "L02")
{
item.maLoai = "L03";
item.maLop = "L" + abc;
}
else
{
item.maLoai = "L04";
}
db.Tbl_PhanLop.Add(item);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult InLuongTheoThang()
{
int a = Convert.ToInt32(TempData["maluongin"]);
//var tienluong = db.Tbl_TienLuong.Where(x => x.maLuong == a).ToList();
var ctll = db.Tbl_ChiTietLuong.Where(x => x.maLuong == a).ToList();
foreach (var item in ctll)
{
Tbl_InLuong inluong = new Tbl_InLuong();
inluong.maGV = item.maGV;
inluong.maLuong = item.maLuong;
inluong.soNgayLam = Convert.ToInt32(item.soNgayLam);
inluong.soTien = Convert.ToInt32(item.soTien);
inluong.hoTen = item.Tbl_GiaoVien.hoTen;
inluong.tenThang = item.Tbl_TienLuong.maThang;
inluong.maNamHoc = item.Tbl_TienLuong.maNamHoc;
int b = Convert.ToInt16(inluong.maNamHoc);
int c = b + 1;
string d = b.ToString() + "-" + c.ToString();;
inluong.tenNamHoc = d;
db.Tbl_InLuong.Add(inluong);
db.SaveChanges();
}
//// Insert into Tbl_InLuong
//StringBuilder strSQL = new StringBuilder();
//strSQL.Append(" INSERT INTO [Tbl_InLuong] ");
//strSQL.Append(" ([hoTen] ");
//strSQL.Append(" ,[soNgayLam] ");
//strSQL.Append(" ,[soTien] ");
//strSQL.Append(" ,[maGV] ");
//strSQL.Append(" ,[maLuong]) ");
//strSQL.Append(" SELECT ");
//strSQL.Append(" GV.hoTen ");
//strSQL.Append(" , CTL.soNgayLam ");
//strSQL.Append(" , CTL.soTien ");
//strSQL.Append(" , GV.maGV ");
//strSQL.Append(" , CTL.maLuong ");
//strSQL.Append(" FROM ");
//strSQL.Append(" Tbl_GiaoVien GV ");
//strSQL.Append(" , Tbl_ChiTietLuong CTL ");
//strSQL.Append(" , Tbl_TienLuong TL ");
//strSQL.Append(" WHERE ");
//strSQL.Append(" GV.maGV = CTL.maGV ");
//strSQL.Append(" AND CTL.maLuong = TL.maLuong ");
//strSQL.Append(" AND CTL.maLuong = '" + a.ToString() + "' ");
//db.Database.ExecuteSqlCommand(strSQL.ToString());
//db.SaveChanges();
// print report
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports/Luong.rpt")));
rd.Refresh();
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
//// Delete worktable
//strSQL = new StringBuilder();
//strSQL.Append(" DELETE FROM ");
//strSQL.Append(" Tbl_InLuong ");
//strSQL.Append(" WHERE ");
//strSQL.Append(" maLuong = '" + a + "' ");
//db.Database.ExecuteSqlCommand(strSQL.ToString());
//db.SaveChanges();
foreach (var item in ctll)
{
var ab = db.Tbl_InLuong.Where(x => x.maLuong == a && x.maGV == item.maGV).FirstOrDefault();
db.Tbl_InLuong.Remove(ab);
db.SaveChanges();
}
return(File(stream, "application/pdf", "Luong.pdf"));
// return Redirect(loai);
}