private void InsertAround() { if (script.AddCheckStraps(txt_straps_start.Text)) { ConnectDB contxt = new ConnectDB(); MySqlConnection conn = new MySqlConnection(); conn = new MySqlConnection(contxt.context()); int aid = 0; if (rb_2.Checked) { //MessageBox.Show("2"); aid = 2; } if (rb_3.Checked) { //MessageBox.Show("3"); aid = 3; } if (rb_1.Checked) { //MessageBox.Show("1"); aid = 1; } conn.Open(); DateTime date_send = new Script().GetDateAround(); MySqlCommand comm = conn.CreateCommand(); comm.CommandText = "INSERT INTO tbl_status_around (tbl_status_around_aid,tbl_status_around_emp_open_id,tbl_status_around_close,tbl_status_around_date,tbl_status_around_cpoint_id,tbl_status_around_cpoint_sub_id) VALUES(@aid, @emp_id,'0',@date,@cpoint,@subcpoint)"; comm.Parameters.Add("@aid", aid); comm.Parameters.Add("@emp_id", emp_id); comm.Parameters.Add("@date", date_send.ToString("dd-MM-yyyy")); comm.Parameters.Add("@cpoint", cpoint_id); comm.Parameters.Add("@subcpoint", maniForm.sub_cpoint); comm.ExecuteNonQuery(); conn.Close(); StreamWriter file = new StreamWriter(script.file_around); file.WriteLine(emp_id + "|" + aid + "|" + date_send.ToString("dd-MM-yyyy") + "|" + txt_straps_start.Text + "|"); file.Close(); FileInfo DirInfo2 = new FileInfo(filename); if (DirInfo2.Exists) { string[] data1 = File.ReadAllText(new Script().file_around).Split('|'); Script script = new Script(); string status_around_id = ""; MySqlDataReader rs = script.Select_SQL("SELECT * FROM tbl_status_around WHERE `tbl_status_around_aid`='" + data1[1] + "' AND `tbl_status_around_emp_open_id`='" + data1[0] + "' AND `tbl_status_around_close` = '0'"); if (rs.Read()) { status_around_id = rs.GetString("tbl_status_around_id"); string[] data = File.ReadAllLines(filename); foreach (string line in data) { string[] line_data = line.Split('|'); script.InsertUpdae_SQL("UPDATE tbl_income SET tbl_income_around_id = '" + status_around_id + "' WHERE tbl_income_emp_id='" + line_data[0] + "' AND tbl_income_around_id IS NULL AND tbl_income_money_bag = '" + line_data[1] + "'"); } File.Delete(filename); } rs.Close(); script.conn.Close(); } //maniForm.Refresh(); Application.Restart(); } }