public List <tOperation> GetOperationParReference(string reference)
{
using (SqlConnection Conn = new SqlConnection(ClassVaribleGolbal.seteconnexion))
try
{
Conn.Open();
List <tOperation> _list = new List <tOperation>();
if (Conn.State != System.Data.ConnectionState.Open)
{
Conn.Open();
}
string s = "select * from tOperation where Reference = @a";
SqlCommand objCommand = new SqlCommand(s, Conn);
objCommand.Parameters.AddWithValue("@a", reference);
SqlDataReader _Reader = objCommand.ExecuteReader();
while (_Reader.Read())
{
tOperation objCust = new tOperation();
objCust.NumOperation = Convert.ToInt32(_Reader["NumOperation"]);
objCust.DateOp = Convert.ToDateTime(_Reader["DateOp"]);
objCust.Libelle = _Reader["Libelle"].ToString();
objCust.Reference = _Reader["Reference"].ToString();
_list.Add(objCust);
}
return(_list);
}
catch
{
throw;
}
finally
{
if (Conn != null)
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
Conn.Dispose();
}
}
}
}
//modification de l'api enregistrement nouvelle operation, changement type de donnee a retourner
public List <tOperation> NouvelleOperation(tOperation tbl)
{
using (SqlConnection con = new SqlConnection(ClassVaribleGolbal.seteconnexion))
{
List <tOperation> _list = new List <tOperation>();
con.Open();
string query = "INSERT INTO tOperation(DateOp,Libelle,Reference) VALUES (@a,@b,@c)";
int reference = GetDernierID();
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@a", DateTime.Now.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@b", tbl.Libelle);
cmd.Parameters.AddWithValue("@c", (reference));
int result = cmd.ExecuteNonQuery();
//rrecuperation de la reponse a retourne lors de l'insertion d'une operations
tOperation objectResult = new tOperation();
if (result == 1)
{
objectResult.DateOp = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
objectResult.Libelle = tbl.Libelle;
objectResult.Reference = Convert.ToString(reference);
objectResult.status_result = result;
objectResult.status_response = "Insertion réussie avec succès";
}
else
{
objectResult.DateOp = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
objectResult.Libelle = "";
objectResult.Reference = "";
objectResult.status_result = result;
objectResult.status_response = "Echec Insertion";
}
_list.Add(objectResult);
return(_list);
}
}
