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. } }