private List <RoadFlow.Data.Model.ProgramBuilderValidates> DataReaderToList(MySqlDataReader dataReader)
{
List <RoadFlow.Data.Model.ProgramBuilderValidates> list = new List <RoadFlow.Data.Model.ProgramBuilderValidates>();
RoadFlow.Data.Model.ProgramBuilderValidates programBuilderValidates = null;
while (((DbDataReader)dataReader).Read())
{
programBuilderValidates = new RoadFlow.Data.Model.ProgramBuilderValidates();
programBuilderValidates.ID = ((DbDataReader)dataReader).GetString(0).ToGuid();
programBuilderValidates.ProgramID = ((DbDataReader)dataReader).GetString(1).ToGuid();
programBuilderValidates.TableName = ((DbDataReader)dataReader).GetString(2);
programBuilderValidates.FieldName = ((DbDataReader)dataReader).GetString(3);
if (!((DbDataReader)dataReader).IsDBNull(4))
{
programBuilderValidates.FieldNote = ((DbDataReader)dataReader).GetString(4);
}
programBuilderValidates.Validate = ((DbDataReader)dataReader).GetInt32(5);
list.Add(programBuilderValidates);
}
return(list);
}
public int Update(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
string sql = "UPDATE ProgramBuilderValidates SET \r\n\t\t\t\tProgramID=@ProgramID,TableName=@TableName,FieldName=@FieldName,FieldNote=@FieldNote,Validate=@Validate\r\n\t\t\t\tWHERE ID=@ID";
SqlParameter[] parameter = new SqlParameter[6]
{
new SqlParameter("@ProgramID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ProgramID
},
new SqlParameter("@TableName", SqlDbType.VarChar, 500)
{
Value = model.TableName
},
new SqlParameter("@FieldName", SqlDbType.VarChar, 500)
{
Value = model.FieldName
},
(model.FieldNote == null) ? new SqlParameter("@FieldNote", SqlDbType.NVarChar, 1000)
{
Value = DBNull.Value
} : new SqlParameter("@FieldNote", SqlDbType.NVarChar, 1000)
{
Value = model.FieldNote
},
new SqlParameter("@Validate", SqlDbType.Int, -1)
{
Value = model.Validate
},
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
}
};
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
string sql = "INSERT INTO ProgramBuilderValidates\r\n\t\t\t\t(ID,ProgramID,TableName,FieldName,FieldNote,Validate) \r\n\t\t\t\tVALUES(@ID,@ProgramID,@TableName,@FieldName,@FieldNote,@Validate)";
SqlParameter[] parameter = new SqlParameter[6]
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@ProgramID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ProgramID
},
new SqlParameter("@TableName", SqlDbType.VarChar, 500)
{
Value = model.TableName
},
new SqlParameter("@FieldName", SqlDbType.VarChar, 500)
{
Value = model.FieldName
},
(model.FieldNote == null) ? new SqlParameter("@FieldNote", SqlDbType.NVarChar, 1000)
{
Value = DBNull.Value
} : new SqlParameter("@FieldNote", SqlDbType.NVarChar, 1000)
{
Value = model.FieldNote
},
new SqlParameter("@Validate", SqlDbType.Int, -1)
{
Value = model.Validate
}
};
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_001f: Unknown result type (might be due to invalid IL or missing references)
//IL_0030: Expected O, but got Unknown
//IL_0031: Expected O, but got Unknown
//IL_003e: Unknown result type (might be due to invalid IL or missing references)
//IL_0043: Unknown result type (might be due to invalid IL or missing references)
//IL_004f: Expected O, but got Unknown
//IL_0050: Expected O, but got Unknown
//IL_005d: Unknown result type (might be due to invalid IL or missing references)
//IL_0062: Unknown result type (might be due to invalid IL or missing references)
//IL_006e: Expected O, but got Unknown
//IL_006f: Expected O, but got Unknown
//IL_0084: Unknown result type (might be due to invalid IL or missing references)
//IL_0089: Unknown result type (might be due to invalid IL or missing references)
//IL_0095: Expected O, but got Unknown
//IL_00a2: Unknown result type (might be due to invalid IL or missing references)
//IL_00a7: Unknown result type (might be due to invalid IL or missing references)
//IL_00b2: Expected O, but got Unknown
//IL_00b3: Expected O, but got Unknown
//IL_00bd: Unknown result type (might be due to invalid IL or missing references)
//IL_00c2: Unknown result type (might be due to invalid IL or missing references)
//IL_00d3: Expected O, but got Unknown
//IL_00d4: Expected O, but got Unknown
//IL_00e2: Unknown result type (might be due to invalid IL or missing references)
//IL_00e7: Unknown result type (might be due to invalid IL or missing references)
//IL_00f8: Expected O, but got Unknown
//IL_00f9: Expected O, but got Unknown
string sql = "UPDATE programbuildervalidates SET \r\n\t\t\t\tProgramID=@ProgramID,TableName=@TableName,FieldName=@FieldName,FieldNote=@FieldNote,Validate=@Validate\r\n\t\t\t\tWHERE ID=@ID";
MySqlParameter[] obj = new MySqlParameter[6];
MySqlParameter val = new MySqlParameter("@ProgramID", 253, 36);
((DbParameter)val).Value = model.ProgramID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@TableName", 752, -1);
((DbParameter)val2).Value = model.TableName;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@FieldName", 752, -1);
((DbParameter)val3).Value = model.FieldName;
obj[2] = val3;
_003F val4;
if (model.FieldNote != null)
{
val4 = new MySqlParameter("@FieldNote", 752, -1);
((DbParameter)val4).Value = model.FieldNote;
}
else
{
val4 = new MySqlParameter("@FieldNote", 752, -1);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
MySqlParameter val5 = new MySqlParameter("@Validate", 3, 11);
((DbParameter)val5).Value = model.Validate;
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@ID", 253, 36);
((DbParameter)val6).Value = model.ID;
obj[5] = val6;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_001f: Unknown result type (might be due to invalid IL or missing references)
//IL_0030: Expected O, but got Unknown
//IL_0031: Expected O, but got Unknown
//IL_003f: Unknown result type (might be due to invalid IL or missing references)
//IL_0044: Unknown result type (might be due to invalid IL or missing references)
//IL_0055: Expected O, but got Unknown
//IL_0056: Expected O, but got Unknown
//IL_0063: Unknown result type (might be due to invalid IL or missing references)
//IL_0068: Unknown result type (might be due to invalid IL or missing references)
//IL_0074: Expected O, but got Unknown
//IL_0075: Expected O, but got Unknown
//IL_0082: Unknown result type (might be due to invalid IL or missing references)
//IL_0087: Unknown result type (might be due to invalid IL or missing references)
//IL_0093: Expected O, but got Unknown
//IL_0094: Expected O, but got Unknown
//IL_00a9: Unknown result type (might be due to invalid IL or missing references)
//IL_00ae: Unknown result type (might be due to invalid IL or missing references)
//IL_00ba: Expected O, but got Unknown
//IL_00c7: Unknown result type (might be due to invalid IL or missing references)
//IL_00cc: Unknown result type (might be due to invalid IL or missing references)
//IL_00d7: Expected O, but got Unknown
//IL_00d8: Expected O, but got Unknown
//IL_00e2: Unknown result type (might be due to invalid IL or missing references)
//IL_00e7: Unknown result type (might be due to invalid IL or missing references)
//IL_00f8: Expected O, but got Unknown
//IL_00f9: Expected O, but got Unknown
string sql = "INSERT INTO programbuildervalidates\r\n\t\t\t\t(ID,ProgramID,TableName,FieldName,FieldNote,Validate) \r\n\t\t\t\tVALUES(@ID,@ProgramID,@TableName,@FieldName,@FieldNote,@Validate)";
MySqlParameter[] obj = new MySqlParameter[6];
MySqlParameter val = new MySqlParameter("@ID", 253, 36);
((DbParameter)val).Value = model.ID;
obj[0] = val;
MySqlParameter val2 = new MySqlParameter("@ProgramID", 253, 36);
((DbParameter)val2).Value = model.ProgramID;
obj[1] = val2;
MySqlParameter val3 = new MySqlParameter("@TableName", 752, -1);
((DbParameter)val3).Value = model.TableName;
obj[2] = val3;
MySqlParameter val4 = new MySqlParameter("@FieldName", 752, -1);
((DbParameter)val4).Value = model.FieldName;
obj[3] = val4;
_003F val5;
if (model.FieldNote != null)
{
val5 = new MySqlParameter("@FieldNote", 752, -1);
((DbParameter)val5).Value = model.FieldNote;
}
else
{
val5 = new MySqlParameter("@FieldNote", 752, -1);
((DbParameter)val5).Value = DBNull.Value;
}
obj[4] = val5;
MySqlParameter val6 = new MySqlParameter("@Validate", 3, 11);
((DbParameter)val6).Value = model.Validate;
obj[5] = val6;
MySqlParameter[] parameter = (MySqlParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
//IL_0015: Unknown result type (might be due to invalid IL or missing references)
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_002b: Expected O, but got Unknown
//IL_002c: Expected O, but got Unknown
//IL_0035: Unknown result type (might be due to invalid IL or missing references)
//IL_003a: Unknown result type (might be due to invalid IL or missing references)
//IL_0046: Expected O, but got Unknown
//IL_0047: Expected O, but got Unknown
//IL_0050: Unknown result type (might be due to invalid IL or missing references)
//IL_0055: Unknown result type (might be due to invalid IL or missing references)
//IL_0061: Expected O, but got Unknown
//IL_0062: Expected O, but got Unknown
//IL_0073: Unknown result type (might be due to invalid IL or missing references)
//IL_0078: Unknown result type (might be due to invalid IL or missing references)
//IL_0084: Expected O, but got Unknown
//IL_008d: Unknown result type (might be due to invalid IL or missing references)
//IL_0092: Unknown result type (might be due to invalid IL or missing references)
//IL_009d: Expected O, but got Unknown
//IL_009e: Expected O, but got Unknown
//IL_00a7: Unknown result type (might be due to invalid IL or missing references)
//IL_00ac: Unknown result type (might be due to invalid IL or missing references)
//IL_00bd: Expected O, but got Unknown
//IL_00be: Expected O, but got Unknown
//IL_00c7: Unknown result type (might be due to invalid IL or missing references)
//IL_00cc: Unknown result type (might be due to invalid IL or missing references)
//IL_00dd: Expected O, but got Unknown
//IL_00de: Expected O, but got Unknown
string sql = "UPDATE ProgramBuilderValidates SET \r\n\t\t\t\tProgramID=:ProgramID,TableName=:TableName,FieldName=:FieldName,FieldNote=:FieldNote,Validate1=:Validate1\r\n\t\t\t\tWHERE ID=:ID";
OracleParameter[] obj = new OracleParameter[6];
OracleParameter val = new OracleParameter(":ProgramID", 126);
((DbParameter)val).Value = model.ProgramID;
obj[0] = val;
OracleParameter val2 = new OracleParameter(":TableName", 126);
((DbParameter)val2).Value = model.TableName;
obj[1] = val2;
OracleParameter val3 = new OracleParameter(":FieldName", 126);
((DbParameter)val3).Value = model.FieldName;
obj[2] = val3;
_003F val4;
if (model.FieldNote != null)
{
val4 = new OracleParameter(":FieldNote", 126);
((DbParameter)val4).Value = model.FieldNote;
}
else
{
val4 = new OracleParameter(":FieldNote", 126);
((DbParameter)val4).Value = DBNull.Value;
}
obj[3] = val4;
OracleParameter val5 = new OracleParameter(":Validate1", 112);
((DbParameter)val5).Value = model.Validate;
obj[4] = val5;
OracleParameter val6 = new OracleParameter(":ID", 126);
((DbParameter)val6).Value = model.ID;
obj[5] = val6;
OracleParameter[] parameter = (OracleParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
//IL_0015: Unknown result type (might be due to invalid IL or missing references)
//IL_001a: Unknown result type (might be due to invalid IL or missing references)
//IL_002b: Expected O, but got Unknown
//IL_002c: Expected O, but got Unknown
//IL_0035: Unknown result type (might be due to invalid IL or missing references)
//IL_003a: Unknown result type (might be due to invalid IL or missing references)
//IL_004b: Expected O, but got Unknown
//IL_004c: Expected O, but got Unknown
//IL_0055: Unknown result type (might be due to invalid IL or missing references)
//IL_005a: Unknown result type (might be due to invalid IL or missing references)
//IL_0066: Expected O, but got Unknown
//IL_0067: Expected O, but got Unknown
//IL_0070: Unknown result type (might be due to invalid IL or missing references)
//IL_0075: Unknown result type (might be due to invalid IL or missing references)
//IL_0081: Expected O, but got Unknown
//IL_0082: Expected O, but got Unknown
//IL_0093: Unknown result type (might be due to invalid IL or missing references)
//IL_0098: Unknown result type (might be due to invalid IL or missing references)
//IL_00a4: Expected O, but got Unknown
//IL_00ad: Unknown result type (might be due to invalid IL or missing references)
//IL_00b2: Unknown result type (might be due to invalid IL or missing references)
//IL_00bd: Expected O, but got Unknown
//IL_00be: Expected O, but got Unknown
//IL_00c7: Unknown result type (might be due to invalid IL or missing references)
//IL_00cc: Unknown result type (might be due to invalid IL or missing references)
//IL_00dd: Expected O, but got Unknown
//IL_00de: Expected O, but got Unknown
string sql = "INSERT INTO ProgramBuilderValidates\r\n\t\t\t\t(ID,ProgramID,TableName,FieldName,FieldNote,Validate1) \r\n\t\t\t\tVALUES(:ID,:ProgramID,:TableName,:FieldName,:FieldNote,:Validate1)";
OracleParameter[] obj = new OracleParameter[6];
OracleParameter val = new OracleParameter(":ID", 126);
((DbParameter)val).Value = model.ID;
obj[0] = val;
OracleParameter val2 = new OracleParameter(":ProgramID", 126);
((DbParameter)val2).Value = model.ProgramID;
obj[1] = val2;
OracleParameter val3 = new OracleParameter(":TableName", 126);
((DbParameter)val3).Value = model.TableName;
obj[2] = val3;
OracleParameter val4 = new OracleParameter(":FieldName", 126);
((DbParameter)val4).Value = model.FieldName;
obj[3] = val4;
_003F val5;
if (model.FieldNote != null)
{
val5 = new OracleParameter(":FieldNote", 126);
((DbParameter)val5).Value = model.FieldNote;
}
else
{
val5 = new OracleParameter(":FieldNote", 126);
((DbParameter)val5).Value = DBNull.Value;
}
obj[4] = val5;
OracleParameter val6 = new OracleParameter(":Validate1", 112);
((DbParameter)val6).Value = model.Validate;
obj[5] = val6;
OracleParameter[] parameter = (OracleParameter[])obj;
return(dbHelper.Execute(sql, parameter));
}
public int Update(RoadFlow.Data.Model.ProgramBuilderValidates model)
{
return(dataProgramBuilderValidates.Update(model));
}
