public List <Addresses> GetAddresses() { List <Addresses> retVal = new List <Addresses>(); try { AddressesBL addresses = new AddressesBL(_connString); tblAddresses = addresses.GetAddresses(); if (tblAddresses != null && tblAddresses.Rows.Count > 0) { foreach (DataRow row in tblAddresses.Rows) { Addresses address = new Addresses(_connString, Utils.DBNullToGuid(row["Address_ID"])); retVal.Add(address); } } } catch (Exception ex) { throw ex; } return(retVal); }
public bool Update_Address(Guid address_ID, Guid user_ID) { bool retVal = false; try { AddressesBL addresses = new AddressesBL(_connString); retVal = addresses.Update_Address(address_ID, _address_1, _address_2, _address_Town, _address_City, _address_County, _address_Postcode, _deleteAddress, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public Guid?Insert_Address(Guid user_ID) { Guid?retVal = null; try { AddressesBL addresses = new AddressesBL(_connString); retVal = addresses.Insert_Address(_address_1, _address_2, _address_Town, _address_City, _address_County, _address_Postcode, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public Addresses(Guid address_ID) { AddressesBL addresses = new AddressesBL(); tblAddresses = addresses.GetAddressByAddress_ID(address_ID); Address_ID = address_ID; Address_1 = tblAddresses[0].Address_1; if (!tblAddresses[0].IsAddress_2Null()) Address_2 = tblAddresses[0].Address_2; if (!tblAddresses[0].IsAddress_TownNull()) Address_Town = tblAddresses[0].Address_Town; if (!tblAddresses[0].IsAddress_CityNull()) Address_City = tblAddresses[0].Address_City; if (!tblAddresses[0].IsAddress_CountyNull()) Address_County = tblAddresses[0].Address_County; if (!tblAddresses[0].IsAddress_PostcodeNull()) Address_Postcode = tblAddresses[0].Address_Postcode; }
public Addresses(string connString, Guid address_ID) { _connString = connString; try { AddressesBL addresses = new AddressesBL(_connString); tblAddresses = addresses.GetAddressByAddress_ID(address_ID); DataRow row = tblAddresses.Rows[0]; _address_ID = address_ID; _address_1 = Utils.DBNullToString(row["Address_1"]); _address_2 = Utils.DBNullToString(row["Address_2"]); _address_Town = Utils.DBNullToString(row["Address_Town"]); _address_City = Utils.DBNullToString(row["Address_City"]); _address_County = Utils.DBNullToString(row["Address_County"]); _address_Postcode = Utils.DBNullToString(row["Address_Postcode"]); } catch (Exception ex) { throw ex; } }
public bool Update_Address(Guid address_ID, Guid user_ID) { bool success = false; AddressesBL addresses = new AddressesBL(); success = addresses.Update_Address(address_ID, Address_1, Address_2, Address_Town, Address_City, Address_County, Address_Postcode, DeleteAddress, user_ID); return success; }
public Guid? Insert_Address(Guid user_ID) { AddressesBL addresses = new AddressesBL(); Guid? newID = (Guid?)addresses.Insert_Address(Address_1, Address_2, Address_Town, Address_City, Address_County, Address_Postcode, user_ID); return newID; }
public List<Addresses> GetAddressesLikeAddress_Town(string address_Town) { List<Addresses> addressList = new List<Addresses>(); AddressesBL addresses = new AddressesBL(); tblAddresses = addresses.GetAddressesLikeAddress_Town(address_Town); if (tblAddresses != null && tblAddresses.Count > 0) { foreach (sss.tblAddressesRow row in tblAddresses) { Addresses address = new Addresses(row.Address_ID); addressList.Add(address); } } return addressList; }