public static List <ClaseMEntity> SelectClaseM(String IdClaseMantenimiento) { List <ClaseMEntity> List = new List <ClaseMEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_ClaseMantenimiento", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdClaseMantenimiento", SqlDbType.Text).Value = IdClaseMantenimiento; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new ClaseMEntity { IdClaseMantenimiento = DataReader.GetStringValue(dr, "IdClaseMantenimiento"), Descripcion = DataReader.GetStringValue(dr, "Descripcion"), NroOrden = DataReader.GetIntValue(dr, "NroOrden"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <BaseEntity> ListPuntoAtencionAutocomplete(string value) { List <BaseEntity> List = new List <BaseEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_TbLG_PuntoAtencion_Autocomplete", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pDescripcion01", SqlDbType.VarChar, 20).Value = value ?? string.Empty; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new BaseEntity { Codigo = DataReader.GetStringValue(dr, "ID_Index"), Descripcion = DataReader.GetStringValue(dr, "Descripcion01"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <BaseEntity> ListTipoUnidadAutocomplete(string value) { List <BaseEntity> List = new List <BaseEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("proc_Tbg_ObtenerMaestras", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Tbg_Tabla", SqlDbType.VarChar, 6).Value = value; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new BaseEntity { Codigo = DataReader.GetStringValue(dr, "Tbg_Codigo"), Descripcion = DataReader.GetStringValue(dr, "Tbg_Descripcion"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <BaseEntity> ListSistemasAutocomplete(string value) { List <BaseEntity> List = new List <BaseEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_EXC_Tb_Sistemas_Autocomplete", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Sistema", SqlDbType.VarChar, 30).Value = (value != null) ? value : string.Empty; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new BaseEntity { Codigo = DataReader.GetStringValue(dr, "ID_tb_Sistema_Mant"), Descripcion = DataReader.GetStringValue(dr, "Sistema"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <MarcaModeloEntity> ListModeloBuses() { List <MarcaModeloEntity> List = new List <MarcaModeloEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_LIS_Tb_ModeloBuses", con)) { cmd.CommandType = CommandType.StoredProcedure; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new MarcaModeloEntity { cod_modelo = DataReader.GetStringValue(dr, "cod_modelo"), modelo = DataReader.GetStringValue(dr, "modelo"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <BaseEntity> ListAlmacenesAutocomplete(string value) { List <BaseEntity> List = new List <BaseEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_Almacenes_Listar_Autocomplete", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pSucursal", SqlDbType.Int).Value = value; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new BaseEntity { Codigo = DataReader.GetStringValue(dr, "Tbg_Codigo"), Descripcion = DataReader.GetStringValue(dr, "Tbg_Descripcion"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <SubSistemasEntity> IdSubSistemas(Int16 ID_tb_Sistema_Mant) { List <SubSistemasEntity> List = new List <SubSistemasEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_MAX_tb_SubSistema_Mant", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ID_tb_Sistema_Mant", SqlDbType.Int).Value = ID_tb_Sistema_Mant; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new SubSistemasEntity { ID_tb_SubSistema_Mant = DataReader.GetStringValue(dr, "ID_tb_SubSistema_Mant"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static List <ClaseMEntity> ListClaseMP() { List <ClaseMEntity> List = new List <ClaseMEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_LIS_Clases", con)) { cmd.CommandType = CommandType.StoredProcedure; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new ClaseMEntity { IdClaseMantenimiento = DataReader.GetStringValue(dr, "IdClaseMantenimiento"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static async Task <SistemasEntity> ListSistemas(Int16 ID_tb_Sistema_Mant) { using (var con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var cmd = new SqlCommand("usp_GEN_tb_Sistema_Mant", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ID_tb_Sistema_Mant", SqlDbType.SmallInt).Value = ID_tb_Sistema_Mant; using (var dr = await cmd.ExecuteReaderAsync()) { while (dr.Read()) { return(new SistemasEntity { ID_tb_Sistema_Mant = DataReader.GetShortValue(dr, "ID_tb_Sistema_Mant"), Descripcion = DataReader.GetStringValue(dr, "Descripcion"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(null); }
public static List <SistemasEntity> SelectSistemas() { List <SistemasEntity> List = new List <SistemasEntity>(); using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_Sistema_Mant", con)) { cmd.CommandType = CommandType.StoredProcedure; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { List.Add(new SistemasEntity { ID_tb_Sistema_Mant = DataReader.GetIntValue(dr, "ID_tb_Sistema_Mant"), Descripcion = DataReader.GetStringValue(dr, "Descripcion"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(List); }
public static async Task <FallasDEntity> InsertFallasD(string IdSolicitudRevisionD, string IdSolicitudRevision, string Observacion, string UsuarioRegistro, string FechaRegistro, string HoraRegistro, int Estado, int IdSistema, int IdObservacion) { try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("Usp_tb_SolicitudRevisionTecnica_DInsert2", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdSolicitudRevisionD ", SqlDbType.Text).Value = IdSolicitudRevisionD; cmd.Parameters.Add("@IdSolicitudRevision", SqlDbType.Text).Value = IdSolicitudRevision; cmd.Parameters.Add("@Observacion", SqlDbType.Text).Value = Observacion; cmd.Parameters.Add("@UsuarioRegistro", SqlDbType.Text).Value = UsuarioRegistro; cmd.Parameters.Add("@FechaRegistro", SqlDbType.Text).Value = FechaRegistro; cmd.Parameters.Add("@HoraRegistro", SqlDbType.Text).Value = HoraRegistro; cmd.Parameters.Add("@Estado", SqlDbType.Int).Value = Estado; cmd.Parameters.Add("@IdSistema", SqlDbType.Int).Value = IdSistema; cmd.Parameters.Add("@IdObservacion", SqlDbType.Int).Value = IdObservacion; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(null); }
public static SolicitudRevisionTecnica_CEntity SelectSolicitudRevisionTecnica_C_Informe(int idInforme) { using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_SolicitudRevisionTecnica_C_DatosInforme", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pIdInforme", SqlDbType.Int).Value = idInforme; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { return(new SolicitudRevisionTecnica_CEntity { IdSolicitudRevision = DataReader.GetStringValue(dr, "IdSolicitudRevision"), Kilometraje = DataReader.GetDecimalValue(dr, "KIlometraje") }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(null); }
public static async Task <int> UpdateInformeTareasReasignarInforme(int IdInformeNuevo, int IdInformeAnterior, int IdTarea, byte Estado) { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_tb_InformeTareas_ReasignarAInforme", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pIdInformeNuevo", SqlDbType.Int).Value = IdInformeNuevo; cmd.Parameters.Add("@pIdInformeAnterior", SqlDbType.Int).Value = IdInformeAnterior; cmd.Parameters.Add("@pIdTarea", SqlDbType.Int).Value = IdTarea; cmd.Parameters.Add("@pEstado", SqlDbType.TinyInt).Value = Estado; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static async Task <TareaMPEntity> UpdateTareaMP(short IdTarea, short IdTipMan, string Descripcion, int Flg_Revision, int ID_tb_Sistema_Mant, string ID_tb_SubSistema_Mant) { try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_UPD_Tb_Tareas", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdTarea", SqlDbType.Int).Value = IdTarea; cmd.Parameters.Add("@IdTipMan", SqlDbType.Int).Value = IdTipMan; cmd.Parameters.Add("@Descripcion", SqlDbType.Text).Value = Descripcion; cmd.Parameters.Add("@Flg_Revision", SqlDbType.Int).Value = Flg_Revision; cmd.Parameters.Add("@ID_tb_Sistema_Mant", SqlDbType.Int).Value = ID_tb_Sistema_Mant; cmd.Parameters.Add("@ID_tb_SubSistema_Mant", SqlDbType.Text).Value = ID_tb_SubSistema_Mant; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(null); }
public static async Task <int> InsertTareasSistemas(string AreCodigo, string IdClaseMantenimiento, string Operacion, string xmlData) { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("proc_InsertarTareaSistema", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Are_Codigo", SqlDbType.VarChar).Value = AreCodigo; cmd.Parameters.Add("@IdClaseMantenimiento", SqlDbType.VarChar).Value = IdClaseMantenimiento; cmd.Parameters.Add("@Operacion", SqlDbType.VarChar).Value = Operacion; cmd.Parameters.Add("@XMLData", SqlDbType.Xml).Value = xmlData; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static async Task <int> DeleteInformeTareas(int IdInforme, int IdTarea, int Estado = 0, string Observacion = "") { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("Usp_Tb_InformeTareas_Delete", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdInforme", SqlDbType.Int).Value = IdInforme; cmd.Parameters.Add("@IdTarea", SqlDbType.Int).Value = IdTarea; cmd.Parameters.Add("@Observacion", SqlDbType.VarChar).Value = Observacion; cmd.Parameters.Add("@estado", SqlDbType.Int).Value = Estado; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static InformeEntity SelectInformePorNumero(decimal NumeroInforme, string Tipo) { using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_Informe_BuscarPorNumero", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pNumeroInforme", SqlDbType.Decimal).Value = NumeroInforme; cmd.Parameters.Add("@pTipo", SqlDbType.VarChar).Value = Tipo; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { return(new InformeEntity { IdInforme = DataReader.GetIntValue(dr, "IdInforme") }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(null); }
public static ProgramacionEntity SelectProgramacionPorInforme(string idInforme, int tipo) { using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_PROGRAMACION_ObtenerProgramacionPorInforme", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pNumeroInforme", SqlDbType.VarChar).Value = idInforme; cmd.Parameters.Add("@pTipoInforme", SqlDbType.Int).Value = tipo; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { return(new ProgramacionEntity { CODI_PROGRAMACION = DataReader.GetStringValue(dr, "CODI_PROGRAMACION"), }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(null); }
public static decimal ValidaExiste(string ben_codigo, decimal idInforme) { decimal result = 0; using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_ODM_ValidaExiste", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pBen_Codigo_Solicitante", SqlDbType.VarChar).Value = ben_codigo; cmd.Parameters.Add("@pODM_Informe", SqlDbType.Decimal).Value = idInforme; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { result = Convert.ToDecimal(dr[0]); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(result); }
public static AreEntity SelectAre(string are_codigo) { using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_Are", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pAre_Codigo", SqlDbType.VarChar).Value = are_codigo; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { return(new AreEntity { Klm_Acumulados = DataReader.GetDecimalValue(dr, "Klm_Acumulados") }); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(null); }
public static async Task <ArticuloTEntity> UpdateArticuloT(short IdArtTar, short IdTarea, short Cod_Mer, short Cantidad, short Orden) { try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_UPD_tb_ArticuloTareas", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdArtTar", SqlDbType.Int).Value = IdArtTar; cmd.Parameters.Add("@IdTarea", SqlDbType.Int).Value = IdTarea; cmd.Parameters.Add("@Cod_Mer", SqlDbType.Int).Value = Cod_Mer; cmd.Parameters.Add("@Cantidad", SqlDbType.Int).Value = Cantidad; cmd.Parameters.Add("@Orden", SqlDbType.Int).Value = Orden; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(null); }
public static async Task <int> InsertTareaMecanicosAyudante(TareaMecanicosAyudanteEntity objEntidad) { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_tb_tareamecanicos_ayudante_insert", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pidtareamecanicos", SqlDbType.Int).Value = objEntidad.IdTareaMecanicos; cmd.Parameters.Add("@pcodmecanico", SqlDbType.VarChar).Value = objEntidad.CodMecanico; cmd.Parameters.Add("@pobservacion", SqlDbType.VarChar).Value = objEntidad.Observacion; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static async Task <int> UpdateInformeTareasKilometraje(int IdInforme, int IdTarea, decimal Kilometraje) { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("Usp_Tb_InformeTareas_Update_Kilometraje", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdInforme", SqlDbType.Int).Value = IdInforme; cmd.Parameters.Add("@IdTarea", SqlDbType.Int).Value = IdTarea; cmd.Parameters.Add("@Kilometraje", SqlDbType.Decimal).Value = Kilometraje; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static string ObtenerUltimaRevisionChofer(string ben_codigo) { string ultimoId = ""; using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("SEL_maxsolxChofer", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Ben_Codigo", SqlDbType.VarChar).Value = ben_codigo; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { ultimoId = Convert.ToString(dr[0]); return(ultimoId); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(ultimoId); }
public static async Task <int> AnularControlUnidadMantenimiento(int IdTipMan, string Are_Codigo) { int nuevoId = 0; try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_tb_ControlUnidadTipoMantenimiento_Anular", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pIdTipMan", SqlDbType.Int).Value = IdTipMan; cmd.Parameters.Add("@pARE_CODIGO", SqlDbType.VarChar).Value = Are_Codigo; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(nuevoId); }
public static string SelectValor(int codigo) { string valor = ""; using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_Configuracion_Mantenimientos", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pCodigo", SqlDbType.Int).Value = codigo; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { return(DataReader.GetStringValue(dr, "Valor")); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(valor); }
public static async Task <TipoMEntity> InsertTipoM(short IdTipMan, string Descripcion, short UsuarioRegistro, string FechaRegistro) { try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_INS_tb_tipomantenimiento_c", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdTipMan", SqlDbType.Int).Value = IdTipMan; cmd.Parameters.Add("@Descripcion", SqlDbType.Text).Value = Descripcion; cmd.Parameters.Add("@UsuarioRegistro", SqlDbType.Int).Value = UsuarioRegistro; cmd.Parameters.Add("@FechaRegistro", SqlDbType.Text).Value = FechaRegistro; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(null); }
public static int ObtenerUltimoId() { int ultimoId = 1; using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_tb_Informe_ObtenerId", con)) { cmd.CommandType = CommandType.StoredProcedure; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { ultimoId = Convert.ToInt32(dr[0]); return(ultimoId); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(ultimoId); }
public static int ObtenerUltimoId() { int ultimoId = 1; using (var con = GetConnection.BDALMACEN()) { using (var cmd = new SqlCommand("usp_SEL_tb_SolicitudRevisionTecnica_C_UltimoId", con)) { cmd.CommandType = CommandType.StoredProcedure; bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (var dr = cmd.ExecuteReader()) { while (dr.Read()) { ultimoId = DataReader.GetIntValue(dr, "NumSol"); return(ultimoId); } dr.Close(); } cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } return(ultimoId); }
public static async Task <UsuarioEntity> Actualizapwd(string codiUsuario, string Password) { try { using (SqlConnection con = GetConnection.BDALMACEN()) { bool openConn = (con.State == ConnectionState.Open); if (!openConn) { con.Open(); } using (SqlCommand cmd = new SqlCommand("usp_ACT_TabUsuario", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Codi_Usuario", SqlDbType.SmallInt).Value = codiUsuario; cmd.Parameters.Add("@Usr_Password", SqlDbType.Text).Value = Password; await cmd.ExecuteNonQueryAsync(); cmd.Dispose(); } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw new Exception(ex.Message); } return(null); }