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