public static int Save(int employeeId, PhysicalAddress addressTosave) { int result = 0; ExecuteTypeEnum queryId = ExecuteTypeEnum.InsertItem; //check for Valid Person - if existis, UPDATE else INSERT // 10 = INSERT_ITEM //20 = UPDATE_ITEM if (addressTosave.AddressId > 0) queryId = ExecuteTypeEnum.UpdateItem; using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("usp_ExecuteAddress", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.AddWithValue("@QueryId", queryId); myCommand.Parameters.AddWithValue("@AddressId", addressTosave.AddressId); //myCommand.Parameters.AddWithValue("@employeeId", employeeId); if (addressTosave.ClientId > 0) myCommand.Parameters.AddWithValue("@ClientId", addressTosave.ClientId); if (addressTosave.PersonId > 0) myCommand.Parameters.AddWithValue("@PersonId", addressTosave.PersonId); if (addressTosave.AddressType.EntityTypeId >0) myCommand.Parameters.AddWithValue("@EntityTypeId", addressTosave.AddressType.EntityTypeId); if (addressTosave.AddressNumber != null) myCommand.Parameters.AddWithValue("@AddressNumber", addressTosave.AddressNumber); if (addressTosave.Street != null) myCommand.Parameters.AddWithValue("@Street", addressTosave.Street); if (addressTosave.ZipCode != null) myCommand.Parameters.AddWithValue("@ZipCode", addressTosave.ZipCode); if (addressTosave.City != null) myCommand.Parameters.AddWithValue("@City", addressTosave.City); if (addressTosave.StateId != null) myCommand.Parameters.AddWithValue("@StateId", addressTosave.StateId); //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 void ProcessAddress() { PhysicalAddress addressToSave = new PhysicalAddress(); addressToSave.AddressNumber = AddressNumber.Text; addressToSave.Street = Street.Text; addressToSave.ZipCode = ZipCode.Text; addressToSave.City = City.Text; addressToSave.StateId = State.Text; addressToSave.AddressType = new EntityType { EntityTypeId = AddressTypeList.SelectedItem.Value.ToInt() }; //Notes: Set Id's from Hidden Values addressToSave.AddressId = AddressId.Value.ToInt(); //addressToSave.ClientId = ClientId.Value.ToInt(); EmployeeBO SlectedPerson = EmployeeManager.GetItem(base.EmployeeId); addressToSave.PersonId = SlectedPerson.PersonId; //Notes: Call Manager to Save PhysicalAddressManager.Save(base.EmployeeId, addressToSave); //notes: outputs string value to the label control if (addressToSave.AddressId > 0 && addressToSave.PersonId > 0) { //notes: Update Successful Response.Redirect("Address.aspx?EmployeeId=" + _employeeId.ToString()); } else { //Notes: Insert successsful - redirect back Response.Redirect("Address.aspx?EmployeeId=" + _employeeId.ToString()); } }
private static PhysicalAddress FillDataRecord(IDataRecord myDataRecord) { PhysicalAddress myObject = new PhysicalAddress(); myObject.PersonId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("PersonId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("ClientId"))) myObject.ClientId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("ClientId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("AddressId"))) myObject.AddressId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("AddressId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("AddressNumber"))) myObject.AddressNumber = myDataRecord.GetString(myDataRecord.GetOrdinal("AddressNumber")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Street"))) myObject.Street = myDataRecord.GetString(myDataRecord.GetOrdinal("Street")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("ZipCode"))) myObject.ZipCode = myDataRecord.GetString(myDataRecord.GetOrdinal("ZipCode")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("City"))) myObject.City = myDataRecord.GetString(myDataRecord.GetOrdinal("City")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("StateId"))) myObject.StateId = myDataRecord.GetString(myDataRecord.GetOrdinal("StateId")); if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("DateCreate"))) myObject.CreateDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("DateCreate")); //entityType AddressType if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("EntityTypeValue"))) myObject.AddressType = new EntityType { EntityTypeValue = myDataRecord.GetString(myDataRecord.GetOrdinal("EntityTypeValue")) }; return myObject; }
public static int Save(int employeeId, PhysicalAddress addressTosave) { //call DAL to save employy info return PhysicalAddressDAL.Save(employeeId,addressTosave); }