private void populateTableChiSoCap(int month, int year) { var tuyenongs = db.Tuyenongs.Where(p => p.IsDelete == false || p.IsDelete == null).ToList(); foreach (var item in tuyenongs) { var chiSoCap = db.Chisocaps.FirstOrDefault(p => p.TuyenongID == item.TuyenongID && p.Thang == month && p.Nam == year); if (chiSoCap == null) { Chisocap chiSoCapTheoThangNam = new Chisocap(); chiSoCapTheoThangNam.Thang = month; chiSoCapTheoThangNam.Nam = year; chiSoCapTheoThangNam.TuyenongID = item.TuyenongID; chiSoCapTheoThangNam.Chiso = 0; db.Chisocaps.Add(chiSoCapTheoThangNam); } db.SaveChanges(); } }
public void NhapSanLuong(String TuyenOngID, String SanLuong, String thang, String nam) { int tuyenongIdToInt = Convert.ToInt32(TuyenOngID); if (!String.IsNullOrEmpty(TuyenOngID)) { var Cthang = DateTime.Now.Month; var Cnam = DateTime.Now.Year; if (!String.IsNullOrEmpty(thang)) { Cthang = Convert.ToInt32(thang); } if (!String.IsNullOrEmpty(nam)) { Cnam = Convert.ToInt32(nam); } Chisocap checkChiSoCapTheoThangNam = db.Chisocaps.FirstOrDefault(p => p.Thang == Cthang && p.Nam == Cnam && p.TuyenongID == tuyenongIdToInt); if (checkChiSoCapTheoThangNam != null) { checkChiSoCapTheoThangNam.Chiso = Convert.ToInt32(SanLuong); db.Entry(checkChiSoCapTheoThangNam).State = EntityState.Modified; db.SaveChanges(); } else { Chisocap chiso = new Chisocap(); chiso.TuyenongID = tuyenongIdToInt; chiso.Thang = Cthang; chiso.Nam = Cnam; chiso.Chiso = Convert.ToInt32(SanLuong); db.Chisocaps.Add(chiso); db.SaveChanges(); } } }