public bool AddEan(Managers.Producte prod, Managers.CodiEan ean, out bool product_not_added)
{
bool ret = false;
product_not_added = false;
if (prod != null && ean != null)
{
Managers.DBManager.Instance.OpenConexion(connection);
string command4 = "DELETE FROM F_EAN WHERE EANEAN ='" + ean.codi_ean + "'";
OleDbCommand Cmd4 = new OleDbCommand(command4, connection);
ret = Managers.DBManager.Instance.ExecuteQuery(connection, Cmd4);
bool has_product = false;
bool add_product = false;
if (ret)
{
string check_product_text = "SELECT * FROM F_ART WHERE CODART ='" + prod.codi_article + "'";
OleDbCommand CheckCmd2 = new OleDbCommand(check_product_text, connection);
OleDbDataReader CheckData2 = Managers.DBManager.Instance.ExecuteReader(connection, CheckCmd2);
if (CheckData2 != null)
{
if (CheckData2.Read())
{
has_product = true;
}
CheckData2.Close();
ret = true;
}
}
if (!has_product)
{
add_eans_timer.Stop();
string message = "El producte amb codi: " + prod.codi_article + " no està a la base de dades, vol incloure'l?";
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show(string.Format(message), "Conflicte", System.Windows.MessageBoxButton.YesNoCancel, System.Windows.MessageBoxImage.Warning);
add_eans_timer.Start();
if (messageBoxResult == MessageBoxResult.Yes)
{
add_product = true;
}
else if (messageBoxResult == MessageBoxResult.Cancel)
{
ret = false;
}
else
{
product_not_added = true;
}
if (add_product)
{
ret = AddProducte(prod);
has_product = true;
}
}
if (ret && has_product)
{
string command = "INSERT INTO F_EAN(";
command += "[ARTEAN]";
command += ", [EANEAN]";
command += ")VALUES(";
command += "@ARTEAN";
command += ", @EANEAN";
command += ")";
OleDbCommand Cmd = new OleDbCommand(command, connection);
Cmd.Parameters.Add("@ARTEAN", OleDbType.VarChar, 13).Value = ean.codi_article;
Cmd.Parameters.Add("@EANEAN", OleDbType.VarChar, 50).Value = ean.codi_ean;;
ret = Managers.DBManager.Instance.ExecuteQuery(connection, Cmd);
}
}
return(ret);
}
public bool AddEan(Managers.CodiEan curr_ean)
{
bool ret = true;
if (connection != null)
{
Managers.DBManager.Instance.OpenConexion(connection);
string check_command_text = "SELECT * FROM BarresMagsa WHERE Barres ='" + curr_ean.codi_ean + "' " +
"AND Codi = '" + curr_ean.codi_article + "'";
OleDbCommand CheckCmd = new OleDbCommand(check_command_text, connection);
OleDbDataReader CheckData = Managers.DBManager.Instance.ExecuteReader(connection, CheckCmd);
bool already_exists = false;
if (CheckData != null)
{
if (CheckData.Read())
{
already_exists = true;
}
CheckData.Close();
ret = true;
}
if (ret && already_exists)
{
string command4 = "DELETE FROM BarresMagsa WHERE Barres ='" + curr_ean.codi_ean + "' " +
"AND Codi = '" + curr_ean.codi_article + "'";
OleDbCommand Cmd4 = new OleDbCommand(command4, connection);
ret = Managers.DBManager.Instance.ExecuteQuery(connection, Cmd4);
}
if (ret)
{
string command = "INSERT INTO BarresMagsa(";
command += "[Linia]";
command += ", [Codi]";
command += ", [Barres]";
command += ")VALUES(";
command += "@Linia";
command += ", @Codi";
command += ", @Barres";
command += ")";
OleDbCommand Cmd = new OleDbCommand(command, connection);
Cmd.Parameters.Add("@Linia", OleDbType.VarChar, 1).Value = "E";
Cmd.Parameters.Add("@Codi", OleDbType.VarChar, 6).Value = curr_ean.codi_article;
Cmd.Parameters.Add("@Barres", OleDbType.VarChar, 13).Value = curr_ean.codi_ean;
ret = Managers.DBManager.Instance.ExecuteQuery(connection, Cmd);
}
}
return(ret);
}
