public static EmployeeOtherControlsSubscriptionsViewData 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 EmployeeOtherControlsSubscriptionsView."); } EmployeeOtherControlsSubscriptionsViewData data = GetDataObjectFromReader(dataReader); dataReader.Close(); return(data); }
public static void Insert(EmployeeOtherControlsSubscriptionsViewData data) { // Create and execute the command string sql = "Insert Into " + TABLE + "(" + "Src," + "Description," + "ClassSrc," + "ClassDescription," + "AllowUnsubscribe," + "SortOrder," + "OrgEmployeesID," + "ControlsID," + "ControlSubscriptionsID," ; sql = sql.Substring(0, sql.Length - 1) + ") values(" + "@Src," + "@Description," + "@ClassSrc," + "@ClassDescription," + "@AllowUnsubscribe," + "@SortOrder," + "@OrgEmployeesID," + "@ControlsID," + "@ControlSubscriptionsID," ; 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("@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)); // Execute the query cmd.ExecuteNonQuery(); }
public static void Update(EmployeeOtherControlsSubscriptionsViewData data) { // Create and execute the command EmployeeOtherControlsSubscriptionsViewData 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.ControlsID.Equals(data.ControlsID)) { sql = sql + "ControlsID=@ControlsID,"; } if (!oldData.ControlSubscriptionsID.Equals(data.ControlSubscriptionsID)) { sql = sql + "ControlSubscriptionsID=@ControlSubscriptionsID,"; } 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.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)); } // Execute the query if (cmd.Parameters.Count > 0) { cmd.ExecuteNonQuery(); } }
private static EmployeeOtherControlsSubscriptionsViewData GetDataObjectFromReader(SqlDataReader dataReader) { EmployeeOtherControlsSubscriptionsViewData data = new EmployeeOtherControlsSubscriptionsViewData(); 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("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"))); } return(data); }