Esempio n. 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            DateTime      date    = Convert.ToDateTime(dateTimePicker1.Value.ToString("yyyy-MM-dd HH:mm:ss"));
            int           amount  = int.Parse(numericUpDown1.Value.ToString());
            string        account = textBox1.Text;
            SqlConnection conn    = SQLConnection.connect();

            conn.Open();
            string     creditString = "INSERT INTO credits (client_id, date_of_issue, fully_repaid, credit_type_id, mother_amount, account) OUTPUT INSERTED.ID VALUES ('" + customer_id + "', '" + date + "', '" + 0 + "', '" + credit_type_id + "', '" + amount + "', '" + account + "')";
            SqlCommand command      = new SqlCommand(creditString, conn);
            int        credit_id    = (Int32)command.ExecuteScalar();

            using (SqlCommand cmd = new SqlCommand("CalculateDay", conn))
            {
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("@credit_id", SqlDbType.Int).Value        = credit_id;
                cmd.Parameters.Add("@credit_type_id", SqlDbType.Int).Value   = credit_type_id;
                cmd.Parameters.Add("@credit_amount", SqlDbType.BigInt).Value = amount;
                cmd.Parameters.Add("@interest_rate", SqlDbType.Float).Value  = interest_rate;

                cmd.ExecuteNonQuery();
                this.Hide();
                MessageBox.Show("This credit is successfully added.");
                Employee_Page employee = new Employee_Page(GlobalVariables.EmployeeId, GlobalVariables.EmployeeFirstName, GlobalVariables.EmployeeLastName);
                employee.ShowDialog();
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            this.Hide();
            Employee_Page employee = new Employee_Page(GlobalVariables.EmployeeId, GlobalVariables.EmployeeFirstName, GlobalVariables.EmployeeLastName);

            employee.ShowDialog();
        }
Esempio n. 3
0
        private void button1_Click(object sender, EventArgs e)
        {
            string        login    = textBox1.Text;
            string        password = textBox2.Text;
            SqlConnection conn     = SQLConnection.connect();

            conn.Open();
            string     selectString = "Select id,firstname,lastname from employee where username='******' and pass='******'";
            SqlCommand command      = new SqlCommand(selectString, conn);

            using (SqlDataReader reader = command.ExecuteReader())
            {
                if (reader.Read())
                {
                    GlobalVariables.EmployeeId        = int.Parse(reader["id"].ToString());
                    GlobalVariables.EmployeeFirstName = reader["firstname"].ToString();
                    GlobalVariables.EmployeeLastName  = reader["lastname"].ToString();
                    Employee_Page employee = new Employee_Page(GlobalVariables.EmployeeId, GlobalVariables.EmployeeFirstName, GlobalVariables.EmployeeLastName);
                    this.Hide();
                    employee.ShowDialog();
                }
            }

            conn.Close();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            int sum = int.Parse(numericUpDown1.Value.ToString());

            if (int.Parse(date.Day.ToString()) <= int.Parse(payment_day.Day.ToString()))
            {
                string        repayment1String = "INSERT INTO repayment (credit_payment_day_id, credit_id, date_of_repayment, paid_mother_amounth, paid_interest_amounth, paid_prew_surcharge, surcharge_mother_amount, surcharge_interest_amount) VALUES ('" + command_credit_payment_day_id + "', '" + credit_id + "', '" + date + "', '" + 1 + "', '" + 1 + "', '" + 1 + "', '" + 0 + "', '" + 0 + "')";
                SqlConnection conn             = SQLConnection.connect();
                conn.Open();
                SqlCommand command1 = new SqlCommand(repayment1String, conn);
                command1.ExecuteNonQuery();
            }
            else
            {
                float percentage_of_fines_for_each_day_mother_amount   = 0;
                float percentage_of_fines_for_each_day_interest_amount = 0;
                //float mother_amount_surcharge = 0;
                //float interest_amount_surcharge = 0;
                int           difference = int.Parse(date.Day.ToString()) - int.Parse(payment_day.Day.ToString());
                SqlConnection conn       = SQLConnection.connect();
                conn.Open();
                string     credit_typeString   = "Select percentage_of_fines_for_each_day_mother_amount, percentage_of_fines_for_each_day_interest_amount from types_of_crediting where id='" + credit_type_id + "'";
                SqlCommand command_credit_type = new SqlCommand(credit_typeString, conn);
                using (SqlDataReader reader = command_credit_type.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        percentage_of_fines_for_each_day_mother_amount   = float.Parse(reader["percentage_of_fines_for_each_day_mother_amount"].ToString());
                        percentage_of_fines_for_each_day_interest_amount = float.Parse(reader["percentage_of_fines_for_each_day_interest_amount"].ToString());
                    }
                }
                float monthly_mother_percent = (monthly_mother_amount * percentage_of_fines_for_each_day_mother_amount) / 100;

                float monthly_interest_percent = (monthly_interest_amount * percentage_of_fines_for_each_day_interest_amount) / 100;


                mother_amount_surcharge   = monthly_mother_percent * (float)difference;
                interest_amount_surcharge = monthly_interest_percent * difference;


                string sql = "Insert into repayment (credit_payment_day_id, credit_id, date_of_repayment, paid_mother_amounth, paid_interest_amounth, paid_prew_surcharge, surcharge_mother_amount, surcharge_interest_amount) "
                             + " values (@credit_payment_day_id, @credit_id, @date_of_repayment, @paid_mother_amounth, @paid_interest_amounth, @paid_prew_surcharge, @surcharge_mother_amount, @surcharge_interest_amount) ";

                SqlCommand cmd = conn.CreateCommand();
                cmd.CommandText = sql;

                cmd.Parameters.Add("@credit_payment_day_id", SqlDbType.Int).Value       = command_credit_payment_day_id;
                cmd.Parameters.Add("@credit_id", SqlDbType.Int).Value                   = credit_id;
                cmd.Parameters.Add("@date_of_repayment", SqlDbType.DateTime).Value      = date;
                cmd.Parameters.Add("@paid_mother_amounth", SqlDbType.Bit).Value         = 1;
                cmd.Parameters.Add("@paid_interest_amounth", SqlDbType.Bit).Value       = 1;
                cmd.Parameters.Add("@paid_prew_surcharge", SqlDbType.Bit).Value         = 1;
                cmd.Parameters.Add("@surcharge_mother_amount", SqlDbType.Float).Value   = mother_amount_surcharge;
                cmd.Parameters.Add("@surcharge_interest_amount", SqlDbType.Float).Value = interest_amount_surcharge;

                // Execute Command (for Delete,Insert or Update).
                cmd.ExecuteNonQuery();
            }
            this.Hide();
            MessageBox.Show("This credit is successfully paid.");
            Employee_Page employee = new Employee_Page(GlobalVariables.EmployeeId, GlobalVariables.EmployeeFirstName, GlobalVariables.EmployeeLastName);

            employee.ShowDialog();
        }