public userItem GetUserById(string id) { uc = new UserController(); userItem result = uc.GetUserById(id); return(result); }
public int SaveUser(userItem user) { uc = new UserController(); int result = uc.SaveUser(user); return(result); }
public int ThirdPartyLogin(userItem user) { uc = new UserController(); int result = uc.thirdPartyLogin(user); return(result); }
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(); } }
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"; } }
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; }
public int ThirdPartyLogin(userItem user) { uc = new UserController(); int result = uc.thirdPartyLogin(user); return result; }
public int SaveUser(userItem user) { uc = new UserController(); int result = uc.SaveUser(user); return result; }
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 + "!"; }