public static void UpdateNaftalCard(string ID, String _code, String _numero, String _libelle, DateTime _date)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDNaftalCard", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = ID; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Code", SqlDbType.NVarChar).Value = _code; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Numéro", SqlDbType.NVarChar).Value = _numero;
cmd.Parameters.AddWithValue("@Libelle", SqlDbType.NVarChar).Value = _libelle;
cmd.Parameters.AddWithValue("@expiredDate", SqlDbType.DateTime).Value = _date;
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "UPDATE";
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.ExecuteNonQuery();
MessageBox.Show("la carte est enregistré. ",
"Mettre a jour une carte", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Mettre a jour la carte", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void deleteDecharge(string iD)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDNaftalCardDecharge", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = iD;
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "DELETE";
cmd.ExecuteNonQuery();
MessageBox.Show("le bon a été supprimer. ",
"Suppression Decharge", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Suppression Decharge", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void createProduct(String DESIGN, String PTYPE, String desc)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDProduct", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DESIGNATION", SqlDbType.NVarChar).Value = DESIGN; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@PTYPE", SqlDbType.NVarChar).Value = PTYPE;
cmd.Parameters.AddWithValue("@DESCR", SqlDbType.NVarChar).Value = desc;
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "INSERT";
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
string formattedTime = DateTime.Now.ToString("yyyy, MM, dd, hh, mm, ss");
cmd.Parameters.AddWithValue("@recordInsertedIn", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.AddWithValue("@recordView", SqlDbType.Bit).Value = true;
cmd.ExecuteNonQuery();
MessageBox.Show("le nouveau produit est enregistré. ",
"Nouveau produit", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Nouveau produit", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void createUser(String username, String password)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDUser", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userName", SqlDbType.NVarChar).Value = username; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@userPass", SqlDbType.NVarChar).Value = password;
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "INSERT";
cmd.ExecuteNonQuery();
MessageBox.Show("le nouveau Utilisateur est enregistré. ",
"Nouveau Utilisateur", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Nouveau Utilisateur", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
//string[] arr = GGAO.Properties.Settings.Default.GGAOConnectionString.Split(';');
public static DataTable getVisibleTransfer()
{
string arr = GGAO.Properties.Settings.Default.GGAOConnectionString
+ "Database=GGAO" + GGAOWindow.getSelectedEXO() + ".mdf;"
+ "User ID=sa;Password=ggaouser;";
DataTable dt = new DataTable();
System.Data.DataSet ds = new DataSet();
try
{
SqlCommand cmd = new SqlCommand("CRUDTransfer", con);
cmd.Parameters.AddWithValue("@choise", SqlDbType.NVarChar).Value = "SELECTALL";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"List des bons Transfer", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
//MessageBox.Show(" DataSet Tables number " + ds.Tables.Count.ToString() + " "+ds.Tables[0].TableName );
return(ds.Tables[0]);
}
public static void UpdateEngine(string ID, String Libelle, String MatriculeIn, String MatriculeNat, string marque, string color, string poleID
, string type, string serie)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDEngine", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = ID;
cmd.Parameters.AddWithValue("@Libelle", SqlDbType.NVarChar).Value = Libelle; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@MatriculeIntern", SqlDbType.NVarChar).Value = MatriculeIn;
cmd.Parameters.AddWithValue("@MatriculeNational", SqlDbType.NVarChar).Value = MatriculeNat;
cmd.Parameters.AddWithValue("@Marque", SqlDbType.NVarChar).Value = marque;
cmd.Parameters.AddWithValue("@Couleur", SqlDbType.NVarChar).Value = color;
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@TYPE", SqlDbType.NVarChar).Value = type;
cmd.Parameters.AddWithValue("@SERIE", SqlDbType.NVarChar).Value = serie;
if (poleID != null)
{
int poleId;
bool parseOps = int.TryParse(poleID, out poleId);
if (!parseOps)
{
poleId = 0;
}
cmd.Parameters.AddWithValue("@PoleID", SqlDbType.Int).Value = poleId;
}
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "UPDATE";
//string formattedTime = DateTime.Now.ToString("yyyy, MM, dd, hh, mm, ss");
//cmd.Parameters.AddWithValue("@recordInsertedIn", SqlDbType.DateTime).Value = DateTime.Now;
//cmd.Parameters.AddWithValue("@recordView", SqlDbType.Bit).Value = true;
cmd.ExecuteNonQuery();
MessageBox.Show("le engine est enregistré. ",
"Mettre a jour un engine", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Mettre a jour un engine", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void UpdateTransfer(string ID, String Ref, String Type, DateTime DocDate, String engineID, String productID, string poleID, string toPoleID,
string driverID, string kilo, string quanity)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDTransfer", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = ID; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Ref", SqlDbType.NVarChar).Value = Ref; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Type", SqlDbType.NVarChar).Value = Type; // this.prenomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Date", SqlDbType.DateTime).Value = DocDate;
cmd.Parameters.AddWithValue("@engineID", SqlDbType.NVarChar).Value = engineID; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@productID", SqlDbType.NVarChar).Value = productID; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@poleID", SqlDbType.NVarChar).Value = poleID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@ToPoleID", SqlDbType.NVarChar).Value = toPoleID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@driverID", SqlDbType.NVarChar).Value = driverID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@kilo", SqlDbType.NVarChar).Value = kilo; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@quant", SqlDbType.NVarChar).Value = quanity; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
//cmd.Parameters.AddWithValue("@print", SqlDbType.Bit).Value = print; // this.mobileTextBox.Text.Trim();
//cmd.Parameters.AddWithValue("@calc", SqlDbType.Bit).Value = calc; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "UPDATE";
cmd.ExecuteNonQuery();
MessageBox.Show("le bon a été enregistré. ",
"Mettre a jour un bon", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Mettre a jour un chaffeure", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void UpdateDriver(string ID, String Nom, String Prenom, String CIN, DateTime DateNaissance, String LieuNaissance, String Mobile)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDDriver", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = ID; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Nom", SqlDbType.NVarChar).Value = Nom; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Prenom", SqlDbType.NVarChar).Value = Prenom; // this.prenomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@CIN", SqlDbType.NVarChar).Value = CIN; // this.cINTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@DateNaissance", SqlDbType.DateTime).Value = DateNaissance;
cmd.Parameters.AddWithValue("@LieuNaissance", SqlDbType.NVarChar).Value = LieuNaissance; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Mobile", SqlDbType.NVarChar).Value = Mobile; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "UPDATE";
//string formattedTime = DateTime.Now.ToString("yyyy, MM, dd, hh, mm, ss");
//cmd.Parameters.AddWithValue("@recordInsertedIn", SqlDbType.DateTime).Value = DateTime.Now;
//cmd.Parameters.AddWithValue("@recordView", SqlDbType.Bit).Value = true;
cmd.ExecuteNonQuery();
MessageBox.Show("le chauffeure est enregistré. ",
"Mettre a jour un chaffeure", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Mettre a jour un chaffeure", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void setTheMainWindow(GGAOWindow obj)
{
Program.myGGAOWindow = obj;
}
public static void updateNaftalCardDecharge(string iD,
string NDocument, string GiverPrsnID, string TakingPrsnID, string EngineID, string NaftalCardID,
DateTime DateMovement, string Descr)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDNaftalCardDecharge", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = iD;
cmd.Parameters.AddWithValue("@Descr", SqlDbType.NVarChar).Value = NDocument;
cmd.Parameters.AddWithValue("@NDocument", SqlDbType.NVarChar).Value = Descr;
cmd.Parameters.AddWithValue("@GiverPrsnID", SqlDbType.NVarChar).Value = GiverPrsnID;
cmd.Parameters.AddWithValue("@TakingPrsnID", SqlDbType.NVarChar).Value = TakingPrsnID;
cmd.Parameters.AddWithValue("@EngineID", SqlDbType.NVarChar).Value = EngineID;
cmd.Parameters.AddWithValue("@NaftalCardID", SqlDbType.NVarChar).Value = NaftalCardID;
cmd.Parameters.AddWithValue("@DateMovement", SqlDbType.DateTime).Value = DateMovement;
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.NVarChar).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "UPDATE";
cmd.ExecuteNonQuery();
MessageBox.Show("la carte est enregistré. ",
"Mettre a jour Decharge", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.Message,
"Mettre a jour Decharge", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static DataTable getVisibleConsommation(string yourChoise, BO.Filtre myfiltre) // int PageNum, DateTime Fromdate, DateTime Todate
{
DataTable dt = new DataTable();
System.Data.DataSet ds = new DataSet();
try
{ if (!ConnectionIsClosed())
{
return(new DataTable());
}
con.Open();
SqlCommand cmd = new SqlCommand("CRUDConsommation", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FromDate", SqlDbType.NVarChar).Value = myfiltre.startDate; //Fromdate.Date ;
cmd.Parameters.AddWithValue("@ToDate", SqlDbType.Date).Value = myfiltre.endDate; //Todate.Date;
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@Ref", SqlDbType.NVarChar).Value = myfiltre.Reference;
cmd.Parameters.AddWithValue("@Type", SqlDbType.NVarChar).Value = myfiltre.Type;
cmd.Parameters.AddWithValue("@kilo", SqlDbType.NVarChar).Value = myfiltre.KLM;
cmd.Parameters.AddWithValue("@quant", SqlDbType.NVarChar).Value = myfiltre.Qte;
if (myfiltre.EngineID != -1)
{
cmd.Parameters.AddWithValue("@EngineID", SqlDbType.Int).Value = myfiltre.EngineID;
}
if (myfiltre.ProductID != -1)
{
cmd.Parameters.AddWithValue("@ProductID", SqlDbType.Int).Value = myfiltre.ProductID;
}
if (myfiltre.SourceID != -1)
{
cmd.Parameters.AddWithValue("@PoleID", SqlDbType.Int).Value = myfiltre.SourceID;
}
if (myfiltre.ImputID != -1)
{
cmd.Parameters.AddWithValue("@PoleImputID", SqlDbType.Int).Value = myfiltre.ImputID;
}
if (myfiltre.DriverID != -1)
{
cmd.Parameters.AddWithValue("@DriverID", SqlDbType.Int).Value = myfiltre.DriverID;
}
cmd.Parameters.AddWithValue("@choice", SqlDbType.Date).Value = yourChoise.ToString();
//cmd.Parameters.AddWithValue("@PageNumber", SqlDbType.Date ).Value = PageNum ; // is not important any more
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds.Tables.Count == 0 || ds.Tables[0] == null || ds.Tables[0].Rows.Count <= 0)
{
MessageBox.Show("Aucune information avec ces critères :\n" +
myfiltre.getActiveCriteria(),
"List des bons Consommation", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"List des bons Consommation", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
//MessageBox.Show(" DataSet Tables number " + ds.Tables.Count.ToString() + " "+ds.Tables[0].TableName );
return(ds.Tables[0]);
}
public static void UpdateConsommation(string ID, String Ref, String Type, DateTime DocDate, String engineID, String productID, string poleID,
string driverID, string PoleImputID, string kilo, string quanity, bool print, bool calc)//, bool print, bool calc
{
try
{
string selectedengineID = getEngineID(ID);
string lastCounter = getLastCounter(selectedengineID, DocDate);
if (checkCounter(lastCounter, kilo))
{
if (!ConnectionIsClosed())
{
return;
}
con.Open();
SqlCommand cmd = new SqlCommand("CRUDConsommation", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", SqlDbType.NVarChar).Value = ID; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Ref", SqlDbType.NVarChar).Value = Ref; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Type", SqlDbType.NVarChar).Value = Type; // this.prenomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Date", SqlDbType.DateTime).Value = DocDate;
cmd.Parameters.AddWithValue("@engineID", SqlDbType.NVarChar).Value = engineID; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@productID", SqlDbType.NVarChar).Value = productID; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@poleID", SqlDbType.NVarChar).Value = poleID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@driverID", SqlDbType.NVarChar).Value = driverID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@PoleImputID", SqlDbType.NVarChar).Value = PoleImputID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@kilo", SqlDbType.NVarChar).Value = kilo; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@quant", SqlDbType.NVarChar).Value = quanity; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@print", SqlDbType.Bit).Value = print; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@calc", SqlDbType.Bit).Value = calc; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "UPDATE";
cmd.ExecuteNonQuery();
MessageBox.Show("le bon a été enregistré. ",
"Mettre a jour un bon", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Mettre a jour un chaffeure", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
public static void createAlimentation(String Ref, String Type, DateTime DocDate, String engineID, String productID, string poleID,
string driverID, string kilo, string quanity)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("CRUDAlimentation", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ref", SqlDbType.NVarChar).Value = Ref; // this.nomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Type", SqlDbType.NVarChar).Value = Type; // this.prenomTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@Date", SqlDbType.DateTime).Value = DocDate;
cmd.Parameters.AddWithValue("@engineID", SqlDbType.NVarChar).Value = engineID; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@productID", SqlDbType.NVarChar).Value = productID; // this.lieuNaissanceTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@poleID", SqlDbType.NVarChar).Value = poleID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@driverID", SqlDbType.NVarChar).Value = driverID; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@kilo", SqlDbType.NVarChar).Value = kilo; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@quant", SqlDbType.NVarChar).Value = quanity; // this.mobileTextBox.Text.Trim();
cmd.Parameters.AddWithValue("@choice", SqlDbType.NVarChar).Value = "INSERT";
cmd.Parameters.AddWithValue("@loginUserId", SqlDbType.Int).Value = GGAOWindow.getCurrentUserID();
cmd.Parameters.AddWithValue("@recordInsertedIn", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.AddWithValue("@recordView", SqlDbType.Bit).Value = true;
cmd.ExecuteNonQuery();
MessageBox.Show("le nouveau bon a été enregistré. ",
"Nouveau Bon", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
catch (Exception exs)
{
MessageBox.Show(exs.ToString(),
"Nouveau Bon", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
finally
{
con.Close();
}
}
