private void eventtable_Click(object sender, EventArgs e) { int selectedrowindex = eventtable.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = eventtable.SelectedRows[0]; Event_Arrange event_Arrange = new Event_Arrange(); event_Arrange.name = selectedRow.Cells["Name"].Value.ToString(); event_Arrange.id = (int)selectedRow.Cells["ID"].Value; event_Arrange.typeID = (int)selectedRow.Cells["TypeID"].Value; event_Arrange.eventStartDateTime = selectedRow.Cells["EventStartDateTime"].Value.ToString(); event_Arrange.eventEndDateTime = selectedRow.Cells["EventEndDateTime"].Value.ToString(); txteventname2.Text = event_Arrange.name; }
private void btndeleteevent_Click(object sender, EventArgs e) { int selectedrowindex = eventtable.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = eventtable.SelectedRows[0]; Event_Arrange event_Arrange = new Event_Arrange(); event_Arrange.name = selectedRow.Cells["Name"].Value.ToString(); event_Arrange.id = (int)selectedRow.Cells["ID"].Value; event_Arrange.print(); if (event_Arrange.id > -1) { DBConnection dbcon = new DBConnection(); dbcon.SqlQuery("DELETE FROM Event WHERE ID=@id"); dbcon.cmd.Parameters.AddWithValue("@id", event_Arrange.id); int val = dbcon.ExNonQuery(); } }
private void btneditevent_Click(object sender, EventArgs e) { int selectedrowindex = eventtable.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = eventtable.SelectedRows[0]; Event_Arrange event_Arrange = new Event_Arrange(); event_Arrange.name = selectedRow.Cells["Name"].Value.ToString(); event_Arrange.id = (int)selectedRow.Cells["ID"].Value; event_Arrange.typeID = (int)selectedRow.Cells["TypeID"].Value; event_Arrange.eventStartDateTime = selectedRow.Cells["EventStartDateTime"].Value.ToString(); event_Arrange.eventEndDateTime = selectedRow.Cells["EventEndDateTime"].Value.ToString(); if (event_Arrange.id > -1) { DBConnection dbcon = new DBConnection(); EventType eventType = new EventType(); dbcon.SqlQuery("SELECT * FROM EventType WHERE EventType=@eventType"); dbcon.cmd.Parameters.AddWithValue("@eventType", dropeventTypes.selectedValue); if (dbcon.cmd.ExecuteScalar() == null) { } else { DataTable dt = new DataTable(); dt = dbcon.ExQuery(); // MessageBox.Show(dt.Rows.Count.ToString()); DataRow dr = dt.Rows[0]; eventType.id = (int)dr["ID"]; } int val = dbcon.ExNonQuery(); dbcon.SqlQuery("UPDATE Event SET Name=@name, TypeID=@newid WHERE ID=@id"); dbcon.cmd.Parameters.AddWithValue("@name", txteventname2.Text); dbcon.cmd.Parameters.AddWithValue("@newid", eventType.id); dbcon.cmd.Parameters.AddWithValue("@id", event_Arrange.id); val = dbcon.ExNonQuery(); } }
private void bunifuFlatButton3_Click(object sender, EventArgs e) { DBConnection dbcon = new DBConnection(); EventType eventType = new EventType(); eventType.eventType = droptype.selectedValue; dbcon.SqlQuery("SELECT * FROM EventType WHERE EventType=@eventType"); dbcon.cmd.Parameters.AddWithValue("@eventType", eventType.eventType); if (dbcon.cmd.ExecuteScalar() == null) { } else { DataTable dt = new DataTable(); dt = dbcon.ExQuery(); // MessageBox.Show(dt.Rows.Count.ToString()); DataRow dr = dt.Rows[0]; eventType.id = (int)dr["ID"]; } int val = dbcon.ExNonQuery(); Event_Arrange event_Arrange = new Event_Arrange(); event_Arrange.name = txteventname.Text; event_Arrange.typeID = eventType.id; event_Arrange.eventStartDateTime = starttime.Value.ToString(); event_Arrange.eventEndDateTime = endtime.Value.ToString(); // event_Arrange.print(); dbcon.SqlQuery("INSERT INTO Event (Name,TypeID,EventStartDateTime,EventEndDateTime) VALUES ( @name, @typeID, @eventStart, @eventEnd)"); // dbcon2.cmd.Parameters.AddWithValue("@arrangementName", arrangement.arrangementName); dbcon.cmd.Parameters.AddWithValue("@name", event_Arrange.name); dbcon.cmd.Parameters.AddWithValue("@typeID", event_Arrange.typeID); dbcon.cmd.Parameters.AddWithValue("@eventStart", event_Arrange.eventStartDateTime); dbcon.cmd.Parameters.AddWithValue("@eventEnd", event_Arrange.eventEndDateTime); val = dbcon.ExNonQuery(); dbcon.SqlQuery("SELECT * FROM Event WHERE Name=@name AND TypeID=@typeID AND EventStartDateTime=@eventStart AND EventEndDateTime=@eventEnd"); dbcon.cmd.Parameters.AddWithValue("@name", event_Arrange.name); dbcon.cmd.Parameters.AddWithValue("@typeID", event_Arrange.typeID); dbcon.cmd.Parameters.AddWithValue("@eventStart", event_Arrange.eventStartDateTime); dbcon.cmd.Parameters.AddWithValue("@eventEnd", event_Arrange.eventEndDateTime); val = dbcon.ExNonQuery(); if (dbcon.cmd.ExecuteScalar() == null) { } else { DataTable dt = new DataTable(); dt = dbcon.ExQuery(); // MessageBox.Show(dt.Rows.Count.ToString()); DataRow dr = dt.Rows[0]; event_Arrange.id = (int)dr["ID"]; } //[matrixarray.Length]; int index = 0; MessageBox.Show(currentarrangement.Length.ToString()); for (int i = 0; i < currentarrangement.Length; i++) { MessageBox.Show("index:" + i + " id:" + event_Arrange.id); currentarrangement[i].eventID = event_Arrange.id; currentarrangement[i].adminID = admin.id; dbcon.SqlQuery("INSERT INTO ArrangementDetails (EventID,AdminID,RoomID,RoomSavedFile) VALUES ( @eventID, @adminID, @roomID, @roomSavedFile)"); // dbcon2.cmd.Parameters.AddWithValue("@arrangementName", arrangement.arrangementName); dbcon.cmd.Parameters.AddWithValue("@eventID", currentarrangement[i].eventID); dbcon.cmd.Parameters.AddWithValue("@adminID", currentarrangement[i].adminID); dbcon.cmd.Parameters.AddWithValue("@roomID", currentarrangement[i].roomID); dbcon.cmd.Parameters.AddWithValue("@roomSavedFile", currentarrangement[i].roomSaveFile); val = dbcon.ExNonQuery(); } if (selectedStudents.Length > 0) { ArrangedStudents[] arrangedStudentsarray = new ArrangedStudents[selectedStudents.Length]; index = 0; foreach (ArrangedStudents arrangedStudents in arrangedStudentsarray) { string name = selectedStudents[0].subjectCode; ArrangedStudents temp = new ArrangedStudents(); temp.student(selectedStudents[index]); temp.eventID = event_Arrange.id; arrangedStudentsarray[index] = temp; index++; } int rowCount = remaininglists.GetLength(0); int columnCount = remaininglists.GetLength(1); foreach (ArrangedStudents arrangedStudents in arrangedStudentsarray) { bool found = false; for (int i = 0; i < rowCount; i++) { for (int j = 0; j < columnCount; j++) { if (remaininglists[i, j] == arrangedStudents.cms) { found = true; break; } } if (found == true) { break; } } if (found == false) { dbcon.SqlQuery("INSERT INTO ArrangedStudents (Subject,SubjectCode,Classs,AdminID,Cms,EventID) VALUES ( @subject, @subjectCode, @classs, @adminID, @cms, @eventID)"); dbcon.cmd.Parameters.AddWithValue("@subject", arrangedStudents.subject); dbcon.cmd.Parameters.AddWithValue("@subjectCode", arrangedStudents.subjectCode); dbcon.cmd.Parameters.AddWithValue("@classs", arrangedStudents.classs); dbcon.cmd.Parameters.AddWithValue("@adminID", arrangedStudents.adminID); dbcon.cmd.Parameters.AddWithValue("@eventID", arrangedStudents.eventID); dbcon.cmd.Parameters.AddWithValue("@cms", arrangedStudents.cms); val = dbcon.ExNonQuery(); } } } }