public List <Exception> Eliminar(int[] clas)
{
List <Exception> list = new List <Exception>();
if (clas != null && clas.Length > 0)
{
foreach (int cla in clas)
{
Entities.OrdenAsignacionCitas item = new Entities.OrdenAsignacionCitas(true);
item.Campus = new Entities.Campus();
item.Campus.ID = Utils.IsNull(cla, 0);
try
{
this.Data.Delete(item);
}
catch (Exception ex)
{
list.Add(ex);
}
}
}
return(list);
}
public override int Delete(Entity entity, DataTransaction tran)
{
Entities.OrdenAsignacionCitas item = entity as Entities.OrdenAsignacionCitas;
DataEntities.SpOrdenAsignacionCitasDel sp = new DataEntities.SpOrdenAsignacionCitasDel();
sp.ClaCampus = item.Campus.ID;
sp.ClaProfesor = item.ClaProfesor;
sp.Orden = item.Orden;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public List <Entities.OrdenAsignacionCitas> ListarOrdenAsignacionCitas(Entities.JQXGridSettings settings, int ClaCampus, int claProfesor, int orden)
{
DataEntities.SpOrdenAsignacionCitasGrd sp = new DataEntities.SpOrdenAsignacionCitasGrd();
List <Entities.OrdenAsignacionCitas> list = new List <Entities.OrdenAsignacionCitas>();
sp.ClaCampus = ClaCampus;
sp.ClaProfesor = claProfesor;
sp.Orden = orden;
this.ConfigurePagedStoredProcedure(sp, settings);
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.OrdenAsignacionCitas item = new Entities.OrdenAsignacionCitas(true);
item.Campus = new Entities.Campus();
item.Campus.ID = Utils.GetDataRowValue(dr, "ClaCampus", 0);
item.ClaProfesor = Utils.GetDataRowValue(dr, "ClaProfesor", 0);
item.Orden = Utils.GetDataRowValue(dr, "Orden", 0);
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
