public static EmployeeControlPermissionViewData 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 EmployeeControlPermissionView.");
}
EmployeeControlPermissionViewData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static void Insert(EmployeeControlPermissionViewData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "OrgEmployeeID,"
+ "ControlsID,"
+ "Description,"
+ "DateStart,"
+ "DateEnd,"
+ "EntireCompany,"
+ "Summary,"
+ "MustShow,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@OrgEmployeeID,"
+ "@ControlsID,"
+ "@Description,"
+ "@DateStart,"
+ "@DateEnd,"
+ "@EntireCompany,"
+ "@Summary,"
+ "@MustShow,"
;
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("@OrgEmployeeID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeeID", DataRowVersion.Proposed, data.OrgEmployeeID.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("@Description", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
cmd.Parameters.Add(new SqlParameter("@EntireCompany", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "EntireCompany", DataRowVersion.Proposed, !data.EntireCompany.IsValid ? data.EntireCompany.DBValue : data.EntireCompany.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
cmd.Parameters.Add(new SqlParameter("@MustShow", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "MustShow", DataRowVersion.Proposed, !data.MustShow.IsValid ? data.MustShow.DBValue : data.MustShow.DBValue.Equals("Y") ? 1 : 0));
// Execute the query
cmd.ExecuteNonQuery();
}
public static void Update(EmployeeControlPermissionViewData data)
{
// Create and execute the command
EmployeeControlPermissionViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.OrgEmployeeID.Equals(data.OrgEmployeeID))
{
sql = sql + "OrgEmployeeID=@OrgEmployeeID,";
}
if (!oldData.ControlsID.Equals(data.ControlsID))
{
sql = sql + "ControlsID=@ControlsID,";
}
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.DateStart.Equals(data.DateStart))
{
sql = sql + "DateStart=@DateStart,";
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
sql = sql + "DateEnd=@DateEnd,";
}
if (!oldData.EntireCompany.Equals(data.EntireCompany))
{
sql = sql + "EntireCompany=@EntireCompany,";
}
if (!oldData.Summary.Equals(data.Summary))
{
sql = sql + "Summary=@Summary,";
}
if (!oldData.MustShow.Equals(data.MustShow))
{
sql = sql + "MustShow=@MustShow,";
}
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.OrgEmployeeID.Equals(data.OrgEmployeeID))
{
cmd.Parameters.Add(new SqlParameter("@OrgEmployeeID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgEmployeeID", DataRowVersion.Proposed, data.OrgEmployeeID.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.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.DateStart.Equals(data.DateStart))
{
cmd.Parameters.Add(new SqlParameter("@DateStart", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateStart", DataRowVersion.Proposed, data.DateStart.DBValue));
}
if (!oldData.DateEnd.Equals(data.DateEnd))
{
cmd.Parameters.Add(new SqlParameter("@DateEnd", SqlDbType.SmallDateTime, 0, ParameterDirection.Input, false, 0, 0, "DateEnd", DataRowVersion.Proposed, data.DateEnd.DBValue));
}
if (!oldData.EntireCompany.Equals(data.EntireCompany))
{
cmd.Parameters.Add(new SqlParameter("@EntireCompany", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "EntireCompany", DataRowVersion.Proposed, !data.EntireCompany.IsValid ? data.EntireCompany.DBValue : data.EntireCompany.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.Summary.Equals(data.Summary))
{
cmd.Parameters.Add(new SqlParameter("@Summary", SqlDbType.VarChar, 200, ParameterDirection.Input, false, 0, 0, "Summary", DataRowVersion.Proposed, data.Summary.DBValue));
}
if (!oldData.MustShow.Equals(data.MustShow))
{
cmd.Parameters.Add(new SqlParameter("@MustShow", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "MustShow", DataRowVersion.Proposed, !data.MustShow.IsValid ? data.MustShow.DBValue : data.MustShow.DBValue.Equals("Y") ? 1 : 0));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static EmployeeControlPermissionViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeControlPermissionViewData data = new EmployeeControlPermissionViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeeID")))
{
data.OrgEmployeeID = IntegerType.UNSET;
}
else
{
data.OrgEmployeeID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeeID")));
}
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("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EntireCompany")))
{
data.EntireCompany = BooleanType.UNSET;
}
else
{
data.EntireCompany = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("EntireCompany")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MustShow")))
{
data.MustShow = BooleanType.UNSET;
}
else
{
data.MustShow = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("MustShow")));
}
return(data);
}
