public ConversionPointModel NouvelleConversion(ConversionPointModel Obj) { try { // string dernier_EB = DernierEtatBesoin() + "EB" + InitialNomUtilisateur; string s = "INSERT INTO tConversionPoint " + " (CodeConversion,CodeClient, PointConvertie, RefOperation,DateOperation) " + " VALUES(@a,@b, @c,@d,@da) "; //Em.CodeEtatdeBesoin, change par dernier_EB string[] r = { DernierCon(), Obj.CodeClient, Obj.PointConvertie, Obj.RefOperation, }; DateTime[] d = { DateTime.Now }; // Verification de solde //double solde. //Clients.ClientDataAccessLayer Dal = new Clients.ClientDataAccessLayer(); ClassRequette req = new ClassRequette(); req.ExecuterSqlAvecDate(ClassVariableGlobal.seteconnexion(), s, r, d);; //EtatBesoinModel etat = new EtatBesoinModel(); //etat.CodeEtatdeBesoin = dernier_EB; //etat.DesignationEtatDeBesion = Em.DesignationEtatDeBesion; return(Obj); } catch { return(null); throw; } }
// Liste point converti par periode par client public List <ConversionPointModel> GetListePointsConvertisTouParperiode(string codeClient, DateTime date1, DateTime date2) { using (SqlConnection Conn = new SqlConnection(ClassVariableGlobal.SetConnexion())) try { Conn.Open(); List <ConversionPointModel> _listePointConvertis = new List <ConversionPointModel>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } string s = "ConversionPourLaPeriode"; //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()) { ConversionPointModel objCust = new ConversionPointModel(); // objCust.IdFacture = Convert.ToInt32(_Reader["IdFacture"]); objCust.CodeClient = _Reader["codeClient"].ToString(); objCust.CodeConversion = (_Reader["codeConversion"].ToString()); try { objCust.DateOperation = (_Reader["dateOperation"].ToString()); } catch { objCust.DateOperation = DateTime.Now.ToString(); } try { objCust.PointConvertie = _Reader["pointConvertie"].ToString(); } 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(); } } } }