public static void Insert(EmployeeControlSubscriptionsViewData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "Src,"
+ "Description,"
+ "ClassSrc,"
+ "ClassDescription,"
+ "AllowUnsubscribe,"
+ "SortOrder,"
+ "OrgEmployeesID,"
+ "OrgGroupsID,"
+ "ControlsID,"
+ "ControlSubscriptionsID,"
+ "ItemID,"
+ "ControlsClassesID,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@Src,"
+ "@Description,"
+ "@ClassSrc,"
+ "@ClassDescription,"
+ "@AllowUnsubscribe,"
+ "@SortOrder,"
+ "@OrgEmployeesID,"
+ "@OrgGroupsID,"
+ "@ControlsID,"
+ "@ControlSubscriptionsID,"
+ "@ItemID,"
+ "@ControlsClassesID,"
;
sql = sql.Substring(0, sql.Length - 1) + ")";
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("@Src", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Src", DataRowVersion.Proposed, data.Src.DBValue));
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
cmd.Parameters.Add(new SqlParameter("@ClassSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ClassSrc", DataRowVersion.Proposed, data.ClassSrc.DBValue));
cmd.Parameters.Add(new SqlParameter("@ClassDescription", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "ClassDescription", DataRowVersion.Proposed, data.ClassDescription.DBValue));
cmd.Parameters.Add(new SqlParameter("@AllowUnsubscribe", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "AllowUnsubscribe", DataRowVersion.Proposed, !data.AllowUnsubscribe.IsValid ? data.AllowUnsubscribe.DBValue : data.AllowUnsubscribe.DBValue.Equals("Y") ? 1 : 0));
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("@OrgEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeesID", DataRowVersion.Proposed, data.OrgEmployeesID.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("@ControlsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsID", DataRowVersion.Proposed, data.ControlsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@ControlSubscriptionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlSubscriptionsID", DataRowVersion.Proposed, data.ControlSubscriptionsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@ItemID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ItemID", DataRowVersion.Proposed, data.ItemID.DBValue));
cmd.Parameters.Add(new SqlParameter("@ControlsClassesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsClassesID", DataRowVersion.Proposed, data.ControlsClassesID.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
}
public static EmployeeControlSubscriptionsViewData Load()
{
WhereClause w = new WhereClause();
SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for EmployeeControlSubscriptionsView.");
}
EmployeeControlSubscriptionsViewData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static void Update(EmployeeControlSubscriptionsViewData data)
{
// Create and execute the command
EmployeeControlSubscriptionsViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.Src.Equals(data.Src))
{
sql = sql + "Src=@Src,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.ClassSrc.Equals(data.ClassSrc))
{
sql = sql + "ClassSrc=@ClassSrc,";
}
if (!oldData.ClassDescription.Equals(data.ClassDescription))
{
sql = sql + "ClassDescription=@ClassDescription,";
}
if (!oldData.AllowUnsubscribe.Equals(data.AllowUnsubscribe))
{
sql = sql + "AllowUnsubscribe=@AllowUnsubscribe,";
}
if (!oldData.SortOrder.Equals(data.SortOrder))
{
sql = sql + "SortOrder=@SortOrder,";
}
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
sql = sql + "OrgEmployeesID=@OrgEmployeesID,";
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
if (!oldData.ControlSubscriptionsID.Equals(data.ControlSubscriptionsID))
{
sql = sql + "ControlSubscriptionsID=@ControlSubscriptionsID,";
}
if (!oldData.ItemID.Equals(data.ItemID))
{
sql = sql + "ItemID=@ItemID,";
}
if (!oldData.ControlsClassesID.Equals(data.ControlsClassesID))
{
sql = sql + "ControlsClassesID=@ControlsClassesID,";
}
WhereClause w = new WhereClause();
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.Src.Equals(data.Src))
{
cmd.Parameters.Add(new SqlParameter("@Src", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Src", DataRowVersion.Proposed, data.Src.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.ClassSrc.Equals(data.ClassSrc))
{
cmd.Parameters.Add(new SqlParameter("@ClassSrc", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "ClassSrc", DataRowVersion.Proposed, data.ClassSrc.DBValue));
}
if (!oldData.ClassDescription.Equals(data.ClassDescription))
{
cmd.Parameters.Add(new SqlParameter("@ClassDescription", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "ClassDescription", DataRowVersion.Proposed, data.ClassDescription.DBValue));
}
if (!oldData.AllowUnsubscribe.Equals(data.AllowUnsubscribe))
{
cmd.Parameters.Add(new SqlParameter("@AllowUnsubscribe", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "AllowUnsubscribe", DataRowVersion.Proposed, !data.AllowUnsubscribe.IsValid ? data.AllowUnsubscribe.DBValue : data.AllowUnsubscribe.DBValue.Equals("Y") ? 1 : 0));
}
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.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
cmd.Parameters.Add(new SqlParameter("@OrgEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeesID", DataRowVersion.Proposed, data.OrgEmployeesID.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.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.ControlSubscriptionsID.Equals(data.ControlSubscriptionsID))
{
cmd.Parameters.Add(new SqlParameter("@ControlSubscriptionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlSubscriptionsID", DataRowVersion.Proposed, data.ControlSubscriptionsID.DBValue));
}
if (!oldData.ItemID.Equals(data.ItemID))
{
cmd.Parameters.Add(new SqlParameter("@ItemID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ItemID", DataRowVersion.Proposed, data.ItemID.DBValue));
}
if (!oldData.ControlsClassesID.Equals(data.ControlsClassesID))
{
cmd.Parameters.Add(new SqlParameter("@ControlsClassesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "ControlsClassesID", DataRowVersion.Proposed, data.ControlsClassesID.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static EmployeeControlSubscriptionsViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeControlSubscriptionsViewData data = new EmployeeControlSubscriptionsViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Src")))
{
data.Src = StringType.UNSET;
}
else
{
data.Src = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Src")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ClassSrc")))
{
data.ClassSrc = StringType.UNSET;
}
else
{
data.ClassSrc = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ClassSrc")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ClassDescription")))
{
data.ClassDescription = StringType.UNSET;
}
else
{
data.ClassDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ClassDescription")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AllowUnsubscribe")))
{
data.AllowUnsubscribe = BooleanType.UNSET;
}
else
{
data.AllowUnsubscribe = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("AllowUnsubscribe")));
}
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("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
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("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlSubscriptionsID")))
{
data.ControlSubscriptionsID = IntegerType.UNSET;
}
else
{
data.ControlSubscriptionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlSubscriptionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ItemID")))
{
data.ItemID = IntegerType.UNSET;
}
else
{
data.ItemID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ItemID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsClassesID")))
{
data.ControlsClassesID = IntegerType.UNSET;
}
else
{
data.ControlsClassesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsClassesID")));
}
return(data);
}
