public override int Insert(Entity entity, DataTransaction tran)
{
Entities.Kardex item = entity as Entities.Kardex;
DataEntities.SpKardexIns
sp = new DataEntities.SpKardexIns();
sp.IdCalificacion = item.ID;
sp.Matricula = item.Matricula;
sp.ClaCampus = item.Campus.ID;
sp.ClaNivel = item.Nivel.ID;
sp.ClaLeccion = item.Leccion.Clave;
sp.ClaProfesor = item.Profesor;
sp.Calificacion = item.Calificacion;
sp.TipoClase = item.TipoClase;
sp.Fecha = item.Fecha;
sp.ClaCalificacion = item.ClaCalificacion;
sp.IdCita = item.IdCita;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public override int Delete(Entity entity, DataTransaction tran)
{
Entities.Kardex item = entity as Entities.Kardex;
DataEntities.SpKardexDel
sp = new DataEntities.SpKardexDel();
sp.Matricula = item.Matricula;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public List <Entities.Kardex> ListarKardex(Entities.JQXGridSettings settings, string Matricula)
{
DataEntities.SpKardexGrd sp = new DataEntities.SpKardexGrd();
List <Entities.Kardex> list = new List <Entities.Kardex>();
sp.Matricula = Matricula;
this.ConfigurePagedStoredProcedure(sp, settings);
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Kardex item = new Entities.Kardex(true);
item.Matricula = Utils.GetDataRowValue(dr, "Matricula", "");
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
public List <Exception> Eliminar(int[] ids)
{
List <Exception> list = new List <Exception>();
if (ids != null && ids.Length > 0)
{
foreach (int id in ids)
{
Entities.Kardex item = new Entities.Kardex(true);
item.ID = Utils.IsNull(id, 0);
try
{
this.Data.Delete(item);
}
catch (Exception ex)
{
list.Add(ex);
}
}
}
return(list);
}
