code_junkie

Class Design Help Needed

Nov 13th, 2011
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.04 KB | None | 0 0
  1. public class Person
  2. {
  3. private string id;
  4. private string currentLastName;
  5. private string currentFirstName;
  6. private string currentMiddleName;
  7. private string currentSuffixtName;
  8.  
  9. private string formerLastName;
  10. private string formerFirstName;
  11. private string formerMiddleName;
  12. private string formerSuffixtName;
  13.  
  14. private string currentAddressNumber;
  15. private string currentAddressDirection;
  16. private string currentAddressStreet;
  17. private string currentAddressStreetType;
  18. private string currentAddressAptNum;
  19. private string currentAddressrCity;
  20. private string currentAddressState;
  21. private string currentAddressZipcode;
  22. private string currentAddressCounty;
  23.  
  24. private string formerAddressNumber;
  25. private string formerAddressDirection;
  26. private string formerAddressStreet;
  27. private string formerAddressStreetType;
  28. private string formerAddressAptNum;
  29. private string formerAddressrCity;
  30. private string formerAddressState;
  31. private string formerAddressZipcode;
  32. private string formerAddressCounty;
  33.  
  34. private string mailAddressLineOne;
  35. private string mailAddressLineTwo;
  36. private string mailAddressLineThree;
  37.  
  38. private DateTime birthdate;
  39. private string gender;
  40. private string HomePhone;
  41. private string WorkPhone;
  42. private string CellPhone;
  43. private string FaxNumber;
  44. private string driversLicense;
  45. private string ssNumber;
  46. private string membershipType;
  47. private DateTime registrationDate;
  48. private string ipAddress;
  49. private string browserInfo;
  50. }
  51.  
  52. public interface IName
  53. {
  54. string getLastName();
  55. string getFirstName();
  56. string getMiddleName();
  57. string getSuffixName();
  58. }
  59.  
  60. public class Name : IName
  61. {
  62. private string _lastName;
  63. private string _firstName;
  64. private string _middleName;
  65. private string _suffixName;
  66.  
  67. // Validation Methods
  68. // private set methods
  69.  
  70. //#region IName Members
  71. }
  72.  
  73.  
  74. public interface IAddress
  75. {
  76. string getAddressNumber();
  77. string getAddressDirection();
  78. string getAddressStreet();
  79. string getAddressStreetType();
  80. string getAddressAptNum();
  81. string getAddressCity();
  82. string getAddressState();
  83. string getAddressZipcode();
  84. string getAddressCounty();
  85. }
  86.  
  87. public class Address : IAddress
  88. {
  89. private string _addressNumber;
  90. private string _addressDirection;
  91. private string _addressStreet;
  92. private string _addressStreetType;
  93. private string _addressAptNum;
  94. private string _addressrCity;
  95. private string _addressState;
  96. private string _addressZipcode;
  97. private string _addressCounty;
  98.  
  99. // Validation Methods
  100. // private Set Methods
  101. // public get methods
  102.  
  103.  
  104. //#region IAddress Members
  105. }
  106. public interface IPerson
  107. {
  108. int getId();
  109. IName getCurrentName();
  110. IName getFormerName();
  111.  
  112. IAddress getCurrentAddress();
  113. IAddress getFormerAddress();
  114. IAddress getMailingAddress();
  115.  
  116. DateTime getBirthdate();
  117. string getGender();
  118. string getSSNumber();
  119. string getPersonType();
  120. DateTime getRegistrationDate();
  121. string getIPAddress();
  122. string getBrowserInfo();
  123. string getDriversLicense();
  124.  
  125. string getHomePhone();
  126. string getWorkPhone();
  127. string getCellPhone();
  128. string getFaxNumber();
  129. string getEmailAddress();
  130. string getSecondaryEmailAddress();
  131.  
  132. bool save();
  133. void load();
  134.  
  135. }
  136.  
  137. public class Person : IPerson
  138. {
  139. private int _id;
  140. private IName _currentName;
  141. private IName _formerName;
  142.  
  143. private IAddress _currentAddress;
  144. private IAddress _formerAddress;
  145. private IAddress _mailingAddress;
  146.  
  147. private DateTime _birthdate;
  148. private string _gender;
  149. private string _ssNumber;
  150. private string _personType;
  151. private DateTime _registrationDate;
  152. private string _ipAddress;
  153. private string _browserInfo;
  154. private string _driversLicense;
  155.  
  156. private string _homePhone;
  157. private string _workPhone;
  158. private string _cellPhone;
  159. private string _faxNumber;
  160. private string _emailAddress;
  161. private string _secondaryEmailAddress;
  162.  
  163.  
  164. // private set methods
  165.  
  166. // #region IPerson Members
  167. // .... Get Methods
  168. public bool save()
  169. {
  170. DataLayer dl = new DataLayer();
  171. if (_id == 0)
  172. return dl.insertPerson(this);
  173. else
  174. return dl.updatePerson(this);
  175. }
  176. }
  177.  
  178. public bool insertPerson(IPerson person)
  179. {
  180. bool inserted = false;
  181. SqlConnection cnDB = DatabaseConnection.GetOpenDBConnection();
  182. try
  183. {
  184. SqlCommand cmDB = new SqlCommand("sp_InsertName", cnDB);
  185. cmDB.CommandType = CommandType.StoredProcedure;
  186. cmDB.Parameters.Add("@last_name", System.Data.SqlDbType.VarChar, 50);
  187. cmDB.Parameters["@last_name"].Value = person.getCurrentName().getLastName();
  188. cmDB.Parameters.Add("@first_name", System.Data.SqlDbType.VarChar, 50);
  189. cmDB.Parameters["@first_name"].Value = person.getCurrentName().getFirstName();
  190. cmDB.Parameters.Add("@middle_name", System.Data.SqlDbType.VarChar, 50);
  191. cmDB.Parameters["@middle_name"].Value = person.getCurrentName().getMiddleName();
  192. cmDB.Parameters.Add("@suffix_name", System.Data.SqlDbType.VarChar, 50);
  193. cmDB.Parameters["@suffix_name"].Value = person.getCurrentName().getSuffixName();
  194. int id = cmDB.ExecuteNonQuery();
  195.  
  196. cmDB = new SqlCommand("sp_InsertName", cnDB);
  197. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  198. cmDB.Parameters["@person_id"].Value = id;
  199. cmDB.Parameters.Add("@last_name", System.Data.SqlDbType.VarChar, 50);
  200. cmDB.Parameters["@last_name"].Value = person.getFormerName().getLastName();
  201. cmDB.Parameters.Add("@former_first_name", System.Data.SqlDbType.VarChar, 50);
  202. cmDB.Parameters["@former_first_name"].Value = person.getFormerName().getFirstName();
  203. cmDB.Parameters.Add("@middle_name", System.Data.SqlDbType.VarChar, 50);
  204. cmDB.Parameters["@middle_name"].Value = person.getFormerName().getMiddleName();
  205. cmDB.Parameters.Add("@suffix_name", System.Data.SqlDbType.VarChar, 50);
  206. cmDB.Parameters["@suffix_name"].Value = person.getFormerName().getSuffixName();
  207. cmDB.ExecuteNonQuery();
  208.  
  209. // Insert Current Address
  210.  
  211. cmDB = new SqlCommand("sp_InsertAddress", cnDB);
  212. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  213. cmDB.Parameters["@person_id"].Value = id;
  214. cmDB.Parameters.Add("@address_number", System.Data.SqlDbType.VarChar, 50);
  215. cmDB.Parameters["@address_number"].Value = person.getCurrentAddress().getAddressNumber();
  216. cmDB.Parameters.Add("@address_direction", System.Data.SqlDbType.VarChar, 50);
  217. cmDB.Parameters["@address_direction"].Value = person.getCurrentAddress().getAddressDirection();
  218. cmDB.Parameters.Add("@address_street", System.Data.SqlDbType.VarChar, 50);
  219. cmDB.Parameters["@address_street"].Value = person.getCurrentAddress().getAddressStreet();
  220. cmDB.Parameters.Add("@address_street_type", System.Data.SqlDbType.VarChar, 50);
  221. cmDB.Parameters["@address_street_type"].Value = person.getCurrentAddress().getAddressStreetType();
  222. cmDB.Parameters.Add("@address_apt_number", System.Data.SqlDbType.VarChar, 50);
  223. cmDB.Parameters["@address_apt_number"].Value = person.getCurrentAddress().getAddressAptNum();
  224. cmDB.Parameters.Add("@address_city", System.Data.SqlDbType.VarChar, 50);
  225. cmDB.Parameters["@address_city"].Value = person.getCurrentAddress().getAddressCity();
  226. cmDB.Parameters.Add("@address_state", System.Data.SqlDbType.VarChar, 50);
  227. cmDB.Parameters["@address_state"].Value = person.getCurrentAddress().getAddressCity();
  228. cmDB.Parameters.Add("@address_zipcode", System.Data.SqlDbType.VarChar, 50);
  229. cmDB.Parameters["@address_zipcode"].Value = person.getCurrentAddress().getAddressZipcode();
  230. cmDB.Parameters.Add("@address_county", System.Data.SqlDbType.VarChar, 50);
  231. cmDB.Parameters["@address_county"].Value = person.getCurrentAddress().getAddressCounty();
  232. cmDB.ExecuteNonQuery();
  233.  
  234. // Insert Former Address
  235.  
  236. cmDB = new SqlCommand("sp_InsertAddress", cnDB);
  237. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  238. cmDB.Parameters["@person_id"].Value = id;
  239. cmDB.Parameters.Add("@address_number", System.Data.SqlDbType.VarChar, 50);
  240. cmDB.Parameters["@address_number"].Value = person.getFormerAddress().getAddressNumber();
  241. cmDB.Parameters.Add("@address_direction", System.Data.SqlDbType.VarChar, 50);
  242. cmDB.Parameters["@address_direction"].Value = person.getFormerAddress().getAddressDirection();
  243. cmDB.Parameters.Add("@address_street", System.Data.SqlDbType.VarChar, 50);
  244. cmDB.Parameters["@address_street"].Value = person.getFormerAddress().getAddressStreet();
  245. cmDB.Parameters.Add("@address_street_type", System.Data.SqlDbType.VarChar, 50);
  246. cmDB.Parameters["@address_street_type"].Value = person.getFormerAddress().getAddressStreetType();
  247. cmDB.Parameters.Add("@address_apt_number", System.Data.SqlDbType.VarChar, 50);
  248. cmDB.Parameters["@address_apt_number"].Value = person.getFormerAddress().getAddressAptNum();
  249. cmDB.Parameters.Add("@address_city", System.Data.SqlDbType.VarChar, 50);
  250. cmDB.Parameters["@address_city"].Value = person.getFormerAddress().getAddressCity();
  251. cmDB.Parameters.Add("@address_state", System.Data.SqlDbType.VarChar, 50);
  252. cmDB.Parameters["@address_state"].Value = person.getFormerAddress().getAddressCity();
  253. cmDB.Parameters.Add("@address_zipcode", System.Data.SqlDbType.VarChar, 50);
  254. cmDB.Parameters["@address_zipcode"].Value = person.getFormerAddress().getAddressZipcode();
  255. cmDB.Parameters.Add("@address_county", System.Data.SqlDbType.VarChar, 50);
  256. cmDB.Parameters["@address_county"].Value = person.getFormerAddress().getAddressCounty();
  257. cmDB.ExecuteNonQuery();
  258.  
  259. // Insert Mailing Address
  260.  
  261. cmDB = new SqlCommand("sp_InsertAddress", cnDB);
  262. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  263. cmDB.Parameters["@person_id"].Value = id;
  264. cmDB.Parameters.Add("@address_number", System.Data.SqlDbType.VarChar, 50);
  265. cmDB.Parameters["@address_number"].Value = person.getMailingAddress().getAddressNumber();
  266. cmDB.Parameters.Add("@address_direction", System.Data.SqlDbType.VarChar, 50);
  267. cmDB.Parameters["@address_direction"].Value = person.getMailingAddress().getAddressDirection();
  268. cmDB.Parameters.Add("@address_street", System.Data.SqlDbType.VarChar, 50);
  269. cmDB.Parameters["@address_street"].Value = person.getMailingAddress().getAddressStreet();
  270. cmDB.Parameters.Add("@address_street_type", System.Data.SqlDbType.VarChar, 50);
  271. cmDB.Parameters["@address_street_type"].Value = person.getMailingAddress().getAddressStreetType();
  272. cmDB.Parameters.Add("@address_apt_number", System.Data.SqlDbType.VarChar, 50);
  273. cmDB.Parameters["@address_apt_number"].Value = person.getMailingAddress().getAddressAptNum();
  274. cmDB.Parameters.Add("@address_city", System.Data.SqlDbType.VarChar, 50);
  275. cmDB.Parameters["@address_city"].Value = person.getMailingAddress().getAddressCity();
  276. cmDB.Parameters.Add("@address_state", System.Data.SqlDbType.VarChar, 50);
  277. cmDB.Parameters["@address_state"].Value = person.getMailingAddress().getAddressCity();
  278. cmDB.Parameters.Add("@address_zipcode", System.Data.SqlDbType.VarChar, 50);
  279. cmDB.Parameters["@address_zipcode"].Value = person.getMailingAddress().getAddressZipcode();
  280. cmDB.Parameters.Add("@address_county", System.Data.SqlDbType.VarChar, 50);
  281. cmDB.Parameters["@address_county"].Value = person.getMailingAddress().getAddressCounty();
  282. cmDB.ExecuteNonQuery();
  283.  
  284. // insert Personal Info
  285.  
  286. cmDB = new SqlCommand("sp_InsertPersonalInfo", cnDB);
  287. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  288. cmDB.Parameters["@person_id"].Value = id;
  289. cmDB.Parameters.Add("@birthdate", System.Data.SqlDbType.DateTime);
  290. cmDB.Parameters["@birthdate"].Value = person.getBirthdate();
  291. cmDB.Parameters.Add("@gender", System.Data.SqlDbType.VarChar, 1);
  292. cmDB.Parameters["@gender"].Value = person.getGender();
  293. cmDB.Parameters.Add("@ss_number", System.Data.SqlDbType.VarChar, 20);
  294. cmDB.Parameters["@ss_number"].Value = person.getSSNumber();
  295. cmDB.Parameters.Add("@person_type", System.Data.SqlDbType.VarChar, 20);
  296. cmDB.Parameters["@person_type"].Value = person.getPersonType();
  297. cmDB.Parameters.Add("@registration_date", System.Data.SqlDbType.DateTime);
  298. cmDB.Parameters["@registration_date"].Value = person.getRegistrationDate();
  299. cmDB.Parameters.Add("@ip_address", System.Data.SqlDbType.VarChar, 20);
  300. cmDB.Parameters["@ip_address"].Value = person.getIPAddress();
  301. cmDB.Parameters.Add("@browser_info", System.Data.SqlDbType.VarChar, 20);
  302. cmDB.Parameters["@browser_info"].Value = person.getBrowserInfo();
  303. cmDB.Parameters.Add("@drivers_license", System.Data.SqlDbType.VarChar, 20);
  304. cmDB.Parameters["@drivers_license"].Value = person.getDriversLicense();
  305. cmDB.ExecuteNonQuery();
  306.  
  307. //insert email address contact type
  308. cmDB = new SqlCommand("sp_InsertContactType", cnDB);
  309. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  310. cmDB.Parameters["@person_id"].Value = id;
  311. cmDB.Parameters.Add("@contact_type", System.Data.SqlDbType.VarChar, 50);
  312. cmDB.Parameters["@contact_type"].Value = "Email";
  313. cmDB.Parameters.Add("@contact", System.Data.SqlDbType.VarChar, 50);
  314. cmDB.Parameters["@gender"].Value = person.getEmailAddress();
  315. cmDB.ExecuteNonQuery();
  316.  
  317. //insert secondary email address contact type
  318. cmDB = new SqlCommand("sp_InsertContactType", cnDB);
  319. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  320. cmDB.Parameters["@person_id"].Value = id;
  321. cmDB.Parameters.Add("@contact_type", System.Data.SqlDbType.VarChar, 50);
  322. cmDB.Parameters["@contact_type"].Value = "Secondary Email";
  323. cmDB.Parameters.Add("@contact", System.Data.SqlDbType.VarChar, 50);
  324. cmDB.Parameters["@gender"].Value = person.getSecondaryEmailAddress();
  325. cmDB.ExecuteNonQuery();
  326.  
  327. //insert home phone contact type
  328. cmDB = new SqlCommand("sp_InsertContactType", cnDB);
  329. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  330. cmDB.Parameters["@person_id"].Value = id;
  331. cmDB.Parameters.Add("@contact_type", System.Data.SqlDbType.VarChar, 50);
  332. cmDB.Parameters["@contact_type"].Value = "Home Phone";
  333. cmDB.Parameters.Add("@contact", System.Data.SqlDbType.VarChar, 50);
  334. cmDB.Parameters["@contact"].Value = person.getHomePhone();
  335. cmDB.ExecuteNonQuery();
  336.  
  337. //insert work phone contact type
  338. cmDB = new SqlCommand("sp_InsertContactType", cnDB);
  339. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  340. cmDB.Parameters["@person_id"].Value = id;
  341. cmDB.Parameters.Add("@contact_type", System.Data.SqlDbType.VarChar, 50);
  342. cmDB.Parameters["@contact_type"].Value = "Work Phone";
  343. cmDB.Parameters.Add("@contact", System.Data.SqlDbType.VarChar, 50);
  344. cmDB.Parameters["@contact"].Value = person.getWorkPhone();
  345. cmDB.ExecuteNonQuery();
  346.  
  347. //insert cell phone contact type
  348. cmDB = new SqlCommand("sp_InsertContactType", cnDB);
  349. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  350. cmDB.Parameters["@person_id"].Value = id;
  351. cmDB.Parameters.Add("@contact_type", System.Data.SqlDbType.VarChar, 50);
  352. cmDB.Parameters["@contact_type"].Value = "Cell Phone";
  353. cmDB.Parameters.Add("@contact", System.Data.SqlDbType.VarChar, 50);
  354. cmDB.Parameters["@contact"].Value = person.getCellPhone();
  355. cmDB.ExecuteNonQuery();
  356.  
  357. //insert cell phone contact type
  358. cmDB = new SqlCommand("sp_InsertContactType", cnDB);
  359. cmDB.Parameters.Add("@person_id", System.Data.SqlDbType.Int);
  360. cmDB.Parameters["@person_id"].Value = id;
  361. cmDB.Parameters.Add("@contact_type", System.Data.SqlDbType.VarChar, 50);
  362. cmDB.Parameters["@contact_type"].Value = "Fax Number";
  363. cmDB.Parameters.Add("@contact", System.Data.SqlDbType.VarChar, 50);
  364. cmDB.Parameters["@contact"].Value = person.getFaxNumber();
  365. cmDB.ExecuteNonQuery();
  366.  
  367.  
  368. inserted = true;
  369. }
  370. catch (SqlException sqlEx)
  371. {
  372. throw new Exception(GetSqlExceptionMessage(sqlEx.Number));
  373. }
  374. catch (Exception ex)
  375. {
  376. throw ex;
  377. }
  378. finally
  379. {
  380. if (cnDB.State == ConnectionState.Open)
  381. cnDB.Close();
  382. }
  383. return inserted;
  384. }
  385.  
  386. public class DALLayer
  387. {
  388. public void InsertPerson(Person p)
  389. {
  390. using (SqlCommand sqlCmd=CreateNewCommand())
  391. {
  392. AddPersonParams(p,sqlCmd);
  393. sqlCmd.ExecuteNonQuery();
  394. }
  395. }
  396.  
  397. public void UpdatePerson(Person p)
  398. {
  399. using (SqlCommand sqlCmd=CreateNewCommand())
  400. {
  401. AddPersonParams(p,sqlCmd);
  402. //We add the Id since we have it in updates but not in inserts
  403. sqlCmd.AddParameter("@PersonId",p.Id);
  404. sqlCmd.ExecuteNonQuery();
  405. }
  406.  
  407. }
  408.  
  409. private void AddPersonParams(Person p, Sqlcommand sqlCmd)
  410. {
  411. //Do all the code to add Params which exists in both insert and updates
  412. }
  413.  
  414. }
  415.  
  416. private void InserAddress(Address address, int Id, AddressType addType)
  417. {
  418.  
  419. }
  420.  
  421. InsertAddress(p.CurrentAddress,id,CurrentAddress);
  422. InsertAddress(p.FormerAddress,id,FormerAddress);
  423.  
  424. public void Save()
  425. {
  426. string.IsNullOrEmpty(Id) ? Insert() : Update();
  427. }
  428.  
  429. using System;
  430. public class PersonName
  431. {
  432. public string Id { get; set; }
  433.  
  434. public string Last { get; set; }
  435. public string First{ get; set; }
  436. public string Middle{ get; set; }
  437. public string Suffix { get; set; }
  438. }
  439.  
  440. public class PersonNameRepository
  441. {
  442. public void Insert(PersonName pa)
  443. {
  444. SqlCommand cmDB = new SqlCommand("sp_InsertName", cnDB);
  445. cmDB.CommandType = CommandType.StoredProcedure;
  446. cmDB.Parameters.Add("@last_name", System.Data.SqlDbType.VarChar, 50);
  447. cmDB.Parameters["@last_name"].Value = pa.Last;
  448. cmDB.Parameters.Add("@first_name", System.Data.SqlDbType.VarChar, 50);
  449. cmDB.Parameters["@first_name"].Value = pa.First;
  450. cmDB.Parameters.Add("@middle_name", System.Data.SqlDbType.VarChar, 50);
  451. cmDB.Parameters["@middle_name"].Value = pa.Middle;
  452. cmDB.Parameters.Add("@suffix_name", System.Data.SqlDbType.VarChar, 50);
  453. cmDB.Parameters["@suffix_name"].Value = pa.Suffix;
  454. int id = cmDB.ExecuteNonQuery();
  455. pa.Id = id.ToString();
  456. }
  457. }
  458.  
  459. public class PersonAddress
  460. {
  461. public string Id { get; set; }
  462.  
  463. public string Number { get; set; }
  464. public string Direction { get; set; }
  465. public string Street { get; set; }
  466. public string City { get; set; }
  467. }
  468.  
  469. public class PersonAddressRepository
  470. {
  471. public void Insert(PersonAddress pa)
  472. {
  473. // Same as PersonNameRepository
  474. }
  475. }
  476.  
  477.  
  478. public class PersonInfo
  479. {
  480. public string Id { get; set; }
  481.  
  482. public DateTime BirthDate { get; set; }
  483. public string Gender { get; set; }
  484. public string SsNumber { get; set; }
  485.  
  486. }
  487.  
  488. public class PersonInfoRepository
  489. {
  490. public void Insert(PersonInfo pa)
  491. {
  492. // Same as PersonNameRepository
  493. }
  494. }
  495. public class Person
  496. {
  497. public string Id { get; set; }
  498. public PersonName CurrentName { get; set; }
  499. public PersonName FormerName { get; set; }
  500.  
  501. public PersonAddress CurrentAddress { get; set; }
  502. public PersonAddress FormerAddress { get; set; }
  503.  
  504. public PersonInfo Info { get; set; }
  505. }
  506.  
  507. public class PersonRepository
  508. {
  509. public void Insert(Person p)
  510. {
  511. // TODO: Begin Transaction
  512.  
  513. p.CurrentName.Insert();
  514. p.FormerName.Insert();
  515. p.CurrentAddress.Insert();
  516. p.FormerAddress.Insert();
  517. p.Info.Insert();
  518.  
  519. SqlCommand cmDB = new SqlCommand("sp_InsertPerson", cnDB);
  520. cmDB.CommandType = CommandType.StoredProcedure;
  521. cmDB.Parameters.Add("@current_name_id", System.Data.SqlDbType.VarChar, 50);
  522. cmDB.Parameters["@current_name_id"].Value = p.CurrentName.Id;
  523. cmDB.Parameters.Add("@former_name_id", System.Data.SqlDbType.VarChar, 50);
  524. cmDB.Parameters["@former_name_id"].Value = p.FormerName.Id; ;
  525. cmDB.Parameters.Add("@current_address_id", System.Data.SqlDbType.VarChar, 50);
  526. cmDB.Parameters["@current_address_id"].Value = p.CurrentAddress.Id;
  527. cmDB.Parameters.Add("@former_address_id", System.Data.SqlDbType.VarChar, 50);
  528. cmDB.Parameters["@former_address_id"].Value = p.FormerAddress.Id;
  529. cmDB.Parameters.Add("@info_id", System.Data.SqlDbType.VarChar, 50);
  530. cmDB.Parameters["@info_id"].Value = p.Info.Id;
  531. int id = cmDB.ExecuteNonQuery();
  532. pa.Id = id.ToString();
  533.  
  534. // TODO: End Transaction
  535. }
  536.  
  537. }
  538.  
  539. public class Name : IName
  540. {
  541. private string _lastName;
  542. private string _firstName;
  543. private string _middleName;
  544. private string _suffixName;
  545.  
  546. public string LastName { get { return _lastName; } }
  547.  
  548. //Alternative automatic property:
  549. public string FirstName { get; protected set; }
  550. }
Add Comment
Please, Sign In to add comment