internal int AddProduit(NonAddresseS2 nonAddresseS)
{
List <NonAddresseS2> roles = conn.Table <NonAddresseS2>().Where(x => x.Ean == nonAddresseS.Ean).ToList();
if (roles.Count == 0)
{
conn.Insert(nonAddresseS);
Console.WriteLine("ajouter" + nonAddresseS.Lib);
return(1);
}
else if (!roles[0].Equals(nonAddresseS))
{
if (!p.TGs.Appartient(nonAddresseS))
{
Console.WriteLine("Modifié" + nonAddresseS.Lib);
conn.Update(nonAddresseS);
return(2);
}
else
{
Console.WriteLine("TG" + nonAddresseS.Lib);
return(3);
}
}
else
{
Console.WriteLine("ignoré" + nonAddresseS.Lib);
return(0);
}
}
public bool Appartient(NonAddresseS2 na)
{
foreach (Doubleint doubleint in emplacement)
{
if (doubleint.Equal(new Doubleint(na.Alle, na.Trave)))
{
return(true);
}
}
return(false);
}
//undone ?
/// <summary>
///
/// </summary>
/// <param name="fileName"></param>
public void GetExcelFile(string fileName)
{
var bdd = Bdd.Instance();
// _list = new List<NonAddresseS2>();
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(@fileName);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
xlApp.Visible = true;
xlApp.AutomationSecurity = Microsoft.Office.Core.MsoAutomationSecurity.msoAutomationSecurityByUI;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
for (int i = 2; i <= rowCount; i++)
{
NonAddresseS2 art = new NonAddresseS2();
for (int j = 1; j <= colCount; j++)
{
switch (j)
{
case 3:
art.Ean = xlRange.Cells[i, j].Value2.ToString();
break;
case 4:
art.Lib = xlRange.Cells[i, j].Value2.ToString();
break;
case 9:
art.Alle = xlRange.Cells[i, j].Value2.ToString();
break;
case 10:
art.Trave = xlRange.Cells[i, j].Value2.ToString();
break;
}
}
bdd.AddProduit(art);
}
GC.Collect();
GC.WaitForPendingFinalizers();
Marshal.ReleaseComObject(xlRange);
Marshal.ReleaseComObject(xlWorksheet);
xlWorkbook.Close();
Marshal.ReleaseComObject(xlWorkbook);
Marshal.ReleaseComObject(xlApp);
/* foreach (NonAddresseS2 nonAddresseS in _list)
* {
* bdd.AddProduit(nonAddresseS);
* }
*/
}
//undone that
/*
* /// <summary>
* ///
* /// </summary>
* private List<NonAddresseS2> _list;
*/
//TODO TEST
/// <summary>
/// /!\ Sur les produits /!\
/// Permet de lire une string pour la decouper et demande de rajouter le produit addressé dans la base
/// (voir la classe bdd)
/// </summary>
/// <param name="text"></param>
public void ReadCp(string text)
{
var bdd = Bdd.Instance();
// _list = new List<NonAddresseS2>();
string str = text;
str = str.Replace('\r', ' ');
string[] vs = str.Split('\n');
Parameters p = Parameters.Instance();
for (int i = 1; i < vs.Length; i++)
{
try
{
string line = vs[i];
string[] item = line.Split('\t');
NonAddresseS2 art = new NonAddresseS2
{
Lib = item[p.prod.LIB - 1], //3];
Ean = long.Parse(item[p.prod.EAN - 1]), //4]);
Alle = int.Parse(item[p.prod.Alle - 1]), //9]);
Trave = int.Parse(item[p.prod.Trave - 1]) //10]);
};
// _list.Add(art);
bdd.AddProduit(art);
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
}
/*
* foreach (NonAddresseS2 nonAddresseS in _list)
* {
* bdd.AddProduit(nonAddresseS);
*
* Console.WriteLine("ok");
* }*/
}
public void blal(string text)
{
//var tlna = new ToutLesNonA();
//tlna.ReadCp("");
var bdd = Bdd.Instance();
// _list = new List<NonAddresseS2>();
string str = text;
str = str.Replace('\r', ' ');
string[] vs = str.Split('\n');
this._nbaTraiter = vs.Length;
this.progressb.Maximum = vs.Length;
Parameters p = Parameters.Instance();
for (int i = 1; i < vs.Length; i++)
{
try
{
string line = vs[i];
string[] item = line.Split('\t');
NonAddresseS2 art = new NonAddresseS2
{
Lib = item[p.prod.LIB - 1], //3];
Ean = long.Parse(item[p.prod.EAN - 1]), //4]);
Alle = int.Parse(item[p.prod.Alle - 1]), //9]);
Trave = int.Parse(item[p.prod.Trave - 1]) //10]);
};
// _list.Add(art);
Maj(bdd.AddProduit(art));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
}
