public MembersUC(DatabaseManager DBManager_O, DocumentManager DocManager_O)
{
mDBManager_O = DBManager_O;
mDocManager_O = DocManager_O;
mInitializingData_b = false;
InitializeComponent();
// Add btn tool tool strip list view
this.DBListViewMembers.ListTitle = "Equipe Malcourant Mécanique";
this.DBListViewMembers.AddToolStripBtn(this.ToolStripBtnAddMember);
ToolStripUCMembersTools.Visible = false;
ToolStripUCMembersTools.Renderer = new BorderlessToolStripRenderer();
List <String> TableField_ST = new List <String>();
List <String> ColumnHeaderName_ST = new List <String>();
List <int> ColumnHeaderDefaultSize_i = new List <int>();
List <HorizontalAlignment> TextAlign_O = new List <HorizontalAlignment>();
TableField_ST.Add("PersNom");
TableField_ST.Add("NumTel");
TableField_ST.Add("PersID");
ColumnHeaderName_ST.Add("Nom");
ColumnHeaderName_ST.Add("Téléphone");
ColumnHeaderDefaultSize_i.Add(200);
ColumnHeaderDefaultSize_i.Add(200);
TextAlign_O.Add(HorizontalAlignment.Left);
TextAlign_O.Add(HorizontalAlignment.Left);
DBListViewMembers.Initialize(mDBManager_O, "Pers", TableField_ST, 2, ColumnHeaderName_ST, ColumnHeaderDefaultSize_i, TextAlign_O);
DBListViewMembers.SelectionChanged += new DBListView.SelectionChangedHandler(this.MemberClick);
DBComboxStatus.FillList(mDBManager_O, "PersStatus", "PersStatutID", "PersStatutLib");
ComBoxFamilyState.Items.Add("Célibataire");
ComBoxFamilyState.Items.Add("Cohabitant");
ComBoxFamilyState.Items.Add("Marié");
ComboxPostalCode.FillList(mDBManager_O, "CodePostal", "CodePostalID", "CodePostal");
ComboxLocality.FillList(mDBManager_O, "CodePostal", "CodePostalID", "Localite");
// Put fields of DB in a list to be able to set their edit state in one loop
Fields_O = new List <Control>();
Fields_O.Add(DBComboxStatus);
Fields_O.Add(DTPBirthdate);
Fields_O.Add(TxtCost);
Fields_O.Add(DTPEntryDate);
Fields_O.Add(TxtBankAccount);
Fields_O.Add(TxtRegNumber);
Fields_O.Add(ComBoxFamilyState);
Fields_O.Add(TxtChilds);
Fields_O.Add(CheckBoxActivePartner);
Fields_O.Add(TxtTel);
Fields_O.Add(TxtAdress);
Fields_O.Add(ComboxPostalCode);
Fields_O.Add(ComboxLocality);
SetEditState(false);
// Define checking recap list view
List <String> TableFieldCheckingRecap_ST = new List <String>();
List <String> ColumnHeaderNameCheckingRecap_ST = new List <String>();
List <int> ColumnHeaderDefaultSizeCheckingRecap_i = new List <int>();
List <HorizontalAlignment> TextAlignCheckingRecap_O = new List <HorizontalAlignment>();
// Define column DB fields
TableFieldCheckingRecap_ST.Add("NumRefInterne");
TableFieldCheckingRecap_ST.Add("ClientNom");
TableFieldCheckingRecap_ST.Add("TypeTacheCod");
TableFieldCheckingRecap_ST.Add("JobLib");
TableFieldCheckingRecap_ST.Add("QteProd");
TableFieldCheckingRecap_ST.Add("DelaiPromis");
TableFieldCheckingRecap_ST.Add("DatePrest");
TableFieldCheckingRecap_ST.Add("NbrH");
TableFieldCheckingRecap_ST.Add("Rem");
// Unshown elements
TableFieldCheckingRecap_ST.Add("PointageID");
// Define column headers text
ColumnHeaderNameCheckingRecap_ST.Add("Num ref int");
ColumnHeaderNameCheckingRecap_ST.Add("Client");
ColumnHeaderNameCheckingRecap_ST.Add("Tâche");
ColumnHeaderNameCheckingRecap_ST.Add("Job libellé");
ColumnHeaderNameCheckingRecap_ST.Add("Qte prod");
ColumnHeaderNameCheckingRecap_ST.Add("Délais promis");
ColumnHeaderNameCheckingRecap_ST.Add("Date prest");
ColumnHeaderNameCheckingRecap_ST.Add("Nbr H");
ColumnHeaderNameCheckingRecap_ST.Add("Remarques");
// size
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(50);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(600);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(50);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(100);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(50);
ColumnHeaderDefaultSizeCheckingRecap_i.Add(300);
// alignment
for (int i = 0; i < ColumnHeaderNameCheckingRecap_ST.Count; i++)
{
if (i == 2 || i == 4 || i == 7)
{
TextAlignCheckingRecap_O.Add(HorizontalAlignment.Center);
}
else
{
TextAlignCheckingRecap_O.Add(HorizontalAlignment.Left);
}
}
MemberDayChickingViewer.Initialize(mDBManager_O, DateTime.Today, 0, true);
DBListViewMembers.AllowMultipleSelecion = false;
DepartmentSelector.Initialize(mDBManager_O);
DepartmentSelector.DepartmentsModified += new DepartmentSelector.DepartmentsModifiedHandler(this.ValueChanged);
ToolStripMemberDocuments.Renderer = new BorderlessToolStripRenderer();
ControlStyle.SetBackgroundStyle(this);
ControlStyle.SetBackgroundStyle(ToolStripUCMembersTools);
ControlStyle.SetFrameHeaderStyle(this.PanelMembersList);
ControlStyle.SetFrameHeaderStyle(this.PanelCheckHeader);
ControlStyle.SetFrameStyle(this.PanelCheckContent);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel2);
ControlStyle.SetFrameHeaderStyle(this.splitContainer2.Panel1);
ControlStyle.SetFrameStyle(this.PanelCheckContent);
ControlStyle.SetFrameStyle(this.ToolStripMemberEditFooter);
ControlStyle.SetFrameStyle(this.DepartmentSelector);
ControlStyle.SetFrameStyle(this.ToolStripMemberDocuments);
}
private void MemberClick(UInt32 MemberID_UL)
{
// Load client info in each control
String SQLRequest_ST;
SqlDataReader SqlDataReader_O;
UInt32 CPID_UL = 0;
UInt32 PersStatusID_UL = 0;
mInitializingData_b = true;
TxtTel.Clear();
DTPBirthdate.Value = DTPBirthdate.MinDate;
DTPEntryDate.Value = DTPEntryDate.MinDate;
TxtCost.Clear();
TxtBankAccount.Clear();
TxtRegNumber.Clear();
TxtChilds.Clear();
TxtAdress.Clear();
ComBoxFamilyState.SelectedItem = null;
CheckBoxActivePartner.Checked = false;
DBComboxStatus.ClearSelectedItem();
ComboxPostalCode.ClearSelectedItem();
ComboxLocality.ClearSelectedItem();
LblMemberName.Text = "";
CheckBoxActivePartner.Checked = false;
DepartmentSelector.Clear();
MemberDayChickingViewer.ChangePers(0, true);
TxtLogin.Clear();
bool ActivePartner_b = false;
if (mDBManager_O != null && mDBManager_O.mConnected_b)
{
// Fill fields of member
SQLRequest_ST = "SELECT * FROM Pers WHERE PersID=" + MemberID_UL;
SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST);
while (SqlDataReader_O.Read())
{
bool.TryParse(SqlDataReader_O["ConjActif"].ToString(), out ActivePartner_b);
// Fill info in panel edit controls
TxtTel.Text = SqlDataReader_O["NumTel"].ToString();
try
{
DTPBirthdate.Value = Convert.ToDateTime(SqlDataReader_O["DateNaissance"].ToString());
}
catch (FormatException e)
{
DTPBirthdate.Value = DTPBirthdate.MinDate;
}
try
{
DTPEntryDate.Value = Convert.ToDateTime(SqlDataReader_O["DateEntreeService"].ToString());
}
catch (FormatException e)
{
DTPEntryDate.Value = DTPEntryDate.MinDate;
}
TxtCost.Text = SqlDataReader_O["CoutHeure"].ToString() + "\u20AC";
TxtBankAccount.Text = SqlDataReader_O["CompteBanq"].ToString();
TxtRegNumber.Text = SqlDataReader_O["NumRegNat"].ToString();
TxtChilds.Text = SqlDataReader_O["NbrEnfCharge"].ToString();
TxtAdress.Text = SqlDataReader_O["Adresse"].ToString();
ComBoxFamilyState.Text = SqlDataReader_O["SitFam"].ToString();
TxtLogin.Text = SqlDataReader_O["UserLogin"].ToString();
CheckBoxActivePartner.Checked = ActivePartner_b;
if (UInt32.TryParse(SqlDataReader_O["PersStatutID"].ToString(), out PersStatusID_UL))
{
DBComboxStatus.SelectItemByID(PersStatusID_UL);
}
if (UInt32.TryParse(SqlDataReader_O["CodePostalID"].ToString(), out CPID_UL))
{
ComboxPostalCode.SelectItemByID(CPID_UL);
ComboxLocality.SelectItemByID(CPID_UL);
}
else
{
ComboxPostalCode.ClearSelectedItem();
ComboxLocality.ClearSelectedItem();
}
// Fill info in panel check controls
LblMemberName.Text = SqlDataReader_O["PersNom"].ToString();
CheckBoxActivePartner.Checked = ActivePartner_b;
// Refresh checking recap
//int NbDays = DateTime.Today.DayOfWeek - DayOfWeek.Monday;
if (!String.IsNullOrEmpty(SqlDataReader_O["PersNom"].ToString()))
{
MemberDayChickingViewer.ChangePers(MemberID_UL, true);
}
}
SqlDataReader_O.Close();
// Fill associated departments
SQLRequest_ST = "SELECT DepID FROM RelDepPers WHERE PersID=" + MemberID_UL;
SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST);
List <UInt32> DepID_UL = new List <UInt32>();
UInt32 ID_UL;
while (SqlDataReader_O.Read())
{
if (UInt32.TryParse(SqlDataReader_O["DepID"].ToString(), out ID_UL))
{
DepID_UL.Add(ID_UL);
}
}
DepartmentSelector.CheckDepartments(DepID_UL);
SqlDataReader_O.Close();
}
mInitializingData_b = false;
}
