public List<project_employee_payment> GetProjectEmployeePayment(String CmdText) { try { Connect(); Debug.WriteLine(CmdText); if (CmdText == "") { CmdText = "SELECT * FROM project_employee_working_day"; } datareader = GetReader(CmdText); List<project_employee_payment> plalist = new List<project_employee_payment>(); while (datareader.Read()) { project_employee_payment pla = new project_employee_payment(); pla.project_employee_allocation_id = Convert.ToInt16(datareader["project_employee_allocation_id"].ToString()); pla.days_worked = Convert.ToInt16((datareader["days_worked"].ToString())); plalist.Add(pla); } datareader.Close(); datareader = null; return plalist; } catch { return null; } }
public bool InsertEmployeePayment(project_employee_payment p) { try { string CmdText = "INSERT INTO project_employee_payment (project_employee_allocation_id , amount , date_payed) VALUES (@project_employee_allocation_id , @amount , @date_payed)"; cmd = new MySqlCommand(CmdText, this.conn); cmd.Parameters.AddWithValue("@project_employee_allocation_id", p.project_employee_allocation_id); cmd.Parameters.AddWithValue("@amount", p.amount); cmd.Parameters.AddWithValue("@date_payed", p.date_paid); cmd.ExecuteNonQuery(); return true; } catch { return false; } }