示例#1
0
        public userItem GetUserById(string id)
        {
            uc = new UserController();
            userItem result = uc.GetUserById(id);

            return(result);
        }
示例#2
0
        public int SaveUser(userItem user)
        {
            uc = new UserController();
            int result = uc.SaveUser(user);

            return(result);
        }
示例#3
0
        public int ThirdPartyLogin(userItem user)
        {
            uc = new UserController();
            int result = uc.thirdPartyLogin(user);

            return(result);
        }
示例#4
0
        private async System.Threading.Tasks.Task AuthenticateTwitter(MobileServiceAuthenticationProvider provider = MobileServiceAuthenticationProvider.Twitter)
        {
            userItems = await usersTable.ToCollectionAsync();

            if (user == null)
            {
                string message;
                try
                {
                    user = await App.MobileService.LoginAsync(provider);

                    message =
                        string.Format("You are now logged in - {0}", user.UserId);
                    var userItem = new userItem {
                        Id = user.UserId, Username = ""
                    };
                    InsertUserItem(userItem);
                    //dialog = new MessageDialog(message);
                    //dialog.Commands.Add(new UICommand("OK"));
                    //await dialog.ShowAsync();
                    Frame.Navigate(typeof(MainPage));
                }
                catch (InvalidOperationException)
                {
                    message = "You must log in. Login Required";
                }

                //extend

                var dialog = new MessageDialog(message);
                dialog.Commands.Add(new UICommand("OK"));
                await dialog.ShowAsync();
            }
        }
