public Article GetArticleByReferences(string references)
{
Article reponse = new Article();
ConnexionSage connexion = new ConnexionSage();
SqlCommand command;
SqlDataReader dataReader;
connexion.Open();
string sql = "SELECT AR_Ref,AR_Design,FA_CodeFamille,CL_No2 FROM F_ARTICLE where AR_Ref='" + references + "'";
command = new SqlCommand(sql, connexion.Connection);
dataReader = command.ExecuteReader();
try
{
while (dataReader.Read())
{
Article article = new Article();
article.References = dataReader.GetValue(0).ToString();
article.Designation = dataReader.GetValue(1).ToString();
article.Code = dataReader.GetValue(2).ToString();
article.Emplacement = dataReader.GetValue(3).ToString();
reponse = article;
}
return(reponse);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
finally
{
connexion.CloseRest(dataReader, command, connexion.Connection);
}
}
public List <string> GetNumeroPiece(string piece, Utilisateur utilisateur)
{
Comptoir comptoir = GetComptoirByNomCaisse(utilisateur.Identifiants);
List <string> reponse = new List <string>();
ConnexionSage connexion = new ConnexionSage();
SqlCommand command;
SqlDataReader dataReader;
connexion.Open();
string sql = "SELECT DISTINCT F_DOCLIGNE.DO_Piece FROM F_DOCLIGNE WHERE F_DOCLIGNE.DO_Piece like '" + piece + "%' and F_DOCLIGNE.CO_No='" + comptoir.IdComptoir + "'";
command = new SqlCommand(sql, connexion.Connection);
dataReader = command.ExecuteReader();
try
{
while (dataReader.Read())
{
reponse.Add(dataReader["DO_Piece"].ToString());
}
return(reponse);
}
catch (Exception exception)
{
throw exception;
}
finally
{
connexion.CloseRest(dataReader, command, connexion.Connection);
}
}
public Emplacement GetEmplacementsByNumero(string numero)
{
Emplacement reponse = new Emplacement();
ConnexionSage connexion = new ConnexionSage();
SqlCommand command;
SqlDataReader dataReader;
connexion.Open();
string sql = "select CL_No,CL_Intitule from F_CATALOGUE where CL_No = '" + numero + "'";
command = new SqlCommand(sql, connexion.Connection);
dataReader = command.ExecuteReader();
try
{
while (dataReader.Read())
{
Emplacement emplacement = new Emplacement();
emplacement.NumeroEmplacement = dataReader[0].ToString();
emplacement.Intitule = dataReader[1].ToString();
reponse = emplacement;
}
return(reponse);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
finally
{
connexion.CloseRest(dataReader, command, connexion.Connection);
}
}
public List <DetailCommande> GetArticlesCommandes(string numero)
{
List <DetailCommande> reponse = new List <DetailCommande>();
ConnexionSage connexion = new ConnexionSage();
SqlCommand command;
SqlDataReader dataReader;
connexion.Open();
string sql = "SELECT F_ARTICLE.AR_Ref,F_ARTICLE.AR_Design,F_ARTICLE.FA_CodeFamille," +
"F_ARTICLE.CL_No2, F_DOCLIGNE.DL_Qte,F_DOCLIGNE.DO_Piece FROM F_DOCLIGNE " +
"join F_ARTICLE on F_ARTICLE.AR_Ref=F_DOCLIGNE.AR_Ref " +
"WHERE F_DOCLIGNE.DO_Piece='" + numero + "'";
command = new SqlCommand(sql, connexion.Connection);
dataReader = command.ExecuteReader();
try
{
while (dataReader.Read())
{
Article article = new Article();
article.References = dataReader.GetValue(0).ToString();
article.Designation = dataReader.GetValue(1).ToString();
article.Code = dataReader.GetValue(2).ToString();
article.Emplacement = dataReader.GetValue(3).ToString();
int emplacement = (int)float.Parse(dataReader.GetValue(3).ToString());
int quantite = (int)float.Parse(dataReader.GetValue(4).ToString());
DetailCommande detailcommande = new DetailCommande(article, quantite, emplacement);
reponse.Add(detailcommande);
}
return(reponse);
}
catch (Exception exception)
{
//throw new Exception(sql);
throw exception;
}
finally
{
connexion.CloseRest(dataReader, command, connexion.Connection);
}
}
public Comptoir GetComptoirByNumTicket(string numero_ticket)
{
ConnexionSage connexion = new ConnexionSage();
SqlCommand command;
SqlDataReader dataReader;
Comptoir comptoirTemp = new Comptoir();
connexion.Open();
string sql = "SELECT DISTINCT F_DOCLIGNE.CO_No, F_CAISSE.CA_Intitule FROM F_DOCLIGNE join F_CAISSE on F_CAISSE.CO_No = F_DOCLIGNE.CO_No join F_ARTICLE on F_ARTICLE.AR_Ref = F_DOCLIGNE.AR_Ref WHERE F_DOCLIGNE.DO_Piece='" + numero_ticket + "'";
command = new SqlCommand(sql, connexion.Connection);
dataReader = command.ExecuteReader();
try
{
if (dataReader.Read().ToString() == "True")
{
comptoirTemp.IdComptoir = dataReader["CO_No"].ToString();
comptoirTemp.NomComptoir = dataReader["CA_Intitule"].ToString();
}
else
{
comptoirTemp.IdComptoir = "0";
comptoirTemp.NomComptoir = "Autres";
}
return(comptoirTemp);
}
catch (Exception exception)
{
throw new Exception(exception.Message);
}
finally
{
connexion.CloseRest(dataReader, command, connexion.Connection);
}
}
public Comptoir GetComptoirByNomCaisse(string nom)
{
ConnexionSage connexion = new ConnexionSage();
SqlCommand command;
SqlDataReader dataReader;
Comptoir comptoirTemp = new Comptoir();
connexion.Open();
string sql = "SELECT * FROM F_CAISSE where CA_Intitule='" + nom + "'";
command = new SqlCommand(sql, connexion.Connection);
dataReader = command.ExecuteReader();
try
{
if (dataReader.Read().ToString() == "True")
{
comptoirTemp.IdComptoir = dataReader["CO_No"].ToString();
comptoirTemp.NomComptoir = dataReader["CA_Intitule"].ToString();
}
else
{
comptoirTemp.IdComptoir = "";
comptoirTemp.NomComptoir = "";
}
return(comptoirTemp);
}
catch (Exception exception)
{
throw exception;
}
finally
{
connexion.CloseRest(dataReader, command, connexion.Connection);
}
}