public bool DeleteById(int id)
{
string sql = " update attendance set deleted=1 where id = @id;";
MySQLConnection sqlHelp = new MySQLConnection();
MySqlParameter parameter = new MySqlParameter("id", id);
if (sqlHelp.ExecuteNonQuery(sql, parameter))
{
return(true);
}
return(false);
}
public bool UpdateById(int id, Attendence att)
{
string sql = "update attendance set employee_id = @employeeId,employee_name=@employeeName,status=@status,late_time=@lateTime,AReason=@aReason where id = @id;";
MySQLConnection sqlHelp = new MySQLConnection();
MySqlParameter parameter1 = new MySqlParameter("employeeId", sqlHelp.SqlNull(att.employeeId));
MySqlParameter parameter2 = new MySqlParameter("employeeName", sqlHelp.SqlNull(att.employeeName));
MySqlParameter parameter3 = new MySqlParameter("status", sqlHelp.SqlNull(att.status));
MySqlParameter parameter4 = new MySqlParameter("lateTime", sqlHelp.SqlNull(att.lateTime));
MySqlParameter parameter5 = new MySqlParameter("aReason", sqlHelp.SqlNull(att.aReason));
if (sqlHelp.ExecuteNonQuery(sql, parameter1, parameter2, parameter3, parameter4, parameter5))
{
return(true);
}
return(false);
}
public bool AddAttendance(Attendence att)
{
string sql = " insert into attendance (employee_id,employee_name,status,late_time,AReason) values(@employeeId,@employeeName,@status,@lateTime,@aReason);";
MySQLConnection sqlHelp = new MySQLConnection();
MySqlParameter parameter1 = new MySqlParameter("employeeId", sqlHelp.SqlNull(att.employeeId));
MySqlParameter parameter2 = new MySqlParameter("employeeName", sqlHelp.SqlNull(att.employeeName));
MySqlParameter parameter3 = new MySqlParameter("status", sqlHelp.SqlNull(att.status));
MySqlParameter parameter4 = new MySqlParameter("lateTime", sqlHelp.SqlNull(att.lateTime));
MySqlParameter parameter5 = new MySqlParameter("aReason", sqlHelp.SqlNull(att.aReason));
if (sqlHelp.ExecuteNonQuery(sql, parameter1, parameter2, parameter3, parameter4, parameter5))
{
return(true);
}
return(false);
}