Example #1
0
        public LoginRoles(DBConnectionControl4.DBConnection xcon)
        {
            select = new selection(this);
                where  = new WHERE(this);
                m_con = xcon;
                tablename = LoginRoles.tablename_const;
                myUpdateObjects = UpdateObjects;

                    o_id.col_name = LoginRoles.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_Name.col_name = LoginRoles.Name.name;
                    o_Name.col_type.m_Type = "nvarchar";
                    o_Name.col_type.bPRIMARY_KEY = false;
                    o_Name.col_type.bFOREIGN_KEY = false;
                    o_Name.col_type.bUNIQUE = false;
                    o_Name.col_type.bNULL = true;
                    Add(o_Name);

                    o_description.col_name = LoginRoles.description.name;
                    o_description.col_type.m_Type = "nvarchar";
                    o_description.col_type.bPRIMARY_KEY = false;
                    o_description.col_type.bFOREIGN_KEY = false;
                    o_description.col_type.bUNIQUE = false;
                    o_description.col_type.bNULL = true;
                    Add(o_description);
        }
Example #2
0
 public void Users_id_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_Users_id.Where.AddParameter(par);
 }
Example #3
0
 public void username_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_username.Where.AddParameter(par);
 }
Example #4
0
 public void Time_When_UserSetsItsOwnPassword_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_Time_When_UserSetsItsOwnPassword.Where.AddParameter(par);
 }
Example #5
0
 public void RoleDescription_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_RoleDescription.Where.AddParameter(par);
 }
Example #6
0
 public void password_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_password.Where.AddParameter(par);
 }
Example #7
0
 public LoginDB_DataSet_Procedures(DBConnectionControl4.DBConnection xcon)
 {
     m_con = xcon;
 }
Example #8
0
        public LoginUsers(DBConnectionControl4.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_UserSetsItsOwnPassword.col_name = LoginUsers.Time_When_UserSetsItsOwnPassword.name;
                    o_Time_When_UserSetsItsOwnPassword.col_type.m_Type = "datetime";
                    o_Time_When_UserSetsItsOwnPassword.col_type.bPRIMARY_KEY = false;
                    o_Time_When_UserSetsItsOwnPassword.col_type.bFOREIGN_KEY = false;
                    o_Time_When_UserSetsItsOwnPassword.col_type.bUNIQUE = false;
                    o_Time_When_UserSetsItsOwnPassword.col_type.bNULL = true;
                    Add(o_Time_When_UserSetsItsOwnPassword);

                    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);
        }
Example #9
0
 public void Identity_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_Identity.Where.AddParameter(par);
 }
Example #10
0
 public void enabled_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_enabled.Where.AddParameter(par);
 }
Example #11
0
 public void Contact_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_Contact.Where.AddParameter(par);
 }
Example #12
0
 public void ChangePasswordOnFirstLogin_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_ChangePasswordOnFirstLogin.Where.AddParameter(par);
 }
Example #13
0
 public LoginDB_DataSet_ScalarFunctions(DBConnectionControl4.DBConnection xcon)
 {
     m_con = xcon;
 }
Example #14
0
        public Login_VIEW(DBConnectionControl4.DBConnection xcon)
        {
            select = new selection(this);
                where  = new WHERE(this);
                m_con = xcon;
                tablename = Login_VIEW.tablename_const;
                myUpdateObjects = UpdateObjects;

                    o_Users_id.col_name = Login_VIEW.Users_id.name;
                    o_Users_id.col_type.m_Type = "int";
                    Add(o_Users_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_Time_When_UserSetsItsOwnPassword.col_name = Login_VIEW.Time_When_UserSetsItsOwnPassword.name;
                    o_Time_When_UserSetsItsOwnPassword.col_type.m_Type = "datetime";
                    Add(o_Time_When_UserSetsItsOwnPassword);

                    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_RoleName.col_name = Login_VIEW.RoleName.name;
                    o_RoleName.col_type.m_Type = "nvarchar";
                    Add(o_RoleName);

                    o_RoleDescription.col_name = Login_VIEW.RoleDescription.name;
                    o_RoleDescription.col_type.m_Type = "nvarchar";
                    Add(o_RoleDescription);
        }
Example #15
0
 public void LoginUsers_id_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_LoginUsersAndLoginRoles.o_LoginUsers_id.Where.AddParameter(par);
 }
Example #16
0
 public void description_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_LoginRoles.o_description.Where.AddParameter(par);
 }
Example #17
0
 public void Name_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_LoginRoles.o_Name.Where.AddParameter(par);
 }
Example #18
0
 public void Maximum_password_age_in_days_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_Maximum_password_age_in_days.Where.AddParameter(par);
 }
Example #19
0
 public void PasswordNeverExpires_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_Login_VIEW.o_PasswordNeverExpires.Where.AddParameter(par);
 }
Example #20
0
 public void last_name_AddParameter(DBConnectionControl4.SQL_Parameter par)
 {
     m_LoginUsers.o_last_name.Where.AddParameter(par);
 }