public static IdType Insert(ControlsGroupsData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "ControlsID,"
+ "OrgGroupsID,"
+ "SortOrder,"
+ "DisplayOnHomePage,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@ControlsID,"
+ "@OrgGroupsID,"
+ "@SortOrder,"
+ "@DisplayOnHomePage,"
;
sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id";
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue));
cmd.Parameters.Add(new SqlParameter("@DisplayOnHomePage", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "DisplayOnHomePage", DataRowVersion.Proposed, !data.DisplayOnHomePage.IsValid ? data.DisplayOnHomePage.DBValue : data.DisplayOnHomePage.DBValue.Equals("Y") ? 1 : 0));
// Execute the query
SqlDataReader returnValue = cmd.ExecuteReader();
returnValue.Read();
int returnId = (int)(returnValue.GetDecimal(0));
returnValue.Close();
// Set the output paramter value(s)
return(new IdType(returnId));
}
public static void Update(ControlsGroupsData data)
{
// Create and execute the command
ControlsGroupsData oldData = Load(data.ControlsGroupsID);
string sql = "Update " + TABLE + " set ";
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
sql = sql + "SortOrder=@SortOrder,";
}
if (!oldData.DisplayOnHomePage.Equals(data.DisplayOnHomePage))
{
sql = sql + "DisplayOnHomePage=@DisplayOnHomePage,";
}
WhereClause w = new WhereClause();
w.And("ControlsGroupsID", data.ControlsGroupsID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.ControlsGroupsID.Equals(data.ControlsGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsGroupsID", DataRowVersion.Proposed, data.ControlsGroupsID.DBValue));
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsID", DataRowVersion.Proposed, data.OrgGroupsID.DBValue));
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
cmd.Parameters.Add(new SqlParameter("@SortOrder", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "SortOrder", DataRowVersion.Proposed, data.SortOrder.DBValue));
}
if (!oldData.DisplayOnHomePage.Equals(data.DisplayOnHomePage))
{
cmd.Parameters.Add(new SqlParameter("@DisplayOnHomePage", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "DisplayOnHomePage", DataRowVersion.Proposed, !data.DisplayOnHomePage.IsValid ? data.DisplayOnHomePage.DBValue : data.DisplayOnHomePage.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static ControlsGroupsData GetDataObjectFromReader(SqlDataReader dataReader)
{
ControlsGroupsData data = new ControlsGroupsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsGroupsID")))
{
data.ControlsGroupsID = IdType.UNSET;
}
else
{
data.ControlsGroupsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder")))
{
data.SortOrder = IntegerType.UNSET;
}
else
{
data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DisplayOnHomePage")))
{
data.DisplayOnHomePage = BooleanType.UNSET;
}
else
{
data.DisplayOnHomePage = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("DisplayOnHomePage")));
}
return(data);
}
public static ControlsGroupsData Load(IdType controlsGroupsID)
{
WhereClause w = new WhereClause();
w.And("ControlsGroupsID", controlsGroupsID.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for ControlsGroups.");
}
ControlsGroupsData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
