public void OnGet()
{
var connection = Connection.Open();
try
{
Id = int.Parse(HttpContext.Request.Query["open"]);
}
catch
{
ReturnWithError();
return;
}
articles = ArticlesDAO.GetArticleFromDb(connection, Id);
if (articles.Name == null || articles.Name.Length < 1)
{
ReturnWithError();
return;
}
var a = UsersDAO.GetSelectedArticles(login.LoginSession, connection);
var str = SelectedArticlesToString(a);
if (str.Length > 0)
{
IsSelected = str.Split(',').Select(int.Parse).ToArray().Contains(Id);
}
connection.Close();
}
//F5 || Supp
private void ListView_Articles_KeyDown(object sender, KeyEventArgs e)
{
Keys Key = e.KeyCode;
if (Key == Keys.F5)
{
Initialise_Articles_ListView();
}
else if (Key == Keys.Delete)
{
if (this.ListView_Articles.SelectedItems.Count <= 0)
{
MessageBox.Show("Il faut choisir un Article pour supprimer.Cliquez sur RefArticle, SVP.", "Warning");
}
else
{
string RefArticle = this.ListView_Articles.SelectedItems[0].SubItems[0].Text.ToString();
if (MessageBox.Show("Vous voulez supprimer cet Article: " + RefArticle,
"Operation: Supprimer un Article", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
ArticlesDAO Articles_DAO = new ArticlesDAO();
Articles_DAO.Supprimer_Article(RefArticle);
MessageBox.Show("Supprimer " + RefArticle + " , vous pouvez utliser F5 pour recharger.", "Operation: Supprimer un Article");
}
}
}
//Console.Write(Key);
}
public void OnGet()
{
var connection = Connection.Open();
Articles = ArticlesDAO.GetAllArticles(connection);
Keywords = ArticlesDAO.MakeNewListOfKeys(connection);
connection.Close();
}
public static List <Articles> List(string y)
{
try
{
return(ArticlesDAO.listArticles(y));
}
catch (Exception ex)
{
throw new Exception("Liste Impossible", ex);
}
}
public static bool Delete(Articles y)
{
try
{
return(ArticlesDAO.deleteArticles(y));
}
catch (Exception ex)
{
throw new Exception("Suppression Impossible", ex);
}
}
public static Articles Save(Articles y)
{
try
{
return(ArticlesDAO.saveArticles(y));
}
catch (Exception ex)
{
throw new Exception("Insertion Impossible", ex);
}
}
public static bool Update(Articles y)
{
try
{
return(ArticlesDAO.updateArticles(y));
}
catch (Exception ex)
{
throw new Exception("Modification Impossible", ex);
}
}
public static Int32 Current(Articles y)
{
try
{
return(ArticlesDAO.currentArticles(y));
}
catch (Exception ex)
{
throw new Exception("Retour Impossible", ex);
}
}
public static Articles One(string y)
{
try
{
return(ArticlesDAO.oneArticles(y));
}
catch (Exception ex)
{
throw new Exception("Retour Impossible", ex);
}
}
/**
* Fonction that convert CSV ligne into data
*/
public void CSVLineToData(string readDescription, string readRefArticle, string readMarque, string readFamille, string readSous_famille, string Readprice)
{
ArticlesDAO DAOArticle = new ArticlesDAO(this);
FamilleDAO DAOFamille = new FamilleDAO(this);
MarquesDAO DAOMarque = new MarquesDAO(this);
SousFamilleDAO DAOSSFamille = new SousFamilleDAO(this);
Articles articles = new Articles(readDescription, readRefArticle, float.Parse(Readprice));
Familles familles = new Familles {
refFamille = -1, familleName = readFamille
};
Marques marques = new Marques {
marqueName = readMarque
};
SousFamilles sousfamille = new SousFamilles {
sousFamilleName = readSous_famille
};
// If famille doesn't exist
if (!DAOFamille.Find <Familles>(ref familles))
{
DAOFamille.CreateDAO <Familles>(ref familles);
}
// If Marque doesn't exist
if (!DAOMarque.Find <Marques>(ref marques))
{
DAOMarque.CreateDAO <Marques>(ref marques);
}
// If sousfamille doesn't exist
if (!DAOSSFamille.Find <SousFamilles>(ref sousfamille))
{
int id = DAOFamille.FindID <Familles>(ref familles);
Familles NEwfamille = new Familles(id);
sousfamille = new SousFamilles(readSous_famille, id);
DAOSSFamille.CreateDAO <SousFamilles>(ref sousfamille);
}
// If Article doesn't exist
if (!DAOArticle.Find <Articles>(ref articles))
{
int idMarque = DAOMarque.FindID <Marques>(ref marques);
int idSousFamille = DAOSSFamille.FindID <SousFamilles>(ref sousfamille);
articles = new Articles(readDescription, readRefArticle, idMarque, idSousFamille, float.Parse(Readprice));
DAOArticle.CreateDAO <Articles>(ref articles);
}
else // else quantite +1
{
articles.quantite += DAOArticle.Count <Articles>(ref articles);
DAOArticle.Update <Articles>(ref articles);
}
}
public static double Stock(Articles y)
{
try
{
return(ArticlesDAO.stock(y));
}
catch (Exception ex)
{
throw new Exception("Retour Impossible", ex);
}
}
//les donnees initialiser
public void Form_Donnees_Initialiser()
{
Marque_Box_Initialiser();
Sous_Familles_Box_Initialiser();
ArticlesDAO Articles_DAO = new ArticlesDAO();
Articles Article = Articles_DAO.Rechercher_Articles(this.Label_Ref_A.Text)[0];
Console.Write(Article.Quantite_Operation);
this.TextBox_Description.Text = Article.Description_Operation;
this.TextBox_Prix.Text = Article.PrixTH_Operation.ToString();
this.TextBox_Quantite.Text = Article.Quantite_Operation.ToString();
this.ComboBox_Marque.Text = Article.Ref_Marque_Operation.ToString();
this.ComboBox_SousFamille.Text = Article.Ref_Sous_Famille_Operation.ToString();
}
public void OnGet()
{
var connection = Connection.Open();
var reader = UsersDAO.GetSelectedArticles(login.LoginSession, connection);
selectedArticles = new List <Articles>();
if (reader != null)
{
while (reader.Read())
{
selectedArticles.Add(ArticlesDAO.MadeNewArticleObject(reader));
}
}
connection.Close();
}
//modifier button
private void Button_Submit_Click(object sender, EventArgs e)
{
string Ref_Article = this.Label_Ref_A.Text;
ArticlesDAO Article_DAO = new ArticlesDAO();
List <Articles> ArticlesListe = Article_DAO.Rechercher_Articles(Ref_Article);
if (ArticlesListe != null && ArticlesListe.Count > 0)
{
Articles Article = ArticlesListe[0];
string Description = this.TextBox_Description.Text;
string SousFamilles = this.ComboBox_SousFamille.Text;
string Marque = this.ComboBox_Marque.Text;
string Prix = this.TextBox_Prix.Text;
string Quantite = this.TextBox_Quantite.Text;
int QuantiteI;
float PrixF;
if (int.TryParse(Quantite, out QuantiteI))
{
if (float.TryParse(Prix, out PrixF))
{
if (MessageBox.Show("Vous voulez modifier L'Article: " + Article.Ref_Article_Operation,
"Operation: Modifier un Article", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
Article_DAO.Modifier_Article(Article.Ref_Article_Operation, Description, int.Parse(SousFamilles), int.Parse(Marque), QuantiteI, PrixF);
MessageBox.Show("Cet Article est modifier,vous pouvez utiliser F5 à la fenêtre principale pour recharger.", "Operation: Modifier");
this.Close();
}
else
{
this.Label_Ref_A.Text = Article.Ref_Article_Operation;
Form_Donnees_Initialiser();
}
}
else
{
MessageBox.Show("Quantite: il faut Float", "Attention: Modifier");
}
}
else
{
MessageBox.Show("Quantite: il faut INT", "Attention: Modifier");
}
}
else
{
MessageBox.Show("Il n'y a pas de cet Article.", "Attention: Modifier");
}
}
//clique droit-supprimer
private void supprimerToolStripMenuItem_Click(object sender, EventArgs e)
{
if (this.ListView_Articles.SelectedItems.Count <= 0)
{
MessageBox.Show("Il faut choisir un Article pour supprimer.Cliquez sur RefArticle, SVP.", "Warning");
}
else
{
string RefArticle = this.ListView_Articles.SelectedItems[0].SubItems[0].Text.ToString();
if (MessageBox.Show("Vous voulez supprimer cet Article: " + RefArticle,
"Operation: Supprimer un Article", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
ArticlesDAO Articles_DAO = new ArticlesDAO();
Articles_DAO.Supprimer_Article(RefArticle);
MessageBox.Show("Supprimer " + RefArticle + " , vous pouvez utliser F5 pour recharger.", "Operation: Supprimer un Article");
}
}
}
//ajouter button
private void Button_Ajouter_Click(object sender, EventArgs e)
{
string Ref_A = this.TextBox_RefArticle.Text;
string Description = this.TextBox_Description.Text;
string SousFamilles = this.ComboBox_SousFamille.Text;
string Marque = this.ComboBox_Marque.Text;
string Prix = this.TextBox_Prix.Text;
string Quantite = this.TextBox_Quantite.Text;
int QuantiteI;
float PrixF;
if (int.TryParse(Quantite, out QuantiteI))
{
if (float.TryParse(Prix, out PrixF))
{
if (MessageBox.Show("Vous voulez ajouter L'Article: " + Ref_A,
"Operation: Modifier un Article", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
ArticlesDAO Article_DAO = new ArticlesDAO();
Article_DAO.Ajouter_Artcle(Ref_A, Description, int.Parse(SousFamilles), int.Parse(Marque), QuantiteI, PrixF);
MessageBox.Show("Cet Article est ajouter,vous pouvez utiliser F5 à la fenêtre principale pour recharger.", "Operation: Ajouter");
this.TextBox_RefArticle.Clear();
this.TextBox_Description.Clear();
this.TextBox_Prix.Clear();
this.TextBox_Quantite.Clear();
Marque_Box_Initialiser();
Sous_Familles_Box_Initialiser();
Familles_Box_Initialiser();
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("Quantite: il faut Float", "Attention: Ajouter");
}
}
else
{
MessageBox.Show("Quantite: il faut INT", "Attention: Ajouter");
}
}
//initialiser listview
private void Initialise_Articles_ListView()
{
this.ListView_Articles.Items.Clear();
ArticlesDAO Articles_DAO = new ArticlesDAO();
List <Articles> Articles = Articles_DAO.GetAll();
this.Label_Article_Nombre.Text = "Il y a " + Articles.Count + " Articles";
if (Articles != null && Articles.Count != 0)
{
int TempCount = 0;
for (TempCount = 0; TempCount < Articles.Count; TempCount++)
{
ListViewItem Item = new ListViewItem(Articles[TempCount].Ref_Article_Operation.ToString());
Item.SubItems.Add(Articles[TempCount].Description_Operation);
Item.SubItems.Add(Articles[TempCount].Ref_Sous_Famille_Operation.ToString());
Item.SubItems.Add(Articles[TempCount].Ref_Marque_Operation.ToString());
Item.SubItems.Add(Articles[TempCount].PrixTH_Operation.ToString());
Item.SubItems.Add(Articles[TempCount].Quantite_Operation.ToString());
this.ListView_Articles.Items.Add(Item);
}
}
}
public HomeController(ILogger <HomeController> logger, ArticlesDAO dao)
{
_logger = logger;
Dao = dao;
}
public ArticlesService()
{
lObjArticlesDAO = new ArticlesDAO();
}
