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