private void GenererLicence_Click(object sender, EventArgs e)
{
if (ProgramManager.DetecteurErreurSaisieNewClient(NomClient, CodeClient, CodePostale, Adresse1) == true)
{
FixRadioGroup();
string licences = GetLicences.GetSeriale(NomClient, CodeClient, CodePostale, Adresse1, GropLicences);
ImputLicences.Text = licences;
DateDebutLicenece.Text = DateTime.Today.ToString("dd-MM-yyyy");
DateFin.Text = Convert.ToDateTime(LicenceDelaisManager.FinLicence(DateTime.Today, LicenceDelaisManager.LicenceLength(GropLicences.Properties.Items[GropLicences.SelectedIndex].Description))).ToString("dd-MM-yyyy");
NombreDeJour.Text = LicenceDelaisManager.LicenceLength(GropLicences.Properties.Items[GropLicences.SelectedIndex].Description).ToString();
ProgramManager.InserstionData(CmdLicenceLoad.UpdateDataClient(NomClient, CodeClient, CodePostale, VilleClient, Adresse1, Adresse2, GropLicences));
ProgramManager.InserstionData(CmdLicenceLoad.LoadDataToDataBase(DateDebutLicenece.Text, DateFin.Text, ImputLicences.Text, NombreDeJour.Text, CodeClient.Text, GropLicences.Properties.Items[GropLicences.SelectedIndex].Description));
AlimenterGrid.FillDataGridView <Client>(GcLicence, ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient()), ProgramManager.Chargement(ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient())));
FindInGridControl(CodeClient.Text);
NomClient.ResetText(); CodeClient.ResetText(); CodePostale.ResetText();
VilleClient.ResetText(); Adresse1.ResetText(); Adresse2.ResetText();
DateDebutLicenece.ResetText(); DateFin.ResetText();
ImputLicences.ResetText(); NombreDeJour.ResetText();
MsgBox.Show(this, MessagesSystem.ModifSaved);
}
else
{
MsgBox.Show(this, MessagesSystem.ErreurAjoutClientExpress);
}
}
private void BtnSearch_Click(object sender, EventArgs e)
{
if (CodeClientDetails.Text != string.Empty)
{
DetailsRepository.DefractionnerObjetReaderDetails(ProgramManager.RecupDataDetails(CodeClientDetails.Text),
PicLicence1, PicLicence2, PicLicence3, DateExpirationDelais, DebutLicenceDetails, GropLicences, NumeroLicnceDetails,
JourRestant, NomClientDetail, txtZipeCode, JourRestant);
LicenceDelaisManager.CodeCouleurDetails(JourRestant);
}
}
private void GvLicence_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
ProgramManager.RecupererElementRow(CodeClient, GvLicence, "ClientCode");
ProgramManager.RecupererElementRow(NomClient, GvLicence, "ClientPrenom");
ProgramManager.RecupererElementRow(CodePostale, GvLicence, "ClientCodePostal");
ProgramManager.RecupererElementRow(Adresse1, GvLicence, "ClientAdresse1");
ProgramManager.RecupererElementRow(Adresse2, GvLicence, "ClientAdresse2");
ProgramManager.RecupererElementRow(VilleClient, GvLicence, "ClientVille");
IsLicenced = ProgramManager.RecupererElementRow(GropLicences, PicLicence1, PicLicence2, PicLicence3, GvLicence, "TypeLicences");
}
private void FrmAcceuil_Shown(object sender, EventArgs e)
{
ImageList il = new ImageList();
il.Images.Add(Properties.Resources.Licence1);
il.Images.Add(Properties.Resources.Licence2);
il.Images.Add(Properties.Resources.Licence3);
LicImageCombo.SmallImages = il;
LicImageCombo.Items.Add("Licence1", "Licence1", 0);
LicImageCombo.Items.Add("Licence2", "Licence2", 1);
LicImageCombo.Items.Add("Licence3", "Licence3", 2);
AlimenterGrid.FillDataGridView <Client>(GcLicence, ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient()), ProgramManager.Chargement(ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient())));
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
BtnRefresh.PerformClick();
ProgramManager.InserstionData(CmdLicenceLoad.LoadDataToDataBase(DebutLicenceDetails.Text, DateExpirationDelais.Text, NumeroLicnceDetails.Text, JourRestant.Text, CodeClientDetails.Text, GropLicences.Properties.Items[GropLicences.SelectedIndex].Description));
MsgBox.Show(this, MessagesSystem.ModifSaved);
}
catch (Exception ex)
{
MsgBox.Show(this, ex.Message);
}
BtnSave.Enabled = false;
}
private void CodeClient_KeyUp(object sender, KeyEventArgs e)
{
for (int index = 0; index < GvLicence.RowCount; index++)
{
if (GvLicence.GetRowCellValue(index, ClientCode).ToString() == CodeClient.Text)
{
GvLicence.FocusedRowHandle = index;
GvLicence.SetRowCellValue(index, ClientCode, CodeClient.Text);
IsLicenced = DetailsRepository.DefractionnerObjetReaderClient(ProgramManager.RecupDataClient(CodeClient.Text), PicLicence1, PicLicence2, PicLicence3, NomClient, CodePostale, VilleClient, Adresse1, Adresse2, GropLicences);
return;
}
}
GvLicence.MoveFirst();
}
private void Sauvgarder_Click(object sender, EventArgs e)
{
try
{
ProgramManager.InserstionData(CmdLicenceLoad.LoadDataToDataBase(DateDebutLicenece.Text, DateFin.Text, ImputLicences.Text, NombreDeJour.Text, CodeClient.Text, GropLicences.Properties.Items[GropLicences.SelectedIndex].Description));
AlimenterGrid.FillDataGridView <Client>(GcLicence, ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient()), ProgramManager.Chargement(ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient())));
MsgBox.Show(this, MessagesSystem.LoadDataSucced + NomClient.Text);
if (ImputLicences.Text == MessagesSystem.StringVide)
{
MsgBox.Show(this, MessagesSystem.StringVide);
}
}
catch (Exception ex)
{
MsgBox.Show(this, ex.Message);
}
}
private void BoutonDetails_Click(object sender, EventArgs e)
{
try
{
if (IsLicenced)
{
if (CodeClient.Text != String.Empty)
{
FrmDetails Details = new FrmDetails();
Details.ShowInTaskbar = false;
Details.ClientCode = CodeClient.Text;
if (Details.ClientCode != "")
{
Details.Dialog = true;
Details.ShowDialog();
Details.ClientCode = "";
AlimenterGrid.FillDataGridView <Client>(GcLicence, ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient()), ProgramManager.Chargement(ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient())));
FindInGridControl(CodeClient.Text);
NomClient.ResetText(); CodeClient.ResetText(); CodePostale.ResetText();
VilleClient.ResetText(); Adresse1.ResetText(); Adresse2.ResetText();
}
else
{
CodeClient.BackColor = Color.Red;
Details.Dispose();
return;
}
}
else
{
MsgBox.Show(this, MessagesSystem.ErreurAjoutClientExpress);
CodeClient.BackColor = Color.Red;
}
}
else
{
MsgBox.Show(this, "User Not Licenced !!!");
return;
}
}
catch (Exception ex)
{
MsgBox.Show(this, ex.Message);
}
}
private void ButtonAjout_Click(object sender, EventArgs e)
{
try
{
if (ProgramManager.DetecteurErreurSaisieNewClient(NomClient, CodeClient, CodePostale, Adresse1) == true)
{
ProgramManager.InsertClientRapide(CmdClient.RequetAjoutClientRapide(CodeClient.Text, Adresse1.Text, Adresse2.Text, CodePostale.Text, VilleClient.Text, NomClient.Text));
AlimenterGrid.FillDataGridView <Client>(GcLicence, ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient()), ProgramManager.Chargement(ProgramManager.Chargementreader(CmdClient.RequetteCaracteristiqueClient())));
MsgBox.Show(this, MessagesSystem.ClientAddSuccecful);
}
else
{
MsgBox.Show(this, MessagesSystem.ErreurAjoutClientExpress);
}
}
catch (Exception EX)
{
MsgBox.Show(this, EX.Message);
}
}
/// <summary>
/// Methode qui permet de faire une tetative de connection a la base de donné
/// </summary>
/// <param name="ImputNom">Text saisie dans la zone de text du nom de l'administrateur</param>
/// <param name="ImputPassword">Zone de saisie du mot de passe </param>
/// <returns>true si les identitifant sont correcte , false si non </returns>
public static bool LoginEssai(string ImputNom, string ImputPassword, XtraForm frm)
{
OleDbDataReader MONoBJET = ProgramManager.Chargementreader(CmdClient.RequetteLogin(ImputNom, ImputPassword));
int count = 0;
bool LoginSucc;
while (MONoBJET.Read())
{
count += 1;
}
if (count == 1)
{
LoginManager.LoginProcess(true);
LoginSucc = true;
}
else
{
LoginManager.LoginProcess(false);
LoginSucc = false;
}
return(LoginSucc);
}
private void FrmDetails_Shown(object sender, EventArgs e)
{
CodeClientDetails.Text = ClientCode;
try
{
if (Dialog)
{
DetailsRepository.DefractionnerObjetReaderDetails(ProgramManager.RecupDataDetails(CodeClientDetails.Text),
PicLicence1, PicLicence2, PicLicence3, DateExpirationDelais, DebutLicenceDetails, GropLicences, NumeroLicnceDetails, JourRestant, NomClientDetail, txtZipeCode, JourRestant);
LicenceDelaisManager.CodeCouleurDetails(JourRestant); Dialog = false;
}
else
{
CodeClientDetails.Enabled = true;
return;
}
}
catch
{
MsgBox.Show(this, MessagesSystem.ErreurConsulterDetails);
this.Close();
}
}
private void AjoutClientExpress_CheckedChanged(object sender, EventArgs e)
{
ProgramManager.AjoutExppress(GcLicence, PicLicence1, PicLicence2, PicLicence3, NomClient, CodeClient, CodePostale, VilleClient, Adresse1,
Adresse2, GropLicences, GenererLicence, ImputLicences, DateDebutLicenece, DateFin,
NombreDeJour, Sauvgarder, BoutonDetails, ButtonAjout);
}
