public static List <MouvementStock> listMouvementStock(string query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
List <MouvementStock> l = new List <MouvementStock>();
if (lect.HasRows)
{
while (lect.Read())
{
MouvementStock y = oneMouvementStock((Int32)((lect["id"] != null) ? (!lect["id"].ToString().Trim().Equals("") ? lect["id"] : 0) : 0));
l.Add(y);
}
}
return(l);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static MouvementStock oneMouvementStock(Int32 id)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from mouvements_stock where id = " + id;
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
MouvementStock y = new MouvementStock();
if (lect.HasRows)
{
while (lect.Read())
{
y.Id = id;
y.Entree = (Boolean)((lect["entree"] != null) ? (!lect["entree"].ToString().Trim().Equals("") ? lect["entree"] : false) : false);
y.Quantite = (Double)((lect["quantite"] != null) ? (!lect["quantite"].ToString().Trim().Equals("") ? lect["quantite"] : 0) : 0);
y.Date = (DateTime)((lect["date_save"] != null) ? (!lect["date_save"].ToString().Trim().Equals("") ? lect["date_save"] : DateTime.Now) : DateTime.Now);
y.Article = BLL.ArticlesBLL.One((Int32)((lect["article"] != null) ? (!lect["article"].ToString().Trim().Equals("") ? lect["article"] : 0) : 0));
y.Contenu = BLL.ContenuStockBLL.One((Int32)((lect["contenu"] != null) ? (!lect["contenu"].ToString().Trim().Equals("") ? lect["contenu"] : 0) : 0));
y.Update = true;
}
}
return(y);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static Int32 currentMouvementStock(MouvementStock f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from mouvements_stock where contenu = " + f.Contenu.Id + " and article = " + f.Article.Id + "";
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
Int32 id = new Int32();
if (lect.HasRows)
{
while (lect.Read())
{
id = (Int32)((lect["id"] != null) ? (!lect["id"].ToString().Trim().Equals("") ? lect["id"] : 0) : 0);
}
}
return(id);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(0);
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool Delete(MouvementStock y)
{
try
{
return(MouvementStockDAO.deleteMouvementStock(y));
}
catch (Exception ex)
{
throw new Exception("Suppression Impossible", ex);
}
}
public static bool Update(MouvementStock y)
{
try
{
return(MouvementStockDAO.updateMouvementStock(y));
}
catch (Exception ex)
{
throw new Exception("Modification Impossible", ex);
}
}
public static Int32 Current(MouvementStock y)
{
try
{
return(MouvementStockDAO.currentMouvementStock(y));
}
catch (Exception ex)
{
throw new Exception("Retour Impossible", ex);
}
}
public static MouvementStock Save(MouvementStock y)
{
try
{
return(MouvementStockDAO.saveMouvementStock(y));
}
catch (Exception ex)
{
throw new Exception("Insertion Impossible", ex);
}
}
public static List <MouvementStock> getListMouvementStock(String query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
List <MouvementStock> l = new List <MouvementStock>();
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
MouvementStock a = new MouvementStock();
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Article = (lect["article"] != null
? (!lect["article"].ToString().Trim().Equals("")
? BLL.ArticleBll.One(Convert.ToInt64(lect["article"].ToString()))
: new Article())
: new Article());
a.Mouvement = lect["mouvement"].ToString();
a.Quantite = (Double)((lect["quantite"] != null) ? (!lect["quantite"].ToString().Trim().Equals("") ? lect["quantite"] : 0) : 0);
a.DateDoc = (DateTime)((lect["date_doc"] != null) ? (!lect["date_doc"].ToString().Trim().Equals("") ? lect["date_doc"] : DateTime.Now) : DateTime.Now);
a.Depot = (lect["depot"] != null
? (!lect["depot"].ToString().Trim().Equals("")
? new Depot(Convert.ToInt64(lect["depot"].ToString()))
: new Depot())
: new Depot());
l.Add(a);
}
lect.Close();
}
return(l);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static MouvementStock getOneMouvementStock(long id)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from yvs_base_mouvement_stock where id = " + id + "";
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
MouvementStock a = new MouvementStock();
if (lect.HasRows)
{
while (lect.Read())
{
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Article = (lect["article"] != null
? (!lect["article"].ToString().Trim().Equals("")
? BLL.ArticleBll.One(Convert.ToInt64(lect["article"].ToString()))
: new Article())
: new Article());
a.Mouvement = lect["mouvement"].ToString();
a.Quantite = (Double)((lect["quantite"] != null) ? (!lect["quantite"].ToString().Trim().Equals("") ? lect["quantite"] : 0) : 0);
a.DateDoc = (DateTime)((lect["date_doc"] != null) ? (!lect["date_doc"].ToString().Trim().Equals("") ? lect["date_doc"] : DateTime.Now) : DateTime.Now);
a.Depot = (lect["depot"] != null
? (!lect["depot"].ToString().Trim().Equals("")
? new Depot(Convert.ToInt64(lect["depot"].ToString()))
: new Depot())
: new Depot());
}
lect.Close();
}
return(a);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool getUpdateMouvementStock(MouvementStock a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string update = "";
NpgsqlCommand Ucmd = new NpgsqlCommand(update, con);
Ucmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool updateMouvementStock(MouvementStock f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string update = "update mouvements_stock set quantite =" + f.Quantite + " , article =" + f.Article.Id + " , contenu =" + f.Contenu.Id + " where id = " + f.Id;
NpgsqlCommand cmd = new NpgsqlCommand(update, con);
cmd.ExecuteNonQuery();
return(true);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
public static MouvementStock getAjoutMouvementStock(MouvementStock a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string insert = "";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
a.Id = getCurrent();
return(a);
}
catch
{
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool deleteMouvementStock(MouvementStock f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string delete = "delete from mouvements_stock where id = " + f.Id;
NpgsqlCommand cmd = new NpgsqlCommand(delete, con);
cmd.ExecuteNonQuery();
return(true);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
public static MouvementStock saveMouvementStock(MouvementStock f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string insert = "insert into mouvements_stock (entree, quantite, article, contenu) values (" + f.Entree + "," + f.Quantite + "," + f.Article.Id + "," + f.Contenu.Id + ")";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
f.Id = currentMouvementStock(f);
return(f);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
private void AddRowApprovision(MouvementStock m)
{
dgv_approvision.Rows.Add(new object[] { m.Id, m.Article.Designation, m.Quantite, m.Image });
}
private void AddRow(MouvementStock m)
{
dgv_liste.Rows.Add(new object[] { m.Id, m.Article != null ? m.Article.Designation : "", m.Quantite > -1 ? m.Quantite : -(m.Quantite), m.Date, m.Icon });
}
public MouvementStockBll(MouvementStock unMouvementStock)
{
mouv = unMouvementStock;
}
