public static CartLocation GetBillingLocationByUserID(int user_id)
{
CartDB db = new CartDB();
DataSet ds = db.LoginGetBillingAddress(user_id);
if (ds != null)
{
using (DataTableReader data = ds.CreateDataReader())
{
if (data.Read())
{
int locationid = 0;
int cartid = 0;
int locationtype = 0;
string businessname = Helper.IsString(data.GetValue(data.GetOrdinal("BldgName")), "");
string fullname = Helper.IsString(data.GetValue(data.GetOrdinal("FullName")), "");
string address1 = Helper.IsString(data.GetValue(data.GetOrdinal("Address1")), "");
string address2 = Helper.IsString(data.GetValue(data.GetOrdinal("Address2")), "");
string city = Helper.IsString(data.GetValue(data.GetOrdinal("City")), "");
string statecode = Helper.IsString(data.GetValue(data.GetOrdinal("State")), "");
string postalcode = Helper.IsString(data.GetValue(data.GetOrdinal("Zip")), "");
string countrycode = Helper.IsString(data.GetValue(data.GetOrdinal("Country")), "");
string phone = Helper.IsString(data.GetValue(data.GetOrdinal("Phone")), "");
string email = Helper.IsString(data.GetValue(data.GetOrdinal("Email")), "");
DateTime datecreated = DateTime.Now;
DateTime lastupdated = DateTime.Now;
string Title = Helper.IsString(data.GetValue(data.GetOrdinal("Title")), "");
string AreaCode = Helper.IsString(data.GetValue(data.GetOrdinal("AreaCode")), "");
string PhoneExt = Helper.IsString(data.GetValue(data.GetOrdinal("PhoneExt")), "");
string Fax = Helper.IsString(data.GetValue(data.GetOrdinal("Fax")), "");
return new CartLocation(locationid, cartid, locationtype, businessname, fullname, address1, address2, city, statecode, postalcode, countrycode, phone, email, datecreated, lastupdated, Title, AreaCode, PhoneExt, Fax);
}
}
}
return null;
}
