internal void InsertOrUpdateXls(Entity wd, InsertInfo info)
{
try
{
insertXls.Parameters[0].Value = wd.Utca;
insertXls.Parameters[1].Value = wd.Kategoria;
insertXls.ExecuteNonQuery();
info.InsertCount++;
}
catch (MySqlException me)
{
if (me.Number == 1062)
{
updateXls.Parameters[0].Value = wd.Kategoria;
updateXls.Parameters[1].Value = wd.Fkod;
updateXls.ExecuteNonQuery();
info.UpdateCount++;
}
else
{
throw;
}
}
catch (Exception ex)
{
AppLogger.WriteException(ex, wd.Fkod);
}
}
void cp_FormClosing(object sender, FormClosingEventArgs e)
{
ConvertProgress cp = sender as ConvertProgress;
InsertInfo info = cp.InsertInfo;
for (int a = 0; a < cp.Lines.Count; a += 3)
{
errorGrid.Rows.Add(cp.Lines[a], cp.Lines[a + 1], cp.Lines[a + 2]);
}
errorGrid.Rows.Add("INFO", string.Format("{0} sor a(z) {1} közül sikeresen feldolgozva.", info.UpdateCount + info.InsertCount, info.TotalCount), "");
errorGrid.Rows.Add("INFO", string.Format("{0} sor lett beszúrva.", info.InsertCount), "");
errorGrid.Rows.Add("INFO", string.Format("{0} sor lett frissítve.", info.UpdateCount), "");
}
public void InsertOrUpdateNet(Entity et, InsertInfo info)
{
try
{
insertNet.Parameters[0].Value = et.Fkod;
insertNet.Parameters[1].Value = et.Kategoria;
insertNet.Parameters[2].Value = et.IranyitoSzam;
insertNet.Parameters[3].Value = et.Helyseg;
insertNet.Parameters[4].Value = et.Utca;
insertNet.Parameters[5].Value = et.HazSzam;
try
{
insertNet.ExecuteNonQuery();
info.InsertCount++;
}
catch (MySqlException ins)
{
if (ins.Number == 1062)
{
//már megvolt.
updateNet.Parameters[0].Value = et.Kategoria;
updateNet.Parameters[1].Value = et.IranyitoSzam;
updateNet.Parameters[2].Value = et.Helyseg;
updateNet.Parameters[3].Value = et.Utca;
updateNet.Parameters[4].Value = et.HazSzam;
updateNet.Parameters[5].Value = et.Fkod;
updateNet.ExecuteNonQuery();
info.UpdateCount++;
}
else
{
throw;
}
}
}
catch (Exception ex)
{
AppLogger.WriteException(ex, et.Fkod);
}
}
