//{ // get { return "http://maps.google.com/preview?q=" + _StrGoogleString; } //} /// <summary> /// Creates Empty caddress class object /// </summary> public cAddress() { AddressID = -1; SortedList sParams = new SortedList(); DataTable dtAddressTypes = cUtilities.LoadDataTable("uspGetAddressTypes", sParams, "LARPortal", "", "cAddress.Creator"); AddressTypes = new List <cAddressType>(); if (new DataView(dtAddressTypes, "AddressTypeID = 0", "", DataViewRowState.CurrentRows).Count == 0) { cAddressType NewAddress = new cAddressType(); NewAddress.AddressTypeID = 0; NewAddress.AddressType = "Choose..."; AddressTypes.Add(NewAddress); } foreach (DataRow dRow in dtAddressTypes.Rows) { cAddressType NewAddress = new cAddressType(); NewAddress.AddressTypeID = dRow["AddressTypeID"].ToString().ToInt32(); NewAddress.AddressType = dRow["AddressType"].ToString(); AddressTypes.Add(NewAddress); } AddressTypeID = 0; }
private void LoadAddresses(DataTable AddressInfo, DataTable AddressType, string sLoginName) { MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; // First create a list of address types. This will be copied into each record. List <cAddressType> AddTypes = new List <cAddressType>(); foreach (DataRow dRow in AddressType.Rows) { cAddressType NewType = new cAddressType(); NewType.AddressType = dRow["AddressType"].ToString(); int iTemp; if (int.TryParse(dRow["AddressTypeID"].ToString(), out iTemp)) { NewType.AddressTypeID = iTemp; } AddTypes.Add(NewType); } UserAddresses = new List <cAddress>(); PrimaryAddress = new cAddress(); foreach (DataRow dRow in AddressInfo.Rows) { cAddress NewAdd = new cAddress(); NewAdd.AddressTypes.AddRange(AddTypes); NewAdd.Address1 = dRow["Address1"].ToString(); NewAdd.Address2 = dRow["Address2"].ToString(); NewAdd.City = dRow["City"].ToString(); NewAdd.StateID = dRow["StateID"].ToString(); NewAdd.PostalCode = dRow["PostalCode"].ToString(); NewAdd.Country = dRow["Country"].ToString(); NewAdd.UserName = sLoginName; int iTemp; if (int.TryParse(dRow["AddressID"].ToString(), out iTemp)) { NewAdd.AddressID = iTemp; } if (int.TryParse(dRow["AddressTypeID"].ToString(), out iTemp)) { NewAdd.AddressTypeID = iTemp; } bool bTemp; if (bool.TryParse(dRow["PrimaryAddress"].ToString(), out bTemp)) { NewAdd.IsPrimary = true; PrimaryAddress = NewAdd; } else { NewAdd.IsPrimary = false; } UserAddresses.Add(NewAdd); } }
/// <summary> /// Creates a caddress class object from data stored in the database with the Address ID provided /// </summary> /// <param name="intAddressID">ID for Address</param> /// <param name="userName">User ID</param> /// public cAddress(Int32 intAddressID, string strUserNameParam, int intuserID) { UserName = strUserNameParam; MethodBase lmth = MethodBase.GetCurrentMethod(); // this is where we use refelection to store the name of the method and class to use it to report errors string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; //so lets say we wanted to load data into this class from a sql query called uspGetSomeData thats take two paraeters @Parameter1 and @Parameter2 SortedList slParams = new SortedList(); // I use a sortedlist wich is a C# hash table to store the paramter and value slParams.Add("@intAddressID", intAddressID); try { DataSet lds = cUtilities.LoadDataSet("uspGetAddress", slParams, "LARPortal", UserName, lsRoutineName); if (lds.Tables[0].Rows.Count > 0) { DataRow dRow = lds.Tables[0].Rows[0]; AddressID = intAddressID;//Table MDBAddresses if (dRow["Address1"] != null) { Address1 = dRow["Address1"].ToString(); } if (dRow["Address2"] != null) { Address2 = dRow["Address2"].ToString(); } if (dRow["City"] != null) { City = dRow["City"].ToString(); } if (dRow["StateID"] != null) { StateID = dRow["StateID"].ToString(); } if (dRow["AddressTypeID"] != null) { AddressTypeID = (Int32)dRow["AddressTypeID"]; } if (dRow["PrimaryAddress"] != null) { IsPrimary = (bool)dRow["PrimaryAddress"]; } if (dRow["PostalCode"] != null) { PostalCode = dRow["PostalCode"].ToString(); } if (dRow["Country"] != null) { Country = dRow["Country"].ToString(); } //if (ldt.Rows[0]["MDBStatesStateName"] != null) { _StateName = ldt.Rows[0]["MDBStatesStateName"].ToString(); } //Table Table MDBStates DateTime dtTemp; if (DateTime.TryParse(dRow["DateAdded"].ToString(), out dtTemp)) { DateAdded = dtTemp; } if (DateTime.TryParse(dRow["DateChanged"].ToString(), out dtTemp)) { DateChanged = dtTemp; } if (DateTime.TryParse(dRow["DateDeleted"].ToString(), out dtTemp)) { DateDeleted = dtTemp; } GoogleString = Address1 + "+" + Address2 + "+" + City + "+" + StateID + "+" + PostalCode; } if (lds.Tables.Count > 1) { AddressTypes = new List <cAddressType>(); foreach (DataRow dRow in lds.Tables[1].Rows) { cAddressType NewAddress = new cAddressType(); NewAddress.AddressTypeID = dRow["AddressTypeID"].ToString().ToInt32(); NewAddress.AddressType = dRow["AddressType"].ToString(); AddressTypes.Add(NewAddress); } } } catch (Exception ex) { ErrorAtServer lobjError = new ErrorAtServer(); lobjError.ProcessError(ex, lsRoutineName, UserName + lsRoutineName); } }