public override int Insert(Entity entity, DataTransaction tran) { Entities.ExtensionesCurso item = entity as Entities.ExtensionesCurso; DataEntities.SpExtensionesCursoIns sp = new DataEntities.SpExtensionesCursoIns(); sp.IdRegistro = item.IdRegistro; sp.ClaCampus = item.Campus.ID; sp.Matricula = item.Matricula; sp.FechaIni = item.FechaIni; sp.FechaFin = item.FechaFin; sp.Comentarios = item.Comentarios; sp.Estatus = item.Estatus; sp.ClaNivel = item.ClaNivel; sp.ClaLeccion = item.ClaLeccion; sp.TipoRegistro = item.TipoRegistro; // if (tran != null) // { // return sp.ExecuteNonQuery(tran); // } // else // { return(sp.ExecuteNonQuery(this.ConnectionString)); // } }
public List <Entities.ExtensionesCurso> ListarExtensionesCurso(InglesIndividual.Entities.JQXGridSettings settings, string matricula) { List <Entities.ExtensionesCurso> list = new List <Entities.ExtensionesCurso>(); DataEntities.SpExtensionesCursoGrd sp = new DataEntities.SpExtensionesCursoGrd(); sp.Matricula = matricula; this.ConfigurePagedStoredProcedure(sp, settings); DataTable dt = sp.GetDataTable(this.ConnectionString); foreach (DataRow dr in dt.Rows) { Entities.ExtensionesCurso item = new Entities.ExtensionesCurso(true); item.IdRegistro = Utils.GetDataRowValue(dr, "IdRegistro", 0); item.Campus = new Entities.Campus(); item.Campus.ID = Utils.GetDataRowValue(dr, "Clave", 0); item.Matricula = Utils.GetDataRowValue(dr, "Matricula", ""); item.FechaIni = Utils.GetDataRowValue(dr, "FechaIni", 0); item.FechaFin = Utils.GetDataRowValue(dr, "FechaFin", 0); item.Comentarios = Utils.GetDataRowValue(dr, "Comentarios", ""); item.Estatus = Utils.GetDataRowValue(dr, "Estatus", 0); item.ClaNivel = Utils.GetDataRowValue(dr, "ClaNivel", 0); item.ClaLeccion = Utils.GetDataRowValue(dr, "ClaLeccion", 0); item.TipoRegistro = Utils.GetDataRowValue(dr, "FechaHoraOriginal", 0); this.SetWebEntityGridValues(item, dr); list.Add(item); } return(list); }
public override void PrepareEntityForEdition(Entity entity) { Entities.ExtensionesCurso item = entity as Entities.ExtensionesCurso; if (item != null && item.FromDataSource) { DataEntities.SpExtensionesCursoSel sp = new DataEntities.SpExtensionesCursoSel(); sp.IdRegistro = item.IdRegistro; sp.ClaCampus = item.Campus.ID; sp.ClaNivel = item.ClaNivel; sp.ClaLeccion = item.ClaLeccion; DataTable dt = sp.GetDataTable(this.ConnectionString); if (dt != null && dt.Rows.Count == 1) { item.IdRegistro = Utils.GetDataRowValue(dt.Rows[0], "IdRegistro", 0); item.Campus = new Entities.Campus(); item.Campus.ID = Utils.GetDataRowValue(dt.Rows[0], "Clave", 0); item.Matricula = Utils.GetDataRowValue(dt.Rows[0], "Matricula", ""); item.FechaIni = Utils.GetDataRowValue(dt.Rows[0], "FechaIni", 0); item.FechaFin = Utils.GetDataRowValue(dt.Rows[0], "FechaFin", 0); item.Comentarios = Utils.GetDataRowValue(dt.Rows[0], "Comentarios", ""); item.Estatus = Utils.GetDataRowValue(dt.Rows[0], "Estatus", 0); item.ClaNivel = Utils.GetDataRowValue(dt.Rows[0], "ClaNivel", 0); item.ClaLeccion = Utils.GetDataRowValue(dt.Rows[0], "ClaLeccion", 0); item.TipoRegistro = Utils.GetDataRowValue(dt.Rows[0], "FechaHoraOriginal", 0); } } }
public override int Delete(Entity entity, DataTransaction tran) { Entities.ExtensionesCurso item = entity as Entities.ExtensionesCurso; DataEntities.SpExtensionesCursoDel sp = new DataEntities.SpExtensionesCursoDel(); sp.IdRegistro = item.IdRegistro; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public override int Update(Entity entity) { Entities.ExtensionesCurso item = entity as Entities.ExtensionesCurso; DataEntities.SpExtensionesCursoUpd sp = new DataEntities.SpExtensionesCursoUpd(); sp.IdRegistro = item.IdRegistro; sp.ClaCampus = item.Campus.ID; sp.Matricula = item.Matricula; sp.FechaIni = item.FechaIni; sp.FechaFin = item.FechaFin; sp.Comentarios = item.Comentarios; sp.Estatus = item.Estatus; sp.ClaNivel = item.ClaNivel; sp.ClaLeccion = item.ClaLeccion; sp.TipoRegistro = item.TipoRegistro; return(sp.ExecuteNonQuery(this.ConnectionString)); }
public List <Exception> Eliminar(string[] ids) { List <Exception> list = new List <Exception>(); if (ids != null && ids.Length > 0) { foreach (string id in ids) { Entities.ExtensionesCurso item = new Entities.ExtensionesCurso(true); item.IdRegistro = Utils.IsNull(id, 0); try { this.Data.Delete(item); } catch (Exception ex) { list.Add(ex); } } } return(list); }