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();
}
}
}
}
