private void button1_Click(object sender, EventArgs e) { // ConnectServer if (Login.Text.Length < 4 || Login.Text.Length < 4) { MessageBox.Show("Логін та пароль мають складатися не менше ніж з 4 символів!"); return; } rs.Login = Login.Text; rs.Parol = Parol.Text; rs = ConnectServer.GetDataServer(rs); //rs = new RiskManagementLib(); rs.isCorrect = 1; if (rs.isCorrect == 0) { MessageBox.Show("Неправильний логін або пароль!"); return; } if (FormS == null) { FormS = new FormSources(rs); thread1 = new Thread(new ParameterizedThreadStart(FormInThread)); thread1.Start(FormS); } else if (FormS.IsDisposed) { FormS = new FormSources(rs); thread1 = new Thread(new ParameterizedThreadStart(FormInThread)); thread1.Start(FormS); } Close(); }
private static void Conect() { IPHostEntry ipHostInfo = Dns.Resolve(Dns.GetHostName()); IPAddress ipAddress = ipHostInfo.AddressList[0]; // створення об’єкту порт+ IP-адреса IPEndPoint localEndPoint = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 12000); Socket listener = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); listener.Bind(localEndPoint); while (true) { listener.Listen(100); Socket handler = listener.Accept(); byte[] bytes = new byte[100000]; int count; // String data = " "; // отримання та надсилання даних count = handler.Receive(bytes); rs = (RiskManagementLib)Convertor.ByteArrayToObject(bytes, count); if (!Check()) { rs.isCorrect = 0; } Console.WriteLine("До БД доступається " + rs.Login); Byte[] SendBytes = Convertor.ObjectToByteArray(rs); handler.Send(SendBytes); handler.Shutdown(SocketShutdown.Both); handler.Close(); } }
public FormPotentialRiskEvents(RiskManagementLib _rs) { rs = _rs; InitializeComponent(); rs.CountPotentialRiskEvents(); CreateTable(); }
public FormSources(RiskManagementLib _rs) { rs = _rs; InitializeComponent(); rs.CountIdentyfyRisk(); //nameOfTable = nameOfT; CreateTable(); }
public FormAnalis(RiskManagementLib _rs) { rs = _rs; InitializeComponent(); CreateTable(); CreateTableRating(); CreateTablePossibility(); CreateTableExperts(); }
internal void ActivateFormAnalis(RiskManagementLib rs) { if (Application.OpenForms["FormAnalis"] == null) { formAnalis = new FormAnalis(rs); thread1 = new Thread(new ParameterizedThreadStart(FormInThread)); thread1.Start(formAnalis); } else { SetForegroundWindow(rs.FormAnalisProcess); } }
internal static bool SelectUsers(RiskManagementLib rs) { SqlCommand command; SqlConnection connection = new SqlConnection("Server=KALYAN\\MSSQLSERVER01; Database=RiskManagementDB; Integrated Security=true;"); connection.Open(); command = new SqlCommand("Select LoginUser, ParolUser, number from Users ", connection); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (rs.Login == reader.GetString(0) && rs.Parol == reader.GetString(1)) { rs.number = reader.GetInt32(2); return(true); } } return(false); } connection.Close(); }
public static bool SendToServer(RiskManagementLib rs) { string response = ""; rs.isCorrect = 2; Byte[] SendBytes = Convertor.ObjectToByteArray(rs);//ObjectToByteArray(message); Byte[] RecvBytes = new byte[100000]; int count; // визначення адреси сервера IPAddress address = Dns.Resolve("localhost").AddressList[0]; // встановлення порту IPEndPoint EPhost = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 12000); // формуваннняоб’єкту Socket Socket socket = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp); // З’єднання з сервером try { socket.Connect(EPhost); // пересилання ти приймання даних socket.Send(SendBytes, SendBytes.Length, SocketFlags.None); count = socket.Receive(RecvBytes); rs = (RiskManagementLib)Convertor.ByteArrayToObject(RecvBytes, count); if (rs.isCorrect == 0) { return(false); } return(true); } catch (Exception error) { MessageBox.Show("Error - " + error); } return(false); }
public Form1() { InitializeComponent(); rs = new RiskManagementLib(); ConnectServer.SendToServer(rs); }
public static void InsertToIdentifyRisk(RiskManagementLib rs) { SqlCommand command; SqlConnection connection = new SqlConnection("Server=KALYAN\\MSSQLSERVER01; Database=RiskManagementDB; Integrated Security=true;"); connection.Open(); using (command = new SqlCommand("DELETE FROM IdentifyRisk", connection)) { command.ExecuteNonQuery(); } string[] text; text = rs.technical; string sqlIns = "INSERT INTO IdentifyRisk (RiskName, Chance, Percents) VALUES (@name, @information, @other)"; try { command = new SqlCommand(sqlIns, connection); for (int k = 0; k < 4; k++) { switch (k) { case 0: text = rs.technical; break; case 1: text = rs.valueRisks; break; case 2: text = rs.planRisks; break; case 3: text = rs.procesRisks; break; } for (int i = 0; i < rs.IdentifyRisk[k].Length; i++) { command.Parameters.AddWithValue("@name", text[i]); command.Parameters.AddWithValue("@information", rs.IdentifyRisk[k][i]); if (i == 0) { command.Parameters.AddWithValue("@other", rs.percentRisk[k]); } else { command.Parameters.AddWithValue("@other", DBNull.Value); } command.ExecuteNonQuery(); command.Parameters.Clear(); } if (k == 3) { command.Parameters.AddWithValue("@name", DBNull.Value); command.Parameters.AddWithValue("@information", DBNull.Value); command.Parameters.AddWithValue("@other", rs.percentRisk[4]); command.ExecuteNonQuery(); } } command.Dispose(); command = null; } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { connection.Close(); } }
internal static void SelectAnalisRiskWithValidity(RiskManagementLib rs) { SqlCommand command; int i = 0; int k = 0; SqlConnection connection = new SqlConnection("Server=KALYAN\\MSSQLSERVER01; Database=RiskManagementDB; Integrated Security=true;"); connection.Open(); command = new SqlCommand("Select RiskName, Expert1, Expert2, Expert3, Expert4, Expert5, Expert6, Expert7, Expert8, Expert9, Expert10, Percents from AnalisRiskWithValidity ", connection); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (k == 0) { rs.eventTechnical[i] = reader.GetString(0); rs.analisRiskWithValidity[k][i, 0] = reader.GetDouble(1); rs.analisRiskWithValidity[k][i, 1] = reader.GetDouble(2); rs.analisRiskWithValidity[k][i, 2] = reader.GetDouble(3); rs.analisRiskWithValidity[k][i, 3] = reader.GetDouble(4); rs.analisRiskWithValidity[k][i, 4] = reader.GetDouble(5); rs.analisRiskWithValidity[k][i, 5] = reader.GetDouble(6); rs.analisRiskWithValidity[k][i, 6] = reader.GetDouble(7); rs.analisRiskWithValidity[k][i, 7] = reader.GetDouble(8); rs.analisRiskWithValidity[k][i, 8] = reader.GetDouble(9); rs.analisRiskWithValidity[k][i, 9] = reader.GetDouble(10); rs.analisRiskWithValidity[k][i, 10] = reader.GetDouble(11); } if (k == 1) { rs.eventValueRisks[i] = reader.GetString(0); rs.analisRiskWithValidity[k][i, 0] = reader.GetDouble(1); rs.analisRiskWithValidity[k][i, 1] = reader.GetDouble(2); rs.analisRiskWithValidity[k][i, 2] = reader.GetDouble(3); rs.analisRiskWithValidity[k][i, 3] = reader.GetDouble(4); rs.analisRiskWithValidity[k][i, 4] = reader.GetDouble(5); rs.analisRiskWithValidity[k][i, 5] = reader.GetDouble(6); rs.analisRiskWithValidity[k][i, 6] = reader.GetDouble(7); rs.analisRiskWithValidity[k][i, 7] = reader.GetDouble(8); rs.analisRiskWithValidity[k][i, 8] = reader.GetDouble(9); rs.analisRiskWithValidity[k][i, 9] = reader.GetDouble(10); rs.analisRiskWithValidity[k][i, 10] = reader.GetDouble(11); } if (k == 2) { rs.eventPlanRisks[i] = reader.GetString(0); rs.analisRiskWithValidity[k][i, 0] = reader.GetDouble(1); rs.analisRiskWithValidity[k][i, 1] = reader.GetDouble(2); rs.analisRiskWithValidity[k][i, 2] = reader.GetDouble(3); rs.analisRiskWithValidity[k][i, 3] = reader.GetDouble(4); rs.analisRiskWithValidity[k][i, 4] = reader.GetDouble(5); rs.analisRiskWithValidity[k][i, 5] = reader.GetDouble(6); rs.analisRiskWithValidity[k][i, 6] = reader.GetDouble(7); rs.analisRiskWithValidity[k][i, 7] = reader.GetDouble(8); rs.analisRiskWithValidity[k][i, 8] = reader.GetDouble(9); rs.analisRiskWithValidity[k][i, 9] = reader.GetDouble(10); rs.analisRiskWithValidity[k][i, 10] = reader.GetDouble(11); } if (k == 3) { rs.eventProcesRisks[i] = reader.GetString(0); rs.analisRiskWithValidity[k][i, 0] = reader.GetDouble(1); rs.analisRiskWithValidity[k][i, 1] = reader.GetDouble(2); rs.analisRiskWithValidity[k][i, 2] = reader.GetDouble(3); rs.analisRiskWithValidity[k][i, 3] = reader.GetDouble(4); rs.analisRiskWithValidity[k][i, 4] = reader.GetDouble(5); rs.analisRiskWithValidity[k][i, 5] = reader.GetDouble(6); rs.analisRiskWithValidity[k][i, 6] = reader.GetDouble(7); rs.analisRiskWithValidity[k][i, 7] = reader.GetDouble(8); rs.analisRiskWithValidity[k][i, 8] = reader.GetDouble(9); rs.analisRiskWithValidity[k][i, 9] = reader.GetDouble(10); rs.analisRiskWithValidity[k][i, 10] = reader.GetDouble(11); } i++; if (i == 12 && k == 0) { i = 0; k = 1; } if (i == 10 && k == 1) { i = 0; k = 2; } if (i == 12 && k == 2) { i = 0; k = 3; } if (i == 17 && k == 3) { i = 0; k = 4; } } } connection.Close(); }
internal static void SelectEventIdentifyRisk(RiskManagementLib rs) { SqlCommand command; int i = 0; int k = 0; SqlConnection connection = new SqlConnection("Server=KALYAN\\MSSQLSERVER01; Database=RiskManagementDB; Integrated Security=true;"); connection.Open(); command = new SqlCommand("Select RiskName, Chance, Percents from EventIdentifyRisk ", connection); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (k == 0) { rs.eventTechnical[i] = reader.GetString(0); rs.eventIdentifyRisk[k][i] = reader.GetInt32(1); if (i == 0) { rs.eventPercentRisk[k] = reader.GetDouble(2); } } if (k == 1) { rs.eventValueRisks[i] = reader.GetString(0); rs.eventIdentifyRisk[k][i] = reader.GetInt32(1); if (i == 0) { rs.eventPercentRisk[k] = reader.GetDouble(2); } } if (k == 2) { rs.eventPlanRisks[i] = reader.GetString(0); rs.eventIdentifyRisk[k][i] = reader.GetInt32(1); if (i == 0) { rs.eventPercentRisk[k] = reader.GetDouble(2); } } if (k == 3) { rs.eventProcesRisks[i] = reader.GetString(0); rs.eventIdentifyRisk[k][i] = reader.GetInt32(1); if (i == 0) { rs.eventPercentRisk[k] = reader.GetDouble(2); } } if (k == 4) { rs.eventPercentRisk[k] = reader.GetDouble(2); } i++; if (i == 12 && k == 0) { i = 0; k = 1; } if (i == 10 && k == 1) { i = 0; k = 2; } if (i == 12 && k == 2) { i = 0; k = 3; } if (i == 17 && k == 3) { i = 0; k = 4; } } } connection.Close(); }
public static void InsertToAnalisRiskWithValidity(RiskManagementLib rs) { SqlCommand command; SqlConnection connection = new SqlConnection("Server=KALYAN\\MSSQLSERVER01; Database=RiskManagementDB; Integrated Security=true;"); connection.Open(); using (command = new SqlCommand("DELETE FROM AnalisRiskWithValidity", connection)) { command.ExecuteNonQuery(); } string[] text; text = rs.technical; string sqlIns = "INSERT INTO AnalisRiskWithValidity (RiskName, Expert1, Expert2, Expert3, Expert4, Expert5, Expert6, Expert7, Expert8, Expert9, Expert10, Percents) VALUES (@name, @expert1, @expert2, @expert3, @expert4, @expert5, @expert6, @expert7, @expert8, @expert9, @expert10, @prcnt)"; try { command = new SqlCommand(sqlIns, connection); for (int k = 0; k < 4; k++) { switch (k) { case 0: text = rs.eventTechnical; break; case 1: text = rs.eventValueRisks; break; case 2: text = rs.eventPlanRisks; break; case 3: text = rs.eventProcesRisks; break; } for (int i = 0; i < rs.analisRiskWithValidity[k].Length / 11; i++) { command.Parameters.AddWithValue("@name", text[i]); command.Parameters.AddWithValue("@expert1", rs.analisRiskWithValidity[k][i, 0]); command.Parameters.AddWithValue("@expert2", rs.analisRiskWithValidity[k][i, 1]); command.Parameters.AddWithValue("@expert3", rs.analisRiskWithValidity[k][i, 2]); command.Parameters.AddWithValue("@expert4", rs.analisRiskWithValidity[k][i, 3]); command.Parameters.AddWithValue("@expert5", rs.analisRiskWithValidity[k][i, 4]); command.Parameters.AddWithValue("@expert6", rs.analisRiskWithValidity[k][i, 5]); command.Parameters.AddWithValue("@expert7", rs.analisRiskWithValidity[k][i, 6]); command.Parameters.AddWithValue("@expert8", rs.analisRiskWithValidity[k][i, 7]); command.Parameters.AddWithValue("@expert9", rs.analisRiskWithValidity[k][i, 8]); command.Parameters.AddWithValue("@expert10", rs.analisRiskWithValidity[k][i, 9]); command.Parameters.AddWithValue("@prcnt", rs.analisRiskWithValidity[k][i, 10]); command.ExecuteNonQuery(); command.Parameters.Clear(); } } command.Dispose(); command = null; } catch (Exception ex) { throw new Exception(ex.ToString(), ex); } finally { connection.Close(); } }
internal static void ch(RiskManagementLib rs) { rs.isCorrect = 10; }
static void Main(string[] args) { rs = new RiskManagementLib(); Conect(); }