//created an array which holds all the values of semIDs
//public Array insertSubSemGridToDb()
//{
// int[] semID = new int[dgvSemesterSubject.RowCount];
// int[] subID = new int[dgvSemesterSubject.RowCount];
// foreach (DataGridViewRow dr in dgvSemesterSubject.Rows)
// {
// for (int i =0; i < dgvSemesterSubject.RowCount; i++)
// {
// int semesterID = Convert.ToInt32(dr.Cells[0].Value);
// semID[i] = i;
// }
// for (int x =0; x < dgvSemesterSubject.RowCount; x++)
// {
// int subjectID = Convert.ToInt32(dr.Cells[0].Value);
// subID[x] = x;
// }
// }
// return semID;
//}
private void btnUpdateDatabse_Click(object sender, EventArgs e)
{
try
{
List <SemesterSubject> saveList = (List <SemesterSubject>)dgvSemesterSubject.DataSource;
if (saveList.Count != 0)
{
systemManager objsystemManager = new systemManager();
Subjects objSubjects = null;
List <Subjects> lstSubjects = new List <Subjects>();
foreach (var item in saveList)
{
objSubjects = new Subjects();
objSubjects.ObjSemesters = new Semesters();
objSubjects.SubjectID = item.SubjectID;
objSubjects.ObjSemesters.SemesterID = item.SemesterID;
lstSubjects.Add(objSubjects);
}
bool res = objsystemManager.insertSubSem(lstSubjects);
if (res)
{
MessageBox.Show("Saved Successfully");
dgvSemesterSubject.DataSource = null;
}
}
else
{
MessageBox.Show("No records has found....\nPlease set values to the feilds before update", "System warning");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}