// Get Address List \ public List <CAddress> GetAddressList(int intUserID = 0) { SqlConnection Connection = new SqlConnection(); List <CAddress> AddressList = new List <CAddress>(); try { if (OpenDBConnection(ref Connection) == 0) { SqlDataAdapter da = new SqlDataAdapter("uspSelectAddresses", Connection); if (intUserID > 0) { SetParameter(ref da, "@intUserID", intUserID, SqlDbType.Int); } else { SetParameter(ref da, "@intUserID", null, SqlDbType.Int); } da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; DataSet ds = new DataSet(); try { da.Fill(ds); foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { CAddress Address = new CAddress(); Address.intAddressID = Convert.ToInt32((dr["intAddressID"])); Address.strAddress = (dr["strStreetAddress"]).ToString(); Address.intStateID = Convert.ToInt32((dr["intStateID"])); Address.strCity = (dr["strCity"]).ToString(); Address.strZipCode = (dr["strZipCode"]).ToString(); AddressList.Add(Address); } } } finally { CloseDBConnection(ref Connection); } } return(AddressList); } catch (Exception ex) { throw new Exception(ex.Message); } }
public static CAddress GetDefaultAddress(int intUserId) { try { CDatabase db = new CDatabase(); CAddress Address = db.GetDefaultAddress(intUserId); return(Address); } catch (Exception) { return(null); } }
public int AddAddress(CAddress Address) { try { CDatabase Database = new CDatabase(); CCategories Category = new CCategories(); int intAddressID = Database.InsertAddress(Address); return(intAddressID); } catch (Exception ex) { throw new Exception(ex.Message); } }
// Insert Address \ public int InsertAddress(CAddress Address) { try { SqlConnection Connection = null; if (OpenDBConnection(ref Connection) == 0) { int intReturnID = 0; CUser User = new CUser(); User = User.GetCurrentUser(); SqlCommand cm = new SqlCommand("uspAddAddress", Connection); SetParameter(ref cm, "@intUserID", User.UserID, SqlDbType.Int); SetParameter(ref cm, "@strStreetAddress", Address.strAddress, SqlDbType.VarChar); SetParameter(ref cm, "@strCity", Address.strCity, SqlDbType.VarChar); SetParameter(ref cm, "@intStateID", Address.intStateID, SqlDbType.Int); SetParameter(ref cm, "@strZipCode", Address.strZipCode, SqlDbType.VarChar); SetParameter(ref cm, "ReturnValue", 0, SqlDbType.Int, Direction: ParameterDirection.ReturnValue); cm.ExecuteReader(); CloseDBConnection(ref Connection); if (!Convert.IsDBNull(cm.Parameters["ReturnValue"].Value)) { intReturnID = (int)cm.Parameters["ReturnValue"].Value; } return(intReturnID); //success } else { return(-1); // No database connection } } catch (Exception ex) { throw new Exception(ex.Message); } }
public int DoesAddressExist(CAddress NewAddress) { try { CDatabase db = new CDatabase(); List <CAddress> AddressList = db.GetAddressList(); foreach (CAddress Address in AddressList) { if (NewAddress.intStateID == Address.intStateID && NewAddress.strAddress == Address.strAddress && NewAddress.strCity == Address.strCity && NewAddress.strZipCode == Address.strZipCode) { return(Address.intAddressID); // match found } } return(0); // No match found } catch (Exception) { return(-1); // Failure } }