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();
}
}
}
