public bool L_InsertarDiaInhabil(CatDiasInhabiles DiaInhabil) { bool Resultado = false; Resultado = DatosAuxiliar.D_InsertarDiaInhabil(DiaInhabil); return(Resultado); }
public bool D_InsertarDiaInhabil(CatDiasInhabiles DiaInhabil) { bool Respuesta = false; SqlConnection Conexion = MetodoGeneral.EstablecerConexionBD(); SQLComandoAuxiliar = MetodoGeneral.CrearLlamadaStoredProcedure("SpInsertarDiaInhabil", Conexion); SQLComandoAuxiliar.Parameters.AddWithValue("@Dia", DiaInhabil.Dia); SQLComandoAuxiliar.Parameters.AddWithValue("@Mes", DiaInhabil.Mes); SQLComandoAuxiliar.Parameters.AddWithValue("@Año", DiaInhabil.Año); SQLComandoAuxiliar.Parameters.AddWithValue("@Activo", 1); SQLComandoAuxiliar.ExecuteNonQuery(); SQLComandoAuxiliar.Connection.Dispose(); Respuesta = true; return(Respuesta); }
public List <CatDiasInhabiles> L_SeleccionarDiasInhabiles(int Mes, int Año) { DataTable dtDdiasInhabiles = new DataTable(); List <CatDiasInhabiles> ListaDiasInhabiles = new List <CatDiasInhabiles>(); dtDdiasInhabiles = DatosAuxiliar.D_SeleccionarDiasInhabiles(Mes, Año); if (dtDdiasInhabiles.Rows.Count > 0) { foreach (DataRow row in dtDdiasInhabiles.Rows) { CatDiasInhabiles DiaInhabil = new CatDiasInhabiles(); DiaInhabil.IdDiaInhabil = (Int32)row["IdDiaInhabil"]; DiaInhabil.Dia = (Int32)row["Dia"]; DiaInhabil.Mes = (Int32)row["Mes"]; DiaInhabil.Año = (Int32)row["Año"]; DiaInhabil.FechaCompleta = String.Format("{0:dd/MMMM/yyyy}", (DateTime)row["FechaCompleta"]); DiaInhabil.Activo = (bool)row["Activo"]; ListaDiasInhabiles.Add(DiaInhabil); } } return(ListaDiasInhabiles); }