示例#5
0
        public userItem GetUserByEmail(string email)
        {
            uc = new UserController();
            userItem result = uc.GetUserByEmail(email);

            return(result);
        }
 protected override void OnNavigatedTo(NavigationEventArgs e)
 {
     base.OnNavigatedTo(e);
     thisuser      = (userItem)e.Parameter;
     UserName.Text = "Hello " + thisuser.UserName + "!";
     menuManager.Getmenus("Eastern", menuItems);
     TitleTextBlock.Text = "Eastern Food";
 }
 private void delete_Click(object sender, RoutedEventArgs e)
 {
     if (dataGrid.SelectedItem != null)
     {
         userItem i = (userItem)dataGrid.SelectedItem;
         userManager.Remove(i.UserName);
         peopleViewModel.staticData.Remove(i);
         dataGrid.SelectedItem = null;
     }
 }
        private void testUser_Click(object sender, RoutedEventArgs e)
        {
            string result = "";

            userManager.BuildDatabase();
            userManager.Insert(new userItem("yao", "yao", 1, "hello", "12345", "*****@*****.**"));
            userManager.Insert(new userItem("zhang", "zhang", 0, "hello", "12345", "*****@*****.**"));
            userManager.Insert(new userItem("new", "new", 1, "hello", "12345", "*****@*****.**"));
            userManager.Insert(new userItem("hello", "hello", 0, "hello", "12345", "*****@*****.**"));
            List <userItem> res = userManager.GetAItem();

            for (int i = 0; i < res.Count; i++)
            {
                result += res.ElementAt(i).UserName;
                result += "  ";
                result += res.ElementAt(i).Password;
                result += "  ";
                result += res.ElementAt(i).Authority;
                result += "  ";
                result += res.ElementAt(i).Image;
                result += "  ";
                result += res.ElementAt(i).Phone;
                result += "  ";
                result += res.ElementAt(i).Email;
                result += "\n";
            }
            userManager.Update("zhang", new userItem("zhangflu", "handsome", 1, "cool", "12345", "*****@*****.**"));
            userItem temp = userManager.GetAItem("zhangflu");

            result += temp.UserName;
            result += "  ";
            result += temp.Password;
            result += "  ";
            result += temp.Authority;
            result += "\n";
            userManager.Remove("hello");
            bool bool1 = userManager.isAdministrator("root");
            bool bool2 = userManager.isAdministrator("yao");

            result    += bool1;
            result    += "\n";
            result    += bool2;
            result    += "\n";
            result    += userManager.check("zhangflu", "handsome");
            result    += userManager.check("root", "hhh");
            result    += userManager.check("r", "hhh");
            result    += "\n";
            result    += safeManager.checkInjection("update MaterialItem set Name = \'hhh\' wherE Name = \'egg\'");
            result    += safeManager.checkInjection("i am handsome");
            test3.Text = result;
        }
        private void CreateCustomer_Click(object sender, RoutedEventArgs e)
        {
            userItem newItem = new userItem("samplename", " ", 0, "", "", "");

            peopleViewModel.staticData.Add(newItem);
            dataGrid.SelectItem(newItem);
            dataGrid.ScrollItemIntoView(newItem, () =>
            {
                try
                {
                    dataGrid.BeginEdit(dataGrid.SelectedItem);
                }
                catch
                {
                }
            });
        }
 //public userManager()
 //{
 //    BuildDatabase();
 //}
 public static bool Insert(userItem inputUserItem)
 {
     if (isExist(inputUserItem.UserName))
     {
         return(false);
     }
     using (var custstmt = ((App)App.Current).conn.Prepare("INSERT INTO UserDataBase (UserName, Password, Authority, Image, Phone, Email) VALUES (?, ?, ?, ?, ?, ?)"))
     {
         custstmt.Bind(1, inputUserItem.UserName);
         custstmt.Bind(2, safeManager.SHA1it(inputUserItem.Password));
         custstmt.Bind(3, inputUserItem.Authority);
         custstmt.Bind(4, inputUserItem.Image);
         custstmt.Bind(5, inputUserItem.Phone);
         custstmt.Bind(6, inputUserItem.Email);
         custstmt.Step();
     }
     return(true);
 }
 //传递三个参数改动一条记录
 public static bool Update(string oldItemName, userItem newItem)
 {
     if (!isExist(oldItemName))
     {
         return(false);
     }
     using (var custstmt = ((App)App.Current).conn.Prepare("UPDATE UserDataBase SET UserName = ? ,Password = ? ,Authority = ?, Image = ?, Phone = ?, Email = ? WHERE UserName=?"))
     {
         custstmt.Bind(1, newItem.UserName);
         custstmt.Bind(2, safeManager.SHA1it(newItem.Password));
         custstmt.Bind(3, newItem.Authority);
         custstmt.Bind(4, newItem.Image);
         custstmt.Bind(5, newItem.Phone);
         custstmt.Bind(6, newItem.Email);
         custstmt.Bind(7, oldItemName);
         custstmt.Step();
     }
     return(true);
 }
        //得到所有记录
        public static List <userItem> GetAItem()
        {
            List <userItem> result = new List <userItem>();

            using (var statement = ((App)App.Current).conn.Prepare("SELECT UserName,Password,Authority,Image,Phone,Email FROM UserDataBase"))
            {
                while (SQLiteResult.ROW == statement.Step())
                {
                    userItem temp = new userItem(
                        (string)statement[0],
                        (string)statement[1],
                        (int)(Int64)statement[2],
                        (string)statement[3],
                        (string)statement[4],
                        (string)statement[5]
                        );
                    result.Add(temp);
                }
            }
            return(result);
        }
        //通过用户名查找人名
        public static userItem GetAItem(string inputUserName)
        {
            userItem result = null;

            using (var statement = ((App)App.Current).conn.Prepare("SELECT UserName,Password,Authority,Image,Phone,Email FROM UserDataBase WHERE UserName = ? "))
            {
                statement.Bind(1, inputUserName);
                while (SQLiteResult.ROW == statement.Step())
                {
                    result = new userItem(
                        (string)statement[0],
                        (string)statement[1],
                        (int)(Int64)statement[2],
                        (string)statement[3],
                        (string)statement[4],
                        (string)statement[5]
                        );
                }
            }
            return(result);
        }
        //通过权限查找人名
        public static List <userItem> queryByAuthority(string inputAuthority)
        {
            List <userItem> result            = new List <userItem>();
            string          newInputAuthority = "%" + inputAuthority + "%";

            using (var statement = ((App)App.Current).conn.Prepare("SELECT UserName,Password,Authority,Image,Phone,Email FROM UserDataBase WHERE Authority LIKE ? "))
            {
                statement.Bind(1, newInputAuthority);
                while (SQLiteResult.ROW == statement.Step())
                {
                    userItem temp = new userItem(
                        (string)statement[0],
                        (string)statement[1],
                        (int)(Int64)statement[2],
                        (string)statement[3],
                        (string)statement[4],
                        (string)statement[5]
                        );
                    result.Add(temp);
                }
            }
            return(result);
        }
 private void PassportSignInButton_Click(object sender, RoutedEventArgs e)
 {
     UserName = username.Text;
     pass     = passw.Password;
     if (!safeManager.checkInjection(UserName))
     {
         ErrorMessage.Text = "The input is unsafe";
     }
     else if (userManager.isExist(UserName))
     {
         userItem thisuser = userManager.GetAItem(UserName);
         if (userManager.check(UserName, pass))
         {
             if (check)
             {
                 AccountHelper.AddAccount(thisuser.UserName);
             }
             if (thisuser.Authority == 1)
             {
                 Frame.Navigate(typeof(ServicePage), thisuser);
             }
             else
             {
                 Frame.Navigate(typeof(userlistpage), thisuser);
             }
         }
         else
         {
             ErrorMessage.Text = "The password is incorrect";
         }
     }
     else
     {
         ErrorMessage.Text = "The user does not exist";
     }
 }
