public LesVentesEtCharges GetVenteJournaliere(DateTime date1, DateTime date2)
{
LesVentesEtCharges listeVenteJ = new LesVentesEtCharges();
using (SqlConnection con = new SqlConnection(connectionString))
{
int daysDiff = Math.Abs(((TimeSpan)(date2 - date1)).Days + 1);
string s = "SELECT tCompte.NumCompte, SUM(tMvtCompte.Entree) AS SDebitCharge, SUM(tMvtCompte.Sortie) AS SCreditProduit, tCompte.DesignationCompte, " +
"((tObjectif.VenteJournalier) * " + daysDiff + ") as ObjectifVenteJournalier, (SUM(tMvtCompte.Sortie) / ((tObjectif.VenteJournalier)* " + daysDiff + ") * 100) AS PourCentageVente " +
" FROM tCompte INNER JOIN " +
" tMvtCompte ON tCompte.NumCompte = tMvtCompte.NumCompte INNER JOIN " +
" tOperation ON tMvtCompte.NumOperation = tOperation.NumOperation CROSS JOIN " +
" tObjectif" +
" WHERE(tOperation.DateOp between @da and @db) " +
" GROUP BY tCompte.NumCompte, tCompte.DesignationCompte, tObjectif.VenteJournalier" +
" HAVING(tCompte.NumCompte = 7000000)";
SqlCommand cmd = new SqlCommand(s, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@da", date1);
cmd.Parameters.AddWithValue("@db", date2);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
listeVenteJ.SCreditProduit = Convert.ToDouble(rdr["SCreditProduit"]);
listeVenteJ.ObjectifVenteJournalier = Convert.ToDouble(rdr["ObjectifVenteJournalier"]);
listeVenteJ.PourCentageVente = Convert.ToDouble(rdr["PourCentageVente"]);
listeVenteJ.DesignationCompte = rdr["DesignationCompte"].ToString();
listeVenteJ.NumCompte = rdr["NumCompte"].ToString();
//Customer.Country = rdr["Country"].ToString();
// Customer.City = rdr["City"].ToString();
}
}
return(listeVenteJ);
}
public LesVentesEtCharges GetChargeStockage(DateTime date1, DateTime date2)
{
LesVentesEtCharges ChargeStockage = objLesVente.GetChargeStockage(date1, date2);
return(ChargeStockage);
}
public LesVentesEtCharges GetVenteJoornaliere(DateTime date1, DateTime date2)
{
LesVentesEtCharges VenteJ = objLesVente.GetVenteJournaliere(date1, date2);
return(VenteJ);
}
