public override int Insert(Entity entity, DataTransaction tran) { Entities.HorarioMaestros item = entity as Entities.HorarioMaestros; DataEntities.SpFwkHorarioMaestrosIns sp = new DataEntities.SpFwkHorarioMaestrosIns(); sp.ClaEmpleado = item.Empleado.ID; sp.ClaCampus = item.ClaCampus.ID; sp.ClaHorario = item.ClaHorario; sp.Lun = item.Lun; sp.Mar = item.Mar; sp.Mie = item.Mie; sp.Jue = item.Jue; sp.Vie = item.Vie; sp.Sab = item.Sab; sp.Dom = item.Dom; sp.OrdenLun = item.OrdenLun; sp.OrdenMar = item.OrdenMar; sp.OrdenMie = item.OrdenMie; sp.OrdenJue = item.OrdenJue; sp.OrdenVie = item.OrdenVie; sp.OrdenSab = item.OrdenSab; sp.OrdenDom = item.OrdenDom; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public override int Delete(Entity entity, DataTransaction tran) { Entities.HorarioMaestros item = entity as Entities.HorarioMaestros; DataEntities.SpHorarioMaestrosDel sp = new DataEntities.SpHorarioMaestrosDel(); sp.ClaEmpleado = item.Empleado.ID; sp.ClaCampus = item.ClaCampus.ID; sp.ClaHorario = item.ClaHorario; if (tran != null) { return(sp.ExecuteNonQuery(tran)); } else { return(sp.ExecuteNonQuery(this.ConnectionString)); } }
public List <Entities.HorarioMaestros> ListarHorarioMaestros(Entities.JQXGridSettings settings, int ClaEmpleado, int ClaCampus, int ClaHorario) { DataEntities.SpFwkHorarioMaestrosGrd sp = new DataEntities.SpFwkHorarioMaestrosGrd(); List <Entities.HorarioMaestros> list = new List <Entities.HorarioMaestros>(); sp.ClaEmpleado = ClaEmpleado; sp.ClaCampus = ClaCampus; this.ConfigurePagedStoredProcedure(sp, settings); DataTable dt = sp.GetDataTable(this.ConnectionString); foreach (DataRow dr in dt.Rows) { Entities.HorarioMaestros item = new Entities.HorarioMaestros(true); item.Empleado = new Entities.Empleados(); item.Empleado.ID = Utils.GetDataRowValue(dr, "ClaEmpleado", 0); item.ClaCampus = new Entities.Campus(); item.ClaCampus.ID = Utils.GetDataRowValue(dr, "ClaCampus", 0); item.ClaHorario = Utils.GetDataRowValue(dr, "ClaHorario", 0); this.SetWebEntityGridValues(item, dr); list.Add(item); } return(list); }
public List <Exception> Eliminar(int[] clas) { List <Exception> list = new List <Exception>(); if (clas != null && clas.Length > 0) { foreach (int cla in clas) { Entities.HorarioMaestros item = new Entities.HorarioMaestros(true); item.Empleado = new Entities.Empleados(); item.Empleado.ID = Utils.IsNull(cla, 0); try { this.Data.Delete(item); } catch (Exception ex) { list.Add(ex); } } } return(list); }