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(); }