public DashBoardClient totalAficherDashBoardCleient(string CodeClient, DateTime date1, DateTime date2) { DashBoardClient objCust = new DashBoardClient(); PointFacuration pf = new PointFacuration(); PointConversionModel pc = new PointConversionModel(); pf = TotlalDesPointFacturePourUnePeriode(CodeClient, date1, date2); pc = TotlalDesPointConvertiePourUnePeriode(CodeClient, date1, date2); objCust.PhoneClient = pf.PhoneClient; objCust.PseudoClient = pf.PseudoClient; objCust.CodeClient = pf.CodeClient; objCust.BalanseDePoint = (pf.SommeFact - pc.SommePoint); objCust.PointConvertie = pc.SpointConvertie; objCust.PointFacture = pf.SommeFact; objCust.PointInitial = (pf.SommeFact - pc.SommePoint) - pf.SommeFact + pc.SpointConvertie; objCust.PhoneClient = "0"; return(objCust); }
public DashBoardClient AfficherSituationGgeneralAdmin(DateTime date1, DateTime date2) { DashBoardClient objCust = new DashBoardClient(); //PointFacuration pf = new PointFacuration(); //PointConversionModel pc = new PointConversionModel(); //pf = TotlalDesPointFacturePourUnePeriode(CodeClient, date1, date2); //pc = TotlalDesPointConvertiePourUnePeriode(CodeClient, date1, date2); objCust.PhoneClient = "GENERALE"; objCust.PseudoClient = "GENERALE"; objCust.CodeClient = "GENERALE"; Double SodeRestourne = SommeDeRestourneSolde(date2); Double SodeConversion = SommeDeConversionSolde(date2); objCust.BalanseDePoint = (SodeRestourne - SodeConversion); objCust.PointConvertie = SommeDeConversion(date1, date2); objCust.PointFacture = SommeDeRestourne(date1, date2); objCust.PointInitial = (objCust.BalanseDePoint) - objCust.PointFacture + objCust.PointConvertie; objCust.PhoneClient = "0"; return(objCust); }
public List <DashBoardClient> GetListeBalancedePoint() { using (SqlConnection Conn = new SqlConnection(ClassVariableGlobal.SetConnexion())) try { Conn.Open(); List <DashBoardClient> _listePointConvertis = new List <DashBoardClient>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } string s = "Pro_BalanceClient"; //SELECT * FROM tClasse SqlCommand objCommand = new SqlCommand(s, Conn); objCommand.CommandType = CommandType.StoredProcedure; //objCommand.Parameters.AddWithValue("@CodeClient", codeClient); //objCommand.Parameters.AddWithValue("@Date1", date1); //objCommand.Parameters.AddWithValue("@Date2", date2); SqlDataReader _Reader = objCommand.ExecuteReader(); while (_Reader.Read()) { DashBoardClient objCust = new DashBoardClient(); // objCust.IdFacture = Convert.ToInt32(_Reader["IdFacture"]); objCust.CodeClient = _Reader["codeClient"].ToString(); objCust.PseudoClient = (_Reader["PseudoClient"].ToString()); objCust.PhoneClient = (_Reader["PhoneClient"].ToString()); objCust.PseudoClient = (_Reader["PseudoClient"].ToString()); try { objCust.BalanseDePoint = Convert.ToDouble((_Reader["BalancePoint"])); } catch { objCust.BalanseDePoint = 0; } try { objCust.PointFacture = Convert.ToDouble(_Reader["SommeRistourne"]); } catch { objCust.PointFacture = 0; } try { objCust.PointConvertie = Convert.ToDouble(_Reader["SommeCoverti"]); } catch { objCust.PointConvertie = 0; } // objCust.RefOperation = (_Reader["refOperation"].ToString()); _listePointConvertis.Add(objCust); } return(_listePointConvertis); } catch { throw; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }