public static bool addRemuneration(Remuneration r)
        {
            DBConnector dbcon = new DBConnector();

            //try
            //{
            if (dbcon.openConnection())
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandText = "INSERT INTO remuneration (rank, post, salary_grade, salary_slip_no, basic_salary, transport_allowance, fuel_allowance, mobile_phone_allowance, housing_allowance, other_allowance, salary_increase_date, salary_increase_amount, current_total_salary, employee_idemployee) VALUES (N'" + r.rank + "', N'" + r.post + "', N'" + r.salary_grade + "', N'" + r.salary_slip_no + "', " + r.basic_salary + ", " + r.transport_allowance + ", " + r.fuel_allowance + ", " + r.mobile_phone_allowance + ", " + r.housing_allowance + ", " + r.other_allowance + ", '" + r.getsalary_increase_date().ToString("yyyy-MM-dd") + "', " + r.salary_increase_amount + ", " + r.current_total_salary + ", " + Employee.employee_id + ")";
                cmd.Connection = dbcon.connection;
                cmd.Prepare();
                cmd.ExecuteNonQuery();

                dbcon.closeConnection();
                return true;
            }
            else
            {
                dbcon.closeConnection();
                return false;
            }

            //}
            //catch (MySqlException e)
            //{
            //int errorcode = e.Number;
            //dbcon.closeConnection();
            //return false;
            //}
        }
        public static Remuneration getRemuneration()
        {
            //try
            //{

            DBConnector dbcon = new DBConnector();

            if (dbcon.openConnection())
            {

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandText = "SELECT * FROM remuneration WHERE employee_idemployee=" + Employee.employee_id;
                cmd.Connection = dbcon.connection;

                MySqlDataReader reader = cmd.ExecuteReader();

                Remuneration r = null;

                if (reader.Read())
                {
                    r = new Remuneration();

                    r.r_id = int.Parse(reader["idremuneration"].ToString());
                    r.rank = reader["rank"].ToString();
                    r.post = reader["post"].ToString();
                    r.salary_grade = reader["salary_grade"].ToString();
                    r.salary_slip_no = reader["salary_slip_no"].ToString();
                    r.basic_salary = (float)Convert.ToDouble(reader["basic_salary"].ToString());
                    r.transport_allowance = (float)Convert.ToDouble(reader["transport_allowance"].ToString());
                    r.fuel_allowance = (float)Convert.ToDouble(reader["fuel_allowance"].ToString());
                    r.mobile_phone_allowance = (float)Convert.ToDouble(reader["mobile_phone_allowance"].ToString());
                    r.housing_allowance = (float)Convert.ToDouble(reader["housing_allowance"].ToString());
                    r.other_allowance = (float)Convert.ToDouble(reader["other_allowance"].ToString());
                    r.salary_increase_amount = (float)Convert.ToDouble(reader["salary_increase_amount"].ToString());
                    r.current_total_salary = (float)Convert.ToDouble(reader["current_total_salary"].ToString());

                    r.setsalary_increase_date(Convert.ToDateTime(reader["salary_increase_date"]));

                }

                reader.Close();

                dbcon.closeConnection();

                return r;
            }
            else
            {

                return null;
            }

            //}
            //catch (MySqlException e)
            //{
            //int errorcode = e.Number;
            //return null;
            //}
        }
Пример #3
0
        public void updateRemuneration()
        {
            Remuneration r = new Remuneration();

            r.r_id = this.r_id;
            r.salary_grade = this.remun_salary_grade.Text;
            r.salary_slip_no = this.remun_salary_slip_no.Text;
            r.basic_salary = (float)Convert.ToDouble(this.remun_basic_salary.Text);
            r.transport_allowance = (float)Convert.ToDouble(this.remun_transport_allowance.Text);
            r.fuel_allowance = (float)Convert.ToDouble(this.remun_fuel_allowance.Text);
            r.mobile_phone_allowance = (float)Convert.ToDouble(this.remun_mobile_phone_allowance.Text);
            r.housing_allowance = (float)Convert.ToDouble(this.remun_housing_allowance.Text);
            r.other_allowance = (float)Convert.ToDouble(this.remun_other_allowance.Text);
            r.salary_increase_amount = (float)Convert.ToDouble(this.remun_salary_increase_amount.Text);
            r.current_total_salary = (float)Convert.ToDouble(this.remun_current_total_salary.Text);
            r.setsalary_increase_date(this.remun_salary_increase_date.Value.Date);
            bool state = RemunerationHandler.updateRemuneration(r);
            Console.Write(state + "\n");
        }
        public static bool updateRemuneration(Remuneration r)
        {
            //try
            //{

            DBConnector dbcon = new DBConnector();

            if (dbcon.openConnection())
            {

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandText = "UPDATE remuneration SET salary_grade=N'" + r.salary_grade + "', salary_slip_no=" + r.salary_slip_no + ", basic_salary=" + r.basic_salary + ", transport_allowance=" + r.transport_allowance + ", fuel_allowance=" + r.fuel_allowance + ", mobile_phone_allowance=" + r.mobile_phone_allowance + ", housing_allowance=" + r.housing_allowance + ", other_allowance=" + r.other_allowance + ", salary_increase_date='" + r.getsalary_increase_date().ToString("yyyy-MM-dd") + "', salary_increase_amount=" + r.salary_increase_amount + ", current_total_salary=" + r.current_total_salary + " WHERE employee_idemployee=" + Employee.employee_id + " AND idremuneration=" + r.r_id;
                cmd.Connection = dbcon.connection;
                cmd.Prepare();
                cmd.ExecuteNonQuery();

                dbcon.closeConnection();

                return true;
            }
            else
            {

                return false;
            }

            //}
            //catch (MySqlException e)
            //{
            //int errorcode = e.Number;
            //return false;
            //}
        }
        private void btnSave_Click(object sender, EventArgs e)
        {
            Remuneration r = new Remuneration();

            r.rank = remun_rank.Text;
            r.post = remun_post.Text;
            r.salary_grade = remun_salary_grade.Text;
            r.salary_slip_no = remun_salary_no.Text;
            r.basic_salary = (float)Convert.ToDouble(remun_basic_salary.Text);
            r.transport_allowance = (float)Convert.ToDouble(remun_transport_allowance.Text);
            r.fuel_allowance = (float)Convert.ToDouble(remun_fuel_allowance.Text);
            r.mobile_phone_allowance = (float)Convert.ToDouble(remun_telephone_allowance.Text);
            r.housing_allowance = (float)Convert.ToDouble(remun_house_allowance.Text);
            r.other_allowance = (float)Convert.ToDouble(remun_other_allowances.Text);
            r.salary_increase_amount = (float)Convert.ToDouble(remun_increased_by.Text);
            r.current_total_salary = (float)Convert.ToDouble(remun_present_salary.Text);
            r.setsalary_increase_date(remun_salary_increased_date.Value.Date);

            bool state = RemunerationHandler.addRemuneration(r);

            if (state)
            {
                MessageBox.Show("Employee remuneration details added succesfully...!");

            }
            else
            {
                MessageBox.Show("Adding employee remuneration details failed...!");
            }
        }