public int newIlRecord()
{
pf pf = new pf();
ilRecord dIl = new ilRecord();
dIl = vulDefaultIl();
int newIlId = 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 Instellingen (Instl_Systeemsetting, Instl_StatusId, Instl_DispStatus, Instl_Naam, Instl_Gegtype, " +
"Instl_Actief, Instl_String, Instl_JN, Instl_Integer, Instl_Real, Instl_Memo, Instl_Datum, Instl_Tijd" +
"Instl_Mutatiedatum, Instl_Opmerking) Values (@2, @3, @4, @5, @6, @7, @8, @9, @10, @11, @12, @13, @14, @15, @16)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 0; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = 195009; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "Instl-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Instelling"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = 0; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 0; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = ""; sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = 0; sqlCmd.Parameters.Add(p9);
SQLiteParameter p10 = new SQLiteParameter(); p10.ParameterName = "@10"; p10.Value = 0; sqlCmd.Parameters.Add(p10);
SQLiteParameter p11 = new SQLiteParameter(); p11.ParameterName = "@11"; p5.Value = 0; sqlCmd.Parameters.Add(p11);
SQLiteParameter p12 = new SQLiteParameter(); p12.ParameterName = "@12"; p6.Value = ""; sqlCmd.Parameters.Add(p12);
SQLiteParameter p13 = new SQLiteParameter(); p13.ParameterName = "@13"; p7.Value = DateTime.Parse("2000-01-01 00:00:00");; sqlCmd.Parameters.Add(p13);
SQLiteParameter p14 = new SQLiteParameter(); p14.ParameterName = "@14"; p8.Value = DateTime.Parse("2000-01-01 00:00:00");; sqlCmd.Parameters.Add(p14);
SQLiteParameter p15 = new SQLiteParameter(); p15.ParameterName = "@15"; p9.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p15);
SQLiteParameter p16 = new SQLiteParameter(); p16.ParameterName = "@10"; p10.Value = findstring; sqlCmd.Parameters.Add(p16);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblIl il = new tblIl();
il.zoekInstellingenRecord("Instl_Opmerking = " + "\"" + findstring + "\"");
newIlId = il.lstInstellingenRecord[0].Instl_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Instellingen set Instl_Opmerking=@8 where Instl_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newIlId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newIlId);
}
}
public ilRecord vanRecord(int recNr)
{
ilRecord ilRec = new ilRecord();
ilRec.Instl_Id = lstInstellingenRecord[recNr].Instl_Id;
ilRec.Instl_Systeemsetting = lstInstellingenRecord[recNr].Instl_Systeemsetting;
ilRec.Instl_StatusId = lstInstellingenRecord[recNr].Instl_StatusId;
ilRec.Instl_DispStatus = lstInstellingenRecord[recNr].Instl_DispStatus;
ilRec.Instl_Naam = lstInstellingenRecord[recNr].Instl_Naam;
ilRec.Instl_Gegtype = lstInstellingenRecord[recNr].Instl_Gegtype;
ilRec.Instl_Actief = lstInstellingenRecord[recNr].Instl_Actief;
ilRec.Instl_String = lstInstellingenRecord[recNr].Instl_String;
ilRec.Instl_JN = lstInstellingenRecord[recNr].Instl_JN;
ilRec.Instl_Integer = lstInstellingenRecord[recNr].Instl_Integer;
ilRec.Instl_Real = lstInstellingenRecord[recNr].Instl_Real;
ilRec.Instl_Memo = lstInstellingenRecord[recNr].Instl_Memo;
ilRec.Instl_Datum = lstInstellingenRecord[recNr].Instl_Datum;
ilRec.Instl_Tijd = lstInstellingenRecord[recNr].Instl_Tijd;
ilRec.Instl_Mutatiedatum = lstInstellingenRecord[recNr].Instl_Mutatiedatum;
return(ilRec);
}
public void saveRecord(int iIlId, ilRecord ilR)
{
string sqlStr = "Update Instellingen (Instl_Systeemsetting=@2, Instl_StatusId=@3, Instl_DispStatus=@4, Instl_Naam=@5, " +
"Instl_Gegtype=@6, Instl_Actief=@7, Instl_String=@8, Instl_JN=@9, Instl_Integer=@10, Instl_Real=@11, " +
"Instl_Memo=@12, Instl_Datum=@13, Instl_Tijd=@14, Instl_Mutatiedatum=@15, Instl_Opmerking=@15 Where Instl_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", iIlId);
sqlCmd.Parameters.AddWithValue("@2", ilR.Instl_Systeemsetting);
sqlCmd.Parameters.AddWithValue("@3", ilR.Instl_StatusId);
sqlCmd.Parameters.AddWithValue("@4", ilR.Instl_DispStatus);
sqlCmd.Parameters.AddWithValue("@5", ilR.Instl_Naam);
sqlCmd.Parameters.AddWithValue("@6", ilR.Instl_Gegtype);
sqlCmd.Parameters.AddWithValue("@7", ilR.Instl_Actief);
sqlCmd.Parameters.AddWithValue("@8", ilR.Instl_String);
sqlCmd.Parameters.AddWithValue("@9", ilR.Instl_JN);
sqlCmd.Parameters.AddWithValue("@10", ilR.Instl_Integer);
sqlCmd.Parameters.AddWithValue("@11", ilR.Instl_Real);
sqlCmd.Parameters.AddWithValue("@12", ilR.Instl_Memo);
sqlCmd.Parameters.AddWithValue("@13", ilR.Instl_Datum);
sqlCmd.Parameters.AddWithValue("@14", ilR.Instl_Tijd);
sqlCmd.Parameters.AddWithValue("@15", ilR.Instl_Mutatiedatum);
sqlCmd.Parameters.AddWithValue("@16", ilR.Instl_Opmerking);
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception) { }
dbcDa.Close();
}
}
public ilRecord vulDefaultIl()
{
pf pf = new pf();
ilRecord ilRec = new ilRecord();
ilRec.Instl_Systeemsetting = 0;
ilRec.Instl_StatusId = 185009;
ilRec.Instl_DispStatus = "Instl-record is leeg / Tabl-initrecord";
ilRec.Instl_Naam = "Instelling";
ilRec.Instl_Gegtype = 0;
ilRec.Instl_Actief = 0;
ilRec.Instl_String = "";
ilRec.Instl_JN = 0;
ilRec.Instl_Integer = 0;
ilRec.Instl_Real = 0;
ilRec.Instl_Memo = "";
ilRec.Instl_Datum = DateTime.Parse("2000-01-01 00:00:00");
ilRec.Instl_Tijd = DateTime.Parse("2000-01-01 00:00:00");
ilRec.Instl_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
ilRec.Instl_Opmerking = "";
return(ilRec);
}
private void recordsInList(SQLiteDataReader r)
{
ilRecord ilr = new ilRecord();
lstInstellingenRecord.Clear();
while (r.Read())
{
//Maak list van geselecteerde rijen
ilListTCount++;
ilr.Instl_Id = r.GetInt32(r.GetOrdinal("Instl_Id"));
ilr.Instl_Systeemsetting = r.GetInt32(r.GetOrdinal("Instl_Systeemsetting"));
ilr.Instl_StatusId = r.GetInt32(r.GetOrdinal("Instl_StatusId"));
ilr.Instl_DispStatus = r.GetString(r.GetOrdinal("Instl_DispStatus"));
if (r.GetInt32(r.GetOrdinal("Instl_StatusId")) != 185009)
{
ilListCount++;
}
ilr.Instl_Naam = r.GetString(r.GetOrdinal("Instl_Naam"));
ilr.Instl_Gegtype = r.GetByte(r.GetOrdinal("Instl_Gegtype"));
ilr.Instl_Actief = r.GetInt32(r.GetOrdinal("Instl_Actief"));
ilr.Instl_String = r.GetString(r.GetOrdinal("Instl_String"));
ilr.Instl_JN = r.GetInt32(r.GetOrdinal("Instl_JN"));
ilr.Instl_Integer = r.GetInt64(r.GetOrdinal("Instl_Integer"));
ilr.Instl_Real = r.GetDecimal(r.GetOrdinal("Instl_Real"));
ilr.Instl_Memo = r.GetString(r.GetOrdinal("Instl_Memo"));
ilr.Instl_Datum = r.GetDateTime(r.GetOrdinal("Instl_Datum"));
ilr.Instl_Tijd = r.GetDateTime(r.GetOrdinal("Instl_Tijd"));
ilr.Instl_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Instl_Mutatiedatum"));
try
{
ilr.Instl_Opmerking = r.GetString(r.GetOrdinal("Instl_Opmerking"));
}
catch (Exception)
{
}
lstInstellingenRecord.Add(ilr);
}
}
