// 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
}
}