示例#16
0
    public static keysFromCompanyTitleResult keysFromCompanyTitle(string companyTitle) {
      var db = NewData.Lib.CreateContext();
      if (companyTitle.EndsWith(" *")) companyTitle = companyTitle.Substring(0, companyTitle.Length - 2);
      var demoCompanyTitle = companyTitle + " *";
      long hash = demoCompanyTitle.GetHashCode(); var host = "blend." + hash;
      var company = db.Companies.FirstOrDefault(c => c.ScormHost == host);
      UserLicence lSpravce = null; UserLicence lStudent = null; UserLicence lUcitel = null; UserLicence lStudentDe = null; UserLicence lUcitelDe = null;
      User uSpravce = null; User uStudent = null; User uUcitel = null; User uStudentDe = null; User uUcitelDe = null;
      var result = new keysFromCompanyTitleResult() { companyTitle = demoCompanyTitle };
      if (company == null) {
        db.Companies.Add(company = new Company() { Title = demoCompanyTitle, Created = DateTime.UtcNow, ScormHost = host });
        var dep = new CompanyDepartment() { Title = company.Title, Company = company };
        db.CompanyDepartments.Add(dep);

        CompanyLicence schoolManLic = null; CompanyLicence englishLic = null;
        foreach (var prodId in new string[] { "/lm/blcourse/schoolmanager.product/", "/lm/prods_lm_blcourse_english/", "/lm/prods_lm_blcourse_french/", "/lm/prods_lm_blcourse_german/" }) {
          var compLicence = new CompanyLicence() { Company = company, Days = 100, ProductId = prodId, Created = DateTime.UtcNow, LastCounter = 10 };
          if (schoolManLic == null) schoolManLic = compLicence; else if (englishLic == null) englishLic = compLicence;
          db.CompanyLicences.Add(compLicence);
        }

        //users
        int lastCounter = 1;
        foreach (var userId in new string[] { "spravce", "ucitel", "student", "ucitelde", "studentde" }) {
          var user = new User() { EMail = userId + "@" + hash + ".cz", Password = "******", FirstName = userId, LastName = "", Created = DateTime.UtcNow, OtherType = (short)OtherType.LANGMaster };
          db.Users.Add(user);
          var compUser = new CompanyUser() { Company = company, User = user, Created = DateTime.UtcNow, CompanyDepartment = dep };
          db.CompanyUsers.Add(compUser);
          if (userId == "spravce") {
            uSpravce = user;
            var courseUser = new CourseUser() { CompanyUser = compUser, Created = DateTime.UtcNow, ProductId = "/lm/blcourse/schoolmanager.product/" };
            db.CourseUsers.Add(courseUser);
            var userLicence = lSpravce = new UserLicence() { CompanyLicence = schoolManLic, CourseUser = courseUser, Started = DateTime.UtcNow, Created = DateTime.UtcNow, Counter = lastCounter++ };
            db.UserLicences.Add(userLicence);
          } else {
            var courseId = userId == "ucitel" || userId == "student" ? "english" : "german";
            var courseUser = new CourseUser() { CompanyUser = compUser, Created = DateTime.UtcNow, ProductId = "/lm/prods_lm_blcourse_" + courseId + "/" };
            db.CourseUsers.Add(courseUser);
            var userLicence = new UserLicence() { CompanyLicence = englishLic, CourseUser = courseUser, Started = DateTime.UtcNow, Created = DateTime.UtcNow, Counter = lastCounter++ };
            db.UserLicences.Add(userLicence);
            switch (userId) {
              case "ucitel": lUcitel = userLicence; uUcitel = user; break;
              case "student": lStudent = userLicence; ; uStudent = user; break;
              case "ucitelde": lUcitelDe = userLicence; uUcitelDe = user; break;
              case "studentde": lStudentDe = userLicence; ; uStudentDe = user; break;
            }
          }
        }

        db.SaveChanges();
        result.newCompanyId = company.Id;

      } else {
        lSpravce = db.UserLicences.Where(l => l.CourseUser.CompanyUser.Company.ScormHost == host && l.CourseUser.CompanyUser.User.EMail == "spravce@" + hash + ".cz" && l.CourseUser.ProductId == "/lm/blcourse/schoolmanager.product/").First();
        lUcitel = db.UserLicences.Where(l => l.CourseUser.CompanyUser.Company.ScormHost == host && l.CourseUser.CompanyUser.User.EMail == "ucitel@" + hash + ".cz" && l.CourseUser.ProductId == "/lm/prods_lm_blcourse_english/").First();
        lStudent = db.UserLicences.Where(l => l.CourseUser.CompanyUser.Company.ScormHost == host && l.CourseUser.CompanyUser.User.EMail == "student@" + hash + ".cz" && l.CourseUser.ProductId == "/lm/prods_lm_blcourse_english/").First();
        lUcitelDe = db.UserLicences.Where(l => l.CourseUser.CompanyUser.Company.ScormHost == host && l.CourseUser.CompanyUser.User.EMail == "ucitelde@" + hash + ".cz" && l.CourseUser.ProductId == "/lm/prods_lm_blcourse_german/").FirstOrDefault();
        lStudentDe = db.UserLicences.Where(l => l.CourseUser.CompanyUser.Company.ScormHost == host && l.CourseUser.CompanyUser.User.EMail == "studentde@" + hash + ".cz" && l.CourseUser.ProductId == "/lm/prods_lm_blcourse_german/").FirstOrDefault();
      }
      Func<UserLicence, User, userItem> createUserItem = (lic, user) => {
        if (lic == null) return null;
        userItem res = new userItem() { licId = lic.LicenceId, licCounter = lic.Counter };
        if (user != null) { res.email = user.EMail; res.firstName = user.FirstName; res.lastName = user.LastName; res.lmcomId = user.Id; }
        return res;
      };
      var master = PrepareDemoData.createEmptyCompany(companyTitle);
      result.admin = createUserItem(lSpravce, uSpravce);
      result.teacher = createUserItem(lUcitel, uUcitel);
      result.student = createUserItem(lStudent, uStudent);
      result.teacherDe = createUserItem(lUcitelDe, uUcitelDe);
      result.studentDe = createUserItem(lStudentDe, uStudentDe);
      result.masterLicId = master.licId;
      result.masterLLicCounter = master.licCounter;
      return result;
    }
示例#17
0
 public int ThirdPartyLogin(userItem user)
 {
     uc = new UserController();
     int result = uc.thirdPartyLogin(user);
     return result;
 }
示例#18
0
 public int SaveUser(userItem user)
 {
     uc = new UserController();
     int result = uc.SaveUser(user);
     return result;
 }
示例#19
0
        private async void InsertUserItem(userItem userItem)
        {
            await usersTable.InsertAsync(userItem);

            userItems.Add(userItem);
        }
 protected override void OnNavigatedTo(NavigationEventArgs e)
 {
     base.OnNavigatedTo(e);
     thisuser      = (userItem)e.Parameter;
     UserName.Text = "Hello " + thisuser.UserName + "!";
 }