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);
}
});
}
