private void UpdateMsgTimer_Tick(object sender, EventArgs e) { SqlDataReader SqlDataReader_O; String SqlRequest_st = "SELECT MAX(MsgID) FROM Msg"; UInt32 DBMaxID_UL, ListMaxID_UL; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SqlDataReader_O = mDBManager_O.Select(SqlRequest_st); while (SqlDataReader_O.Read()) { if (UInt32.TryParse(SqlDataReader_O[0].ToString(), out DBMaxID_UL)) { ListMaxID_UL = DBListViewMsg.GetMaxID(); if (ListMaxID_UL < DBMaxID_UL) { DBListViewMsg.Refresh(); NewMessage(); } else if (ListMaxID_UL != DBMaxID_UL) { DBListViewMsg.Refresh(); } } else { DBListViewMsg.Refresh(); } } SqlDataReader_O.Close(); } }
public void FillList(DatabaseManager DBManager_O, String TableName_ST, String DBFieldID_ST, String DBField_ST, String Where_ST = "") { SqlDataReader SqlDataReader_O; DBComboBoxItem DBListBoxItem_O; String SQLRequest_ST; UInt32 ID_UL = 0; String Field_ST = ""; if (DBManager_O != null && DBManager_O.mConnected_b && !String.IsNullOrEmpty(TableName_ST) && !String.IsNullOrEmpty(DBFieldID_ST) && !String.IsNullOrEmpty(DBField_ST)) { this.Items.Clear(); this.Text = null; SQLRequest_ST = "SELECT " + DBFieldID_ST + ", " + DBField_ST + " FROM " + TableName_ST; if (!String.IsNullOrEmpty(Where_ST)) { SQLRequest_ST += " WHERE " + Where_ST; } SqlDataReader_O = DBManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { UInt32.TryParse(SqlDataReader_O[DBFieldID_ST].ToString(), out ID_UL); Field_ST = SqlDataReader_O[DBField_ST].ToString(); DBListBoxItem_O = new DBComboBoxItem(ID_UL, Field_ST); this.Items.Add(DBListBoxItem_O); } SqlDataReader_O.Close(); } }
/// <summary> /// Method that initialize the user control (it display some lines with a slected department) /// </summary> public void Initialize(DatabaseManager DBManager_O, List <UInt32> SelectedItem_UL = null) { mDBManager_O = DBManager_O; SqlDataReader SqlDataReader_O; String SQLRequest_O; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_O = "SELECT * FROM TypeDep"; SqlDataReader_O = mDBManager_O.Select(SQLRequest_O); while (SqlDataReader_O.Read()) { UInt32 DepID_UL; if (UInt32.TryParse(SqlDataReader_O["TypeDepID"].ToString(), out DepID_UL)) { CheckBox Checkbox_O = new CheckBox(); Checkbox_O.AutoSize = true; Checkbox_O.Text = SqlDataReader_O["TypeDepLib"].ToString(); Checkbox_O.Tag = DepID_UL; Checkbox_O.Checked = (SelectedItem_UL != null && SelectedItem_UL.Contains(DepID_UL)); Checkbox_O.CheckedChanged += new EventHandler(this.DepartmentCheckedChanged); FlowLayoutPanel.Controls.Add(Checkbox_O); mDepartmentCheckbox_O.Add(Checkbox_O); } } SqlDataReader_O.Close(); } }
public void RefreshJobs() { // TODO : this method may take a little time and optimization by refreshing only selected job could be considered SqlDataReader SqlDataReader_O; ListViewItem ListViewItem_O; String SQLRequest_O; // Clear list before continuing, otherwise list will only grow with new items CustomComJobListView.Items.Clear(); if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_O = "Select "; for (int i = 0; i < mColumnDBField_O.Count; i++) { SQLRequest_O += mColumnDBField_O[i]; if (i != mColumnDBField_O.Count - 1) { SQLRequest_O += ","; } } SQLRequest_O += " from ComJobSelectPop " + BuildWhereStatement() + " " + BuildOrderByStatement(); SqlDataReader_O = mDBManager_O.Select(SQLRequest_O); mLastSQLRequest_st = SQLRequest_O; while (SqlDataReader_O.Read()) { ListViewItem_O = new ListViewItem(); ListViewItem_O.SubItems[0].Text = SqlDataReader_O[mColumnDBField_O[0]].ToString(); for (int i = 1; i < mColumnDBField_O.Count; i++) { if ((i == 8 || i == 10) && SqlDataReader_O[mColumnDBField_O[i]].ToString().Length > 10) { ListViewItem_O.SubItems.Add(SqlDataReader_O[mColumnDBField_O[i]].ToString().Substring(0, 10)); } else { ListViewItem_O.SubItems.Add(SqlDataReader_O[mColumnDBField_O[i]].ToString()); } } CustomComJobListView.Items.Add(ListViewItem_O); } SqlDataReader_O.Close(); } }
private void ComClick(UInt32 ComID_UL) { // Load client info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; int RappConf_i = 0, NoteEnvoi_i = 0, Certif_i = 0; mInitializingComData_b = true; ClearComInfo(); if (ComJobSelector.GetJobListView().GetSelectedItemID() == 0) { ClearJobInfo(); } if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM ComSelectPop WHERE ComID=" + ComID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { int.TryParse(SqlDataReader_O["RappConf"].ToString(), out RappConf_i); int.TryParse(SqlDataReader_O["NoteEnvoi"].ToString(), out NoteEnvoi_i); int.TryParse(SqlDataReader_O["Certif"].ToString(), out Certif_i); // Fill info in panel edit controls TxtComNumber.Text = SqlDataReader_O["NumRefInterne"].ToString(); TxtClient.Text = SqlDataReader_O["ClientNom"].ToString(); try { DTPComDate.Value = Convert.ToDateTime(SqlDataReader_O["ComDate"].ToString()); } catch (FormatException e) { DTPComDate.Value = DTPComDate.MinDate; } TxtNumComClient.Text = SqlDataReader_O["NumCmdClient"].ToString(); TxtComLib.Text = SqlDataReader_O["LibelleCmd"].ToString(); TxtComInfos.Text = SqlDataReader_O["Info"].ToString(); CheckBoxRappConf.Checked = RappConf_i != 0 ? true : false; CheckBoxNE.Checked = NoteEnvoi_i != 0 ? true : false; CheckBoxCertif.Checked = Certif_i != 0 ? true : false; } SqlDataReader_O.Close(); } mInitializingComData_b = false; }
public void Refresh() { // TODO : this method may take a little time and optimization by refreshing only selected job could be considered SqlDataReader SqlDataReader_O; ListViewItem ListViewItem_O; String SQLRequest_O; // Clear list before continuing, otherwise list will only grow with new items mListView_O.Items.Clear(); if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_O = "SELECT "; for (int i = 0; i < mTableFields_ST.Count; i++) { SQLRequest_O += mTableFields_ST[i]; if (i != mTableFields_ST.Count - 1) { SQLRequest_O += ","; } } SQLRequest_O += " FROM " + mTableName_ST; if (!String.IsNullOrEmpty(mInitialWhere_ST)) { SQLRequest_O += " WHERE " + mInitialWhere_ST; } SQLRequest_O += " " + BuildWhereFromFilter(); SQLRequest_O += " " + BuildOrderByFromFilter(); SqlDataReader_O = mDBManager_O.Select(SQLRequest_O); mLastSQLRequest_st = SQLRequest_O; if (SqlDataReader_O != null) { while (SqlDataReader_O.Read()) { ListViewItem_O = new ListViewItem(); ListViewItem_O.SubItems[0].Text = SqlDataReader_O[mTableFields_ST[0]].ToString(); ListViewItem_O.SubItems[0].Name = mTableFields_ST[0]; for (int i = 1; i < mTableFields_ST.Count; i++) { // If type of data is date, take only 10 first char to avoid time if ((SqlDataReader_O.GetFieldType(SqlDataReader_O.GetOrdinal(mTableFields_ST[i])) == typeof(DateTime)) && !String.IsNullOrEmpty(SqlDataReader_O[mTableFields_ST[i]].ToString())) { DateTime Date_O = Convert.ToDateTime(SqlDataReader_O[mTableFields_ST[i]].ToString()); ListViewItem_O.SubItems.Add(Date_O.ToShortDateString()); } else { ListViewItem_O.SubItems.Add(SqlDataReader_O[mTableFields_ST[i]].ToString()); } ListViewItem_O.SubItems[i].Name = mTableFields_ST[i]; } mListView_O.Items.Add(ListViewItem_O); } SqlDataReader_O.Close(); if (ListRefreshed != null) { ListRefreshed(); } } } if (mListView_O.Items.Count > 0) { SelectFirst(); } else { // Throw event as if non existing item with ID 0 was selected, such that UC can understand that no item is selected // because .net do not fires selected index changed when nothing is selected if (SelectionChanged != null) { SelectionChanged(0); } } }
public void LoadChecking() { String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 PointageMachine_UL = 1; UInt32 TaskID_UL = 0; UInt32 MachineID_UL = 0; UInt32 HallID_UL = 0; UInt32 DepID_UL = 0; if (mDataBaseManager_O != null && mDataBaseManager_O.mConnected_b) { // Fill pointage info SQLRequest_ST = "SELECT * FROM Pointage WHERE ComJobEtapeID=" + mComJobEtapeID_UL; SqlDataReader_O = mDataBaseManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { // Select Task if (UInt32.TryParse(mDataBaseManager_O.GetTableField("ComJobEtape", "TypeTacheID", "ComJobEtapeID=" + mComJobEtapeID_UL), out TaskID_UL)) { if (UInt32.TryParse(mDataBaseManager_O.GetTableField("TypeTache", "TypeDepID", "TypeTacheID=" + TaskID_UL), out DepID_UL)) { DBComboxDep.SelectItemByID(DepID_UL); DBComboxTask.SelectItemByID(TaskID_UL); } } // Fill NbrH field TxtNbrH.Text = SqlDataReader_O["NbrH"].ToString(); // Fill Rem field TxtRem.Text = SqlDataReader_O["Rem"].ToString(); } SqlDataReader_O.Close(); // Fill pointage machine info SQLRequest_ST = "SELECT * FROM PointageMachine WHERE ComJobEtapeID=" + mComJobEtapeID_UL; SqlDataReader_O = mDataBaseManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { if (PointageMachine_UL >= 1 && PointageMachine_UL <= 4) { UInt32.TryParse(SqlDataReader_O["PointageMachinelID"].ToString(), out mPointageMachineID_O[PointageMachine_UL - 1]); } if (PointageMachine_UL == 1) { if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL)) { if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL)) { DBComboxHall1.SelectItemByID(HallID_UL); DBComboxMachine1.SelectItemByID(MachineID_UL); } } TxtNbrhMach1.Text = SqlDataReader_O["NbrHMachine"].ToString(); } else if (PointageMachine_UL == 2) { if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL)) { if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL)) { DBComboxHall2.SelectItemByID(HallID_UL); DBComboxMachine2.SelectItemByID(MachineID_UL); } } TxtNbrhMach2.Text = SqlDataReader_O["NbrHMachine"].ToString(); } else if (PointageMachine_UL == 3) { if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL)) { if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL)) { DBComboxHall3.SelectItemByID(HallID_UL); DBComboxMachine3.SelectItemByID(MachineID_UL); } } TxtNbrhMach3.Text = SqlDataReader_O["NbrHMachine"].ToString(); } else if (PointageMachine_UL == 4) { if (UInt32.TryParse(SqlDataReader_O["MachineID"].ToString(), out MachineID_UL)) { if (UInt32.TryParse(mDataBaseManager_O.GetTableField("Machine", "HallID", "MachineID=" + MachineID_UL), out HallID_UL)) { DBComboxHall4.SelectItemByID(HallID_UL); DBComboxMachine4.SelectItemByID(MachineID_UL); } } TxtNbrhMach4.Text = SqlDataReader_O["NbrHMachine"].ToString(); } PointageMachine_UL++; } SqlDataReader_O.Close(); } }
private void ClientClick(UInt32 ClientID_UL) { // Load client info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 TypeSocID_UL = 0; UInt32 CPID_UL = 0; int RappConf_i = 0, NoteEnvoi_i = 0, Certif_i = 0; // Fill info in panel edit controls mInitializingData_b = true; TxtClientNumber.Clear(); TxtClientName.Clear(); TxtTel.Clear(); TxtFax.Clear(); TxtAdressFact.Clear(); TxtAdressLivr.Clear(); TxtContactMail.Clear(); TxtContactTel.Clear(); TxtContactName.Clear(); TxtTVA.Clear(); TxtMail.Clear(); TxtRem.Clear(); CheckBoxRappConf.Checked = false; CheckBoxNE.Checked = false; CheckBoxCertif.Checked = false; DBComboxTypeSoc.ClearSelectedItem(); DBComboxCPFact.ClearSelectedItem(); DBComboxCPLivr.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); DBComboxCPLibLivr.ClearSelectedItem(); mInitializingData_b = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM Client WHERE ClientID=" + ClientID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); mInitializingData_b = true; while (SqlDataReader_O.Read()) { int.TryParse(SqlDataReader_O["RappConf"].ToString(), out RappConf_i); int.TryParse(SqlDataReader_O["NoteEnvoi"].ToString(), out NoteEnvoi_i); int.TryParse(SqlDataReader_O["Certif"].ToString(), out Certif_i); // Fill info in panel edit controls TxtClientNumber.Text = SqlDataReader_O["NumClientInterne"].ToString(); TxtClientName.Text = SqlDataReader_O["ClientNom"].ToString(); TxtTel.Text = SqlDataReader_O["ClientTel"].ToString(); TxtFax.Text = SqlDataReader_O["ClientFax"].ToString(); TxtAdressFact.Text = SqlDataReader_O["AdresseFact"].ToString(); TxtAdressLivr.Text = SqlDataReader_O["AdresseLivraison"].ToString(); TxtContactMail.Text = SqlDataReader_O["ContactEmail"].ToString(); TxtContactTel.Text = SqlDataReader_O["ContactTel"].ToString(); TxtContactName.Text = SqlDataReader_O["Contact"].ToString(); TxtTVA.Text = SqlDataReader_O["NrTVA"].ToString(); TxtMail.Text = SqlDataReader_O["ClientMail"].ToString(); TxtRem.Text = SqlDataReader_O["ClientRem"].ToString(); CheckBoxRappConf.Checked = RappConf_i != 0 ? true : false; CheckBoxNE.Checked = NoteEnvoi_i != 0 ? true : false; CheckBoxCertif.Checked = Certif_i != 0 ? true : false; if (UInt32.TryParse(SqlDataReader_O["TypeSocID"].ToString(), out TypeSocID_UL)) { DBComboxTypeSoc.SelectItemByID(TypeSocID_UL); } if (UInt32.TryParse(SqlDataReader_O["CodePostalFactID"].ToString(), out CPID_UL)) { DBComboxCPFact.SelectItemByID(CPID_UL); DBComboxCPLibFact.SelectItemByID(CPID_UL); } else { DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); } if (UInt32.TryParse(SqlDataReader_O["CodePostalLivraisonID"].ToString(), out CPID_UL)) { DBComboxCPLivr.SelectItemByID(CPID_UL); DBComboxCPLibLivr.SelectItemByID(CPID_UL); } else { DBComboxCPLivr.ClearSelectedItem(); DBComboxCPLibLivr.ClearSelectedItem(); } // Refresh job recap if (!String.IsNullOrEmpty(SqlDataReader_O["ClientNom"].ToString())) { DBListViewComjobRecap.SetInitialFilter("ClientNom='" + SqlDataReader_O["ClientNom"].ToString() + "'", "DelaiPromis desc"); DBListViewComjobRecap.Refresh(); } } SqlDataReader_O.Close(); mInitializingData_b = false; } }
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; }
private void ProviderClick(UInt32 ProviderID_UL) { // Load provider info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; UInt32 TypeSocID_UL = 0; UInt32 CPID_UL = 0; mInitializingData_b = true; TxtProviderNumber.Clear(); TxtProviderName.Clear(); TxtTel.Clear(); TxtFax.Clear(); TxtAdressFact.Clear(); TxtContactMail.Clear(); TxtContactTel.Clear(); TxtContactName.Clear(); TxtTVA.Clear(); TxtMail.Clear(); TxtRem.Clear(); DBComboxTypeSoc.ClearSelectedItem(); DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); mInitializingData_b = false; if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM Fourn WHERE FournID=" + ProviderID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); mInitializingData_b = true; while (SqlDataReader_O.Read()) { // Fill info in panel edit controls TxtProviderNumber.Text = SqlDataReader_O["NumFournInterne"].ToString(); TxtProviderName.Text = SqlDataReader_O["FournNom"].ToString(); TxtTel.Text = SqlDataReader_O["FournTel"].ToString(); TxtFax.Text = SqlDataReader_O["FournFax"].ToString(); TxtAdressFact.Text = SqlDataReader_O["Adresse"].ToString(); TxtContactMail.Text = SqlDataReader_O["ContactEmail"].ToString(); TxtContactTel.Text = SqlDataReader_O["ContactTel"].ToString(); TxtContactName.Text = SqlDataReader_O["Contact"].ToString(); TxtTVA.Text = SqlDataReader_O["NrTVA"].ToString(); TxtMail.Text = SqlDataReader_O["FournMail"].ToString(); TxtRem.Text = SqlDataReader_O["FournRem"].ToString(); if (UInt32.TryParse(SqlDataReader_O["TypeSocID"].ToString(), out TypeSocID_UL)) { DBComboxTypeSoc.SelectItemByID(TypeSocID_UL); } if (UInt32.TryParse(SqlDataReader_O["CodePostalID"].ToString(), out CPID_UL)) { DBComboxCPFact.SelectItemByID(CPID_UL); DBComboxCPLibFact.SelectItemByID(CPID_UL); } else { DBComboxCPFact.ClearSelectedItem(); DBComboxCPLibFact.ClearSelectedItem(); } } SqlDataReader_O.Close(); mInitializingData_b = false; } }
private void JobClick(UInt32 ComJobID_UL) { // Load client info in each control String SQLRequest_ST; SqlDataReader SqlDataReader_O; int RegieWork_i = 0; mInitializingJobData_b = true; // Fill info in panel edit controls ClearJobInfo(); if (mDBManager_O != null && mDBManager_O.mConnected_b) { SQLRequest_ST = "SELECT * FROM ComJobSelectPop WHERE ComJobID=" + ComJobID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { int.TryParse(SqlDataReader_O["ChkRegie"].ToString(), out RegieWork_i); // Fill info in panel edit controls ToolStripBtnJobLib.Text = SqlDataReader_O["JobLib"].ToString(); TxtQte.Text = SqlDataReader_O["Qte"].ToString(); TxtQteProd.Text = SqlDataReader_O["QteProd"].ToString(); TxtQteFact.Text = SqlDataReader_O["QteFact"].ToString(); TxtHEstim.Text = SqlDataReader_O["HTravEstim"].ToString(); TxtPVUnitEst.Text = SqlDataReader_O["CoutEstim"].ToString(); TxtPVUnitFact.Text = SqlDataReader_O["PVFact"].ToString(); TxtJobStatus.Text = SqlDataReader_O["JobStatusLib"].ToString(); try { DTPClientDelay.Value = Convert.ToDateTime(SqlDataReader_O["DelaiClient"].ToString()); } catch (FormatException e) { DTPClientDelay.Value = DTPClientDelay.MinDate; } try { DTPPromiseDelay.Value = Convert.ToDateTime(SqlDataReader_O["DelaiPromis"].ToString()); } catch (FormatException e) { DTPPromiseDelay.Value = DTPPromiseDelay.MinDate; } try { DTPRealisedDelay.Value = Convert.ToDateTime(SqlDataReader_O["DelaRealise"].ToString()); DTPRealisedDelay.Visible = true; } catch (FormatException e) { DTPRealisedDelay.Value = DTPRealisedDelay.MinDate; DTPRealisedDelay.Visible = false; } TxtJobInfo.Text = SqlDataReader_O["InfoJob"].ToString(); CheckBoxRegieWork.Checked = RegieWork_i > 0; // Fill sum hours prested on job float NbrH_f = mDBManager_O.mFunctionManager_O.SCFNC_CountPointageHoursOnJob(ComJobID_UL); if (!String.IsNullOrEmpty(TxtHEstim.Text)) { TxtHPrest.Text = NbrH_f.ToString(); JobProgress.Maximum = (int)Convert.ToDecimal(TxtHEstim.Text); JobProgress.Value = Math.Min((int)NbrH_f, JobProgress.Maximum); } } SqlDataReader_O.Close(); // Fill associated departments SQLRequest_ST = "SELECT TypeDepID FROM RelJobTypeDep WHERE ComJobID=" + ComJobID_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["TypeDepID"].ToString(), out ID_UL)) { DepID_UL.Add(ID_UL); } } JobAssociatedDep.CheckDepartments(DepID_UL); // Fill associated Send note FlowLayoutPaneSendNote.Controls.Clear(); SQLRequest_ST = "SELECT NoteEnvoiID FROM NoteEnvoiAndCertif WHERE ComJobID=" + ComJobID_UL; SqlDataReader_O = mDBManager_O.Select(SQLRequest_ST); while (SqlDataReader_O.Read()) { if (UInt32.TryParse(SqlDataReader_O["NoteEnvoiID"].ToString(), out ID_UL)) { NECertifUC NewNECertifUC_O = new NECertifUC(mDBManager_O, mDocManager_O, ID_UL); NewNECertifUC_O.Width = FlowLayoutPaneSendNote.Width; FlowLayoutPaneSendNote.Controls.Add(NewNECertifUC_O); } } } mInitializingJobData_b = false; }