public static System_Setting getTransac_CheckPoint() { Clustering_Users_DAO dao = null; System_Setting transac_check_point = new System_Setting(); try { dao = new Clustering_Users_DAO(); dao.beginTransaction(); List<System_Setting> listSystemSetting = dao.getListSystemSetting(); foreach (var item in listSystemSetting) { if (item.Key.Equals(ConstantValues.SST_TRANSAC_CP)) { item.Values = dao.getListSystemSettingValue(ConstantValues.SST_TRANSAC_CP); return item; } } dao.commitTransaction(); } catch (Exception ex) { dao.rollbackTransaction(); throw ex; } return transac_check_point; }
public void addSystemSetting(System_Setting sst) { string strQuery = "INSERT INTO [RS].[SYSTEM_SETTING_TBL] ([Key] ,[DataType] ,[Description]) VALUES (@Key ,@DataType ,@Description)"; Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters.Add("@Key", sst.Key); parameters.Add("@DataType", sst.DataType); parameters.Add("@Description", sst.Description); executeNonQuery(strQuery, parameters); }
public static void addNewTransacCheckpointKey() { Clustering_Users_DAO dao = null; try { dao = new Clustering_Users_DAO(); dao.beginTransaction(); // Add Key ConstantVariables.SST_TRANSAC_CHECK_POINT System_Setting transac_checkpoint = new System_Setting(); transac_checkpoint.Key = ConstantValues.SST_TRANSAC_CP; transac_checkpoint.DataType = ConstantValues.SST_TRANSAC_CP_TYPE; transac_checkpoint.Description = ConstantValues.SST_TRANSAC_CP_DES; dao.addSystemSetting(transac_checkpoint); dao.commitTransaction(); } catch (Exception ex) { dao.rollbackTransaction(); throw ex; } }
public List<System_Setting> getListSystemSetting() { List<System_Setting> lst = new List<System_Setting>(); Dictionary<string, object> parameters = new Dictionary<string, object>(); SqlDataReader reader = executeReader("SELECT [Key],[DataType],[Description] FROM [RS].[SYSTEM_SETTING_TBL] ", parameters); while (reader.Read()) { System_Setting cs = new System_Setting(); cs.Key = reader.GetString(reader.GetOrdinal("Key")); cs.DataType = reader.GetString(reader.GetOrdinal("DataType")); cs.Description = reader.GetString(reader.GetOrdinal("Description")); lst.Add(cs); } reader.Close(); return lst; }