Exemple #1
0
        public static void Login(string userName, bool success)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            ta.Login(userName, success);
        }
Exemple #2
0
        public static Int32 UpdateUser(string userName, string firstName, string lastName, string password, Int32 userRoleId, Int32 userId, string timeZone)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            return(ta.Update(userId, firstName, lastName, userName, password, "", userRoleId, timeZone));
        }
Exemple #3
0
        public static Int32 DeleteUser(Int32 userId)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            return(ta.Delete(userId));
        }
Exemple #4
0
        public static UserDS.UserDSDataTable GetUserByGuid(Guid userGuid)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            return(ta.GetUserByGuid(userGuid));
        }
Exemple #5
0
        public static UserDS.UserDSDataTable SelectUser(Int32 userId)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            return(ta.GetData(userId));
        }
Exemple #6
0
        public static UserDS.UserDSDataTable GetUsersByRole(Int32 userRoleId)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            return(ta.GetUsersByRole(userRoleId));
        }
Exemple #7
0
        public static UserDS.UserDSDataTable GetUser(string userName)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;
            return(ta.GetUserByUsername(userName));
        }
Exemple #8
0
        public static Int32 InsertUser(string userName, string firstName, string lastName, string password, Int32 userRoleId, string timeZone)
        {
            UserDSTableAdapter ta = new UserDSTableAdapter();

            ta.Connection.ConnectionString = UcConnection.ConnectionString;

            int id = Convert.ToInt32(ta.InsertUser(firstName, lastName, userName, password, "", userRoleId, timeZone));

            return(id);
        }