public void saveRecord(int iEaId, eaRecord eaR)
{
string sqlStr = "Update Emailadres set Ea_StatusId=@2, Ea_DispStatus=@3, Ea_KlBgId=@4, Ea_DispKlBg=@5, " +
"Ea_Emailadres=@6, Ea_Mutatiedatum=@7, Ea_Opmerking=@8 Where Ea_Id=@1;";
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
try
{
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", iEaId);
sqlCmd.Parameters.AddWithValue("@2", eaR.Ea_StatusId);
sqlCmd.Parameters.AddWithValue("@3", eaR.Ea_DispStatus);
sqlCmd.Parameters.AddWithValue("@4", eaR.Ea_KlBgId);
sqlCmd.Parameters.AddWithValue("@5", eaR.Ea_DispKlBg);
sqlCmd.Parameters.AddWithValue("@6", eaR.Ea_Emailadres);
sqlCmd.Parameters.AddWithValue("@7", eaR.Ea_Mutatiedatum);
sqlCmd.Parameters.AddWithValue("@8", eaR.Ea_Opmerking);
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception) { }
dbcDa.Close();
}
}
private void recordsInList(SQLiteDataReader r)
{
eaRecord ear = new eaRecord();
lstSubuitgavesoort.Clear();
eaListCount = 0;
eaListTCount = 0;
while (r.Read())
{
//Maak list van geselecteerde rijen
eaListTCount++;
ear.Ea_Id = r.GetInt32(r.GetOrdinal("Ea_Id"));
ear.Ea_StatusId = r.GetInt32(r.GetOrdinal("Ea_StatusId"));
ear.Ea_DispStatus = r.GetString(r.GetOrdinal("Ea_DispStatus"));
if (r.GetInt32(r.GetOrdinal("Ea_StatusId")) != 200009)
{
eaListCount++;
}
ear.Ea_KlBgId = r.GetInt32(r.GetOrdinal("Ea_KlBgId"));
ear.Ea_DispKlBg = r.GetString(r.GetOrdinal("Ea_DispKlBg"));
ear.Ea_Emailadres = r.GetString(r.GetOrdinal("Ea_Emailadres"));
ear.Ea_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Ea_Mutatiedatum"));
ear.Ea_Opmerking = "";
try
{
ear.Ea_Opmerking = r.GetString(r.GetOrdinal("Ea_Opmerking"));
}
catch (Exception)
{
}
lstSubuitgavesoort.Add(ear);
}
}
public eaRecord vulDefaultEa()
{
pf pf = new pf();
eaRecord eaRec = new eaRecord();
eaRec.Ea_StatusId = 200009;
eaRec.Ea_DispStatus = "Emailadresgegevens zijn leeg / Tabelinitrecord";
eaRec.Ea_KlBgId = 1;
eaRec.Ea_DispKlBg = "Klant-Begunstigde";
eaRec.Ea_Emailadres = "*****@*****.**";
eaRec.Ea_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
eaRec.Ea_Opmerking = "";
return(eaRec);
}
public eaRecord vanRecord(int recNr)
{
eaRecord eaRec = new eaRecord();
eaRec.Ea_Id = lstSubuitgavesoort[recNr].Ea_Id;
eaRec.Ea_StatusId = lstSubuitgavesoort[recNr].Ea_StatusId;
eaRec.Ea_DispStatus = lstSubuitgavesoort[recNr].Ea_DispStatus;
eaRec.Ea_KlBgId = lstSubuitgavesoort[recNr].Ea_KlBgId;
eaRec.Ea_DispKlBg = lstSubuitgavesoort[recNr].Ea_DispKlBg;
eaRec.Ea_Emailadres = lstSubuitgavesoort[recNr].Ea_Emailadres;
eaRec.Ea_Mutatiedatum = lstSubuitgavesoort[recNr].Ea_Mutatiedatum;
eaRec.Ea_Opmerking = lstSubuitgavesoort[recNr].Ea_Opmerking;
return(eaRec);
}
public int newEaRecord()
{
pf pf = new pf();
eaRecord dEa = new eaRecord();
dEa = vulDefaultEa();
int newEaId = new int();
string sCs = "Data Source=" + gv.sDataFilePad + ";Version=3;New=False;";
using (SQLiteConnection dbcDa = new SQLiteConnection(sCs))
{
dbcDa.Open();
string findstring = pf.randomString(6);
string sqlStr = "Insert Into Emailadres (Ea_StatusId, Ea_DispStatus, Ea_KlBgId, Ea_DispKlBg, " +
"Ea_Emailadres, Ea_Mutatiedatum, Ea_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 200009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Emailadrs-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = 1; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Klant-Begunstigde"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "*****@*****.**"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = findstring; sqlCmd.Parameters.Add(p8);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblEa ea = new tblEa();
ea.zoekSubuitgavesoort("Ea_Opmerking = " + "\"" + findstring + "\"");
newEaId = ea.lstSubuitgavesoort[0].Ea_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Emailadres set Ea_Opmerking=@8 where Ea_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newEaId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newEaId);
}
}
