// Bring all values to default
private void Reset()
{
TxtClientNumber.ResetText();
CmbAuthors.ResetText();
CmbBooks.ResetText();
NumInterval.Value = 30;
}
// Reset all items to default...
private void Reset()
{
// Reset combo boxes not to confuse the FillDgvReservations method. It considers these combo boxes and TxtClientNumber...
CmbSearch.SelectedIndex = -1;
CmbBooks.SelectedIndex = -1;
CmbAuthors.SelectedIndex = -1;
CmbUsers.SelectedIndex = -1;
CmbWhichDates.SelectedIndex = -1;
TxtClientNumber.ResetText();
ClickedRow = -1;
ClickedId = 0;
// Do not show any group boxes because nothing is selected in CmbSearch...
GrbUsers.Visible = false;
GrbBookDetails.Visible = false;
GrbClientNumber.Visible = false;
BtnStopReservation.Visible = false;
BtnDeleteReservation.Visible = false;
FillDgvReservations();
}
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;
}
}
