public static void SetValues(ParamCodes uc, Object val)
{
SqlConnection sc = new SqlConnection(DEFS.ConSTR);
sc.Open();
string search_obj = uc.ToString();
string field_name = "";
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandType = CommandType.Text;
switch (GetType(uc))
{
case ParamTypes.egesz:
field_name = "PARAM_VALUE_I";
break;
case ParamTypes.szoveg:
field_name = "PARAM_VALUE_S";
break;
case ParamTypes.tizedes:
field_name = "PARAM_VALUE_F";
break;
case ParamTypes.image:
field_name = "PARAM_VALUE_IMAGE";
break;
default:
field_name = "";
break;
}
if (field_name != "")
{
string sql_str = "IF EXISTS(select '' from syspar where PARAM_NAME = '" + search_obj + "') BEGIN " +
" UPDATE SYSPAR SET " + field_name + " = '" + val.ToString() + "' WHERE PARAM_NAME = '" + search_obj + "' " +
" end else begin INSERT INTO syspar (PARAM_NAME, " + field_name + ") VALUES ('" + search_obj + "' ,'" + val.ToString() + "') END ";
cmd.CommandText = sql_str;
cmd.ExecuteNonQuery();
sc.Close();
}
}
public static Object GetValue(ParamCodes c)
{
Object ret_obj = null;
string search_obj = c.ToString();
string field_name = "";
SqlConnection sc = new SqlConnection(DEFS.ConSTR);
sc.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandType = CommandType.Text;
switch (GetType(c))
{
case ParamTypes.egesz:
field_name = "PARAM_VALUE_I";
break;
case ParamTypes.szoveg:
field_name = "PARAM_VALUE_S";
break;
case ParamTypes.tizedes:
field_name= "PARAM_VALUE_F";
break;
case ParamTypes.image:
field_name = "PARAM_VALUE_IMAGE";
break;
default:
field_name = "";
break;
}
if (field_name != "")
{
cmd.CommandText = "select " + field_name + " as VALUE from syspar where PARAM_NAME = '" + search_obj + "'";
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
ret_obj = rdr["VALUE"];
}
sc.Close();
if (ret_obj == null) { return (Object)(""); }
else
{
return (Object)(ret_obj);
}
}
else
{
return ("");
}
}