public dynamic GetUser(string uName) { dynamic table = new sUser(); var objUser = table.First(UserName: uName); return(objUser); }
public UserInfoForm(int id, int action) : this() { this._uid = id; this._action = action; if (action == 1) { tbUserName.Enabled = cbUserType.Enabled = false; } checkBox1.Checked = groupBox1.Enabled = (id == 0 || action == 1); checkBox1.Enabled = !groupBox1.Enabled; if (_uid != 0) { sUser ui = Engine.db().getUser(_uid); tbUserName.Text = ui.Name; switch (ui.Group) { case sUser.Admin: cbUserType.SelectedIndex = 0; break; case sUser.Zootech: cbUserType.SelectedIndex = 1; break; case sUser.Butcher: cbUserType.SelectedIndex = 2; break; } } if (_uid == Engine.get().UserID) { cbUserType.Enabled = false; } }
public void socketIoEmit(string name, int locked, String user, Socket socket, int userId, int fileId) { nameToChange = name; action = locked; sUser nowy = new sUser { user_id = userId, username = user, file_name = name, file_id = fileId }; sUser drugi = new sUser { username = user, file_name = name }; if (nameToChange != null) { if (action == 1) // 1 - jest zablokowany { socket.Emit("fileLocked", JsonConvert.SerializeObject(nowy)); //Console.WriteLine(nowy); Console.WriteLine("Locked -> Name: {0}, ID_file: {1}, user: {2}, ID_user: {3}", nameToChange, fileId, user, userId); } else if (action == 0) // 0 - jest odblokowany { socket.Emit("fileUnlocked", JsonConvert.SerializeObject(nowy)); Console.WriteLine("Unlocked -> Name: {0}, ID_file: {1}, user: {2}, ID_user: {3}", nameToChange, fileId, user, userId); } else if (action == 2) // 2 - jest nowy zapisany { socket.Emit("fileSaved", JsonConvert.SerializeObject(drugi)); Console.WriteLine("Saved -> Name: {0}, ID_file: {1}, user: {2}, ID_user: {3}", nameToChange, fileId, user, userId); } else if (action == 3) // 3- jest zmodyfikowany { socket.Emit("fileUpdated", JsonConvert.SerializeObject(nowy)); Console.WriteLine("Updated -> Name: {0}, ID_file: {1}, user: {2}, ID_user: {3}", nameToChange, fileId, user, userId); } } nameToChange = null; action = 4; socket.On(Socket.EVENT_DISCONNECT, () => { Console.WriteLine("Rozlaczono"); } ); }
/// <summary> /// Возвразает одного пользователя по ID /// </summary> /// <param name="uid">ID пользователя</param> /// <returns></returns> public sUser getUser(int uid) { MySqlDataReader rd = reader(String.Format("SELECT u_name,u_group,u_id FROM users WHERE u_id={0};", uid.ToString())); sUser res = null; while (rd.Read()) { res = new sUser(rd.GetInt32("u_id"), rd.GetString("u_name"), rd.GetString("u_group")); } rd.Close(); return(res); }
public ActionResult CreateUser(UserReqVM user) { using (LIVEEntities db = new LIVEEntities()) { sUser nw = new sUser(); nw.UserID = user.UserID; nw.UserName = user.UserName; nw.UserPass = user.UserPass; nw.UserPin = user.UserPin; nw.RoleId = user.RoleId; nw.MobileNo = user.MobileNo; nw.PlantNo = user.PlantNo; nw.Email = user.Email; nw.UserStatus = "ACT"; nw.LoginType = "A"; nw.ActiveSession = 0; nw.CreateBy = User.Identity.Name; nw.CreateDate = DateTime.Now; db.sUsers.Add(nw); db.SaveChanges(); return(RedirectToAction("Index")); } }
// GET: UserManage public ActionResult Index() { LIVEEntities db = new LIVEEntities(); List <sRole> role = db.sRoles.ToList(); ViewBag.RoleID = new SelectList(db.sRoles, "RoleID", "RoleName"); var data = db.sPlants.Select(s => new { Text = s.PlantNo + "---" + s.PlantCode + " --- " + s.PlantName, Value = s.PlantNo }).ToList(); ViewBag.PlantNo = new SelectList(data, "Value", "Text"); int value = db.sUsers.Max(a => a.UserID); int num = value; sUser usr = new sUser { UserID = (num + 1), }; return(View(usr)); }
public void socketIoManager(Socket socket, String user) { userLogged = user; sUser nowyUser = new sUser(); showIcon(); socket.On(Socket.EVENT_DISCONNECT, () => { Console.WriteLine("Rozlaczono"); } ); socket.On("fileLocked", (data) => { var locked = JsonConvert.DeserializeObject <sUser>(data.ToString()); nowyUser.username = locked.username; nowyUser.file_name = locked.file_name; if (!user.Equals(nowyUser.username)) { Console.WriteLine("SocketIO: zablokowano plik {0}, {1}", nowyUser.username, nowyUser.file_name); //MessageBox.Show("File " + nowyUser.file_name + " has been locked by " + nowyUser.username); lockedFile = nowyUser.file_name; lockf = nowyUser.file_name; Login.main.Toggle = false; _notifyIcon.Visible = true; _notifyIcon.ShowBalloonTip(3000, "File has been locked", nowyUser.file_name + ", locked by " + nowyUser.username, ToolTipIcon.Info); if (lockedFile.Equals(unlockedFile)) { returnUnlockedFile(); } } }); socket.On("fileUpdated", (data) => { var saved = JsonConvert.DeserializeObject <sUser>(data.ToString()); nowyUser.username = saved.username; nowyUser.file_name = saved.file_name; if (!user.Equals(nowyUser.username)) { //MessageBox.Show("File " + nowyUser.file_name + " has been modified.\nPlease, refresh."); modifiedFile = nowyUser.file_name; modifiedBy = nowyUser.username; Login.main.refreshWindow = ""; _notifyIcon.Visible = true; _notifyIcon.ShowBalloonTip(3000, "A file has been modified", nowyUser.file_name + ", modified by " + nowyUser.username, ToolTipIcon.Info); } }); socket.On("fileUnlocked", (data) => { var unlocked = JsonConvert.DeserializeObject <sUser>(data.ToString()); nowyUser.username = unlocked.username; nowyUser.file_name = unlocked.file_name; if (!user.Equals(nowyUser.username)) { Console.WriteLine("SocketIO: odblokowano plik {0}, {1}", nowyUser.username, nowyUser.file_name); //MessageBox.Show("File " + nowyUser.file_name + " has been unlocked " + nowyUser.username); unlockedFile = nowyUser.file_name; unlockf = nowyUser.file_name; _notifyIcon.Visible = true; _notifyIcon.ShowBalloonTip(3000, "File has been unlocked", nowyUser.file_name + ", unlocked by " + nowyUser.username, ToolTipIcon.Info); if (nowyUser.file_name.Equals(lockf)) { lockf = null; } Login.main.Toggle = true; if (unlockedFile.Equals(lockedFile)) { returnLockedFile(); } } }); socket.On("fileSaved", (data) => { var saved = JsonConvert.DeserializeObject <sUser>(data.ToString()); nowyUser.username = saved.username; nowyUser.file_name = saved.file_name; if (!user.Equals(nowyUser.username)) { //MessageBox.Show("File " + nowyUser.file_name + " hase been saved.\nPlease, refresh."); savedFile = nowyUser.file_name; Login.main.CleanFiles = true; Login.main.UploadFiles = true; _notifyIcon.Visible = true; _notifyIcon.ShowBalloonTip(3000, "New file has been saved", nowyUser.file_name, ToolTipIcon.Info); } }); }