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(AttendanceContent attendanceContent)
{
connection.open();
command = new SqlCommand("update AttendanceContent set d1='" + attendanceContent.getDays()[0] + "' , d2='" + attendanceContent.getDays()[1] + "' , d3='" + attendanceContent.getDays()[2] + "' , d4='" + attendanceContent.getDays()[3] + "' , d5='" + attendanceContent.getDays()[4] + "' , d6='" + attendanceContent.getDays()[5] + "' , d7='" + attendanceContent.getDays()[6] + "' , d8='" + attendanceContent.getDays()[7] + "' , d9='" + attendanceContent.getDays()[8] + "' , d10='" + attendanceContent.getDays()[9] + "' , d11='" + attendanceContent.getDays()[10] + "' , d12='" + attendanceContent.getDays()[11] + "' , d13='" + attendanceContent.getDays()[12] + "' , d14='" + attendanceContent.getDays()[13] + "' , d15='" + attendanceContent.getDays()[14] + "' , d16='" + attendanceContent.getDays()[15] + "' , d17='" + attendanceContent.getDays()[16] + "' , d18='" + attendanceContent.getDays()[17] + "' , d19='" + attendanceContent.getDays()[18] + "' , d20='" + attendanceContent.getDays()[19] + "' , d21='" + attendanceContent.getDays()[20] + "' , d22='" + attendanceContent.getDays()[21] + "' , d23='" + attendanceContent.getDays()[22] + "' , d24='" + attendanceContent.getDays()[23] + "' , d25='" + attendanceContent.getDays()[24] + "' , d26='" + attendanceContent.getDays()[25] + "' , d27='" + attendanceContent.getDays()[26] + "' , d28='" + attendanceContent.getDays()[27] + "' , d29='" + attendanceContent.getDays()[28] + "' , d30='" + attendanceContent.getDays()[29] + "' , d31='" + attendanceContent.getDays()[30] + "' where attendanceID='" + attendanceContent.getAttendanceID() + "' and empID='" + attendanceContent.getEmpID() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public void insert(AttendanceContent attendanceContent)
{
connection.open();
command = new SqlCommand("insert into AttendanceContent values('" + attendanceContent.getAttendanceID() + "' , '" + attendanceContent.getEmpID() + "' , '" + attendanceContent.getDays()[0] + "' , '" + attendanceContent.getDays()[1] + "' , '" + attendanceContent.getDays()[2] + "' , '" + attendanceContent.getDays()[3] + "' , '" + attendanceContent.getDays()[4] + "' , '" + attendanceContent.getDays()[5] + "' , '" + attendanceContent.getDays()[6] + "' , '" + attendanceContent.getDays()[7] + "' , '" + attendanceContent.getDays()[8] + "' , '" + attendanceContent.getDays()[9] + "' , '" + attendanceContent.getDays()[10] + "' , '" + attendanceContent.getDays()[11] + "' , '" + attendanceContent.getDays()[12] + "' , '" + attendanceContent.getDays()[13] + "' , '" + attendanceContent.getDays()[14] + "' , '" + attendanceContent.getDays()[15] + "' , '" + attendanceContent.getDays()[16] + "' , '" + attendanceContent.getDays()[17] + "' , '" + attendanceContent.getDays()[18] + "' , '" + attendanceContent.getDays()[19] + "' , '" + attendanceContent.getDays()[20] + "' , '" + attendanceContent.getDays()[21] + "' , '" + attendanceContent.getDays()[22] + "' , '" + attendanceContent.getDays()[23] + "' , '" + attendanceContent.getDays()[24] + "' , '" + attendanceContent.getDays()[25] + "' , '" + attendanceContent.getDays()[26] + "' , '" + attendanceContent.getDays()[27] + "' , '" + attendanceContent.getDays()[28] + "' , '" + attendanceContent.getDays()[29] + "' , '" + attendanceContent.getDays()[30] + "')", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
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);
}
}
public bool checkIfAttendanceContentIsSubmitted(AttendanceContent attendanceContent)
{
connection.open();
command = new SqlCommand("select count(*) from AttendanceContent where attendanceID='" + attendanceContent.getAttendanceID() + "'", connection.getConnection());
int count = (int)command.ExecuteScalar();
connection.close();
if (count > 0)
{
return(true); // submitted before.
}
else
{
return(false); // not submited before.
}
}
