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(Person personToSave)
{
int returnValue;
returnValue = PersonDAL.Save(personToSave);
return returnValue;
}
public static int Save(Person personToSave)
{
ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem;
int result = 0;
//Check for valid personId - if exists, Update else Insert
if (personToSave.PersonId > 0)
{
queryId = ExecuteTypeEnum.UpdateItem;
}
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_ExecutePerson", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", queryId);
myCommand.Parameters.AddWithValue("@PersonId", personToSave.PersonId);
if (personToSave.FirstName != null)
{
myCommand.Parameters.AddWithValue("@FirstName", personToSave.FirstName);
}
if (personToSave.MiddleName != null)
{
myCommand.Parameters.AddWithValue("@MiddleName", personToSave.MiddleName);
}
if (personToSave.LastName != null)
{
myCommand.Parameters.AddWithValue("@LastName", personToSave.LastName);
}
if (personToSave.BirthDate != DateTime.MinValue)
{
myCommand.Parameters.AddWithValue("@BirthDate", personToSave.BirthDate);
}
if (personToSave.SocialSecurityNumber != null)
{
myCommand.Parameters.AddWithValue("@SocialSecurityNumber", personToSave.SocialSecurityNumber);
}
//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 = Convert.ToInt32(myCommand.Parameters["@ReturnValue"].Value);
}
myConnection.Close();
}
return result;
}
private static void testClasses()
{
Person myPerson = new Person();
myPerson.PersonId = 1;
myPerson.Title = "Mr.";
myPerson.FirstName = "Jesse";
myPerson.LastName = "Peterson";
myPerson.Gender = "M";
int Id = 1;
string title = "Mr.";
string fName = "Jesse";
string lName = "Peterson";
string displayFName = "Jessifer";
string gender = "M";
Console.WriteLine(myPerson.displayPersonAttributes(Id, title, fName, lName, displayFName, gender));
Console.Read();
}
