private void listViewEmployee_Click(object sender, EventArgs e)
{
if (listViewEmployee.SelectedItems.Count != 0)
{
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), listViewEmployee.SelectedItems[0].Index);
}
}
public Affiliate(int waitMillisec, int SkinsID)
{
m_waitMillisec = waitMillisec;
m_SkinsID = SkinsID;
string cnString = CConfig.stGetConfigValue("DatabaseConnectionString", false);
oDB = new CSQL(cnString);
}
private void Form1_Load(object sender, EventArgs e)
{
List <CDepartment> Departments = CSQL.GetDepartments();
SetNodes(treeView1, Departments,
CBranch.GetDepartmentsByParentDepartmentID(Departments, "").ToList()[0] as CDepartment);
treeView1.SelectedNode = treeView1.Nodes[0];
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), 0);
}
private void ButtonUpdDept_Click(object sender, EventArgs e)
{
CSQL.UpdateDeptIDInEmployee(EMPOLOYEE);
treeView1.NodeMouseClick -= treeView1_NodeMouseDeptToEmp_Click;
treeView1.NodeMouseClick += treeView1_NodeMouseClick;
Button bn = this.Controls.Find("UpdDept", true).FirstOrDefault() as Button;
splitContainer1.Panel2.Enabled = true;
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), listViewEmployee.SelectedItems[0].Index);
bn.Dispose();
}
private void buttonInsEmp_Click(object sender, EventArgs e)
{
if (listViewEmployee.SelectedItems.Count != 0)
{
CSQL.InsertIntoEmployee(GetDateFromEditors());
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), listViewEmployee.SelectedItems[0].Index);
}
else
{
MessageBox.Show("Нет данных для обновленя");
}
}
private void Dispose(bool disposing)
{
if (!this.disposed)
{
if (disposing)
{
}
if (oDB != null)
{
oDB.CloseConnection(true);
oDB = null;
}
}
disposed = true;
}
public int UpdateAvatarData(int UserID, string file, string size)
{
CSQL oDB = null;
try
{
string cnString = CConfig.stGetConfigValue("DatabaseConnectionString", false);
oDB = new CSQL(cnString);
DataRow dt = oDB.GetFirstRow("admGetUserLoginName", CommandType.StoredProcedure,
CSQL.GetArrayListParameters(new object [] { "@id", UserID }));
if (dt == null)
{
return(-1);
}
string lName = dt[0].ToString();
string mPath = CConfig.stGetConfigValue("AvatarUploadURL", false);
if (mPath == String.Empty)
{
return(-2);
}
mPath += lName; //+"/"+file;
int ret = oDB.ExecuteNonQueryWithReturnID("admSaveAvatar", CommandType.StoredProcedure,
CSQL.GetArrayListParameters(new object [] { "@UserID", UserID, "@Path", mPath, "@File", file, "@Size", size }));
mPath = GetDestinationPath("");
mPath += "\\Avatars";
ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.CreateNoWindow = true;
startInfo.UseShellExecute = false;
startInfo.WorkingDirectory = mPath;
startInfo.FileName = mPath + "\\" + CConfig.stGetConfigValue("FileSecurityBat", false);
startInfo.Arguments = string.Format("{0} {1}", mPath, mPath + "\\" + lName);
bool bRes = WSCommon.RunCommand(ref startInfo, 60000, this);
return(bRes?ret:-100);
}
catch (Exception ex)
{
CLog.stLogException(ex);
return(-100);
}
finally
{
if (oDB != null)
{
oDB.CloseConnection(true);
}
}
}
public void Start()
{
CSQL sql = new CSQL();
wordList = new List <string>();
if (!sql.start())
{
Console.WriteLine("Reverting to secondary list...");
wordList.Add("gubbe");
wordList.Add("dator");
wordList.Add("nätverk");
}
clientList = new List <SClient>();
IPHostEntry host;
string LocalIp = "";
host = Dns.GetHostEntry(Dns.GetHostName());
foreach (IPAddress ip in host.AddressList)
{
if (ip.AddressFamily == AddressFamily.InterNetwork)
{
LocalIp = ip.ToString();
break;
}
}
server = new TcpListener(IPAddress.Parse(LocalIp), 80);
server.Start();
Console.WriteLine("Server has started on: " + LocalIp + "{0}Waiting for a connection...", Environment.NewLine);
ClientConnection = new Thread(new ThreadStart(Clientconnected));
ClientConnection.Start();
gameThread = new Thread(new ThreadStart(gameListener));
gameThread.Start();
//ClientMessage = new Thread(new ThreadStart(Clientmessage));
//ClientMessage.Start();
while (true)
{
Console.ForegroundColor = ConsoleColor.Blue;
string message = "Server: " + Console.ReadLine();
sendMessagetoClients(message, null);
}
}
private void buttonUpbEmp_Click(object sender, EventArgs e)
{
if (GetDateFromEditors().ID != "")
{
try
{
CSQL.UpdateEmployee(GetDateFromEditors());
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), listViewEmployee.SelectedItems[0].Index);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Нет данных для сохранения");
}
}
private void ButtonDelEmp_Click(object sender, EventArgs e)
{
if (listViewEmployee.SelectedItems.Count != 0)
{
if (MessageBox.Show("Вы уверены, что хотите удалить выбранного сотрудника?", "Удаление", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
CSQL.DeleteFromEmployee(GetDateFromEditors());
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), listViewEmployee.SelectedItems[0].Index);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("Нет данных для удаления");
}
}
private void treeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
treeView1.SelectedNode = e.Node;
UpdListEmployee(CSQL.GetEmployeesByDepartmentID(treeView1.SelectedNode.Tag.ToString()), 0);
}
