private List <RoadFlow.Data.Model.ProgramBuilderFields> DataReaderToList(SqlDataReader dataReader)
{
List <RoadFlow.Data.Model.ProgramBuilderFields> programBuilderFieldsList = new List <RoadFlow.Data.Model.ProgramBuilderFields>();
while (dataReader.Read())
{
RoadFlow.Data.Model.ProgramBuilderFields programBuilderFields = new RoadFlow.Data.Model.ProgramBuilderFields();
programBuilderFields.ID = dataReader.GetGuid(0);
programBuilderFields.ProgramID = dataReader.GetGuid(1);
if (!dataReader.IsDBNull(2))
{
programBuilderFields.Field = dataReader.GetString(2);
}
programBuilderFields.ShowTitle = dataReader.GetString(3);
programBuilderFields.Align = dataReader.GetString(4);
if (!dataReader.IsDBNull(5))
{
programBuilderFields.Width = dataReader.GetString(5);
}
programBuilderFields.ShowType = dataReader.GetInt32(6);
if (!dataReader.IsDBNull(7))
{
programBuilderFields.ShowFormat = dataReader.GetString(7);
}
if (!dataReader.IsDBNull(8))
{
programBuilderFields.CustomString = dataReader.GetString(8);
}
programBuilderFields.Sort = dataReader.GetInt32(9);
programBuilderFieldsList.Add(programBuilderFields);
}
return(programBuilderFieldsList);
}
public int Add(RoadFlow.Data.Model.ProgramBuilderFields model)
{
string sql = "INSERT INTO ProgramBuilderFields\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Align,Width,ShowType,ShowFormat,CustomString,Sort) \r\n\t\t\t\tVALUES(@ID,@ProgramID,@Field,@ShowTitle,@Align,@Width,@ShowType,@ShowFormat,@CustomString,@Sort)";
SqlParameter[] sqlParameterArray = new SqlParameter[10];
int index1 = 0;
SqlParameter sqlParameter1 = new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1);
sqlParameter1.Value = (object)model.ID;
sqlParameterArray[index1] = sqlParameter1;
int index2 = 1;
SqlParameter sqlParameter2 = new SqlParameter("@ProgramID", SqlDbType.UniqueIdentifier, -1);
sqlParameter2.Value = (object)model.ProgramID;
sqlParameterArray[index2] = sqlParameter2;
int index3 = 2;
SqlParameter sqlParameter3 = new SqlParameter("@Field", SqlDbType.VarChar, 500);
sqlParameter3.Value = (object)model.Field;
sqlParameterArray[index3] = sqlParameter3;
int index4 = 3;
SqlParameter sqlParameter4 = new SqlParameter("@ShowTitle", SqlDbType.VarChar, -1);
sqlParameter4.Value = (object)model.ShowTitle;
sqlParameterArray[index4] = sqlParameter4;
int index5 = 4;
SqlParameter sqlParameter5 = new SqlParameter("@Align", SqlDbType.VarChar, 50);
sqlParameter5.Value = (object)model.Align;
sqlParameterArray[index5] = sqlParameter5;
int index6 = 5;
SqlParameter sqlParameter6;
if (model.Width != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@Width", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.Width;
sqlParameter6 = sqlParameter7;
}
else
{
sqlParameter6 = new SqlParameter("@Width", SqlDbType.VarChar, 50);
sqlParameter6.Value = (object)DBNull.Value;
}
sqlParameterArray[index6] = sqlParameter6;
int index7 = 6;
SqlParameter sqlParameter8 = new SqlParameter("@ShowType", SqlDbType.Int, -1);
sqlParameter8.Value = (object)model.ShowType;
sqlParameterArray[index7] = sqlParameter8;
int index8 = 7;
SqlParameter sqlParameter9;
if (model.ShowFormat != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@ShowFormat", SqlDbType.VarChar, 50);
sqlParameter7.Value = (object)model.ShowFormat;
sqlParameter9 = sqlParameter7;
}
else
{
sqlParameter9 = new SqlParameter("@ShowFormat", SqlDbType.VarChar, 50);
sqlParameter9.Value = (object)DBNull.Value;
}
sqlParameterArray[index8] = sqlParameter9;
int index9 = 8;
SqlParameter sqlParameter10;
if (model.CustomString != null)
{
SqlParameter sqlParameter7 = new SqlParameter("@CustomString", SqlDbType.VarChar, -1);
sqlParameter7.Value = (object)model.CustomString;
sqlParameter10 = sqlParameter7;
}
else
{
sqlParameter10 = new SqlParameter("@CustomString", SqlDbType.VarChar, -1);
sqlParameter10.Value = (object)DBNull.Value;
}
sqlParameterArray[index9] = sqlParameter10;
int index10 = 9;
SqlParameter sqlParameter11 = new SqlParameter("@Sort", SqlDbType.Int, -1);
sqlParameter11.Value = (object)model.Sort;
sqlParameterArray[index10] = sqlParameter11;
SqlParameter[] parameter = sqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderFields model)
{
string sql = "INSERT INTO ProgramBuilderFields\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Align,Width,ShowType,ShowFormat,CustomString,Sort) \r\n\t\t\t\tVALUES(:ID,:ProgramID,:Field,:ShowTitle,:Align,:Width,:ShowType,:ShowFormat,:CustomString,:Sort)";
OracleParameter[] oracleParameterArray = new OracleParameter[10];
int index1 = 0;
OracleParameter oracleParameter1 = new OracleParameter(":ID", OracleDbType.Varchar2);
oracleParameter1.Value = (object)model.ID;
oracleParameterArray[index1] = oracleParameter1;
int index2 = 1;
OracleParameter oracleParameter2 = new OracleParameter(":ProgramID", OracleDbType.Varchar2);
oracleParameter2.Value = (object)model.ProgramID;
oracleParameterArray[index2] = oracleParameter2;
int index3 = 2;
OracleParameter oracleParameter3 = new OracleParameter(":Field", OracleDbType.Varchar2);
oracleParameter3.Value = (object)model.Field;
oracleParameterArray[index3] = oracleParameter3;
int index4 = 3;
OracleParameter oracleParameter4 = new OracleParameter(":ShowTitle", OracleDbType.Varchar2);
oracleParameter4.Value = (object)model.ShowTitle;
oracleParameterArray[index4] = oracleParameter4;
int index5 = 4;
OracleParameter oracleParameter5 = new OracleParameter(":Align", OracleDbType.Varchar2);
oracleParameter5.Value = (object)model.Align;
oracleParameterArray[index5] = oracleParameter5;
int index6 = 5;
OracleParameter oracleParameter6;
if (model.Width != null)
{
OracleParameter oracleParameter7 = new OracleParameter(":Width", OracleDbType.Varchar2);
oracleParameter7.Value = (object)model.Width;
oracleParameter6 = oracleParameter7;
}
else
{
oracleParameter6 = new OracleParameter(":Width", OracleDbType.Varchar2);
oracleParameter6.Value = (object)DBNull.Value;
}
oracleParameterArray[index6] = oracleParameter6;
int index7 = 6;
OracleParameter oracleParameter8 = new OracleParameter(":ShowType", OracleDbType.Int32);
oracleParameter8.Value = (object)model.ShowType;
oracleParameterArray[index7] = oracleParameter8;
int index8 = 7;
OracleParameter oracleParameter9;
if (model.ShowFormat != null)
{
OracleParameter oracleParameter7 = new OracleParameter(":ShowFormat", OracleDbType.Varchar2);
oracleParameter7.Value = (object)model.ShowFormat;
oracleParameter9 = oracleParameter7;
}
else
{
oracleParameter9 = new OracleParameter(":ShowFormat", OracleDbType.Varchar2);
oracleParameter9.Value = (object)DBNull.Value;
}
oracleParameterArray[index8] = oracleParameter9;
int index9 = 8;
OracleParameter oracleParameter10;
if (model.CustomString != null)
{
OracleParameter oracleParameter7 = new OracleParameter(":CustomString", OracleDbType.Varchar2);
oracleParameter7.Value = (object)model.CustomString;
oracleParameter10 = oracleParameter7;
}
else
{
oracleParameter10 = new OracleParameter(":CustomString", OracleDbType.Varchar2);
oracleParameter10.Value = (object)DBNull.Value;
}
oracleParameterArray[index9] = oracleParameter10;
int index10 = 9;
OracleParameter oracleParameter11 = new OracleParameter(":Sort", OracleDbType.Int32);
oracleParameter11.Value = (object)model.Sort;
oracleParameterArray[index10] = oracleParameter11;
OracleParameter[] parameter = oracleParameterArray;
return(this.dbHelper.Execute(sql, parameter));
}
public int Add(RoadFlow.Data.Model.ProgramBuilderFields model)
{
string sql = "INSERT INTO programbuilderfields\r\n\t\t\t\t(ID,ProgramID,Field,ShowTitle,Align,Width,ShowType,ShowFormat,CustomString,Sort) \r\n\t\t\t\tVALUES(@ID,@ProgramID,@Field,@ShowTitle,@Align,@Width,@ShowType,@ShowFormat,@CustomString,@Sort)";
MySqlParameter[] mySqlParameterArray = new MySqlParameter[10];
int index1 = 0;
MySqlParameter mySqlParameter1 = new MySqlParameter("@ID", MySqlDbType.VarChar, 36);
mySqlParameter1.Value = (object)model.ID;
mySqlParameterArray[index1] = mySqlParameter1;
int index2 = 1;
MySqlParameter mySqlParameter2 = new MySqlParameter("@ProgramID", MySqlDbType.VarChar, 36);
mySqlParameter2.Value = (object)model.ProgramID;
mySqlParameterArray[index2] = mySqlParameter2;
int index3 = 2;
MySqlParameter mySqlParameter3;
if (model.Field != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@Field", MySqlDbType.Text, -1);
mySqlParameter4.Value = (object)model.Field;
mySqlParameter3 = mySqlParameter4;
}
else
{
mySqlParameter3 = new MySqlParameter("@Field", MySqlDbType.Text, -1);
mySqlParameter3.Value = (object)DBNull.Value;
}
mySqlParameterArray[index3] = mySqlParameter3;
int index4 = 3;
MySqlParameter mySqlParameter5 = new MySqlParameter("@ShowTitle", MySqlDbType.LongText, -1);
mySqlParameter5.Value = (object)model.ShowTitle;
mySqlParameterArray[index4] = mySqlParameter5;
int index5 = 4;
MySqlParameter mySqlParameter6 = new MySqlParameter("@Align", MySqlDbType.VarChar, 50);
mySqlParameter6.Value = (object)model.Align;
mySqlParameterArray[index5] = mySqlParameter6;
int index6 = 5;
MySqlParameter mySqlParameter7;
if (model.Width != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@Width", MySqlDbType.VarChar, 50);
mySqlParameter4.Value = (object)model.Width;
mySqlParameter7 = mySqlParameter4;
}
else
{
mySqlParameter7 = new MySqlParameter("@Width", MySqlDbType.VarChar, 50);
mySqlParameter7.Value = (object)DBNull.Value;
}
mySqlParameterArray[index6] = mySqlParameter7;
int index7 = 6;
MySqlParameter mySqlParameter8 = new MySqlParameter("@ShowType", MySqlDbType.Int32, 11);
mySqlParameter8.Value = (object)model.ShowType;
mySqlParameterArray[index7] = mySqlParameter8;
int index8 = 7;
MySqlParameter mySqlParameter9;
if (model.ShowFormat != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@ShowFormat", MySqlDbType.VarChar, 50);
mySqlParameter4.Value = (object)model.ShowFormat;
mySqlParameter9 = mySqlParameter4;
}
else
{
mySqlParameter9 = new MySqlParameter("@ShowFormat", MySqlDbType.VarChar, 50);
mySqlParameter9.Value = (object)DBNull.Value;
}
mySqlParameterArray[index8] = mySqlParameter9;
int index9 = 8;
MySqlParameter mySqlParameter10;
if (model.CustomString != null)
{
MySqlParameter mySqlParameter4 = new MySqlParameter("@CustomString", MySqlDbType.LongText, -1);
mySqlParameter4.Value = (object)model.CustomString;
mySqlParameter10 = mySqlParameter4;
}
else
{
mySqlParameter10 = new MySqlParameter("@CustomString", MySqlDbType.LongText, -1);
mySqlParameter10.Value = (object)DBNull.Value;
}
mySqlParameterArray[index9] = mySqlParameter10;
int index10 = 9;
MySqlParameter mySqlParameter11 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11);
mySqlParameter11.Value = (object)model.Sort;
mySqlParameterArray[index10] = mySqlParameter11;
MySqlParameter[] parameter = mySqlParameterArray;
return(this.dbHelper.Execute(sql, parameter, false));
}
public int Update(RoadFlow.Data.Model.ProgramBuilderFields model)
{
return(this.dataProgramBuilderFields.Update(model));
}
