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; }
}
