private void SaveActivity_Button_Click(object sender, EventArgs e)
{
HEADERTEXT = NewActivityHeaderTextBox.Text;
SUMMARYTEXT = NewActivitySummaryTextBox.Text;
LEADERTEXT = NewActivityLeadersTextBox.Text;
INSERTERTEXT = NewActivityInserterTextBox.Text;
//StartDateTime = StartDatePicker.Value.Date + StartTimePicker.Value.TimeOfDay;
StartDateTime = StartDatePicker.Value.ToString("yyyy-MM-dd HH:mm:ss");
//EndDateTime = EndDatePicker.Value.Date + EndTimePicker.Value.TimeOfDay;
EndDateTime = StartDatePicker.Value.ToString("yyyy-MM-dd HH:mm:ss");
STARTED = 'Y';
PAUSED = 'N';
STOPPED = 'N';
Console.WriteLine(StartDatePicker.Value.ToString("yyyy - MM - dd"));
DialogResult result;
result = MessageBox.Show("וודא שפרטי הפעילות נכונים, אם אכן כך, בחר ב'OK'", "וודא אמיתות הפרטים", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.Cancel)
{
return;
}
else
{
newactivity = DataBaseQueries.Insert(HEADERTEXT, SUMMARYTEXT, SEVERITYLEVEL, INSERTERTEXT, LEADERTEXT, StartDateTime, EndDateTime, STARTED, PAUSED, STOPPED);
this.Close();
}
}
public New_Activity()
{
InitializeComponent();
DataBaseQueries.InitializeDB();
Console.WriteLine(StartDatePicker.Value.ToString("yyyy-MM-dd"));
Console.WriteLine(StartDatePicker.Value.ToString("HH:mm:ss"));
Console.WriteLine(StartDatePicker.Value.ToString("yyyy-MM-dd HH:mm:ss"));
}
public void updateActivities()
{
List <string> activitiesID = DataBaseQueries.GetActivitiesID();
startedActivitiesCount = activitiesID.Count;
switch (this.startedActivitiesCount)
{
case 0:
Activity1Panel.Visible = false;
Activity1AddImageButton.Visible = true;
Activity2Panel.Visible = false;
Activity2AddImageButton.Visible = true;
Activity3Panel.Visible = false;
Activity3AddImageButton.Visible = true;
Activity4Panel.Visible = false;
Activity4AddImageButton.Visible = true;
break;
case 1:
Activity1Panel.Visible = true;
Activity1AddImageButton.Visible = false;
Activity2Panel.Visible = false;
Activity2AddImageButton.Visible = true;
Activity3Panel.Visible = false;
Activity3AddImageButton.Visible = true;
Activity4Panel.Visible = false;
Activity4AddImageButton.Visible = true;
activities = DataBaseQueries.getActivities();
Activity1Header.Text = activities[0].header;
Activity1Summary.Text = activities[0].summary;
Leaders1TextBox.Text = activities[0].leaders;
Inserter1TextBox.Text = activities[0].inserter;
Severity1TextBox.Text = activities[0].severity.ToString();
ID1TextBox.Text = activities[0].ID.ToString();
StartDateTime1TextBox.Text = activities[0].StartDateTime.ToString();
EndDateTime1TextBox.Text = activities[0].EndDateTime.ToString();
break;
case 2:
Activity1Panel.Visible = true;
Activity1AddImageButton.Visible = false;
Activity2Panel.Visible = true;
Activity2AddImageButton.Visible = false;
Activity3Panel.Visible = false;
Activity3AddImageButton.Visible = true;
Activity4Panel.Visible = false;
Activity4AddImageButton.Visible = true;
activities = DataBaseQueries.getActivities();
Activity1Header.Text = activities[0].header;
Activity1Summary.Text = activities[0].summary;
Leaders1TextBox.Text = activities[0].leaders;
Severity1TextBox.Text = activities[0].severity.ToString();
Inserter1TextBox.Text = activities[0].inserter;
ID1TextBox.Text = activities[0].ID.ToString();
StartDateTime1TextBox.Text = activities[0].StartDateTime.ToString();
EndDateTime1TextBox.Text = activities[0].EndDateTime.ToString();
Activity2Header.Text = activities[1].header;
Activity2Summary.Text = activities[1].summary;
Leaders2TextBox.Text = activities[1].leaders;
Severity2TextBox.Text = activities[1].severity.ToString();
Inserter2TextBox.Text = activities[1].inserter;
ID2TextBox.Text = activities[1].ID.ToString();
StartDateTime2TextBox.Text = activities[1].StartDateTime.ToString();
EndDateTime2TextBox.Text = activities[1].EndDateTime.ToString();
break;
case 3:
Activity1Panel.Visible = true;
Activity1AddImageButton.Visible = false;
Activity2Panel.Visible = true;
Activity2AddImageButton.Visible = false;
Activity3Panel.Visible = true;
Activity3AddImageButton.Visible = false;
Activity4Panel.Visible = false;
Activity4AddImageButton.Visible = true;
activities = DataBaseQueries.getActivities();
Activity1Header.Text = activities[0].header;
Activity1Summary.Text = activities[0].summary;
Leaders1TextBox.Text = activities[0].leaders;
Severity1TextBox.Text = activities[0].severity.ToString();
Inserter1TextBox.Text = activities[0].inserter;
ID1TextBox.Text = activities[0].ID.ToString();
StartDateTime1TextBox.Text = activities[0].StartDateTime.ToString();
EndDateTime1TextBox.Text = activities[0].EndDateTime.ToString();
Activity2Header.Text = activities[1].header;
Activity2Summary.Text = activities[1].summary;
Leaders2TextBox.Text = activities[1].leaders;
Severity2TextBox.Text = activities[1].severity.ToString();
Inserter2TextBox.Text = activities[1].inserter;
ID2TextBox.Text = activities[1].ID.ToString();
StartDateTime2TextBox.Text = activities[1].StartDateTime.ToString();
EndDateTime2TextBox.Text = activities[1].EndDateTime.ToString();
Activity3Header.Text = activities[2].header;
Activity3Summary.Text = activities[2].summary;
Leaders3TextBox.Text = activities[2].leaders;
Severity3TextBox.Text = activities[2].severity.ToString();
Inserter3TextBox.Text = activities[2].inserter;
ID3TextBox.Text = activities[2].ID.ToString();
StartDateTime3TextBox.Text = activities[2].StartDateTime.ToString();
EndDateTime3TextBox.Text = activities[2].EndDateTime.ToString();
break;
case 4:
Activity1Panel.Visible = true;
Activity1AddImageButton.Visible = false;
Activity2Panel.Visible = true;
Activity2AddImageButton.Visible = false;
Activity3Panel.Visible = true;
Activity3AddImageButton.Visible = false;
Activity4Panel.Visible = true;
Activity4AddImageButton.Visible = false;
activities = DataBaseQueries.getActivities();
Activity1Header.Text = activities[0].header;
Activity1Summary.Text = activities[0].summary;
Leaders1TextBox.Text = activities[0].leaders;
Severity1TextBox.Text = activities[0].severity.ToString();
Inserter1TextBox.Text = activities[0].inserter;
ID1TextBox.Text = activities[0].ID.ToString();
StartDateTime1TextBox.Text = activities[0].StartDateTime.ToString();
EndDateTime1TextBox.Text = activities[0].EndDateTime.ToString();
Activity2Header.Text = activities[1].header;
Activity2Summary.Text = activities[1].summary;
Leaders2TextBox.Text = activities[1].leaders;
Severity2TextBox.Text = activities[1].severity.ToString();
Inserter2TextBox.Text = activities[1].inserter;
ID2TextBox.Text = activities[1].ID.ToString();
StartDateTime2TextBox.Text = activities[1].StartDateTime.ToString();
EndDateTime2TextBox.Text = activities[1].EndDateTime.ToString();
Activity3Header.Text = activities[2].header;
Activity3Summary.Text = activities[2].summary;
Leaders3TextBox.Text = activities[2].leaders;
Severity3TextBox.Text = activities[2].severity.ToString();
Inserter3TextBox.Text = activities[2].inserter;
ID3TextBox.Text = activities[2].ID.ToString();
StartDateTime3TextBox.Text = activities[2].StartDateTime.ToString();
EndDateTime3TextBox.Text = activities[2].EndDateTime.ToString();
Activity4Header.Text = activities[3].header;
Activity4Summary.Text = activities[3].summary;
Leaders4TextBox.Text = activities[3].leaders;
Severity4TextBox.Text = activities[3].severity.ToString();
Inserter4TextBox.Text = activities[3].inserter;
ID4TextBox.Text = activities[3].ID.ToString();
StartDateTime4TextBox.Text = activities[3].StartDateTime.ToString();
EndDateTime4TextBox.Text = activities[3].EndDateTime.ToString();
break;
default:
Activity1Panel.Visible = false;
Activity1AddImageButton.Visible = true;
Activity2Panel.Visible = false;
Activity2AddImageButton.Visible = true;
Activity3Panel.Visible = false;
Activity3AddImageButton.Visible = true;
Activity4Panel.Visible = false;
Activity4AddImageButton.Visible = true;
activities = DataBaseQueries.getActivities();
break;
}
}
public Page_Menu()
{
InitializeComponent();
DataBaseQueries.InitializeDB();
updateActivities();
}