public LoginComputer(DBConnectionControl40.DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LoginComputer.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LoginComputer.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_ComputerName.col_name = LoginComputer.ComputerName.name;
o_ComputerName.col_type.m_Type = "nvarchar";
o_ComputerName.col_type.bPRIMARY_KEY = false;
o_ComputerName.col_type.bFOREIGN_KEY = false;
o_ComputerName.col_type.bUNIQUE = false;
o_ComputerName.col_type.bNULL = true;
Add(o_ComputerName);
}
public void Name_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginRoles.o_Name.Where.AddParameter(par);
}
public void username_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_username.Where.AddParameter(par);
}
public void Role_PrivilegesLevel_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_Role_PrivilegesLevel.Where.AddParameter(par);
}
public void password_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_password.Where.AddParameter(par);
}
public void NotActiveAfterPasswordExpires_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_NotActiveAfterPasswordExpires.Where.AddParameter(par);
}
public void Identity_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_Identity.Where.AddParameter(par);
}
public void Contact_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_Contact.Where.AddParameter(par);
}
public LoginUsers(DBConnectionControl40.DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LoginUsers.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LoginUsers.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_first_name.col_name = LoginUsers.first_name.name;
o_first_name.col_type.m_Type = "nvarchar";
o_first_name.col_type.bPRIMARY_KEY = false;
o_first_name.col_type.bFOREIGN_KEY = false;
o_first_name.col_type.bUNIQUE = false;
o_first_name.col_type.bNULL = true;
Add(o_first_name);
o_last_name.col_name = LoginUsers.last_name.name;
o_last_name.col_type.m_Type = "nvarchar";
o_last_name.col_type.bPRIMARY_KEY = false;
o_last_name.col_type.bFOREIGN_KEY = false;
o_last_name.col_type.bUNIQUE = false;
o_last_name.col_type.bNULL = true;
Add(o_last_name);
o_Identity.col_name = LoginUsers.Identity.name;
o_Identity.col_type.m_Type = "nvarchar";
o_Identity.col_type.bPRIMARY_KEY = false;
o_Identity.col_type.bFOREIGN_KEY = false;
o_Identity.col_type.bUNIQUE = false;
o_Identity.col_type.bNULL = true;
Add(o_Identity);
o_Contact.col_name = LoginUsers.Contact.name;
o_Contact.col_type.m_Type = "nvarchar";
o_Contact.col_type.bPRIMARY_KEY = false;
o_Contact.col_type.bFOREIGN_KEY = false;
o_Contact.col_type.bUNIQUE = false;
o_Contact.col_type.bNULL = true;
Add(o_Contact);
o_username.col_name = LoginUsers.username.name;
o_username.col_type.m_Type = "nvarchar";
o_username.col_type.bPRIMARY_KEY = false;
o_username.col_type.bFOREIGN_KEY = false;
o_username.col_type.bUNIQUE = true;
o_username.col_type.bNULL = false;
Add(o_username);
o_password.col_name = LoginUsers.password.name;
o_password.col_type.m_Type = "varbinary";
o_password.col_type.bPRIMARY_KEY = false;
o_password.col_type.bFOREIGN_KEY = false;
o_password.col_type.bUNIQUE = false;
o_password.col_type.bNULL = true;
Add(o_password);
o_enabled.col_name = LoginUsers.enabled.name;
o_enabled.col_type.m_Type = "bit";
o_enabled.col_type.bPRIMARY_KEY = false;
o_enabled.col_type.bFOREIGN_KEY = false;
o_enabled.col_type.bUNIQUE = false;
o_enabled.col_type.bNULL = false;
Add(o_enabled);
o_ChangePasswordOnFirstLogin.col_name = LoginUsers.ChangePasswordOnFirstLogin.name;
o_ChangePasswordOnFirstLogin.col_type.m_Type = "bit";
o_ChangePasswordOnFirstLogin.col_type.bPRIMARY_KEY = false;
o_ChangePasswordOnFirstLogin.col_type.bFOREIGN_KEY = false;
o_ChangePasswordOnFirstLogin.col_type.bUNIQUE = false;
o_ChangePasswordOnFirstLogin.col_type.bNULL = false;
Add(o_ChangePasswordOnFirstLogin);
o_Time_When_AdministratorSetsPassword.col_name = LoginUsers.Time_When_AdministratorSetsPassword.name;
o_Time_When_AdministratorSetsPassword.col_type.m_Type = "datetime";
o_Time_When_AdministratorSetsPassword.col_type.bPRIMARY_KEY = false;
o_Time_When_AdministratorSetsPassword.col_type.bFOREIGN_KEY = false;
o_Time_When_AdministratorSetsPassword.col_type.bUNIQUE = false;
o_Time_When_AdministratorSetsPassword.col_type.bNULL = true;
Add(o_Time_When_AdministratorSetsPassword);
o_Administrator_LoginUsers_id.col_name = LoginUsers.Administrator_LoginUsers_id.name;
o_Administrator_LoginUsers_id.col_type.m_Type = "int";
o_Administrator_LoginUsers_id.col_type.bPRIMARY_KEY = false;
o_Administrator_LoginUsers_id.col_type.bFOREIGN_KEY = false;
o_Administrator_LoginUsers_id.col_type.bUNIQUE = false;
o_Administrator_LoginUsers_id.col_type.bNULL = true;
Add(o_Administrator_LoginUsers_id);
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_name = LoginUsers.Time_When_UserSetsItsOwnPassword_FirstTime.name;
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_type.m_Type = "datetime";
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_type.bPRIMARY_KEY = false;
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_type.bFOREIGN_KEY = false;
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_type.bUNIQUE = false;
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_type.bNULL = true;
Add(o_Time_When_UserSetsItsOwnPassword_FirstTime);
o_Time_When_UserSetsItsOwnPassword_LastTime.col_name = LoginUsers.Time_When_UserSetsItsOwnPassword_LastTime.name;
o_Time_When_UserSetsItsOwnPassword_LastTime.col_type.m_Type = "datetime";
o_Time_When_UserSetsItsOwnPassword_LastTime.col_type.bPRIMARY_KEY = false;
o_Time_When_UserSetsItsOwnPassword_LastTime.col_type.bFOREIGN_KEY = false;
o_Time_When_UserSetsItsOwnPassword_LastTime.col_type.bUNIQUE = false;
o_Time_When_UserSetsItsOwnPassword_LastTime.col_type.bNULL = true;
Add(o_Time_When_UserSetsItsOwnPassword_LastTime);
o_PasswordNeverExpires.col_name = LoginUsers.PasswordNeverExpires.name;
o_PasswordNeverExpires.col_type.m_Type = "bit";
o_PasswordNeverExpires.col_type.bPRIMARY_KEY = false;
o_PasswordNeverExpires.col_type.bFOREIGN_KEY = false;
o_PasswordNeverExpires.col_type.bUNIQUE = false;
o_PasswordNeverExpires.col_type.bNULL = false;
Add(o_PasswordNeverExpires);
o_Maximum_password_age_in_days.col_name = LoginUsers.Maximum_password_age_in_days.name;
o_Maximum_password_age_in_days.col_type.m_Type = "int";
o_Maximum_password_age_in_days.col_type.bPRIMARY_KEY = false;
o_Maximum_password_age_in_days.col_type.bFOREIGN_KEY = false;
o_Maximum_password_age_in_days.col_type.bUNIQUE = false;
o_Maximum_password_age_in_days.col_type.bNULL = true;
Add(o_Maximum_password_age_in_days);
o_NotActiveAfterPasswordExpires.col_name = LoginUsers.NotActiveAfterPasswordExpires.name;
o_NotActiveAfterPasswordExpires.col_type.m_Type = "bit";
o_NotActiveAfterPasswordExpires.col_type.bPRIMARY_KEY = false;
o_NotActiveAfterPasswordExpires.col_type.bFOREIGN_KEY = false;
o_NotActiveAfterPasswordExpires.col_type.bUNIQUE = false;
o_NotActiveAfterPasswordExpires.col_type.bNULL = false;
Add(o_NotActiveAfterPasswordExpires);
}
public void Logout_time_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginSession_VIEW.o_Logout_time.Where.AddParameter(par);
}
public void LoginComputer_id_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginSession_VIEW.o_LoginComputer_id.Where.AddParameter(par);
}
public void ComputerUserName_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginSession_VIEW.o_ComputerUserName.Where.AddParameter(par);
}
public LoginSession_VIEW(DBConnectionControl40.DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LoginSession_VIEW.tablename_const;
myUpdateObjects = UpdateObjects;
o_LoginSession_id.col_name = LoginSession_VIEW.LoginSession_id.name;
o_LoginSession_id.col_type.m_Type = "int";
Add(o_LoginSession_id);
o_LoginUsers_id.col_name = LoginSession_VIEW.LoginUsers_id.name;
o_LoginUsers_id.col_type.m_Type = "int";
Add(o_LoginUsers_id);
o_username.col_name = LoginSession_VIEW.username.name;
o_username.col_type.m_Type = "nvarchar";
Add(o_username);
o_first_name.col_name = LoginSession_VIEW.first_name.name;
o_first_name.col_type.m_Type = "nvarchar";
Add(o_first_name);
o_last_name.col_name = LoginSession_VIEW.last_name.name;
o_last_name.col_type.m_Type = "nvarchar";
Add(o_last_name);
o_Identity.col_name = LoginSession_VIEW.Identity.name;
o_Identity.col_type.m_Type = "nvarchar";
Add(o_Identity);
o_Contact.col_name = LoginSession_VIEW.Contact.name;
o_Contact.col_type.m_Type = "nvarchar";
Add(o_Contact);
o_Login_time.col_name = LoginSession_VIEW.Login_time.name;
o_Login_time.col_type.m_Type = "datetime";
Add(o_Login_time);
o_Logout_time.col_name = LoginSession_VIEW.Logout_time.name;
o_Logout_time.col_type.m_Type = "datetime";
Add(o_Logout_time);
o_LoginComputer_id.col_name = LoginSession_VIEW.LoginComputer_id.name;
o_LoginComputer_id.col_type.m_Type = "int";
Add(o_LoginComputer_id);
o_ComputerName.col_name = LoginSession_VIEW.ComputerName.name;
o_ComputerName.col_type.m_Type = "nvarchar";
Add(o_ComputerName);
o_LoginComputerUser_id.col_name = LoginSession_VIEW.LoginComputerUser_id.name;
o_LoginComputerUser_id.col_type.m_Type = "int";
Add(o_LoginComputerUser_id);
o_ComputerUserName.col_name = LoginSession_VIEW.ComputerUserName.name;
o_ComputerUserName.col_type.m_Type = "nvarchar";
Add(o_ComputerUserName);
}
public void id_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginSession.o_id.Where.AddParameter(par);
}
public LoginSession(DBConnectionControl40.DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LoginSession.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LoginSession.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_LoginUsers_id.col_name = LoginSession.LoginUsers_id.name;
o_LoginUsers_id.col_type.m_Type = "int";
o_LoginUsers_id.col_type.bPRIMARY_KEY = false;
o_LoginUsers_id.col_type.bFOREIGN_KEY = false;
o_LoginUsers_id.col_type.bUNIQUE = false;
o_LoginUsers_id.col_type.bNULL = false;
Add(o_LoginUsers_id);
o_Login_time.col_name = LoginSession.Login_time.name;
o_Login_time.col_type.m_Type = "datetime";
o_Login_time.col_type.bPRIMARY_KEY = false;
o_Login_time.col_type.bFOREIGN_KEY = false;
o_Login_time.col_type.bUNIQUE = false;
o_Login_time.col_type.bNULL = false;
Add(o_Login_time);
o_Logout_time.col_name = LoginSession.Logout_time.name;
o_Logout_time.col_type.m_Type = "datetime";
o_Logout_time.col_type.bPRIMARY_KEY = false;
o_Logout_time.col_type.bFOREIGN_KEY = false;
o_Logout_time.col_type.bUNIQUE = false;
o_Logout_time.col_type.bNULL = true;
Add(o_Logout_time);
o_LoginComputer_id.col_name = LoginSession.LoginComputer_id.name;
o_LoginComputer_id.col_type.m_Type = "int";
o_LoginComputer_id.col_type.bPRIMARY_KEY = false;
o_LoginComputer_id.col_type.bFOREIGN_KEY = false;
o_LoginComputer_id.col_type.bUNIQUE = false;
o_LoginComputer_id.col_type.bNULL = true;
Add(o_LoginComputer_id);
o_LoginComputerUser_id.col_name = LoginSession.LoginComputerUser_id.name;
o_LoginComputerUser_id.col_type.m_Type = "int";
o_LoginComputerUser_id.col_type.bPRIMARY_KEY = false;
o_LoginComputerUser_id.col_type.bFOREIGN_KEY = false;
o_LoginComputerUser_id.col_type.bUNIQUE = false;
o_LoginComputerUser_id.col_type.bNULL = true;
Add(o_LoginComputerUser_id);
}
public Login_VIEW(DBConnectionControl40.DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = Login_VIEW.tablename_const;
myUpdateObjects = UpdateObjects;
o_LoginUsers_id.col_name = Login_VIEW.Users_id.name;
o_LoginUsers_id.col_type.m_Type = "int";
Add(o_LoginUsers_id);
o_first_name.col_name = Login_VIEW.first_name.name;
o_first_name.col_type.m_Type = "nvarchar";
Add(o_first_name);
o_last_name.col_name = Login_VIEW.last_name.name;
o_last_name.col_type.m_Type = "nvarchar";
Add(o_last_name);
o_Identity.col_name = Login_VIEW.Identity.name;
o_Identity.col_type.m_Type = "nvarchar";
Add(o_Identity);
o_Contact.col_name = Login_VIEW.Contact.name;
o_Contact.col_type.m_Type = "nvarchar";
Add(o_Contact);
o_username.col_name = Login_VIEW.username.name;
o_username.col_type.m_Type = "nvarchar";
Add(o_username);
o_password.col_name = Login_VIEW.password.name;
o_password.col_type.m_Type = "varbinary";
Add(o_password);
o_PasswordNeverExpires.col_name = Login_VIEW.PasswordNeverExpires.name;
o_PasswordNeverExpires.col_type.m_Type = "bit";
Add(o_PasswordNeverExpires);
o_enabled.col_name = Login_VIEW.enabled.name;
o_enabled.col_type.m_Type = "bit";
Add(o_enabled);
o_Maximum_password_age_in_days.col_name = Login_VIEW.Maximum_password_age_in_days.name;
o_Maximum_password_age_in_days.col_type.m_Type = "int";
Add(o_Maximum_password_age_in_days);
o_NotActiveAfterPasswordExpires.col_name = Login_VIEW.NotActiveAfterPasswordExpires.name;
o_NotActiveAfterPasswordExpires.col_type.m_Type = "bit";
Add(o_NotActiveAfterPasswordExpires);
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_name = Login_VIEW.Time_When_UserSetsItsOwnPassword_FirstTime.name;
o_Time_When_UserSetsItsOwnPassword_FirstTime.col_type.m_Type = "datetime";
Add(o_Time_When_UserSetsItsOwnPassword_FirstTime);
o_Time_When_UserSetsItsOwnPassword_LastTime.col_name = Login_VIEW.Time_When_UserSetsItsOwnPassword_LastTime.name;
o_Time_When_UserSetsItsOwnPassword_LastTime.col_type.m_Type = "datetime";
Add(o_Time_When_UserSetsItsOwnPassword_LastTime);
o_ChangePasswordOnFirstLogin.col_name = Login_VIEW.ChangePasswordOnFirstLogin.name;
o_ChangePasswordOnFirstLogin.col_type.m_Type = "bit";
Add(o_ChangePasswordOnFirstLogin);
o_Role_id.col_name = Login_VIEW.Role_id.name;
o_Role_id.col_type.m_Type = "int";
Add(o_Role_id);
o_Role_Name.col_name = Login_VIEW.Role_Name.name;
o_Role_Name.col_type.m_Type = "nvarchar";
Add(o_Role_Name);
o_Role_PrivilegesLevel.col_name = Login_VIEW.Role_PrivilegesLevel.name;
o_Role_PrivilegesLevel.col_type.m_Type = "int";
Add(o_Role_PrivilegesLevel);
o_Role_description.col_name = Login_VIEW.Role_description.name;
o_Role_description.col_type.m_Type = "nvarchar";
Add(o_Role_description);
}
public void ChangePasswordOnFirstLogin_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_ChangePasswordOnFirstLogin.Where.AddParameter(par);
}
public void id_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginComputerUser.o_id.Where.AddParameter(par);
}
public void enabled_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_enabled.Where.AddParameter(par);
}
public LoginDB_DataSet_Procedures(DBConnectionControl40.DBConnection xcon)
{
m_con = xcon;
}
public void Maximum_password_age_in_days_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_Maximum_password_age_in_days.Where.AddParameter(par);
}
public void Administrator_LoginUsers_id_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginUsers.o_Administrator_LoginUsers_id.Where.AddParameter(par);
}
public void PasswordNeverExpires_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_PasswordNeverExpires.Where.AddParameter(par);
}
public void last_name_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginUsers.o_last_name.Where.AddParameter(par);
}
public void Role_description_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_Role_description.Where.AddParameter(par);
}
public void Time_When_AdministratorSetsPassword_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginUsers.o_Time_When_AdministratorSetsPassword.Where.AddParameter(par);
}
public void Time_When_UserSetsItsOwnPassword_LastTime_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_Time_When_UserSetsItsOwnPassword_LastTime.Where.AddParameter(par);
}
public LoginUsersAndLoginRoles(DBConnectionControl40.DBConnection xcon)
{
select = new selection(this);
where = new WHERE(this);
m_con = xcon;
tablename = LoginUsersAndLoginRoles.tablename_const;
myUpdateObjects = UpdateObjects;
o_id.col_name = LoginUsersAndLoginRoles.id.name;
o_id.col_type.m_Type = "int";
o_id.col_type.bPRIMARY_KEY = true;
o_id.col_type.bFOREIGN_KEY = false;
o_id.col_type.bUNIQUE = false;
o_id.col_type.bNULL = false;
Add(o_id);
o_LoginUsers_id.col_name = LoginUsersAndLoginRoles.LoginUsers_id.name;
o_LoginUsers_id.col_type.m_Type = "int";
o_LoginUsers_id.col_type.bPRIMARY_KEY = false;
o_LoginUsers_id.col_type.bFOREIGN_KEY = false;
o_LoginUsers_id.col_type.bUNIQUE = false;
o_LoginUsers_id.col_type.bNULL = false;
Add(o_LoginUsers_id);
o_LoginRoles_id.col_name = LoginUsersAndLoginRoles.LoginRoles_id.name;
o_LoginRoles_id.col_type.m_Type = "int";
o_LoginRoles_id.col_type.bPRIMARY_KEY = false;
o_LoginRoles_id.col_type.bFOREIGN_KEY = false;
o_LoginRoles_id.col_type.bUNIQUE = false;
o_LoginRoles_id.col_type.bNULL = false;
Add(o_LoginRoles_id);
}
public void Users_id_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_Login_VIEW.o_LoginUsers_id.Where.AddParameter(par);
}
public void LoginUsers_id_AddParameter(DBConnectionControl40.SQL_Parameter par)
{
m_LoginUsersAndLoginRoles.o_LoginUsers_id.Where.AddParameter(par);
}
