private void addConsecRoom_Click(object sender, EventArgs e)
{
int conSessionID1 = 0;
int selectedSessionsCount = 0;
foreach (DataGridViewRow dr in dataGridViewSessions.Rows)
{
bool chkboxselected = Convert.ToBoolean(dr.Cells["checkBoxColumn"].Value);
if (chkboxselected)
{
if (selectedSessionsCount == 0)
{
conSessionID1 = int.Parse(dr.Cells[1].Value.ToString());
selectedSessionsCount++;
}
}
}
ConsecRoom ses = new ConsecRoom();
IConsecRoomService consecRoomService = new ConsecRoomService();
ses.Room = comboRoom.Text.Trim();
if (consecRoomService.addConsecutive(conSessionID1, ses))
{
label1.Text = "Consecutive-Sessions Added Successfully";
}
else
{
label1.Text = "there is somethin wrong when Consecutive-sessions adding";
}
}
public bool addConsecutive(int con_id, ConsecRoom room)
{
Boolean result = false;
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
try
{
string query = "INSERT INTO consecutives (con_id,room) VALUES (@con_id,@room)";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.Parameters.AddWithValue("@con_id", con_id);
cmd.Parameters.AddWithValue("@room", room);
cmd.Prepare();
if (cmd.ExecuteNonQuery() == 1)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(result);
}
