public DataTable SelectByIdFichaSoporte(int codigo) { DetalleFichaSoporteEntity objEnt = new DetalleFichaSoporteEntity(); objEnt.IdFichaSoporte = codigo; return(objDetFicSopMod.ListarDetFicSoporte(objEnt)); }
public DataTable ListarDetFicSoporte(DetalleFichaSoporteEntity objEnt) { con = objCon.Conectar(); con.Open(); SqlDataAdapter da = new SqlDataAdapter("SP_SEL_POR_ID_FIC_SOPORTE", con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@ID", SqlDbType.Int).Value = objEnt.IdFichaSoporte; DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public bool Insert(DetalleFichaSoporteEntity objEnt) { con = objCon.Conectar(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "SP_INS_DET_FIC_SOPORTE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.Parameters.Add("@IDFICSOPORTE", SqlDbType.Int).Value = objEnt.IdFichaSoporte; cmd.Parameters.Add("@IDDETALLE_MOTIVO", SqlDbType.Int).Value = objEnt.IdDetalleMotivo; try { int r = cmd.ExecuteNonQuery(); if (r == 1) { return(true); } } catch (Exception ex) { //throw new Exception(ex.Message); return(false); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } return(false); }
public bool Add(DetalleFichaSoporteEntity objEnt) { return(objDetFicSopMod.Insert(objEnt)); }