public static LoginBL getByUserName(String strUserName)
{
SummitDS.LoginDataTable thisTable = getAdapter().GetDataByUserName(strUserName);
if (thisTable != null && thisTable.Rows.Count > 0)
{
return(BuildFromRow(thisTable.Rows[0]));
}
return(null);
}
public static LoginBL getByShopId(Int32 iShopId)
{
SummitDS.LoginDataTable thisTable = getAdapter().GetDataByShopId(iShopId);
if (thisTable != null && thisTable.Rows.Count > 0)
{
return(BuildFromRow(thisTable.Rows[0]));
}
return(null);
}
public static List <LoginBL> AdminShopList()
{
SummitDS.LoginDataTable thisTable = getAdapter().AdminList();
if (thisTable != null && thisTable.Rows.Count > 0)
{
return(BuildFromTable(thisTable));
}
return(null);
}
/// <summary>
/// Get all users who are in the role of marketing user
/// </summary>
/// <returns></returns>
public static List <LoginBL> GetAllMarketingUsers()
{
SummitDS.LoginDataTable thisTable = getAdapter().GetAllMarketingUsers();
List <LoginBL> _list = new List <LoginBL>();
if (thisTable != null && thisTable.Rows.Count > 0)
{
foreach (DataRow dr in thisTable.Rows)
{
LoginBL _thisMember = new LoginBL(dr);
_list.Add(_thisMember);
}
}
return(_list);
}
public static List <LoginBL> getByEmail(String strEmail)
{
SummitDS.LoginDataTable thisTable = getAdapter().GetDataByEmail(strEmail);
List <LoginBL> _list = new List <LoginBL>();
if (thisTable != null && thisTable.Rows.Count > 0)
{
foreach (DataRow dr in thisTable.Rows)
{
LoginBL _thisMember = new LoginBL(dr);
_list.Add(_thisMember);
}
}
return(_list);
}
protected override void SaveToRow()
{
SummitDS.LoginDataTable _thisTable = new SummitDS.LoginDataTable();
if (_rowToSave == null)
{
_rowToSave = _thisTable.NewLoginRow();
}
SummitDS.LoginRow _dataRow = _rowToSave as SummitDS.LoginRow;
if (_dataRow != null)
{
if (IsExisting())
{
if (String.IsNullOrEmpty(m_strUserName))
{
if (!_dataRow.IsUserNameNull())
{
_dataRow.SetUserNameNull();
}
}
else if (_dataRow.IsUserNameNull() ? true : _dataRow.UserName != m_strUserName)
{
_dataRow.UserName = m_strUserName;
}
if (String.IsNullOrEmpty(m_strPassword))
{
if (!_dataRow.IsPasswordNull())
{
_dataRow.SetPasswordNull();
}
}
else if (_dataRow.IsPasswordNull() ? true : _dataRow.Password != m_strPassword)
{
_dataRow.Password = m_strPassword;
}
if (String.IsNullOrEmpty(m_strFirstName))
{
if (!_dataRow.IsFirstNameNull())
{
_dataRow.SetFirstNameNull();
}
}
else if (_dataRow.IsFirstNameNull() ? true : _dataRow.FirstName != m_strFirstName)
{
_dataRow.FirstName = m_strFirstName;
}
if (String.IsNullOrEmpty(m_strLastName))
{
if (!_dataRow.IsLastNameNull())
{
_dataRow.SetLastNameNull();
}
}
else if (_dataRow.IsLastNameNull() ? true : _dataRow.LastName != m_strLastName)
{
_dataRow.LastName = m_strLastName;
}
if (String.IsNullOrEmpty(m_strEmail))
{
if (!_dataRow.IsEmailNull())
{
_dataRow.SetEmailNull();
}
}
else if (_dataRow.IsEmailNull() ? true : _dataRow.Email != m_strEmail)
{
_dataRow.Email = m_strEmail;
}
if (String.IsNullOrEmpty(m_strPhone))
{
if (!_dataRow.IsPhoneNull())
{
_dataRow.SetPhoneNull();
}
}
else if (_dataRow.IsPhoneNull() ? true : _dataRow.Phone != m_strPhone)
{
_dataRow.Phone = m_strPhone;
}
if (String.IsNullOrEmpty(m_strCompany))
{
if (!_dataRow.IsCompanyNull())
{
_dataRow.SetCompanyNull();
}
}
else if (_dataRow.IsCompanyNull() ? true : _dataRow.Company != m_strCompany)
{
_dataRow.Company = m_strCompany;
}
if (String.IsNullOrEmpty(m_strSMTPServerName))
{
if (!_dataRow.IsSMTPServerNameNull())
{
_dataRow.SetSMTPServerNameNull();
}
}
else if (_dataRow.IsSMTPServerNameNull() ? true : _dataRow.SMTPServerName != m_strSMTPServerName)
{
_dataRow.SMTPServerName = m_strSMTPServerName;
}
if (String.IsNullOrEmpty(m_strSMTPServerPassword))
{
if (!_dataRow.IsSMTPServerPasswordNull())
{
_dataRow.SetSMTPServerPasswordNull();
}
}
else if (_dataRow.IsSMTPServerPasswordNull() ? true : _dataRow.SMTPServerPassword != m_strSMTPServerPassword)
{
_dataRow.SMTPServerPassword = m_strSMTPServerPassword;
}
if (String.IsNullOrEmpty(m_strSMTPServerUserName))
{
if (!_dataRow.IsSMTPServerUserNameNull())
{
_dataRow.SetSMTPServerUserNameNull();
}
}
else if (_dataRow.IsSMTPServerUserNameNull() ? true : _dataRow.SMTPServerUserName != m_strSMTPServerUserName)
{
_dataRow.SMTPServerUserName = m_strSMTPServerUserName;
}
if (m_boolUseProvidedSMTPServer == null)
{
if (!_dataRow.IsUseProvidedSMTPServerNull())
{
_dataRow.SetUseProvidedSMTPServerNull();
}
}
else if (_dataRow.IsUseProvidedSMTPServerNull() ? true : _dataRow.UseProvidedSMTPServer != m_boolUseProvidedSMTPServer)
{
_dataRow.UseProvidedSMTPServer = m_boolUseProvidedSMTPServer;
}
if (iCompanySize.HasValue)
{
_dataRow.CompanySize = iCompanySize.Value;
}
else
{
_dataRow.SetCompanySizeNull();
}
if (iCountryEntityID.HasValue)
{
_dataRow.CountryEntityID = iCountryEntityID.Value;
}
else
{
_dataRow.SetCountryEntityIDNull();
}
if (iShopID.HasValue)
{
_dataRow.ShopID = iShopID.Value;
}
else
{
_dataRow.SetShopIDNull();
}
if (iRoleID.HasValue)
{
_dataRow.RoleId = iRoleID.Value;
}
else
{
_dataRow.SetRoleIdNull();
}
if (iAvailableSMS.HasValue)
{
_dataRow.AvailableSMS = iAvailableSMS.Value;
}
else
{
_dataRow.SetAvailableSMSNull();
}
if (iSentSMS.HasValue)
{
_dataRow.SentSMS = iSentSMS.Value;
}
else
{
_dataRow.SetSentSMSNull();
}
if (dtSMSActivationDate.HasValue)
{
_dataRow.SMSActivationDate = dtSMSActivationDate.Value;
}
else
{
_dataRow.SetSMSActivationDateNull();
}
if (iSMTPPort.HasValue)
{
_dataRow.SMTPServerPort = iSMTPPort.Value;
}
else
{
_dataRow.SetSMTPServerPortNull();
}
if (m_boolEnableSSL == null)
{
_dataRow.EnableSSL = false;
}
else
{
_dataRow.EnableSSL = m_boolEnableSSL;
}
if (String.IsNullOrEmpty(m_strSMTPServerEmail))
{
if (!_dataRow.IsSMTPServerEmailNull())
{
_dataRow.SetSMTPServerEmailNull();
}
}
else if (_dataRow.IsSMTPServerEmailNull() ? true : _dataRow.SMTPServerEmail != m_strSMTPServerEmail)
{
_dataRow.SMTPServerEmail = m_strSMTPServerEmail;
}
}
else
{
if (String.IsNullOrEmpty(m_strUserName))
{
if (!_dataRow.IsUserNameNull())
{
_dataRow.SetUserNameNull();
}
}
else if (_dataRow.IsUserNameNull() ? true : _dataRow.UserName != m_strUserName)
{
_dataRow.UserName = m_strUserName;
}
if (String.IsNullOrEmpty(m_strPassword))
{
if (!_dataRow.IsPasswordNull())
{
_dataRow.SetPasswordNull();
}
}
else if (_dataRow.IsPasswordNull() ? true : _dataRow.Password != m_strPassword)
{
_dataRow.Password = m_strPassword;
}
if (String.IsNullOrEmpty(m_strFirstName))
{
if (!_dataRow.IsFirstNameNull())
{
_dataRow.SetFirstNameNull();
}
}
else if (_dataRow.IsFirstNameNull() ? true : _dataRow.FirstName != m_strFirstName)
{
_dataRow.FirstName = m_strFirstName;
}
if (String.IsNullOrEmpty(m_strLastName))
{
if (!_dataRow.IsLastNameNull())
{
_dataRow.SetLastNameNull();
}
}
else if (_dataRow.IsLastNameNull() ? true : _dataRow.LastName != m_strLastName)
{
_dataRow.LastName = m_strLastName;
}
if (String.IsNullOrEmpty(m_strEmail))
{
if (!_dataRow.IsEmailNull())
{
_dataRow.SetEmailNull();
}
}
else if (_dataRow.IsEmailNull() ? true : _dataRow.Email != m_strEmail)
{
_dataRow.Email = m_strEmail;
}
if (String.IsNullOrEmpty(m_strPhone))
{
if (!_dataRow.IsPhoneNull())
{
_dataRow.SetPhoneNull();
}
}
else if (_dataRow.IsPhoneNull() ? true : _dataRow.Phone != m_strPhone)
{
_dataRow.Phone = m_strPhone;
}
if (String.IsNullOrEmpty(m_strCompany))
{
if (!_dataRow.IsCompanyNull())
{
_dataRow.SetCompanyNull();
}
}
else if (_dataRow.IsCompanyNull() ? true : _dataRow.Company != m_strCompany)
{
_dataRow.Company = m_strCompany;
}
if (String.IsNullOrEmpty(m_strSMTPServerName))
{
if (!_dataRow.IsSMTPServerNameNull())
{
_dataRow.SetSMTPServerNameNull();
}
}
else if (_dataRow.IsSMTPServerNameNull() ? true : _dataRow.SMTPServerName != m_strSMTPServerName)
{
_dataRow.SMTPServerName = m_strSMTPServerName;
}
if (String.IsNullOrEmpty(m_strSMTPServerPassword))
{
if (!_dataRow.IsSMTPServerPasswordNull())
{
_dataRow.SetSMTPServerPasswordNull();
}
}
else if (_dataRow.IsSMTPServerPasswordNull() ? true : _dataRow.SMTPServerPassword != m_strSMTPServerPassword)
{
_dataRow.SMTPServerPassword = m_strSMTPServerPassword;
}
if (String.IsNullOrEmpty(m_strSMTPServerUserName))
{
if (!_dataRow.IsSMTPServerUserNameNull())
{
_dataRow.SetSMTPServerUserNameNull();
}
}
else if (_dataRow.IsSMTPServerUserNameNull() ? true : _dataRow.SMTPServerUserName != m_strSMTPServerUserName)
{
_dataRow.SMTPServerUserName = m_strSMTPServerUserName;
}
if (m_boolUseProvidedSMTPServer == null)
{
if (!_dataRow.IsUseProvidedSMTPServerNull())
{
_dataRow.SetUseProvidedSMTPServerNull();
}
}
else if (_dataRow.IsUseProvidedSMTPServerNull() ? true : _dataRow.UseProvidedSMTPServer != m_boolUseProvidedSMTPServer)
{
_dataRow.UseProvidedSMTPServer = m_boolUseProvidedSMTPServer;
}
if (iCompanySize.HasValue)
{
_dataRow.CompanySize = iCompanySize.Value;
}
else
{
_dataRow.SetCompanySizeNull();
}
if (iCountryEntityID.HasValue)
{
_dataRow.CountryEntityID = iCountryEntityID.Value;
}
else
{
_dataRow.SetCountryEntityIDNull();
}
if (iShopID.HasValue)
{
_dataRow.ShopID = iShopID.Value;
}
else
{
_dataRow.SetShopIDNull();
}
if (iRoleID.HasValue)
{
_dataRow.RoleId = iRoleID.Value;
}
else
{
_dataRow.SetRoleIdNull();
}
if (iAvailableSMS.HasValue)
{
_dataRow.AvailableSMS = iAvailableSMS.Value;
}
else
{
_dataRow.SetAvailableSMSNull();
}
if (iSentSMS.HasValue)
{
_dataRow.SentSMS = iSentSMS.Value;
}
else
{
_dataRow.SetSentSMSNull();
}
if (dtSMSActivationDate.HasValue)
{
_dataRow.SMSActivationDate = dtSMSActivationDate.Value;
}
else
{
_dataRow.SetSMSActivationDateNull();
}
if (iSMTPPort.HasValue)
{
_dataRow.SMTPServerPort = iSMTPPort.Value;
}
else
{
_dataRow.SetSMTPServerPortNull();
}
if (m_boolEnableSSL == null)
{
_dataRow.EnableSSL = false;
}
else
{
_dataRow.EnableSSL = m_boolEnableSSL;
}
if (String.IsNullOrEmpty(m_strSMTPServerEmail))
{
if (!_dataRow.IsSMTPServerEmailNull())
{
_dataRow.SetSMTPServerEmailNull();
}
}
else if (_dataRow.IsSMTPServerEmailNull() ? true : _dataRow.SMTPServerEmail != m_strSMTPServerEmail)
{
_dataRow.SMTPServerEmail = m_strSMTPServerEmail;
}
_thisTable.AddLoginRow(_dataRow);
}
}
}
