private void LoadAddresses() { MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; _PrimaryAddress = new cAddress(_PrimaryAddressID, _LoginName, _UserID); try { SortedList slParams = new SortedList(); // I use a sortedlist wich is a C# hash table to store the paramter and value slParams.Add("@intKeyID", _UserID); slParams.Add("@strKeyType", "cUser"); DataTable ldt = cUtilities.LoadDataTable("uspGetAddressByKey", slParams, "LARPortal", _LoginName, lsRoutineName); _UserAddresses = new List <cAddress>(); if (ldt.Rows.Count > 0) { foreach (DataRow ldr in ldt.Rows) { cAddress cAdd = new cAddress(ldr["AddressID"].ToString().Trim().ToInt32(), _LoginName, _UserID); _UserAddresses.Add(cAdd); } } } catch (Exception ex) { ErrorAtServer lobjError = new ErrorAtServer(); lobjError.ProcessError(ex, lsRoutineName, _LoginName + lsRoutineName); } }
//public List<cNoifications> UserNotifications; //public cCalandar UserCalandar; //public List<LarpPortal.Classes.cCharacter> UserCharacters; private cUser() { UserID = -1; LoginName = ""; PrimaryEmailID = -1; PrimaryEmailAddress = new cEMail(); UserEmails = new List <cEMail>(); LoginEmail = ""; LoginPassword = ""; SecurityRoleID = -1; FirstName = ""; LastName = ""; MiddleName = ""; NickName = ""; ForumUserName = ""; AuthorName = ""; NotificationPreference = -1; PrimaryAddressID = -1; PrimaryAddress = new cAddress(); UserAddresses = new List <cAddress>(); PrimaryPhoneNumberID = -1; PrimaryPhone = new cPhone(); UserPhones = new List <cPhone>(); DeliveryPreferenceID = -1; LastLoggedInLocation = ""; UserCampaigns = new List <cUserCampaign>(); LastLoggedInCampaign = 0; LastLoggedInCharacter = 0; LastLoggedInMyCharOrCamp = ""; LastLoggedInSkillSetID = 0; XRefNumber = -1; Comments = ""; UserCPBank = new cBank(); }
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); } }
public cSite(Int32 intSiteID, Int32 intUserID, string strUserName) { 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; _SiteID = intSiteID; _UserID = intUserID; _UserName = strUserName; //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("@intSiteID", _SiteID); try { DataTable ldt = cUtilities.LoadDataTable("uspGetSTSitesByID", slParams, "LarpPortal", _UserName, lsRoutineName); if (ldt.Rows.Count > 0) { _SiteName = ldt.Rows[0]["SiteName"].ToString(); _SiteAddress = new cAddress(ldt.Rows[0]["AddressID"].ToString().ToInt32(), _UserName, _UserID); _SitePhone = new cPhone(ldt.Rows[0]["PhoneID"].ToString().ToInt32(), _UserID, _UserName); _URL = ldt.Rows[0]["URL"].ToString().Trim(); _SiteMapURL = ldt.Rows[0]["SiteMapURL"].ToString().Trim(); _SiteDirections = ldt.Rows[0]["SiteDirections"].ToString(); _YearRound = ldt.Rows[0]["YearRound"].ToString().ToBoolean(); _TimeRestrictions = ldt.Rows[0]["TimeRestrictions"].ToString(); _EMTCertReqd = ldt.Rows[0]["EMTCertificationRequired"].ToString().ToBoolean(); _CookCertReqd = ldt.Rows[0]["CookingCertificationRequired"].ToString().ToBoolean(); _AddWaiversReqd = ldt.Rows[0]["AdditionalWaiversRequired"].ToString().ToBoolean(); _SiteNotes = ldt.Rows[0]["SiteNotes"].ToString().Trim(); _Comments = ldt.Rows[0]["Comments"].ToString().Trim(); _DateAdded = Convert.ToDateTime(ldt.Rows[0]["DateAdded"].ToString().ToString()); _DateChanged = Convert.ToDateTime(ldt.Rows[0]["DateChanged"].ToString().ToString()); LoadSitePolicies(); LoadSiteImages(); LoadSiteContacts(); LoadSiteComments(); LoadSiteAvailabilityDates(); LoadLocations(); } } catch (Exception ex) { ErrorAtServer lobjError = new ErrorAtServer(); lobjError.ProcessError(ex, lsRoutineName, _UserName + lsRoutineName); } }
public cUser(string strLoginName, string strLoginPassword, string sSessionID) { MethodBase lmth = MethodBase.GetCurrentMethod(); string lsRoutineName = lmth.DeclaringType + "." + lmth.Name; // JLB 5/12/2018 - Put in default values. It appeared as if the values were defaulting. UserID = -1; LoginName = ""; PrimaryEmailID = -1; PrimaryEmailAddress = new cEMail(); UserEmails = new List <cEMail>(); LoginEmail = ""; LoginPassword = ""; SecurityRoleID = -1; FirstName = ""; LastName = ""; MiddleName = ""; NickName = ""; ForumUserName = ""; AuthorName = ""; NotificationPreference = -1; PrimaryAddressID = -1; PrimaryAddress = new cAddress(); UserAddresses = new List <cAddress>(); PrimaryPhoneNumberID = -1; PrimaryPhone = new cPhone(); UserPhones = new List <cPhone>(); DeliveryPreferenceID = -1; LastLoggedInLocation = ""; UserCampaigns = new List <cUserCampaign>(); LastLoggedInCampaign = 0; LastLoggedInCharacter = 0; LastLoggedInSkillSetID = 0; LastLoggedInMyCharOrCamp = ""; // 5/8/2019 JLB Needed for multiple skill sets. XRefNumber = -1; Comments = ""; UserCPBank = new cBank(); SortedList slParams = new SortedList(); LoginName = strLoginName; LoginPassword = strLoginPassword; SessionID = sSessionID; slParams = new SortedList(); slParams.Add("@LoginUserName", LoginName); try { DataSet ldt = cUtilities.LoadDataSet("uspGetUserByLoginName", slParams, "LARPortal", LoginName, lsRoutineName); ldt.Tables[0].TableName = "UserInfo"; ldt.Tables[1].TableName = "AddressInfo"; ldt.Tables[2].TableName = "AddressType"; ldt.Tables[3].TableName = "PhoneNumber"; ldt.Tables[4].TableName = "PhoneType"; ldt.Tables[5].TableName = "PhoneProviders"; if (ldt.Tables["UserInfo"].Rows.Count > 0) { DataRow dUserInfo = ldt.Tables["UserInfo"].Rows[0]; UserID = dUserInfo["UserID"].ToString().ToInt32(); PrimaryEmailID = dUserInfo["EmailID"].ToString().ToInt32(); SecurityRoleID = dUserInfo["SecurityRoleID"].ToString().ToInt32(); FirstName = dUserInfo["FirstName"].ToString(); MiddleName = dUserInfo["MiddleName"].ToString(); LastName = dUserInfo["LastName"].ToString(); NickName = dUserInfo["NickName"].ToString(); PrimaryPhoneNumberID = dUserInfo["PrimaryPhoneID"].ToString().ToInt32(); PrimaryAddressID = dUserInfo["PrimaryAddressID"].ToString().ToInt32(); ForumUserName = dUserInfo["ForumUsername"].ToString(); NotificationPreference = dUserInfo["NotificationPreferenceID"].ToString().ToInt32(); DeliveryPreferenceID = dUserInfo["DeliveryPreferenceID"].ToString().ToInt32(); LastLoggedInLocation = dUserInfo["LastLoggedInLocation"].ToString(); LastLoggedInCampaign = dUserInfo["LastLoggedInCampaign"].ToString().ToInt32(); LastLoggedInCharacter = dUserInfo["LastLoggedInCharacter"].ToString().ToInt32(); LastLoggedInMyCharOrCamp = dUserInfo["LastLoggedInMyCharOrCamp"].ToString(); LastLoggedInSkillSetID = dUserInfo["LastLoggedInSkillSetID"].ToString().ToInt32(); // 5/8/2019 JLB Needed for multiple skill sets. XRefNumber = dUserInfo["XRefNumber"].ToString().ToInt32(); DateAdded = Convert.ToDateTime(dUserInfo["DateAdded"].ToString()); DateChanged = Convert.ToDateTime(dUserInfo["DateChanged"].ToString()); } LoadAddresses(ldt.Tables["AddressInfo"], ldt.Tables["AddressType"], strLoginName); LoadPhones(ldt.Tables["PhoneNumber"], ldt.Tables["PhoneType"], ldt.Tables["PhoneProviders"]); LoadEmails(); } catch (Exception ex) { ErrorAtServer lobjError = new ErrorAtServer(); lobjError.ProcessError(ex, lsRoutineName, LoginName + lsRoutineName); } }