Пример #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                sf       = new studentFeeClass();
                dg       = new datagridVeiwWorking();
                sf.month = comboBox1.Text;
                sf.year  = comboBox2.Text;
                if (radioButton1.Checked)
                {
                    string query = "select * from studentFees where monthName ='" + comboBox1.Text + "' and studentYear = '" + comboBox2.Text + "' and paymentAmount >= " + sf.monthlyFee();

                    dataGridView1.DataSource = dg.goFill(query).Tables[0];
                }
                else if (radioButton2.Checked)
                {
                    string query = "select * from studentFees where monthName ='" + comboBox1.Text + "' and studentYear = '" + comboBox2.Text + "' and paymentAmount < " + sf.monthlyFee();

                    dataGridView1.DataSource = dg.goFill(query).Tables[0];
                }
            }
            catch (FormatException)
            {
                MessageBox.Show("Enter Correct Values!!", "Alert!");
            }
        }
Пример #2
0
        private void employeeSalaryInformation_Load(object sender, EventArgs e)
        {
            radioLoad rad = new radioLoad();

            comboBox1.DataSource    = rad.mydt("select * from employeeBoxData");
            comboBox1.DisplayMember = "Id";
            comboBox1.ValueMember   = "Id";

            dg.query = "select * from employeePayments";
            dataGridView1.DataSource = dg.goFill().Tables[0];
        }
Пример #3
0
        private void button3_Click(object sender, EventArgs e)
        {
            if (textBox5.Text != "")
            {
                rad = new radioLoad();
                rbc = new returnBookClass();
                string query = "select studentID,studentName, titleBook,authorBook,placeLibrary,conditionBook from  IssueBooks INNER JOIN addingBooks on  addingBooks.serialNo = IssueBooks.bookID where studentID = " + textBox5.Text;

                dataGridView1.DataSource = dv.goFill(query).Tables[0];
                textBox1.Enabled         = true;
                textBox2.Enabled         = true;
                comboBox2.Enabled        = true;
                comboBox3.Enabled        = true;
                comboBox2.DataSource     = rad.mydt("select * from IssueBooks where studentID = " + textBox5.Text);
                comboBox2.DisplayMember  = "bookID";
                comboBox2.ValueMember    = "studentID";
                rbc.bookD    = comboBox2.Text;
                rbc.studentD = textBox5.Text;
            }
            else
            {
                MessageBox.Show("Enter Student ID", "Alert!!");
            }
            textBox2.Text = DateTime.Now.ToString();
        }
Пример #4
0
        private void employeeSalaries_Load(object sender, EventArgs e)
        {
            radioLoad rad = new radioLoad();

            comboBox1.DataSource    = rad.mydt("select * from employeeBoxData");
            comboBox1.DisplayMember = "Id";
            comboBox1.ValueMember   = "Id";

            comboBox2.DataSource    = rad.mydt("select * from monthNames");
            comboBox2.DisplayMember = "title";
            comboBox2.ValueMember   = "ID";
            textBox1.Enabled        = false;
            textBox2.Enabled        = false;
            textBox2.Text           = DateTime.Now.ToShortDateString();
            dg.query = "SELECT * from employeePayments";
            dataGridView1.DataSource = dg.goFill().Tables[0];
        }
Пример #5
0
        private void button1_Click(object sender, EventArgs e)
        {
            dg = new datagridVeiwWorking();
            rb = new returnBookClass();
            radioLoad rad = new radioLoad();

            dg.query = "SELECT studentID,studentName,serialNo,titleBook,authorBook FROM addingBooks INNER JOIN IssueBooks ON addingBooks.serialNo = IssueBooks.bookID where studentID=" + comboBox1.Text;
            dataGridView1.DataSource = dg.goFill().Tables[0];
            comboBox2.DataSource     = rad.mydt("select * from IssueBooks where studentID = " + comboBox1.Text);
            comboBox2.DisplayMember  = "bookID";
            comboBox2.ValueMember    = "studentID";
        }
        private void button1_Click(object sender, EventArgs e)
        {
            dg.query = "SELECT serialNo,titleBook,authorBook,quantity,placeLibrary,conditionBook from addingBooks where quantity >" + 0;
            dataGridView1.DataSource = dg.goFill().Tables[0];
            sd = new showingData();
            li = new library();
            string queryForCount = "select count(studentID) from IssueBooks where studentID = " + comboBox1.Text;

            countingAdmissions = sd.countAdmission(queryForCount);

            numberOfQuantity = li.checkQuantity(Convert.ToInt32(comboBox2.Text));
            if (countingAdmissions >= limit)
            {
                MessageBox.Show("Return previous Books!!", "Alert");
            }
            else
            {
                if (numberOfQuantity > 0)
                {
                    string querya  = "Select bookID from IssueBooks where studentID =" + comboBox1.Text;
                    string checkID = li.alreadyExitsBook(querya);
                    if (comboBox2.Text != checkID)
                    {
                        string query = "insert into IssueBooks(studentID,studentName,takenBooks,maxAllowed,bookID,issueDate,lastDate)values('" + comboBox1.Text + "','" + textBox2.Text + "','" + Convert.ToInt32(textBox1.Text) + "','" + Convert.ToInt32(textBox3.Text) + "','" + comboBox2.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')";
                        li = new library();
                        li.updateBook(query);
                        li.minusQuantity(Convert.ToInt32(comboBox2.Text));

                        MessageBox.Show("Book has been issued Successfully!!!");
                        textBox1.Clear();
                        textBox2.Clear();
                    }
                    else
                    {
                        MessageBox.Show("This book is already Issued to you!!");
                    }
                }
                else
                {
                    MessageBox.Show("Book quantity is zero!!", "Alert");
                }
            }
        }