public Dictionary<string, SystemParameter> GetSystemParameters(ref string errMessage) { Database db = DatabaseFactory.CreateDatabase(); var list = new Dictionary<string, SystemParameter>(); errMessage = ""; try { DataSet ds = SystemParametersDataAccess.GetSystemParameters(db); SystemParameter systemParameter; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { systemParameter = new SystemParameter(ds.Tables[0].Rows[i]); list.Add(systemParameter.Name, systemParameter); } _listSystemParameter = list; return list; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); _listSystemParameter = null; return null; } }
public static int UpdateParameter(Database db, SystemParameter systemParameter) { StringBuilder sb = new StringBuilder(); if (IsExistRow(db, systemParameter.Name)) { sb.Append("update systemParameter set"); sb.AppendFormat(" Value='{0}',Type='{1}' where Name='{2}'", systemParameter.Name, systemParameter.Type,systemParameter.Value); } else { sb.Append("insert into systemParameter(name,type,value) "); sb.AppendFormat("values('{0}','{1}','{2}')", systemParameter.Name, systemParameter.Type, systemParameter.Value); } string cmdText = sb.ToString(); try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public int UpdateParameter(ref string errMessage, SystemParameter systemParameter) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { int ret = SystemParametersDataAccess.UpdateParameter(db, systemParameter); GetSystemParameters(ref errMessage); return ret; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return -1; } }