protected void deleteUserButton_Click(object sender, EventArgs e) { LinkButton button = sender as LinkButton; string[] p = button.CommandArgument.Split(new char[] { '|' }); string partitionKey = p[0]; string rowKey = p[1]; usr u = new usr() { PartitionKey = partitionKey, RowKey = rowKey }; zlnkDC svc = new zlnkDC(); svc.AttachTo("usrs", u, "*"); svc.DeleteObject(u); try { svc.SaveChanges(); } catch (DataServiceRequestException e2) { } }
public ActionResult Login(usr user) { var usr = db.usrs.Where(u => u.userName == user.userName && u.userPassword == user.userPassword).FirstOrDefault(); if (usr != null) { Session["UserId"] = usr.userId.ToString(); Session["Username"] = usr.userName.ToString(); Session["UserType"] = usr.userType.ToString(); if (Session["UserType"].ToString() == "Admin") { return(RedirectToAction("Index", "users")); } else if (Session["UserType"].ToString() == "Agent") { return(RedirectToAction("Index", "Bookings")); } else { return(RedirectToAction("Login")); } } else { ModelState.AddModelError("", "Username or Password is wrong."); } return(View()); }
public ActionResult DeleteConfirmed(int id) { usr usr = db.usrs.Find(id); db.usrs.Remove(usr); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "userId,userName,userPassword,userType")] usr usr) { if (ModelState.IsValid) { db.Entry(usr).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(usr)); }
public ActionResult Create([Bind(Include = "userId,userName,userPassword,userType")] usr usr) { if (ModelState.IsValid) { db.usrs.Add(usr); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(usr)); }
public ActionResult Search(string search, usr x) { //if a user choose the radio button option as Subject if (search != "") { //Index action method will return a view with a student records based on what a user specify the value in textbox return(View("Index", db.usrs.Where(db => db.userName == search).ToList())); } else { return(View(db.usrs.ToList())); } }
public void render_me(auth a) { if (a.result) { pr = Instantiate(prefab_pr, new Vector3(), new Quaternion()); usr p = pr.GetComponent <usr>(); p.ini(a.value.photo); p.id = a.value.id; p.name = a.value.name; p.position = new Vector3((float)a.value.coord[0], (float)a.value.coord[0], 0); p.status = a.value.status; } }
// GET: users/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } usr usr = db.usrs.Find(id); if (usr == null) { return(HttpNotFound()); } return(View(usr)); }
protected void ActivateUserButton_Click(object sender, EventArgs e) { LinkButton button = sender as LinkButton; string[] p = button.CommandArgument.Split(new char[] { '|' }); string partitionKey = p[0]; string rowKey = p[1]; zlnkDC svc = new zlnkDC(); usr us = (from u in svc.usrs where u.PartitionKey == partitionKey && u.RowKey == rowKey select u).FirstOrDefault <usr>(); us.IsActive = us.IsActive ? false : true; svc.UpdateObject(us); svc.SaveChanges(); }
public static bool GetUserDomain(string sUN, out string sShortDN, out string sLongDN) { try { zlnkDC svc = new zlnkDC(); usr us = (from u in svc.usrs where u.UN == sUN && u.IsActive.Equals(true) select u).First <usr>(); sShortDN = us.ShortDN; sLongDN = us.LongDN; return(true); } catch { sShortDN = ""; sLongDN = ""; return(false); } }
protected void btnLogin_Click(object sender, EventArgs e) { zlnkDC svc = new zlnkDC(); try { usr us = (from u in svc.usrs where u.UN == txtUN0.Text && u.Pwd == CryptoHelper.Encrypt(txtPwd0.Text) select u).First <usr>(); if (us.IsActive) { LoadLinks(); } } catch { lblMesssage.Text = "your account info is wrong"; } }
public void render_or(user_info a) { if (ini.finBbyId(a.id) == null) { GameObject ty = Instantiate(prefab_pr, new Vector3(), new Quaternion()); ty.name = "fd_" + a.id; usr p = ty.GetComponent <usr>(); p.ini(a.photo); p.id = a.id; p.position = new Vector3((float)a.coord[0], (float)a.coord[0], 0); p.status = a.status; ty.transform.position = new Vector3((float)a.coord[0], (float)a.coord[0], 0); } else { GameObject ty = ini.finBbyId(a.id); ty.transform.position = new Vector3((float)a.coord[0], (float)a.coord[0], 0); } }
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context) { context.OwinContext.Response.Headers.Add("Access-Control-Allow-Origin", new[] { "*" }); var identity = new ClaimsIdentity(context.Options.AuthenticationType); using (var db = new ddiarydbEntities()) { var user = new usr(); if (Regex.IsMatch(context.UserName, @"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}", RegexOptions.IgnoreCase)) { user = db.usrs.FirstOrDefault(x => x.Email == context.UserName); } else if (Regex.IsMatch(context.UserName, @"(\d*-)?\d{10}", RegexOptions.IgnoreCase)) { user = (from x in db.Doctor_Master join u in db.usrs on x.User_id equals u.Id where x.Doctor_contact == context.UserName select u).FirstOrDefault(); } else { user = null; } if (user != null && user.passwd == context.Password) { identity.AddClaim(new Claim(ClaimTypes.Role, "user")); identity.AddClaim(new Claim("username", user.Email)); identity.AddClaim(new Claim(ClaimTypes.Name, user.Firstname + " " + user.Lastname)); context.Validated(identity); } else { context.SetError("invalid_grant", "Provided username and password is incorrect"); return; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { zlnkDC svc = new zlnkDC(); if (txtSDN.Text.EndsWith("/")) { txtSDN.Text = txtSDN.Text.Remove(txtSDN.Text.Length - 1); } if (txtODN.Text.EndsWith("/")) { txtODN.Text = txtODN.Text.Remove(txtODN.Text.Length - 1); } string PLID = "free"; if (txtSDN.Text.Trim() != "http://zlnk.net") { PLID = "pro1"; } try { usr us = (from u in svc.usrs where u.UN == txtUN.Text select u).First <usr>(); lblMesssage.Text = "Username is already in use"; } catch { usr user = new usr(txtUN.Text, CryptoHelper.Encrypt(txtPwd.Text), txtSDN.Text, txtODN.Text, txtEmail.Text, PLID); user.IsActive = true; svc.AddObject("usrs", user); svc.SaveChanges(); lblMesssage.Text = "Your user account got created"; } }
public string Post([FromBody] JObject jObj) { DBEntities db = new DBEntities(); List <usr> uData = db.usr.ToList(); List <course> cData = db.course.ToList(); List <uc> ucData = db.uc.ToList(); string type = jObj["type"].ToString(); //客户端操作类型 if (type.Equals("login")) { string inNo = jObj["no"].ToString(); string inPw = jObj["pw"].ToString(); //匹配成功,返回users的id,密码错误返回-1, 账号不存在返回0 for (int i = 0; i < uData.Count; i++) { if (uData[i].no == inNo) { if (uData[i].pw == inPw) { return(uData[i].uid.ToString()); } else { return("-1"); } } } return("0"); } else if (type.Equals("register")) { string no = jObj["no"].ToString(); string pw = jObj["pw"].ToString(); string school = jObj["school"].ToString(); string major = jObj["major"].ToString(); usr uTmp = db.usr.Where(usr => usr.no == no).FirstOrDefault(); if (uTmp == null) { usr u = new usr() { no = no, pw = pw, school = school, major = major }; db.usr.Add(u); if (db.SaveChanges() > 0) { return("1"); } return("-1"); } else { return("0"); } } else if (type.Equals("getCourseInfo")) { int uid = int.Parse(jObj["uid"].ToString()); //得到客户端当前登录用户的id List <course> cUidData = new List <course>(); //储存匹配到的当前用户的课程信息 for (int i = 0; i < ucData.Count; i++) { if (ucData[i].uid == uid) { for (int j = 0; j < cData.Count; j++) { if (cData[j].cid == ucData[i].cid) { course c = new course(); //一条课程记录 c.cid = cData[j].cid; c.coursename = cData[j].coursename; c.teacher = cData[j].teacher; c.classroom = cData[j].classroom; c.classstart = cData[j].classstart; c.classend = cData[j].classend; c.day = cData[j].day; cUidData.Add(c); } } } } return(JsonConvert.SerializeObject(cUidData)); } else if (type.Equals("addCourse") || type.Equals("editCourse") || type.Equals("delCourse")) { int uid = int.Parse(jObj["uid"].ToString()); //得到当前用户的id int cid = int.Parse(jObj["cid"].ToString()); //得到课程id,若type为edit则为修改前的id,若为del则为要删除的id, 若为add则为0(防止空指针异常) if (type.Equals("delCourse")) //删除操作 { uc ucTmp = db.uc.Where(uc => uc.uid == uid && uc.cid == cid).FirstOrDefault(); db.uc.Remove(ucTmp); } else { //得到修改后的课程 string cn = jObj["coursename"].ToString(); string tn = jObj["teacher"].ToString(); string cr = jObj["classroom"].ToString(); int cs = int.Parse(jObj["classstart"].ToString()); int ce = int.Parse(jObj["classend"].ToString()); int day = int.Parse(jObj["day"].ToString()); if (type.Equals("addCourse")) //若添加的课程与已存在的课程时间段有重合,则添加失败 { List <course> cSEList = db.course.Where(course => course.classstart >= cs && course.classend <= ce && course.day == day).ToList(); List <uc> ucUidList = db.uc.Where(uc => uc.uid == uid).ToList(); for (int i = 0; i < cSEList.Count; i++) { for (int j = 0; j < ucUidList.Count; j++) { if (cSEList[i].cid == ucUidList[j].cid) { return("0"); } } } } course cTmp1 = db.course.Where(course => course.coursename == cn && course.teacher == tn && course.classroom == cr && course.classstart == cs && course.classend == ce && course.day == day ).FirstOrDefault(); course c = new course(); course cTmp2 = new course(); if (cTmp1 == null) { cTmp2.coursename = cn; cTmp2.teacher = tn; cTmp2.classroom = cr; cTmp2.classstart = cs; cTmp2.classend = ce; cTmp2.day = day; db.course.Add(cTmp2); db.SaveChanges(); c = cTmp2; } else { c = cTmp1; } if (type.Equals("addCourse")) //添加操作 { uc ucTmp = new uc() { uid = uid, cid = c.cid }; db.uc.Add(ucTmp); } else if (type.Equals("editCourse")) //编辑操作 { uc ucUid = db.uc.Where(uc => uc.uid == uid && uc.cid == cid).FirstOrDefault(); ucUid.cid = c.cid; } cid = c.cid; //便于返回cid } if (db.SaveChanges() > 0) { return(cid.ToString()); } return("0"); } return("0"); }
public static void show_stat(stats form_stat) { form_stat.fLP.Controls.Clear(); List <stat> stat = load_stat("data\\results\\results.csv"); if (stat == null) { MessageBox.Show("Проидите хотя бы один тест"); return; } string[] users = new string[stat.Count]; for (int i = 0; i < stat.Count; i++) { users[i] = stat[i].login; } users = users.Distinct().ToArray(); List <usr> struct_users = new List <usr>(); usr tmp_user = new usr(); foreach (string user in users) { List <stat> s = stat.FindAll(a => a.login == user); int sum = 0, percent = 0; foreach (var test in s) { sum += Convert.ToInt32(test.percent); } percent = sum / s.Count; tmp_user.user = user; tmp_user.percent = percent; tmp_user.fio = s[0].fio; struct_users.Add(tmp_user); } // соритровка по кол-ву баллов struct_users.Sort((a, b) => (b.percent.CompareTo(a.percent))); foreach (usr user in struct_users) { Label lb = new Label(); lb.AutoSize = true; lb.Anchor = AnchorStyles.None; lb.Dock = DockStyle.Fill; //lb.TextAlign = ContentAlignment.MiddleCenter; lb.TextAlign = ContentAlignment.MiddleLeft; lb.ForeColor = Color.FromArgb(255, 200, 255, 255); lb.Font = new Font("Times New Roman", 15, FontStyle.Bold); lb.Text = "\r\n" + user.fio + ": " + user.percent + "%\r\n"; form_stat.fLP.WrapContents = false; form_stat.fLP.Controls.Add(lb); } // Sort((a, b) => (a.ToString()[0].CompareTo(b.ToString()[0]))); form_stat.Show(); }