public string Create(string UserName, string FullName, string DOB, string Email, string PhoneNumber, string Active, List <String> RoleName) { var accTest = _context.Accounts.Where(m => m.UserName == UserName).SingleOrDefault(); if (accTest == null) { if (ModelState.IsValid) { try { Account account = new Account() { UserName = UserName, Password = "******", FullName = FullName, DOB = DateTime.ParseExact(DOB, "dd/MM/yyyy", null), Email = Email, PhoneNumber = PhoneNumber, Active = Convert.ToBoolean(Active), }; _context.Accounts.Add(account); foreach (var i in RoleName) { Account_Role ar = new Account_Role() { RoleName = i, UserName = UserName }; _context.Account_Roles.Add(ar); } _context.SaveChanges(); return("success"); }catch (DbUpdateConcurrencyException) { return(""); } } } else if (accTest != null) { ModelState.AddModelError("UserNameExist", "User Name này đã tồn tại"); } return("fail"); }
public bool CreateCatalog(string TagName, string deviceName, string Address, string Unit, string WarningMin, string WarningMax) { try { Catalog_Data cld = new Catalog_Data() { TagName = TagName, DeviceName = deviceName, Address = Address, Unit = Unit, WarnningMin = double.Parse(WarningMin), WarnningMax = double.Parse(WarningMax) }; _context.Add(cld); _context.SaveChanges(); } catch { return(false); } return(true); }
public string UpdateDeivces(string name, string nameShow, string branchOrProtocol) { try { var d = _context.Devices.Find(name); if (d == null) { return("device không tồn tại"); } d.NameShow = nameShow; d.Name = name; d.BranchOrProtocol = branchOrProtocol; //remove _context.SaveChanges(); } catch (Exception ex) { return("Update device không thành công !!!"); } return("success"); }
public string UpdateRole(string RoleName, string Description, List <String> PermissionRole) { try { if (PermissionRole == null) { PermissionRole = new List <string>(); } var r = _context.Roles.Find(RoleName); if (r == null) { return("Role không tồn tại"); } r.Description = Description; //remove var getPer = _context.AccoPermission_Roles.Where(x => x.RoleName == RoleName); foreach (var i in getPer) { _context.AccoPermission_Roles.Remove(i); } //add new foreach (var i in PermissionRole) { var pe_ro = new Permission_Role() { RoleName = RoleName, PermissionID = int.Parse(i) }; _context.AccoPermission_Roles.Add(pe_ro); } _context.SaveChanges(); } catch (Exception ex) { } return("success"); }
public string Edit(string FullName, string Email, string Dob, string phoneNumber, string Password) { if (ModelState.IsValid) { var account = _db.Accounts.FirstOrDefault(x => x.UserName == HttpContext.Session.GetString("UserName").ToString()); if (account != null) { account.FullName = FullName; account.Password = Password; account.Email = Email; account.DOB = DateTime.ParseExact(Dob, "dd/MM/yyyy", null);; account.PhoneNumber = phoneNumber; } _db.SaveChanges(); HttpContext.Session.SetObjectAsJson("Account", account); return("success"); } return("fali"); }