public static void Insert(GroupEmployeeViewData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "FirstName,"
+ "LastName,"
+ "DepartmentName,"
+ "GroupIsActive,"
+ "OrgGroupsID,"
+ "LocationName,"
+ "EmployeeTitle,"
+ "EmployeeIsActive,"
+ "OrgGroupsEmployeesID,"
+ "OrgEmployeesID,"
+ "Email,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@FirstName,"
+ "@LastName,"
+ "@DepartmentName,"
+ "@GroupIsActive,"
+ "@OrgGroupsID,"
+ "@LocationName,"
+ "@EmployeeTitle,"
+ "@EmployeeIsActive,"
+ "@OrgGroupsEmployeesID,"
+ "@OrgEmployeesID,"
+ "@Email,"
;
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("@FirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "FirstName", DataRowVersion.Proposed, data.FirstName.DBValue));
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastName", DataRowVersion.Proposed, data.LastName.DBValue));
cmd.Parameters.Add(new SqlParameter("@DepartmentName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "DepartmentName", DataRowVersion.Proposed, data.DepartmentName.DBValue));
cmd.Parameters.Add(new SqlParameter("@GroupIsActive", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "GroupIsActive", DataRowVersion.Proposed, !data.GroupIsActive.IsValid ? data.GroupIsActive.DBValue : data.GroupIsActive.DBValue.Equals("Y") ? 1 : 0));
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("@LocationName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "LocationName", DataRowVersion.Proposed, data.LocationName.DBValue));
cmd.Parameters.Add(new SqlParameter("@EmployeeTitle", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "EmployeeTitle", DataRowVersion.Proposed, data.EmployeeTitle.DBValue));
cmd.Parameters.Add(new SqlParameter("@EmployeeIsActive", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "EmployeeIsActive", DataRowVersion.Proposed, !data.EmployeeIsActive.IsValid ? data.EmployeeIsActive.DBValue : data.EmployeeIsActive.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@OrgGroupsEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsEmployeesID", DataRowVersion.Proposed, data.OrgGroupsEmployeesID.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("@Email", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Proposed, data.Email.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
}
public static GroupEmployeeViewData 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 GroupEmployeeView.");
}
GroupEmployeeViewData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
public static void Update(GroupEmployeeViewData data)
{
// Create and execute the command
GroupEmployeeViewData oldData = Load();
string sql = "Update " + TABLE + " set ";
if (!oldData.FirstName.Equals(data.FirstName))
{
sql = sql + "FirstName=@FirstName,";
}
if (!oldData.LastName.Equals(data.LastName))
{
sql = sql + "LastName=@LastName,";
}
if (!oldData.DepartmentName.Equals(data.DepartmentName))
{
sql = sql + "DepartmentName=@DepartmentName,";
}
if (!oldData.GroupIsActive.Equals(data.GroupIsActive))
{
sql = sql + "GroupIsActive=@GroupIsActive,";
}
if (!oldData.OrgGroupsID.Equals(data.OrgGroupsID))
{
sql = sql + "OrgGroupsID=@OrgGroupsID,";
}
if (!oldData.LocationName.Equals(data.LocationName))
{
sql = sql + "LocationName=@LocationName,";
}
if (!oldData.EmployeeTitle.Equals(data.EmployeeTitle))
{
sql = sql + "EmployeeTitle=@EmployeeTitle,";
}
if (!oldData.EmployeeIsActive.Equals(data.EmployeeIsActive))
{
sql = sql + "EmployeeIsActive=@EmployeeIsActive,";
}
if (!oldData.OrgGroupsEmployeesID.Equals(data.OrgGroupsEmployeesID))
{
sql = sql + "OrgGroupsEmployeesID=@OrgGroupsEmployeesID,";
}
if (!oldData.OrgEmployeesID.Equals(data.OrgEmployeesID))
{
sql = sql + "OrgEmployeesID=@OrgEmployeesID,";
}
if (!oldData.Email.Equals(data.Email))
{
sql = sql + "Email=@Email,";
}
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.FirstName.Equals(data.FirstName))
{
cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "FirstName", DataRowVersion.Proposed, data.FirstName.DBValue));
}
if (!oldData.LastName.Equals(data.LastName))
{
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "LastName", DataRowVersion.Proposed, data.LastName.DBValue));
}
if (!oldData.DepartmentName.Equals(data.DepartmentName))
{
cmd.Parameters.Add(new SqlParameter("@DepartmentName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "DepartmentName", DataRowVersion.Proposed, data.DepartmentName.DBValue));
}
if (!oldData.GroupIsActive.Equals(data.GroupIsActive))
{
cmd.Parameters.Add(new SqlParameter("@GroupIsActive", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "GroupIsActive", DataRowVersion.Proposed, !data.GroupIsActive.IsValid ? data.GroupIsActive.DBValue : data.GroupIsActive.DBValue.Equals("Y") ? 1 : 0));
}
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.LocationName.Equals(data.LocationName))
{
cmd.Parameters.Add(new SqlParameter("@LocationName", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "LocationName", DataRowVersion.Proposed, data.LocationName.DBValue));
}
if (!oldData.EmployeeTitle.Equals(data.EmployeeTitle))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeTitle", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "EmployeeTitle", DataRowVersion.Proposed, data.EmployeeTitle.DBValue));
}
if (!oldData.EmployeeIsActive.Equals(data.EmployeeIsActive))
{
cmd.Parameters.Add(new SqlParameter("@EmployeeIsActive", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "EmployeeIsActive", DataRowVersion.Proposed, !data.EmployeeIsActive.IsValid ? data.EmployeeIsActive.DBValue : data.EmployeeIsActive.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.OrgGroupsEmployeesID.Equals(data.OrgGroupsEmployeesID))
{
cmd.Parameters.Add(new SqlParameter("@OrgGroupsEmployeesID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgGroupsEmployeesID", DataRowVersion.Proposed, data.OrgGroupsEmployeesID.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.Email.Equals(data.Email))
{
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 30, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Proposed, data.Email.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static GroupEmployeeViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
GroupEmployeeViewData data = new GroupEmployeeViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("FirstName")))
{
data.FirstName = StringType.UNSET;
}
else
{
data.FirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("FirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastName")))
{
data.LastName = StringType.UNSET;
}
else
{
data.LastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DepartmentName")))
{
data.DepartmentName = StringType.UNSET;
}
else
{
data.DepartmentName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("DepartmentName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupIsActive")))
{
data.GroupIsActive = BooleanType.UNSET;
}
else
{
data.GroupIsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("GroupIsActive")));
}
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("LocationName")))
{
data.LocationName = StringType.UNSET;
}
else
{
data.LocationName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LocationName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeTitle")))
{
data.EmployeeTitle = StringType.UNSET;
}
else
{
data.EmployeeTitle = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EmployeeTitle")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeIsActive")))
{
data.EmployeeIsActive = BooleanType.UNSET;
}
else
{
data.EmployeeIsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("EmployeeIsActive")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsEmployeesID")))
{
data.OrgGroupsEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgGroupsEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsEmployeesID")));
}
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("Email")))
{
data.Email = StringType.UNSET;
}
else
{
data.Email = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Email")));
}
return(data);
}
