Exemple #1
0
        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            Attendence frm = new Attendence();

            this.Hide();
            frm.Show();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                Attendence s = new Attendence();
                s.set_Registration_No(comboBox2.Text);
                s.set_Attendence_Date(dateTimePicker1.Value);
                s.set_Student_Status(comboBox1.Text);
                if ((comboBox2.Text == "") || (dateTimePicker1.Value == null) || (comboBox1.Text == ""))
                {
                    MessageBox.Show("Submssion is not allowed with null values");
                }
                else if ((s.get_Registration_No() == null || (s.get_Attendence_Date() == null)) || (s.get_Student_Status() == null))
                {
                    MessageBox.Show("Invalid Data Entered!!");
                }
                else
                {
                    string        constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
                    SqlConnection c      = new SqlConnection(constr);
                    c.Open();
                    string     s1  = string.Format("INSERT INTO ClassAttendance(AttendanceDate) values('" + s.get_Attendence_Date() + "' )");
                    SqlCommand y   = new SqlCommand(s1, c);
                    int        ros = y.ExecuteNonQuery();


                    string     s2 = string.Format("SELECT Id FROM Student WHERE RegistrationNumber =@RegistrationNumber ");
                    SqlCommand a  = new SqlCommand(s2, c);
                    a.Parameters.Add(new SqlParameter("@RegistrationNumber", s.get_Registration_No()));
                    //a.Parameters.Add(new SqlParameter("@Name", this.Registration_Number.Text));
                    int id = (int)a.ExecuteScalar();

                    string     s3 = string.Format("SELECT LookupId FROM Lookup WHERE Category=@Category and Name =@Name");
                    SqlCommand b  = new SqlCommand(s3, c);
                    b.Parameters.Add(new SqlParameter("@Category", "ATTENDANCE_STATUS"));
                    b.Parameters.Add(new SqlParameter("@Name", s.get_Student_Status()));
                    int id1 = (int)b.ExecuteScalar();

                    string     s5  = string.Format("SELECT MAX(Id) FROM ClassAttendance");
                    SqlCommand d   = new SqlCommand(s5, c);
                    int        id4 = (int)d.ExecuteScalar();

                    string     s4   = string.Format("INSERT INTO StudentAttendance(StudentId,AttendanceId,AttendanceStatus) values('" + id + "','" + id4 + "','" + id1 + "')");
                    SqlCommand a2   = new SqlCommand(s4, c);
                    int        rows = a2.ExecuteNonQuery();
                    if (rows != 0 && ros != 0)
                    {
                        MessageBox.Show("Attendence Added");
                        this.Close();
                        //Manage_Clo h = new Manage_Clo();
                        //h.Show();
                    }
                    c.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Exemple #3
0
        private void label1_Click(object sender, EventArgs e)

        {
            Attendence frm = new Attendence();

            this.Hide();
            frm.Show();
        }