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