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