private void frmPersons_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'beaDBDataSet.tblPersons' table. You can move, or remove it, as needed.
this.tblPersonsTableAdapter.Fill(this.beaDBDataSet.tblPersons);
dgv = this.tblPersonsDataGridView;
bnv = this.tblPersonsBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Προσωπικό";
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].HeaderText = "Όνομα";
dgv.Columns["dataGridViewTextBoxColumn2"].Width = 250;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Επώνυμο";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 250;
dgv.Columns["dataGridViewTextBoxColumn4"].Visible = false;
dgv.Columns["Availability"].HeaderText = "Διαθεσιμότητα";
dgv.Columns["Availability"].Width = 100;
dgv.Columns["Cost"].HeaderText = "Κόστος";
dgv.Columns["Cost"].Width = 75;
dgv.Columns["timeSheet"].HeaderText = "Απασχόληση";
dgv.Columns["timeSheet"].Width = 100;
dgv.Columns["timeSheet"].Visible = false;
dgv.Columns["TimeSheet2"].HeaderText = "Απασχόληση 2";
dgv.Columns["TimeSheet2"].Width = 100;
}
private void frmWorkActions_Load(object sender, EventArgs e)
{
try
{
this.tblWorkActionsTableAdapter.Fill(this.beaDBDataSet.tblWorkActions, this.actwrkID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblWorkActionsDataGridView;
bnv = this.tblWorkActionsBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Εργασίες";
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Κωδικός";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Τίτλος";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 400;
dgv.Columns["dataGridViewTextBoxColumn5"].Visible = false;
}
private void frmActivityTeam2_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'beaDBDataSet.vPersons' table. You can move, or remove it, as needed.
//this.vPersonsTableAdapter.Fill(this.beaDBDataSet.vPersons);
try
{
this.tblActivityTeamTableAdapter.Fill(this.beaDBDataSet.tblActivityTeam, this.practID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
try
{
this.vProjectTeamTableAdapter.Fill(this.beaDBDataSet.vProjectTeam, this.projID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblActivityTeamDataGridView;
bnv = this.tblActivityTeamBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Ομάδα Δραστηριότητας";
this.lblCurrentActivity.Text = bea.currentActivity;
this.lblCurrentActivity.Location = new Point(300, 110);
this.label2.Text = "Προυπολογισμός AH:";
this.label4.Text = "Αδιάθετες ΑΗ:";
this.lblBudget.Text = GetActivityWorkBudget(practID).Item1.ToString();
this.lblRemainingBudget.Text = GetActivityWorkBudget(practID).Item2.ToString();
// this.label1.Text = GetProjectAvailableHours(this.projID).ToString();
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn4"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].HeaderText = "Εργαζόμενος";
dgv.Columns["dataGridViewTextBoxColumn2"].Width = 220;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Απασχόληση - ΑΗ";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 120;
dgv.Columns["actteamBudget"].HeaderText = "Κόστος";
dgv.Columns["actteamBudget"].Width = 90;
dgv.Columns["availabilityIcon"].HeaderText = "";
dgv.Columns["availabilityIcon"].Width = 70;
dgv.Columns["availability"].HeaderText = "Διαθέσιμες ΑΗ";
dgv.Columns["availability"].Width = 120;
DesignHelper.InactivateColumn(dgv, dgv.Columns["availability"].Index);
}
private void frmProjectTeam_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'beaDBDataSet.vPersons' table. You can move, or remove it, as needed.
this.vPersonsTableAdapter.Fill(this.beaDBDataSet.vPersons);
try
{
this.tblProjectTeamTableAdapter.Fill(this.beaDBDataSet.tblProjectTeam, this.projectID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblProjectTeamDataGridView;
bnv = this.tblProjectTeamBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Ομάδα Έργου";
this.lblCurrentProject.Text = bea.currentProject;
this.lblCurrentProject.Location = new Point(310, 110);
this.lblBudget.Text = GetProjectBudget(projectID).Item1.ToString("C", CultureInfo.CurrentCulture);
this.lblRemainingBudget.Text = GetProjectBudget(projectID).Item2.ToString("C", CultureInfo.CurrentCulture);
this.label2.Text = "Προυπολογισμός:";
this.label4.Text = "Αδιάθετα:";
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Εργαζόμενος";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 270;
dgv.Columns["prteamRole"].HeaderText = "Ρόλος";
dgv.Columns["prteamRole"].Width = 270;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Απασχόληση - ΑΗ";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 140;
dgv.Columns["prteamBudget"].HeaderText = "Κόστος";
dgv.Columns["prteamBudget"].Width = 100;
DesignHelper.InactivateColumn(dgv, dgv.Columns["prteamBudget"].Index);
dgv.Columns["availabilityIcon"].HeaderText = "";
dgv.Columns["availabilityIcon"].Width = 70;
dgv.Columns["availability"].HeaderText = "Διαθέσιμες ΑΗ";
dgv.Columns["availability"].Width = 120;
DesignHelper.InactivateColumn(dgv, dgv.Columns["availability"].Index);
}
private void frmActivityWorks_Load(object sender, EventArgs e)
{
try
{
this.tblActivityWorksTableAdapter.Fill(this.beaDBDataSet.tblActivityWorks, this.practID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblActivityWorksDataGridView;
bnv = this.tblActivityWorksBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Ενέργειες Δραστηριότητας";
this.lblDescription.Text = this.practCodeTitle;
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Κωδικός";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Τίτλος";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 300;
dgv.Columns["dataGridViewTextBoxColumn5"].Visible = false;
dgv.Columns["From"].HeaderText = "";
dgv.Columns["From"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn6"].HeaderText = "Από";
dgv.Columns["dataGridViewTextBoxColumn6"].Width = 70;
dgv.Columns["To"].HeaderText = "";
dgv.Columns["To"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn7"].HeaderText = "Έως";
dgv.Columns["dataGridViewTextBoxColumn7"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn8"].HeaderText = "Απασχόληση";
dgv.Columns["dataGridViewTextBoxColumn8"].Width = 100;
dgv.Columns["WorkDetails"].HeaderText = "Περιγραφή";
dgv.Columns["WorkDetails"].Width = 70;
dgv.Columns["WorkActions"].HeaderText = "Εργασίες";
dgv.Columns["WorkActions"].Width = 70;
dgv.Columns["WorkActions"].Visible = false;
}
private void frmTimeSheet_Load(object sender, EventArgs e)
{
this.dateTo = DateTime.Today;
this.dateFrom = DateTime.Today.AddDays(-7);
this.dateTimePicker1.Visible = false;
this.monthCalendar1.Visible = false;
try
{
this.vActivityTeamTableAdapter.Fill(this.beaDBDataSet.vActivityTeam, this.personID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblOccupationsDataGridView;
bnv = this.tblOccupationsBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Απολογισμός Απασχόλησης";
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].HeaderText = "Δραστηριότητα";
dgv.Columns["dataGridViewTextBoxColumn2"].Width = 400;
dgv.Columns["dataGridViewTextBoxColumn3"].Visible = false;
dgv.Columns["pickDate"].HeaderText = "";
dgv.Columns["pickDate"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Ημερομηνία";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 100;
dgv.Columns["dataGridViewTextBoxColumn5"].HeaderText = "Απασχόληση-ΑΩ";
dgv.Columns["dataGridViewTextBoxColumn5"].Width = 120;
dgv.Columns["dataGridViewTextBoxColumn6"].HeaderText = "Περιγραφή";
dgv.Columns["dataGridViewTextBoxColumn6"].Width = 120;
LoadData();
}
private void frmPersonAvailability_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'beaDBDataSet.vAvailability' table. You can move, or remove it, as needed.
this.vAvailabilityTableAdapter.Fill(this.beaDBDataSet.vAvailability);
// TODO: This line of code loads data into the 'beaDBDataSet.tblPersonAvailability' table. You can move, or remove it, as needed.
this.tblPersonAvailabilityTableAdapter.Fill(this.beaDBDataSet.tblPersonAvailability, personID);
dgv = this.tblPersonAvailabilityDataGridView;
bnv = this.tblPersonAvailabilityBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.monthCalendar1.Visible = false;
this.monthCalendar2.Visible = false;
this.Text = "Μη διαθεσιμότητα";
this.lblPersonel.Text = bea.currentPerson;
this.lblPersonel.Location = new Point(320, 110);
dgv.Width = 700;
dgv.Height = 300;
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn6"].HeaderText = "Αιτία";
dgv.Columns["dataGridViewTextBoxColumn6"].Width = 250;
dgv.Columns["fromDate"].HeaderText = "";
dgv.Columns["fromDate"].Width = 75;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Από";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 100;
DesignHelper.InactivateColumn(dgv, dgv.Columns["dataGridViewTextBoxColumn3"].Index);
dgv.Columns["toDate"].HeaderText = "";
dgv.Columns["toDate"].Width = 75;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Έως";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 100;
DesignHelper.InactivateColumn(dgv, dgv.Columns["dataGridViewTextBoxColumn4"].Index);
dgv.Columns["dataGridViewTextBoxColumn5"].Visible = false;
}
private void frmUsers_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'beaDBDataSet.vUserRoles' table. You can move, or remove it, as needed.
this.vUserRolesTableAdapter.Fill(this.beaDBDataSet.vUserRoles);
// TODO: This line of code loads data into the 'beaDBDataSet.tblUsers' table. You can move, or remove it, as needed.
this.tblUsersTableAdapter.Fill(this.beaDBDataSet.tblUsers);
dgv = this.tblUsersDataGridView;
bnv = this.tblUsersBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Χρήστες Εφαρμογής";
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].HeaderText = "Όνομα Χρήστη";
dgv.Columns["dataGridViewTextBoxColumn2"].Width = 150;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Όνομα";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 150;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Επώνυμο";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 150;
dgv.Columns["dataGridViewTextBoxColumn5"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn5"].HeaderText = "Κωδικός";
dgv.Columns["dataGridViewTextBoxColumn5"].Width = 150;
dgv.Columns["userMail"].HeaderText = "Mail";
dgv.Columns["userMail"].Width = 120;
dgv.Columns["userTelephone"].HeaderText = "Τηλέφωνο";
dgv.Columns["userTelephone"].Width = 120;
dgv.Columns["dataGridViewTextBoxColumn6"].HeaderText = "Ρόλος";
dgv.Columns["dataGridViewTextBoxColumn6"].Width = 200;
}
private void frmProjects_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'beaDBDataSet.tblProjects' table. You can move, or remove it, as needed.
this.tblProjectsTableAdapter.Fill(this.beaDBDataSet.tblProjects);
dgv = this.tblProjectsDataGridView;
bnv = this.tblProjectsBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
foreach (DataGridViewRow row in dgv.Rows)
{
row.Height = 25;
}
dgv.RowTemplate.Height = 25;
//MessageBox.Show(dgv.RowTemplate.Height.ToString());
this.monthCalendar1.Visible = false;
this.monthCalendar2.Visible = false;
//this.WindowState = FormWindowState.Maximized;
this.Text = "Έργα";
this.labelUser.Text = bea.userFullName;
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].HeaderText = "Τίτλος";
dgv.Columns["dataGridViewTextBoxColumn2"].Width = 200;
dgv.Columns["dataGridViewTextBoxColumn3"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Έναρξη";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 90;
DesignHelper.InactivateColumn(dgv, dgv.Columns["dataGridViewTextBoxColumn4"].Index);
dgv.Columns["projStart"].HeaderText = "";
dgv.Columns["projStart"].Width = 50;
dgv.Columns["dataGridViewTextBoxColumn5"].HeaderText = "Λήξη";
dgv.Columns["dataGridViewTextBoxColumn5"].Width = 90;
DesignHelper.InactivateColumn(dgv, 6);
dgv.Columns["projFinish"].HeaderText = "";
dgv.Columns["projFinish"].Width = 50;
dgv.Columns["projTotalBudget"].HeaderText = "Συνολικός ΠΥ";
dgv.Columns["projTotalBudget"].Width = 110;
dgv.Columns["projBudget"].HeaderText = "ΠΥ Προσωπικού";
dgv.Columns["projBudget"].Width = 130;
dgv.Columns["dataGridViewTextBoxColumn6"].HeaderText = "Απασχόληση";
dgv.Columns["dataGridViewTextBoxColumn6"].Width = 130;
dgv.Columns["dataGridViewTextBoxColumn6"].Visible = false;
dgv.Columns["projActivities"].HeaderText = "Δραστηριότητες";
dgv.Columns["projActivities"].Width = 110;
dgv.Columns["projTeam"].HeaderText = "Ομάδα Έργου";
dgv.Columns["projTeam"].Width = 100;
}
private void frmPersonCost_Load(object sender, EventArgs e)
{
try
{
this.tblPersonCostTableAdapter.Fill(this.beaDBDataSet.tblPersonCost, personID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblPersonCostDataGridView;
bnv = this.tblPersonCostBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Κόστος Εργαζόμενου";
this.lblCurrentPerson.Text = bea.currentPerson;
this.lblCurrentPerson.Location = new Point(320, 110);
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].Visible = false;
dgv.Columns["From"].HeaderText = "";
dgv.Columns["From"].Width = 50;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Από";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 80;
DesignHelper.InactivateColumn(dgv, dgv.Columns["dataGridViewTextBoxColumn3"].Index);
dgv.Columns["To"].HeaderText = "";
dgv.Columns["To"].Width = 50;
dgv.Columns["To"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn4"].HeaderText = "Έως";
dgv.Columns["dataGridViewTextBoxColumn4"].Width = 80;
dgv.Columns["dataGridViewTextBoxColumn4"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn5"].HeaderText = "Ημερήσιο Κόστος";
dgv.Columns["dataGridViewTextBoxColumn5"].Width = 150;
dgv.Columns["dataGridViewTextBoxColumn5"].Visible = false;
dgv.Columns["personcostMonthSalary"].HeaderText = "Μισθός";
dgv.Columns["personcostMonthSalary"].Width = 75;
dgv.Columns["personcostMonthContributions"].HeaderText = "Εισφορές";
dgv.Columns["personcostMonthContributions"].Width = 75;
dgv.Columns["personcostMonth"].HeaderText = "Μηνιαίο";
dgv.Columns["personcostMonth"].Width = 75;
DesignHelper.InactivateColumn(dgv, dgv.Columns["personcostMonth"].Index);
dgv.Columns["personcostYear"].HeaderText = "Ετήσιο";
dgv.Columns["personcostYear"].Width = 75;
DesignHelper.InactivateColumn(dgv, dgv.Columns["personcostYear"].Index);
dgv.Columns["personcostDay"].HeaderText = "Ημερήσιο";
dgv.Columns["personcostDay"].Width = 75;
DesignHelper.InactivateColumn(dgv, dgv.Columns["personcostDay"].Index);
dgv.Columns["personcostHour"].HeaderText = "Ωριαίο";
dgv.Columns["personcostHour"].Width = 75;
DesignHelper.InactivateColumn(dgv, dgv.Columns["personcostHour"].Index);
}
private void frmProjectActivities_Load(object sender, EventArgs e)
{
try
{
this.tblProjectActivitiesTableAdapter.Fill(this.beaDBDataSet.tblProjectActivities, this.projectID);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
dgv = this.tblProjectActivitiesDataGridView;
bnv = this.tblProjectActivitiesBindingNavigator;
DesignHelper.DesignDataGridView(dgv);
DesignHelper.DesignDataGridNavigator(bnv);
this.Text = "Δραστηριότητες Έργου";
this.Size = new Size(1200, 550);
dgv.Size = new Size(1070, 300);
this.lblCurrentProject.Text = bea.currentProject;
this.lblCurrentProject.Location = new Point(320, 110);
//MessageBox.Show("Available from Activities: " + bea.GetProjectAvailableHours(projectID).Item1.ToString() + " Available from People: " + bea.GetProjectAvailableHours(projectID).Item2.ToString());
this.label2.Text = "Προυπολογισμός AH:";
this.label4.Text = "Αδιάθετες ΑΗ:";
this.lblBudget.Text = GetProjectWorkBudget(projectID).Item1.ToString();
this.lblRemainingBudget.Text = GetProjectWorkBudget(projectID).Item2.ToString();
dgv.Columns["dataGridViewTextBoxColumn1"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn2"].Visible = false;
dgv.Columns["dataGridViewTextBoxColumn3"].HeaderText = "Τίτλος";
dgv.Columns["dataGridViewTextBoxColumn3"].Width = 250;
dgv.Columns["practCode"].HeaderText = "Κωδικός";
dgv.Columns["practCode"].Width = 70;
dgv.Columns["dataGridViewTextBoxColumn4"].Visible = false;
dgv.Columns["dateFrom"].HeaderText = "";
dgv.Columns["dateFrom"].Width = 50;
dgv.Columns["dataGridViewTextBoxColumn5"].HeaderText = "Έναρξη";
dgv.Columns["dataGridViewTextBoxColumn5"].Width = 100;
dgv.Columns["dateTo"].HeaderText = "";
dgv.Columns["dateTo"].Width = 50;
dgv.Columns["dataGridViewTextBoxColumn6"].HeaderText = "Λήξη";
dgv.Columns["dataGridViewTextBoxColumn6"].Width = 100;
dgv.Columns["practBudget"].HeaderText = "Προυπολογισμός";
dgv.Columns["practBudget"].Width = 120;
dgv.Columns["dataGridViewTextBoxColumn7"].HeaderText = "Απασχόληση-ΑΗ";
dgv.Columns["dataGridViewTextBoxColumn7"].Width = 120;
dgv.Columns["practTeam"].HeaderText = "Ομάδα";
dgv.Columns["practTeam"].Width = 80;
dgv.Columns["practTeam"].Visible = true;
dgv.Columns["Works"].HeaderText = "Ενέργειες";
dgv.Columns["Works"].Width = 80;
dgv.Columns["Works"].Visible = true;
}