public void saveRecord(int iHcId, hcRecord hcR)
{
string sqlStr = "Update Hoofdcategorie (Hcat_StatusId=@2, Hcat_DispStatus=@3, Hcat_Prefix=@4, Hcat_Kort=@5, Hcat_Lang=@6, " +
"Hcat_WijzigentoegestaanJN=@7, Hcat_Mutatiedatum=@8, Hcat_Opmerking=9 Where Hcat_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", iHcId);
sqlCmd.Parameters.AddWithValue("@2", hcR.Hcat_StatusId);
sqlCmd.Parameters.AddWithValue("@3", hcR.Hcat_DispStatus);
sqlCmd.Parameters.AddWithValue("@4", hcR.Hcat_Prefix);
sqlCmd.Parameters.AddWithValue("@5", hcR.Hcat_Kort);
sqlCmd.Parameters.AddWithValue("@6", hcR.Hcat_Lang);
sqlCmd.Parameters.AddWithValue("@7", hcR.Hcat_WijzigentoegestaanJN);
sqlCmd.Parameters.AddWithValue("@8", hcR.Hcat_Mutatiedatum);
sqlCmd.Parameters.AddWithValue("@9", hcR.Hcat_Opmerking);
sqlCmd.ExecuteNonQuery();
}
}
catch (Exception) { }
dbcDa.Close();
}
}
public int newHcRecord()
{
pf pf = new pf();
hcRecord dHc = new hcRecord();
dHc = vulDefaultHc();
int newHcId = 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 Hoofdcategorie (Hcat_StatusId, Hcat_DispStatus, Hcat_Prefix, Hcat_Kort, Hcat_Lang, " +
"Hcat_WijzigentoegestaanJN, Hcat_Mutatiedatum, Hcat_Opmerking) Values " +
"(@2, @3, @4, @5, @6, @7, @8, @9)";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
SQLiteParameter p2 = new SQLiteParameter(); p2.ParameterName = "@2"; p2.Value = 195009; sqlCmd.Parameters.Add(p2);
SQLiteParameter p3 = new SQLiteParameter(); p3.ParameterName = "@3"; p3.Value = "Hcat-record is zijn leeg / Tabelinitrecord"; sqlCmd.Parameters.Add(p3);
SQLiteParameter p4 = new SQLiteParameter(); p4.ParameterName = "@4"; p4.Value = "PFX"; sqlCmd.Parameters.Add(p4);
SQLiteParameter p5 = new SQLiteParameter(); p5.ParameterName = "@5"; p5.Value = "Hcat_kort"; sqlCmd.Parameters.Add(p5);
SQLiteParameter p6 = new SQLiteParameter(); p6.ParameterName = "@6"; p6.Value = "Hcat_lang"; sqlCmd.Parameters.Add(p6);
SQLiteParameter p7 = new SQLiteParameter(); p7.ParameterName = "@7"; p7.Value = 1; sqlCmd.Parameters.Add(p7);
SQLiteParameter p8 = new SQLiteParameter(); p8.ParameterName = "@8"; p8.Value = DateTime.Parse("2000-01-01 00:00:00"); sqlCmd.Parameters.Add(p8);
SQLiteParameter p9 = new SQLiteParameter(); p9.ParameterName = "@9"; p9.Value = findstring; sqlCmd.Parameters.Add(p9);
sqlCmd.ExecuteNonQuery();
dbcDa.Close();
}
// Zoek toegevoegde record
tblHc hc = new tblHc();
hc.zoekHoofdcategorieRecord("Hcat_Opmerking = " + "\"" + findstring + "\"");
newHcId = hc.lstHoofdcategorieRecord[0].Hcat_Id;
// Verwijder infor uit Opmerking-veld
dbcDa.Open();
sqlStr = "Update Hoofdcategorie set Hcat_Opmerking=@8 where Hcat_Id = @1;";
using (SQLiteCommand sqlCmd = new SQLiteCommand(sqlStr, dbcDa))
{
sqlCmd.Parameters.AddWithValue("@1", newHcId);
sqlCmd.Parameters.AddWithValue("@8", "");
sqlCmd.ExecuteNonQuery();
}
dbcDa.Close();
return(newHcId);
}
}
public hcRecord vanRecord(int recNr)
{
hcRecord hcRec = new hcRecord();
hcRec.Hcat_Id = lstHoofdcategorieRecord[recNr].Hcat_Id;
hcRec.Hcat_StatusId = lstHoofdcategorieRecord[recNr].Hcat_StatusId;
hcRec.Hcat_DispStatus = lstHoofdcategorieRecord[recNr].Hcat_DispStatus;
hcRec.Hcat_Prefix = lstHoofdcategorieRecord[recNr].Hcat_Prefix;
hcRec.Hcat_Kort = lstHoofdcategorieRecord[recNr].Hcat_Kort;
hcRec.Hcat_Lang = lstHoofdcategorieRecord[recNr].Hcat_Lang;
hcRec.Hcat_WijzigentoegestaanJN = lstHoofdcategorieRecord[recNr].Hcat_WijzigentoegestaanJN;
hcRec.Hcat_Mutatiedatum = lstHoofdcategorieRecord[recNr].Hcat_Mutatiedatum;
hcRec.Hcat_Opmerking = lstHoofdcategorieRecord[recNr].Hcat_Opmerking;
return(hcRec);
}
public hcRecord vulDefaultHc()
{
pf pf = new pf();
hcRecord hcRec = new hcRecord();
hcRec.Hcat_StatusId = 195009;
hcRec.Hcat_DispStatus = "Hcat-record is leeg / Tabel-initrecord";
hcRec.Hcat_Prefix = "PFX";
hcRec.Hcat_Kort = "Hcat_kort";
hcRec.Hcat_Lang = "Hcat_lang";
hcRec.Hcat_WijzigentoegestaanJN = 1;
hcRec.Hcat_Mutatiedatum = DateTime.Parse("2000-01-01 00:00:00");
hcRec.Hcat_Opmerking = "";
return(hcRec);
}
private void recordsInList(SQLiteDataReader r)
{
hcRecord hcr = new hcRecord();
lstHoofdcategorieRecord.Clear();
hcListCount = 0;
hcListTCount = 0;
while (r.Read())
{
//Maak list van geselecteerde rijen
hcListTCount++;
hcr.Hcat_Id = r.GetInt32(r.GetOrdinal("Hcat_Id"));
hcr.Hcat_StatusId = r.GetInt32(r.GetOrdinal("Hcat_StatusId"));
hcr.Hcat_DispStatus = r.GetString(r.GetOrdinal("Hcat_DispStatus"));
if (r.GetInt32(r.GetOrdinal("Hcat_StatusId")) != 195009)
{
hcListCount++;
}
hcr.Hcat_Prefix = r.GetString(r.GetOrdinal("Hcat_Prefix"));
hcr.Hcat_Kort = r.GetString(r.GetOrdinal("Hcat_Kort"));
hcr.Hcat_Lang = r.GetString(r.GetOrdinal("Hcat_Lang"));
hcr.Hcat_WijzigentoegestaanJN = r.GetInt32(r.GetOrdinal("Hcat_WijzigentoegestaanJN"));
hcr.Hcat_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Hcat_Mutatiedatum"));
hcr.Hcat_Opmerking = "";
try
{
hcr.Hcat_Opmerking = r.GetString(r.GetOrdinal("Hcat_Opmerking"));
}
catch (Exception)
{
}
lstHoofdcategorieRecord.Add(hcr);
}
}
