public FacturaEn buscar_proveedor_xRuc(string ruc) { try { FacturaEn emp = new FacturaEn(); using (SqlConnection cn = new SqlConnection(objCn.conex("SISE"))) { cn.Open(); SqlCommand cmd = new SqlCommand("usp_tbSunat_buscar", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ruc", ruc); SqlDataReader dr; dr = cmd.ExecuteReader(); if (dr.HasRows == true) { while (dr.Read()) { emp.razonSocial = dr["razon_social"].ToString(); emp.direccion = dr["direccion"].ToString(); } } } return(emp); } catch (Exception ex) { throw new Exception(ex.Message); } }
public object fun_ejecutar_script(string bd, string sp, string tipo = "text") { ConexionDAO objCn = new ConexionDAO(); using (SqlConnection cn = new SqlConnection(objCn.conex(bd))) { cn.Open(); SqlCommand cmd = new SqlCommand(sp, cn); cmd.CommandType = (tipo == "text") ? CommandType.Text : CommandType.StoredProcedure; object x = cmd.ExecuteScalar(); return(x); } }
public int registrar_reparacion_cab(ReparacionEn rep) { try { int idReparacion = 0; using (SqlConnection cn = new SqlConnection(objCn.conex("activos"))) { cn.Open(); SqlCommand cmd = new SqlCommand("usp_ReparacionCabecera_ins", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idGuia", rep.idGuia); cmd.Parameters.AddWithValue("@total", rep.total); cmd.Parameters.AddWithValue("@observ", rep.observ); idReparacion = int.Parse(cmd.ExecuteScalar().ToString()); } return(idReparacion); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable fun_ejecutar_script_dt(string bd, string sp, string tipo = "text") { ConexionDAO objCn = new ConexionDAO(); using (SqlConnection cn = new SqlConnection(objCn.conex(bd))) { cn.Open(); SqlDataAdapter da = new SqlDataAdapter(sp, cn); if (tipo == "text") { da.SelectCommand.CommandType = CommandType.Text; } else { da.SelectCommand.CommandType = CommandType.StoredProcedure; } DataTable dt = new DataTable(); da.Fill(dt); return(dt); } }