public int updatefct(Commande obj, int fct)
{
int res = 0;
try
{
SqlConnection cnx = Connexion.GetConnection();
TableDAO daot = new TableDAO();
if (daot.checkIfEmpty(obj.NumTable))
{
SqlCommand cmd = new SqlCommand("UPDATE Commande SET idFacture=@fct where IdCommande=@idc", cnx);
cmd.Parameters.AddWithValue("fct", fct);
cmd.Parameters.AddWithValue("idc", obj.IdCommande);
int done = (int)cmd.ExecuteNonQuery();
if (done > 0)
{
res = 1;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally { Connexion.closeConnection(); }
return(res);
}
public int updateCommande(Commande obj, int id)
{
int res = 0;
SqlDataReader reader;
int numtableold = 0;
try
{
SqlConnection cnx = Connexion.GetConnection();
TableDAO daot = new TableDAO();
if (daot.checkIfEmpty(id))
{
SqlCommand getOldTable = new SqlCommand("SELECT NumTable From Commande where IdCommande=@idc", cnx);
getOldTable.Parameters.AddWithValue("idc", id);
reader = getOldTable.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
numtableold = reader.GetInt32(0);
}
}
reader.Close();
SqlCommand updatOldTable = new SqlCommand("UPDATE Tables SET Etat=@etat1 where NumTable=@ntb", cnx);
updatOldTable.Parameters.AddWithValue("ntb", numtableold);
updatOldTable.Parameters.AddWithValue("etat1", false);
int executeQ = (int)updatOldTable.ExecuteScalar();
SqlCommand cmd = new SqlCommand("UPDATE Commande SET NumTable=@numtb,datecommande=@dtc,IdServeur=@nomserv where IdCommande=@idc", cnx);
SqlCommand UpdateTable = new SqlCommand("UPDATE Tables SET Etat=@etat2 where NumTable=@idt", cnx);
UpdateTable.Parameters.AddWithValue("idt", obj.NumTable);
UpdateTable.Parameters.AddWithValue("etat2", true);
cmd.Parameters.AddWithValue("numtb", obj.IdCommande);
cmd.Parameters.AddWithValue("dtc", obj.datecommande);
// cmd.Parameters.AddWithValue("idartc", obj.IdArticle);
cmd.Parameters.AddWithValue("nomserv", obj.idserveur);
cmd.Parameters.AddWithValue("idc", id);
int done1 = (int)UpdateTable.ExecuteNonQuery();
int done = (int)cmd.ExecuteNonQuery();
if (done > 0 && done1 > 0)
{
res = 1;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally { Connexion.closeConnection(); }
return(res);
}
public int update(Commande obj)
{
int res = 0;
try
{
SqlConnection cnx = Connexion.GetConnection();
TableDAO daot = new TableDAO();
if (daot.checkIfEmpty(obj.NumTable))
{
SqlCommand getOldTable = new SqlCommand("SELECT NumTable From Commande where idCommande=@idc", cnx);
getOldTable.Parameters.AddWithValue("idc", obj.IdCommande);
int numtableold = (int)getOldTable.ExecuteScalar();
SqlCommand updatOldTable = new SqlCommand("UPDATE Tables SET Etat=False where NumTable=@ntb", cnx);
updatOldTable.Parameters.AddWithValue("ntb", numtableold);
int executeQ = (int)updatOldTable.ExecuteScalar();
SqlCommand cmd = new SqlCommand("UPDATE Commande SET NumTable=@numtb,datecommande=@dtc,IdServeur=@nomserv where IdCommande=@idc", cnx);
SqlCommand UpdateTable = new SqlCommand("UPDATE Tables SET Etat=True where NumTable=@idt", cnx);
UpdateTable.Parameters.AddWithValue("idt", obj.NumTable);
cmd.Parameters.AddWithValue("numtb", obj.IdCommande);
cmd.Parameters.AddWithValue("dtc", obj.datecommande);
// cmd.Parameters.AddWithValue("idartc", obj.IdArticle);
cmd.Parameters.AddWithValue("nomserv", obj.idserveur);
cmd.Parameters.AddWithValue("idc", obj.IdCommande);
int done1 = (int)UpdateTable.ExecuteNonQuery();
int done = (int)cmd.ExecuteNonQuery();
if (done > 0 && done1 > 0)
{
res = 1;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally { Connexion.closeConnection(); }
return(res);
}