public void insertUpdate(int month, int year, string locationName, DataGridView dataGridView)
{
attendanceContent = new AttendanceContent();
attendanceContentDB = new AttendanceContentDB();
attendanceControl = new AttendanceControl();
bool flag = attendanceControl.checkIfLocationAttendanceSubmitted(month, year, locationName);
int attendanceID = attendanceControl.getID(month, year, locationName);
attendanceContent.setAttendanceID(attendanceID);
bool flag1 = attendanceContentDB.checkIfAttendanceContentIsSubmitted(attendanceContent);
if (flag == true)
{
//submitted //update
if (flag1 == true)
{
this.update(month, year, locationName, dataGridView);
}
else if (flag1 == false)
{
this.insert(dataGridView);
}
}
else if (flag == false)
{
//not submitted //insert
attendanceControl.insert(month, year, locationName);
this.insert(dataGridView);
}
}
public void update(int month, int year, string locationName, DataGridView dataGridView)
{
attendanceControl = new AttendanceControl();
attendanceContent = new AttendanceContent();
attendanceContentDB = new AttendanceContentDB();
int attendanceID = attendanceControl.getID(month, year, locationName);
List <string> list = new List <string>();
foreach (DataGridViewRow row in dataGridView.Rows)
{
list.Clear();
int code = int.Parse(row.Cells[0].Value.ToString());
//string name = row.Cells[1].Value.ToString();
list.Add(row.Cells[2].Value.ToString());
list.Add(row.Cells[3].Value.ToString());
list.Add(row.Cells[4].Value.ToString());
list.Add(row.Cells[5].Value.ToString());
list.Add(row.Cells[6].Value.ToString());
list.Add(row.Cells[7].Value.ToString());
list.Add(row.Cells[8].Value.ToString());
list.Add(row.Cells[9].Value.ToString());
list.Add(row.Cells[10].Value.ToString());
list.Add(row.Cells[11].Value.ToString());
list.Add(row.Cells[12].Value.ToString());
list.Add(row.Cells[13].Value.ToString());
list.Add(row.Cells[14].Value.ToString());
list.Add(row.Cells[15].Value.ToString());
list.Add(row.Cells[16].Value.ToString());
list.Add(row.Cells[17].Value.ToString());
list.Add(row.Cells[18].Value.ToString());
list.Add(row.Cells[19].Value.ToString());
list.Add(row.Cells[20].Value.ToString());
list.Add(row.Cells[21].Value.ToString());
list.Add(row.Cells[22].Value.ToString());
list.Add(row.Cells[23].Value.ToString());
list.Add(row.Cells[24].Value.ToString());
list.Add(row.Cells[25].Value.ToString());
list.Add(row.Cells[26].Value.ToString());
list.Add(row.Cells[27].Value.ToString());
list.Add(row.Cells[28].Value.ToString());
list.Add(row.Cells[29].Value.ToString());
list.Add(row.Cells[30].Value.ToString());
list.Add(row.Cells[31].Value.ToString());
list.Add(row.Cells[32].Value.ToString());
attendanceContent.setDays(list);
attendanceContent.setEmpID(code);
attendanceContent.setAttendanceID(attendanceID);
attendanceContentDB.update(attendanceContent);
}
}