private void loadDataMAJ()
{
object o = SqlServer_Classes.ExecuteScalar("select idMAJ from MiseA_Jour order by DateMAJ desc");
if (o != null)
{
DateTime dateM = DateTime.Parse(SqlServer_Classes.ExecuteScalar("select DateMAJ from MiseA_Jour where idMAJ = '" + int.Parse(o.ToString()) + "'").ToString());
lblLastMAJ.Text = dateM.ToString("ddd dd/MM/yyyy à HH:mm");
int Progress = SqlServer_Classes.getProgress(int.Parse(o.ToString()));
lblProgress.Text = Progress + " %";
progressMAJ.Value = Progress;
}
else
{
lblLastMAJ.Text = "Aucune mise à jour n'a été effectué";
lblProgress.Text = "0 %";
progressMAJ.Value = 0;
}
}
private void printBonChargemenet()
{
int CodeChargement = int.Parse(SqlServer_Classes.ExecuteScalar("select IDENT_CURRENT('Chargement')").ToString());
var App = Application.OpenForms["Form1"] as Form1;
Command_UC ucComm = (Command_UC)App.panelContainer.Controls[0];
DataSet Data_Set = SqlServer_Classes.getBonChargement(CodeChargement);
BonDeChargement reportCommande = new BonDeChargement();
reportCommande.SetDataSource(Data_Set);
ReportViewer_UC viewer_UC = new ReportViewer_UC();
viewer_UC.Dock = DockStyle.Fill;
viewer_UC.crystalReportViewer1.ReportSource = reportCommande;
viewer_UC.Refresh();
App.panelContainer.Controls.Clear();
App.panelContainer.Controls.Add(viewer_UC);
}
private void btnCommande_Click(object sender, EventArgs e)
{
try
{
using (OpenFileDialog Ds = new OpenFileDialog())
{
Ds.Filter = "Fichier CSV|*Csv";
Ds.Multiselect = false;
if (Ds.ShowDialog() == DialogResult.OK)
{
Dictionary <int, Commande> commandes = new Dictionary <int, Commande>();
List <ligneCommande> lineCommandes = new List <ligneCommande>();
using (var reader = new StreamReader(Ds.FileName))
{
while (!reader.EndOfStream)
{
string line = reader.ReadLine();
if (line.Trim().Length != 0 && !line.Contains("affectée") && !line.Contains("affected") && !line.Contains("Codecommande"))
{
if (!commandes.ContainsKey(int.Parse(line.Split(',')[0])))
{
commandes.Add(int.Parse(line.Split(',')[0]), new Commande(
int.Parse(line.Split(',')[0]),
DateTime.Parse(line.Split(',')[1]),
int.Parse(line.Split(',')[3])
));
}
lineCommandes.Add(new ligneCommande(
int.Parse(line.Split(',')[0].Trim()),
int.Parse(line.Split(',')[6].Trim()),
int.Parse(line.Split(',')[7].Trim())
));
}
}
}
SqlServer_Classes.ExecuteQuery("insert into MiseA_Jour values(DeFAULT)");
int CodeMAJ = int.Parse(SqlServer_Classes.ExecuteScalar("select IDENT_CURRENT('MiseA_Jour')").ToString());
List <SqlParameter> parameters = new List <SqlParameter>();
foreach (Commande commande in commandes.Values)
{
parameters.Clear();
parameters.Add(new SqlParameter("@dateComm", commande.DateCommande));
parameters.Add(new SqlParameter("@codeDepot", Program.CodeDepot));
parameters.Add(new SqlParameter("@CodeClient", commande.CodeClient));
parameters.Add(new SqlParameter("@numMAJ", CodeMAJ));
SqlServer_Classes.ExecuteQuery("insert into Commande values(@dateComm, @codeDepot, @CodeClient, @numMAJ)", parameters);
int CodeCommande = int.Parse(SqlServer_Classes.ExecuteScalar("select IDENT_CURRENT('Commande')").ToString());
foreach (ligneCommande ligneCommande in lineCommandes)
{
if (ligneCommande.CodeCommande == commande.CodeCommande)
{
parameters.Clear();
parameters.Add(new SqlParameter("@codeComm", CodeCommande));
parameters.Add(new SqlParameter("@codeProduit", ligneCommande.CodeProduit));
parameters.Add(new SqlParameter("@Qte", ligneCommande.Qte));
SqlServer_Classes.ExecuteQuery("insert into ligneCommande values(@codeComm, @codeProduit, @Qte)", parameters);
}
}
}
loadDataMAJ();
MessageBox.Show("la mise à jour a bien été effectué de la base de donnée", "Opération Terminé", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (IOException exept)
{
MessageBox.Show(exept.Message, "Un Erreur a été survenue lors de l'ouverture et lecture du fichier", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}