public static void SetDataKeyValue(string dataKeyName, string dataKeyValue)
{
string _connStr = SetConn();
SQLUpdateNugget n = SQLUpdateNugget.GetNuggets("SchemaVersionUpdate").FirstOrDefault();
if (n != null)
{
List <SqlParameter> parms = new List <SqlParameter>();
SqlParameter parmNewVal = new SqlParameter();
parmNewVal.ParameterName = "@DataValue";
parmNewVal.SqlDbType = SqlDbType.VarChar;
parmNewVal.Size = 100;
parmNewVal.Direction = ParameterDirection.Input;
parmNewVal.Value = dataKeyValue;
parms.Add(parmNewVal);
SqlParameter parmKey = new SqlParameter();
parmKey.ParameterName = "@DataKey";
parmKey.SqlDbType = SqlDbType.VarChar;
parmKey.Size = 100;
parmKey.Direction = ParameterDirection.Input;
parmKey.Value = dataKeyName;
parms.Add(parmKey);
ExecuteNonQueryCommands(_connStr, n.SQLQuery, parms);
}
}
public static DataInfo GetDataKeyValue(string dataKeyName)
{
string _connStr = SetConn();
DataInfo d = new DataInfo();
SQLUpdateNugget n = SQLUpdateNugget.GetNuggets("SchemaVersionCheck").FirstOrDefault();
if (n != null)
{
List <SqlParameter> parms = new List <SqlParameter>();
SqlParameter parmKey = new SqlParameter();
parmKey.ParameterName = "@DataKey";
parmKey.SqlDbType = SqlDbType.VarChar;
parmKey.Size = 100;
parmKey.Direction = ParameterDirection.Input;
parmKey.Value = dataKeyName;
parms.Add(parmKey);
DataTable dt = ExecuteDataTableCommands(_connStr, n.SQLQuery, parms);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
d.DataKey = dr["DataKey"].ToString();
d.DataValue = dr["DataValue"].ToString();
}
}
if (d != null && string.IsNullOrEmpty(d.DataValue))
{
d.DataValue = String.Empty;
}
return(d);
}