public Parameter(DataSetParameters dsp, object value)
{
this.name = dsp.name.Trim();
switch ((type_tag)dsp.type)
{
case type_tag.DATETIME: this.type = DbType.DateTime; break;
case type_tag.INT: this.type = DbType.Int32; break;
case type_tag.STRING: this.type = DbType.String; break;
case type_tag.DATE: this.type = DbType.Date; break;
default: this.type = DbType.Object; break;
}
//this.where = where;
this.value = value;
}
public DataSetParameters DeleteDataSetParameters(int id)
{
DataSetParameters dbEntry = context.DataSetParameters.Find(id);
if (dbEntry != null)
{
try
{
context.DataSetParameters.Remove(dbEntry);
context.SaveChanges();
}
catch (Exception e)
{
e.WriteErrorMethod(String.Format("DeleteDataSetParameters(id={0})", id), eventID);
return(null);
}
}
return(dbEntry);
}
public int SaveDataSetParameters(DataSetParameters DataSetParameters)
{
DataSetParameters dbEntry;
try
{
if (DataSetParameters.id == 0)
{
dbEntry = new DataSetParameters()
{
id = 0,
id_dataset = DataSetParameters.id_dataset,
description = DataSetParameters.description,
name = DataSetParameters.name,
type = DataSetParameters.type,
type_where = DataSetParameters.type_where
};
context.DataSetParameters.Add(dbEntry);
}
else
{
dbEntry = context.DataSetParameters.Find(DataSetParameters.id);
if (dbEntry != null)
{
dbEntry.id_dataset = DataSetParameters.id_dataset;
dbEntry.description = DataSetParameters.description;
dbEntry.name = DataSetParameters.name;
dbEntry.type = DataSetParameters.type;
dbEntry.type_where = DataSetParameters.type_where;
}
}
context.SaveChanges();
}
catch (Exception e)
{
e.WriteErrorMethod(String.Format("SaveDataSetParameters(DataSetParameters={0})", DataSetParameters.GetFieldsAndValue()), eventID);
return(-1);
}
return(dbEntry.id);
}
