public static CRecords get_LastDataRecords(String sCategory, int iNumberOfRecord) { CRecords myRecs = new CRecords(); CRecords retRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } if (myRecs.Count <= iNumberOfRecord) { for (int i = myRecs.Count - 1; i >= 0; i--) { retRecs.Add(myRecs.Record(i)); } } else { for (int j = myRecs.Count - 1; j >= myRecs.Count - iNumberOfRecord; j--) { retRecs.Add(myRecs.Record(j)); } } return(retRecs); }
public static void save_DataRecord(String sCategory, CRecord saveRecord) { saveRecord.Controlfields.Controlfield("005").Value = DateTime.Now.ToLongDateString(); CRecords myRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } CControlfield Cf = new CControlfield(); String sID = "0"; if (saveRecord.Controlfields.get_Controlfield("001", ref Cf)) { if (Cf.Value == "") { Cf.Value = "0"; } sID = Cf.Value; } else { Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = "0"; saveRecord.Controlfields.Add(Cf); } myRecs.Filter("001", sID, true); if (myRecs.Count > 0) { CRecord ptOldRec = myRecs.Record(0); myRecs.Replace(ref ptOldRec, ref saveRecord); } else { myRecs.Add(saveRecord); } myRecs.Save(dataFileName); }
public static int add_DataRecord(String sCategory, CRecord addRecord) { addRecord.Controlfields.Controlfield("005").Value = DateTime.Now.ToLongDateString(); CRecords myRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } int iID = 0; myRecs.Filter("001", iID.ToString(), true); while (myRecs.Count > 0) { iID++; myRecs.Refresh(); myRecs.Filter("001", iID.ToString(), true); } CControlfield Cf = new CControlfield(); if (addRecord.Controlfields.get_Controlfield("001", ref Cf)) { Cf.Value = iID.ToString(); } else { Cf = new CControlfield(); Cf.Tag = "001"; Cf.Value = iID.ToString(); addRecord.Controlfields.Add(Cf); } myRecs.Add(addRecord); myRecs.Save(dataFileName); myRecs.Refresh(); return(iID); }
public static void increase_DownloadCount(String sCategory, int iIndex) { CRecords myRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } if (iIndex < myRecs.Count) { CRecord myRec = myRecs.Record(iIndex); myRec.Datafields.Datafield("245").Subfields.Subfield("n").Value = (int.Parse("0" + myRec.Datafields.Datafield("245").Subfields.Subfield("n").Value) + 1).ToString(); } myRecs.Save(dataFileName); }
public static void delete_DataRecord(String sCategory, string sID) { CRecords myRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } myRecs.Filter("001", sID, true); if (myRecs.Count > 0) { myRecs.Remove(0); } myRecs.Save(dataFileName); }
public static CRecord get_DataRecord(String sCategory, string sID) { CRecords myRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } if (myRecs.Count > 0) { switch (sID.ToLower()) { case "first": return(myRecs.Record(0)); break; case "last": return(myRecs.Record(myRecs.Count - 1)); break; default: int iID = int.Parse("0" + sID); myRecs.Filter("001", sID, true); if (myRecs.Count > 0) { return(myRecs.Record(0)); } else { CRecord myRec = new CRecord(); myRec.load_File(FileTemplateDataProvider.get_WorkformTemplateFile(sCategory)); return(myRec); } break; } } else { CRecord myRec1 = new CRecord(); myRec1.load_File(FileTemplateDataProvider.get_WorkformTemplateFile(sCategory)); return(myRec1); } }
public static CRecords get_DataRecords(String sCategory) { CRecords myRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); } else { myRecs.Save(dataFileName); } return(myRecs); }
public static CRecords get_DataRecords(String sCategory, String sSubCategory) { CRecords myRecs = new CRecords(); CRecords retRecs = new CRecords(); String dataFileName = System.Configuration.ConfigurationManager.AppSettings["LegoWebFilesPhysicalPath"].ToString() + "File/Data/" + System.Threading.Thread.CurrentThread.CurrentCulture.TwoLetterISOLanguageName + "\\" + sCategory + ".xml"; if (File.Exists(dataFileName)) { myRecs.load_File(dataFileName); myRecs.Filter("003", sCategory + "." + sSubCategory, true); for (int i = myRecs.Count; i < myRecs.Count; i++) { retRecs.Add(myRecs.Record(i)); } } else { myRecs.Save(dataFileName); } return(retRecs); }