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