예제 #1
0
        public Boolean EntregaFinalNew(EntregaFinalBE eBE)
        {
            con.ConnectionString = conection.GetCon();
            cmd.Connection       = con;
            cmd.CommandType      = CommandType.StoredProcedure;
            cmd.CommandText      = "DOCUMENTO.EntregaFinalNew";
            bool success;

            try {
                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@id_proyecto", eBE.Id_proyecto);
                cmd.Parameters.AddWithValue("@id_encargado", eBE.Id_encargado);
                cmd.Parameters.AddWithValue("@fecha", eBE.Fecha);
                cmd.Parameters.AddWithValue("@path_scan_reporte", eBE.Path_scan_reporte);

                con.Open();
                cmd.ExecuteNonQuery();

                success = true;
            } catch (SqlException x) {
                success = false;
                throw new Exception(x.Message);
            } finally {
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
                cmd.Parameters.Clear();
            }
            return(success);
        }
예제 #2
0
        public EntregaFinalBE ListarEntregaPorId(int idDocumento)
        {
            EntregaFinalBE entBE = new EntregaFinalBE();

            try {
                con.ConnectionString = conection.GetCon();
                cmd.Connection       = con;
                cmd.CommandType      = CommandType.StoredProcedure;
                cmd.CommandText      = "DOCUMENTO.ListarEntregaFinalPorId";

                cmd.Parameters.Clear();
                cmd.Parameters.AddWithValue("@id_documento", idDocumento);

                con.Open();
                SqlDataReader dtr = cmd.ExecuteReader();

                if (dtr.HasRows == true)
                {
                    dtr.Read();
                    entBE.Id_documento      = int.Parse(dtr["id_documento"].ToString());
                    entBE.Id_proyecto       = int.Parse(dtr["id_proyecto"].ToString());
                    entBE.Id_encargado      = int.Parse(dtr["id_encargado"].ToString());
                    entBE.Path_scan_reporte = dtr["path_scan_reporte"].ToString();
                    entBE.Fecha             = Convert.ToDateTime(dtr["fecha"]);
                }
                else
                {
                    throw new Exception("Error al buscar el documento.");
                }
                dtr.Close();
            } catch (Exception ex) {
                throw new Exception(ex.Message);
            } finally {
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
                cmd.Parameters.Clear();
            }
            return(entBE);
        }
예제 #3
0
 public Boolean ModificarEntregaFinal(EntregaFinalBE eBE)
 {
     return(entregaFinal.ModificarEntregaFinal(eBE));
 }
예제 #4
0
 public Boolean EntregaFinalNew(EntregaFinalBE eBE)
 {
     return(entregaFinal.EntregaFinalNew(eBE));
 }