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); } }