private void btnSave2_Click(object sender, EventArgs e) { CashBenefit cb = new CashBenefit(); cb.approved_benefit = cash_approved_benefit.Text; cb.price = (float)Convert.ToDouble(cash_issued_price.Text); cb.setdate_issued(cash_issued_date.Value.Date); bool state = BenefitsHandler.addCashBenefit(cb); if (state) { MessageBox.Show("Employee Cash Benefit details added succesfully...!"); } else { MessageBox.Show("Adding employee Cash Benefit details failed...!"); } }
public static bool addCashBenefit(CashBenefit cb) { DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO cash_benefit (approved_benefit, date_issued, price, employee_idemployee) VALUES (N'" + cb.approved_benefit + "', '" + cb.getdate_issued().ToString("yyyy-MM-dd") + "', " + cb.price + ", " + Employee.employee_id + ")"; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { dbcon.closeConnection(); return false; } }
public static CashBenefit getCashBenefit() { DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM cash_benefit WHERE employee_idemployee=" + Employee.employee_id; cmd.Connection = dbcon.connection; MySqlDataReader reader = cmd.ExecuteReader(); CashBenefit cb = null; if (reader.Read()) { cb = new CashBenefit(); cb.cb_id = int.Parse(reader["idcash_benefit"].ToString()); cb.approved_benefit = reader["approved_benefit"].ToString(); cb.price = (float)Convert.ToDouble(reader["price"].ToString()); cb.setdate_issued(Convert.ToDateTime(reader["date_issued"])); } reader.Close(); dbcon.closeConnection(); return cb; } else { return null; } }
public void updateBenefits() { CashBenefit cb = new CashBenefit(); cb.cb_id = this.cb_id; cb.approved_benefit = this.cash_approved_benefit.Text; cb.price = (float)Convert.ToDouble(this.cash_issued_price.Text); cb.setdate_issued(this.cash_issued_date.Value.Date); bool state = BenefitsHandler.updateCashBenefit(cb); Console.Write(state + "\n"); NonCashBenefit ncb = new NonCashBenefit(); ncb.ncb_id = this.ncb_id; ncb.approved_benefit = this.noncash_approved_benefit.Text; ncb.price = (float)Convert.ToDouble(this.noncash_price.Text); ncb.amount = (float)Convert.ToDouble(this.noncash_quantity.Text); ncb.setdate_issued(this.noncash_issued_date.Value.Date); state = BenefitsHandler.updateNonCashBenefit(ncb); Console.Write(state + "\n"); }
public static bool updateCashBenefit(CashBenefit cb) { DBConnector dbcon = new DBConnector(); if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "UPDATE cash_benefit SET approved_benefit=N'" + cb.approved_benefit + "', date_issued='" + cb.getdate_issued().ToString("yyyy-MM-dd") + "', price=" + cb.price + " WHERE employee_idemployee=" + Employee.employee_id + " AND idcash_benefit=" + cb.cb_id; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { return false; } }