/// <summary>
/// TL-41
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int GerenteTLDesactivar(prop.TeamLeader item)
{
CreateTextCommand("UPDATE TeamLeaders SET Activo=? WHERE IdTL=?");
AddParameter("?", item.Activo, OleDbType.Numeric);
AddParameter("?", item.Id, OleDbType.Numeric);
return(Update());
}
/// <summary>
/// TL-31
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public string GerenteTLInsert(prop.TeamLeader item)
{
CreateTextCommand("INSERT INTO TeamLeaders (Nombre, Correo, Activo) VALUES (?,?,?)");
AddParameter("?", item.Nombre, OleDbType.VarChar);
AddParameter("?", item.Correo, OleDbType.VarChar);
AddParameter("?", item.Activo, OleDbType.Numeric);
return(Insert());
}
/// <summary>
/// TL-42
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public int GerenteTLUpdate(prop.TeamLeader item)
{
CreateTextCommand("UPDATE TeamLeaders SET Nombre=?, Correo=?, Activo=? WHERE IdTL=?");
AddParameter("?", item.Nombre, OleDbType.VarChar);
AddParameter("?", item.Correo, OleDbType.VarChar);
AddParameter("?", item.Activo, OleDbType.Numeric);
AddParameter("?", item.Id, OleDbType.Numeric);
return(Update());
}
/// <summary>
/// TL-03
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public DataTable GerenteTLSelectById(prop.TeamLeader item)
{
CreateTextCommand("SELECT IdTL, Nombre, Correo, SWITCH (Activo = 1, 'Activo', Activo = 0, 'Inactivo') AS Activo FROM TeamLeaders WHERE IdTL=?");
AddParameter("?", item.Id, OleDbType.Numeric);
return(Select());
}
public int GerenteTLUpdate(prop.TeamLeader item)
{
return(tl.GerenteTLUpdate(item));
}
public string GerenteTLInsert(prop.TeamLeader item)
{
return(tl.GerenteTLInsert(item));
}
public int GerenteTLDesactivar(prop.TeamLeader item)
{
return(tl.GerenteTLDesactivar(item));
}
public DataTable GerenteTLSelectById(prop.TeamLeader item)
{
return(tl.GerenteTLSelectById(item));
}