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