public Caj_ConceptoBE ConsultarConcepto(int in_idConcepto)
{
try
{
objSqlConnection.Open();
Caj_ConceptoBE objConcepto;
SqlCommand objSqlCommand = new SqlCommand("sp_sel_Caj_Concepto_seleccionar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
objSqlCommand.Parameters.Add(new SqlParameter("@i_idConcepto", in_idConcepto));
SqlDataReader objSqlDateReader = objSqlCommand.ExecuteReader();
if (objSqlDateReader.Read())
{
objConcepto = new Caj_ConceptoBE();
objConcepto.in_idConcepto = (int)objSqlDateReader["i_idConcepto"];
objConcepto.bl_ver = (bool)objSqlDateReader["b_ver"];
objConcepto.dt_fchRegistro = (DateTime)(objSqlDateReader["dt_fchRegistro"]);
objConcepto.st_dscpConcepto = (string)objSqlDateReader["vc_dscpConcepto"];
objConcepto.objDenominacionBE.in_idDenominacion = (int)objSqlDateReader["i_idDenominacion"];
objConcepto.objDenominacionBE.st_dscpDenominacion = (string)objSqlDateReader["vc_dscpDenominacion"];
return(objConcepto);
}
objSqlConnection.Close();
return(null);
}
catch (Exception e)
{
objSqlConnection.Close();
return(null);
}
}
public List <Caj_ConceptoBE> ListarConcepto(int _case, string filtro)
{
try
{
SqlConnection objSqlConnection = Conexion.GetConexion();
objSqlConnection.Open();
List <Caj_ConceptoBE> objListConcepto = new List <Caj_ConceptoBE>();
Caj_ConceptoBE objConcepto; //sp_list_Caj_Concepto_listar
SqlCommand objSqlCommand = new SqlCommand("sp_list_Caj_Concepto_listar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
objSqlCommand.Parameters.Add(new SqlParameter("@case", _case));
objSqlCommand.Parameters.Add(new SqlParameter("@filtro", filtro));
SqlDataReader objSqlDataReader = objSqlCommand.ExecuteReader();
while (objSqlDataReader.Read())
{
objConcepto = new Caj_ConceptoBE();
objConcepto.in_idConcepto = (int)objSqlDataReader["i_idConcepto"];
objConcepto.bl_ver = (bool)objSqlDataReader["b_ver"];
objConcepto.dt_fchRegistro = (DateTime)objSqlDataReader["dt_fchRegistro"];
objConcepto.st_dscpConcepto = (string)objSqlDataReader["vc_dscpConcepto"];
objConcepto.objDenominacionBE.in_idDenominacion = (int)objSqlDataReader["i_idDenominacion"];
objConcepto.objDenominacionBE.st_dscpDenominacion = (string)objSqlDataReader["vc_dscpDenominacion"];
objListConcepto.Add(objConcepto);
}
objSqlDataReader.Close();
objSqlConnection.Close();
return(objListConcepto);
}
catch (Exception e)
{
return(null);
}
}
public Boolean QuitarConcepto(Caj_ConceptoBE objConcepto)
{
try
{
objSqlConnection.Open();
SqlCommand objSqlCommand = new SqlCommand("sp_del_Caj_Concepto_eliminar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
// objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.Parameters.Add(new SqlParameter("@i_idConcepto", objConcepto.in_idConcepto));
objSqlCommand.Parameters.Add(new SqlParameter("@b_ver", objConcepto.bl_ver));
objSqlCommand.ExecuteNonQuery();
//objSqlTransaction.Commit();
objSqlConnection.Close();
return(true);
}
catch (Exception e)
{
objSqlConnection.Close();
return(false);
}
}
public Boolean ModificarConcepto(Caj_ConceptoBE objConcepto)
{
try
{
objSqlConnection.Open();
SqlCommand objSqlCommand = new SqlCommand("sp_upd_Caj_Concepto_actualizar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
// objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.Parameters.Add(new SqlParameter("@i_idConcepto", objConcepto.in_idConcepto));
objSqlCommand.Parameters.Add(new SqlParameter("@vc_dscpConcepto", objConcepto.st_dscpConcepto));
objSqlCommand.Parameters.Add(new SqlParameter("@i_idDenominacion", objConcepto.objDenominacionBE.in_idDenominacion));
objSqlCommand.ExecuteNonQuery();
//objSqlTransaction.Commit();
objSqlConnection.Close();
return(true);
}
catch (Exception e)
{
objSqlConnection.Close();
return(false);
}
}
public Boolean InsertarRegistro(Caj_ConceptoBE objConcepto)
{
//SqlTransaction objSqlTransaction = objSqlConnection.BeginTransaction();
try
{
objSqlConnection.Open();
SqlCommand objSqlCommand = new SqlCommand("sp_ins_Caj_Concepto_registrar", objSqlConnection);
objSqlCommand.CommandType = CommandType.StoredProcedure;
// objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.Parameters.Add(new SqlParameter("@dt_fchRegistro", objConcepto.dt_fchRegistro));
objSqlCommand.Parameters.Add(new SqlParameter("@vc_dscpConcepto", objConcepto.st_dscpConcepto));
objSqlCommand.Parameters.Add(new SqlParameter("@b_ver", "true"));
objSqlCommand.Parameters.Add(new SqlParameter("@i_idDenominacion", objConcepto.objDenominacionBE.in_idDenominacion));
objSqlCommand.ExecuteNonQuery();
//objSqlTransaction.Commit();
objSqlConnection.Close();
return(true);
}
catch (Exception e)
{
objSqlConnection.Close();
return(false);
}
}
