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