private static int SavePerson(Employee employeeToSave)
{
Person tempPerson = new Person();
tempPerson.PersonId = employeeToSave.PersonId;
if (employeeToSave.FirstName != null)
{
tempPerson.FirstName = employeeToSave.FirstName;
}
if (employeeToSave.MiddleName != null)
{
tempPerson.MiddleName = employeeToSave.MiddleName;
}
if (employeeToSave.LastName != null)
{
tempPerson.LastName = employeeToSave.LastName;
}
if (employeeToSave.SocialSecurityNumber != null)
{
tempPerson.SocialSecurityNumber = employeeToSave.SocialSecurityNumber;
}
if (employeeToSave.BirthDate != DateTime.MinValue)
{
tempPerson.BirthDate = employeeToSave.BirthDate;
}
return PersonBLL.Save(tempPerson);
}
public static int Save(Employee employeeToSave)
{
int personId = SavePerson(employeeToSave);
employeeToSave.PersonId = personId;
return EmployeeDAL.Save(employeeToSave);
}
private void ProcessFormValues()
{
//Create string builder object and then append the string values to that object
StringBuilder myStringBuilder = new StringBuilder();
//string variables for the web form controls
string firstName = txtFirstName.Text;
string middleName = txtMiddleName.Text;
string lastName = txtLastName.Text;
string socialSecurityNum = txtSSN.Text;
DateTime birthDate = Convert.ToDateTime(txtBirthDate.Text);
DateTime hireDate = Convert.ToDateTime(txtDateOfHire.Text);
DateTime termDate = Convert.ToDateTime(txtDateOfTermination.Text);
string categoryText = DropDownCategory.SelectedItem.Text;
string tierLevelText = DropDownTierLevel.SelectedItem.Text;
string laptopText = DropDownLaptop.SelectedItem.Text;
string background = txtBackground.Text;
int categoryValue = Convert.ToInt32(DropDownCategory.SelectedValue);
int tierLevelValue = Convert.ToInt32(DropDownTierLevel.SelectedValue);
int laptopValue = Convert.ToInt32(DropDownLaptop.SelectedValue);
int payRate = Convert.ToInt32(txtPayRate.Text);
//Set Employee Properties
Employee employeeToSave = new Employee();
//Person specific properties
employeeToSave.FirstName = firstName;
employeeToSave.MiddleName = middleName;
employeeToSave.LastName = lastName;
employeeToSave.SocialSecurityNumber = socialSecurityNum;
employeeToSave.BirthDate = birthDate;
//Employee Specific Properties
employeeToSave.HireDate = hireDate;
employeeToSave.TermDate = termDate;
employeeToSave.PayRate = payRate;
employeeToSave.Background = background;
//Complex properties
employeeToSave.Category = new EntityType { EntityTypeId = categoryValue };
employeeToSave.TierLevel = new EntityType { EntityTypeId = tierLevelValue };
employeeToSave.Laptop = new EntityType { EntityTypeId = laptopValue };
//Set Id's from hidden fields
employeeToSave.EmployeeId = Convert.ToInt32(EmployeeId.Value);
employeeToSave.PersonId = Convert.ToInt32(PersonId.Value);
//Call BLL to save to database
int employeeId = EmployeeBLL.Save(employeeToSave);
//Prints a page message if it is a success
if (employeeToSave.PersonId > 0 && employeeToSave.EmployeeId > 0)
{
this.DisplayLocalMessage("Update was successful.");
}
else
{
//Insert was successful - redirect back
Response.Redirect("EmployeeBasic.aspx?EmployeeId=" + employeeId.ToString());
}
}
/// <summary>
/// Initializes a new instance of the Game class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static Employee FillDataRecord(IDataRecord myDataRecord)
{
Employee myEmployeeObject = new Employee();
Entity myEntityObject = new Entity();
EntityType myEntityTypeObject = new EntityType();
myEmployeeObject.EmployeeId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("employeeId"));
myEmployeeObject.PersonId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("personId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("payRate")))
{
myEmployeeObject.PersonId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("personId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("firstName")))
{
myEmployeeObject.FirstName = myDataRecord.GetString(myDataRecord.GetOrdinal("firstName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("middleName")))
{
myEmployeeObject.MiddleName = myDataRecord.GetString(myDataRecord.GetOrdinal("middleName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("lastName")))
{
myEmployeeObject.LastName = myDataRecord.GetString(myDataRecord.GetOrdinal("lastName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("socialSecurityNumber")))
{
myEmployeeObject.SocialSecurityNumber = myDataRecord.GetString(myDataRecord.GetOrdinal("socialSecurityNumber"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("payRate")))
{
myEmployeeObject.PayRate = myDataRecord.GetInt32(myDataRecord.GetOrdinal("payRate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("background")))
{
myEmployeeObject.Background = myDataRecord.GetString(myDataRecord.GetOrdinal("background"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("driversLicenseNumber")))
{
myEmployeeObject.DriversLicenseNumber = myDataRecord.GetString(myDataRecord.GetOrdinal("driversLicenseNumber"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("birthDate")))
{
myEmployeeObject.BirthDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("birthDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("hireDate")))
{
myEmployeeObject.HireDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("hireDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("termDate")))
{
myEmployeeObject.TermDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("termDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("driversLicenceExpireDate")))
{
myEmployeeObject.DriversLicenseExpireDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("driversLicenceExpireDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Category Entity Id")))
{
myEntityTypeObject.Category = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Category Entity Id"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Tier Level Entity Id")))
{
myEntityTypeObject.TierLevel = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Tier Level Entity Id"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Laptop Entity Id")))
{
myEntityTypeObject.Laptop = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Laptop Entity Id"));
}
return myEmployeeObject;
}
public static int Save(Employee employeeToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
if (employeeToSave.EmployeeId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecuteEmployee", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@PersonId", employeeToSave.PersonId);
myCommand.Parameters.AddWithValue("@EmployeeId", employeeToSave.EmployeeId);
if (employeeToSave.HireDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@HireDate", employeeToSave.HireDate);
}
if (employeeToSave.TermDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@TermDate", employeeToSave.TermDate);
}
if (employeeToSave.PayRate != null)
{
myCommand.Parameters.AddWithValue("@PayRate", employeeToSave.PayRate);
}
if (employeeToSave.Background != null)
{
myCommand.Parameters.AddWithValue("@Background", employeeToSave.Background);
}
//Complex properties
if (employeeToSave.Category != null && employeeToSave.Category.EntityTypeId > 0)
{
myCommand.Parameters.AddWithValue("@Category", employeeToSave.Category.EntityTypeId);
}
if (employeeToSave.TierLevel != null && employeeToSave.TierLevel.EntityTypeId > 0)
{
myCommand.Parameters.AddWithValue("@TierLevel", employeeToSave.TierLevel.EntityTypeId);
}
if (employeeToSave.Laptop != null && employeeToSave.Laptop.EntityTypeId > 0)
{
myCommand.Parameters.AddWithValue("@Laptop", employeeToSave.Laptop.EntityTypeId);
}
//add return output parameter to command object
myCommand.Parameters.Add(HelperDAL.GetReturnParameterInt("ReturnValue"));
myConnection.Open();
myCommand.ExecuteNonQuery();
//Get return value from stored procedure and return Id
result = (int)myCommand.Parameters["@ReturnValue"].Value;
}
myConnection.Close();
}
return result;
}
private static void LessonSerialize()
{
Employee myEmployee = new Employee("Jesse", "Peterson");
XmlSerializer serializer = new XmlSerializer(typeof(Employee));
string xml;
using (StringWriter writer = new StringWriter())
{
serializer.Serialize(writer, myEmployee);
xml = writer.ToString();
}
System.Console.WriteLine(xml);
System.Console.ReadLine();
}
private static void LessonInheritance()
{
Employee myEmployee = new Employee();
myEmployee.EmployeeId = 1;
myEmployee.FirstName = "Bobby";
}
private static void LessonConstructors()
{
string firstName = "";
string lastName = "";
Employee myEmployee = new Employee(firstName, lastName);
Console.WriteLine(myEmployee.DisplayFullName());
Console.Read();
}