public ActionResult Capnhatchamcong(int id, int ngay, int thang, int nam, FormCollection f, string ncham)
{
List <ChiTietCC> lstCTCC = data.ChiTietCCs.ToList();
ChiTietCC chiTietCC = lstCTCC.SingleOrDefault(n => n.Thang == thang && n.Nam == nam && n.Ngay == ngay && n.MaNV == id);
if (chiTietCC != null)
{
chiTietCC.TrangThai = f["txtTrangThai"].ToString();
data.SubmitChanges();
}
return(RedirectToAction("ChamCong", new { /*Ngaycham = ngay + "/" + thang + "/" + nam*/ Ngaycham = ncham }));
}
//public List<ChamCong> getChamCong(int iMaNV)
//{
// List<ChamCong> lstChamCong = new List<ChamCong>();
// ChamCong chamcong = lstChamCong.Find(n => n.iMaNV == iMaNV)
// if (chamcong == null)
// {
// chamcong = new ChamCong(iMaNV);
// }
//}
public ActionResult ChamCong(string Ngaycham)
{
QuanLy tk = (QuanLy)Session["Taikhoanadmin"];
if (tk.Allower == 2 || tk.Allower == 4)
{
IQueryable <ChiTietCC> chamcong = data.ChiTietCCs;
ViewBag.Ngaycham = Ngaycham;
if (!string.IsNullOrEmpty(Ngaycham))
{
DateTime ngaycham = Convert.ToDateTime(Ngaycham);
DateTime now = DateTime.Now;
if (DateTime.Compare(ngaycham, now) <= 0)
{
BangCC bccong = data.BangCCs.SingleOrDefault(n => n.Thang == Convert.ToInt16(ngaycham.Month) && n.Nam == Convert.ToInt16(ngaycham.Year));
if (bccong == null)
{
BangCC bcc = new BangCC();
List <NhanVien> lstNV = data.NhanViens.ToList();
bcc.Thang = Convert.ToInt16(ngaycham.Month);
bcc.Nam = Convert.ToInt16(ngaycham.Year);
data.BangCCs.InsertOnSubmit(bcc);
data.SubmitChanges();
foreach (var item in lstNV)
{
if (DateTime.Compare(item.NgayVaoLam, ngaycham) < 0)
{
ChiTietCC cc = new ChiTietCC();
cc.Thang = bcc.Thang;
cc.Nam = bcc.Nam;
cc.Ngay = Convert.ToInt16(ngaycham.Day);
cc.MaNV = item.MaNV;
data.ChiTietCCs.InsertOnSubmit(cc);
}
}
data.SubmitChanges();
chamcong = chamcong.Where(n => n.Thang == Convert.ToInt16(ngaycham.Month) && n.Nam == Convert.ToInt16(ngaycham.Year) && n.Ngay == Convert.ToInt16(ngaycham.Day));
}
else if (bccong != null)
{
ChiTietCC chiTietCC = data.ChiTietCCs.ToList().Find(n => n.Thang == Convert.ToInt16(ngaycham.Month) && n.Nam == Convert.ToInt16(ngaycham.Year) && n.Ngay == Convert.ToInt16(ngaycham.Day));
if (chiTietCC == null)
{
List <NhanVien> lstNV = data.NhanViens.ToList();
foreach (var item in lstNV)
{
if (DateTime.Compare(item.NgayVaoLam, ngaycham) < 0)
{
ChiTietCC cc = new ChiTietCC();
cc.Thang = bccong.Thang;
cc.Nam = bccong.Nam;
cc.Ngay = Convert.ToInt16(ngaycham.Day);
cc.MaNV = item.MaNV;
data.ChiTietCCs.InsertOnSubmit(cc);
}
}
data.SubmitChanges();
chamcong = chamcong.Where(n => n.Thang == Convert.ToInt16(ngaycham.Month) && n.Nam == Convert.ToInt16(ngaycham.Year) && n.Ngay == Convert.ToInt16(ngaycham.Day));
}
else
{
chamcong = chamcong.Where(n => n.Thang == Convert.ToInt16(ngaycham.Month) && n.Nam == Convert.ToInt16(ngaycham.Year) && n.Ngay == Convert.ToInt16(ngaycham.Day));
}
}
}
}
return(View(chamcong.ToList().OrderByDescending(n => DateTime.Parse(n.Ngay + "/" + n.Thang + "/" + n.Nam))));
}
else
{
return(RedirectToAction("ThongBao", "Admin"));
}
}
public ActionResult Luong(string NV, string Year, string Month)
{
QuanLy tk = (QuanLy)Session["Taikhoanadmin"];
if (tk.Allower == 2 || tk.Allower == 4)
{
IQueryable <Luong> luong = data.Luongs;
ViewBag.Thang = Month;
ViewBag.Nam = Year;
ViewBag.MaNV = NV;
if (DateTime.Now.Day <= 5)
{
if (!String.IsNullOrEmpty(Month) && !String.IsNullOrEmpty(Year))
{
int thang = Convert.ToInt32(Month);
int nam = Convert.ToInt32(Year);
BangCC cc = data.BangCCs.SingleOrDefault(n => n.Thang == thang && n.Nam == nam);
if (cc != null)
{
if (String.IsNullOrEmpty(NV))
{
List <NhanVien> lstNV = data.NhanViens.ToList();
foreach (var item in lstNV)
{
Luong lstLuong = data.Luongs.ToList().Find(n => n.Thang == thang && n.Nam == nam && n.MaNV == item.MaNV);
if (lstLuong == null)
{
data.TinhLuong(item.MaNV, thang, nam);
data.SubmitChanges();
}
else
{
data.CapNhatLuong(item.MaNV, thang, nam);
data.SubmitChanges();
}
}
luong = luong.Where(n => n.Thang == thang && n.Nam == nam);
}
else
{
int manv = Convert.ToInt32(NV);
Luong lstLuong = data.Luongs.ToList().Find(n => n.Thang == thang && n.Nam == nam && n.MaNV == manv);
if (lstLuong == null)
{
data.TinhLuong(manv, thang, nam);
data.SubmitChanges();
}
else
{
data.CapNhatLuong(manv, thang, nam);
data.SubmitChanges();
}
luong = luong.Where(n => n.Thang == thang && n.Nam == nam && n.MaNV == manv);
}
}
}
}
else
{
if (!String.IsNullOrEmpty(Month) && !String.IsNullOrEmpty(Year) && !String.IsNullOrEmpty(NV))
{
int thang = Convert.ToInt32(Month);
int nam = Convert.ToInt32(Year);
int manv = Convert.ToInt32(NV);
ChiTietCC chitiet = data.ChiTietCCs.ToList().Find(n => n.Thang == thang && n.Nam == nam && n.MaNV == manv);
if (chitiet != null)
{
Luong lstLuong = data.Luongs.ToList().Find(n => n.Thang == thang && n.Nam == nam && n.MaNV == manv);
if (lstLuong == null)
{
data.TinhLuong(manv, thang, nam);
data.SubmitChanges();
}
else
{
data.CapNhatLuong(manv, thang, nam);
data.SubmitChanges();
}
luong = luong.Where(n => n.Thang == thang && n.Nam == nam && n.MaNV == manv);
}
}
}
return(View(luong.ToList().OrderBy(n => n.MaNV)));
}
else
{
return(RedirectToAction("ThongBao", "Admin"));
}
}
