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;
}
}
