コード例 #1
0
ファイル: UC_Emp.cs プロジェクト: sakif330/HRManagement
 private void employeeAttendanceToolStripMenuItem_Click(object sender, EventArgs e)
 {
     Employee.EmpAtnd er = new Employee.EmpAtnd();
     //  ag.MdiParent = this ;
     er.StartPosition = FormStartPosition.CenterScreen;
     er.Show();
 }
コード例 #2
0
ファイル: EmpAtnd.cs プロジェクト: sakif330/HRManagement
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (atndExist(label7.Text, comboBox1.Text, comboBox2.Text))
                {
                    MessageBox.Show("Attendance Already Given!");
                    ClearData();
                    LoadData();
                    Employee.EmpAtnd er = new Employee.EmpAtnd();
                    //  ag.MdiParent = this ;
                    er.StartPosition = FormStartPosition.CenterScreen;
                    er.Show();
                    this.Close();
                    //   ClearData();

                    //break;
                }
                //   else
                //  {

                /* if (NoEmpName(textBox3.Text) == true)
                 * {
                 *   MessageBox.Show("Employee Doesn't Exists!");
                 *   ClearData();
                 *   LoadData();
                 *   Employee.EmpAtnd er = new Employee.EmpAtnd();
                 *   //  ag.MdiParent = this ;
                 *   er.StartPosition = FormStartPosition.CenterScreen;
                 *   er.Show();
                 *   this.Close();
                 * }*/

                /*  else if (atndExist(textBox3.Text, comboBox1.Text, comboBox2.Text))
                 *    {
                 *        MessageBox.Show("Attendance Already Given!");
                 *       ClearData();
                 *       LoadData();
                 *       Employee.EmpAtnd er = new Employee.EmpAtnd();
                 *       //  ag.MdiParent = this ;
                 *       er.StartPosition = FormStartPosition.CenterScreen;
                 *       er.Show();
                 *      this.Close();
                 *       //   ClearData();
                 *
                 *       //break;
                 *   }*/
                else
                {
                    string query = " insert into EmpAtnd3(E_ID,Year,Month,WD,PD) values ('" + Int32.Parse(label7.Text) + "','"
                                   + comboBox1.Text + "','"
                                   + comboBox2.Text + "','"
                                   + textBox1.Text + "','"
                                   + textBox2.Text + "')";
                    // private SqlCommand sqlCommand;
                    sqlCommand = new SqlCommand(query, sqlConnection);

                    // sqlConnection.Open();
                    sqlCommand.ExecuteNonQuery();
                    // sqlConnection.Close();
                    //LoadData();
                    MessageBox.Show("Data Added Successfully");

                    ClearData();
                    LoadData();
                }
                //  }
            }
            catch (Exception ex)
            {
                // MessageBox.Show("Error");
            }
        }