/// <summary>
        /// 
        /// </summary>
        /// <param name="src"></param>
        /// <returns></returns>
        public override CyNetwork GetNetwork(CyNetwork src)
        {
            string connStr = ConfigurationManager.ConnectionStrings["qwerty"].ConnectionString;

            using (var conn = new SqlConnection(connStr))
            {
                conn.Open();

                string coordsHash;

                using (var md5 = MD5.Create())
                using (var ins = new FileStream(this.FileName, FileMode.Open, FileAccess.Read))
                {
                    coordsHash = md5.ComputeHash(ins).ToHex(false);
                }

                var checkCoordsHashCmd = new SqlCommand("CheckCoordsHash", conn); ;
                checkCoordsHashCmd.CommandType = CommandType.StoredProcedure;
                checkCoordsHashCmd.Parameters.Add(new SqlParameter("CoordsHash", SqlDbType.Char, 32) { Value = coordsHash });
                int checkCoordsHashRes = (int)checkCoordsHashCmd.ExecuteScalar();

                if (checkCoordsHashRes == 0)
                {
                    string putCoordsSql = string.Format(
                        "INSERT INTO TSV (SeqName, StartTSV, EndTSV)\n\tVALUES\n {0};",
                        string.Join(
                            ",",
                            File.ReadLines(this.FileName)
                                .Select(
                                    delegate(string line)
                                    {
                                        var parts = line.Split(new char[] { ':', '-', '/', '\t' });
                                        return string.Format(
                                            "(\"{0}\", {1}, {2})",
                                            parts[0],
                                            long.Parse(parts[1]),
                                            long.Parse(parts[2])
                                            );
                                    })
                            )
                        );

                    var putCoordsCmd = new SqlCommand(putCoordsSql);
                }
            }

            return new CyNetwork(Path.GetFileNameWithoutExtension(this.FileName));
        }
예제 #2
0
        private void btnSend_Click(object sender, EventArgs e)
        {
            try
            {
                var nw = new CyNetwork("Client Network");

                var n1 = new CyNode("n1", "Node 1");
                var n2 = new CyNode("n2", "Node 2");
                nw.Nodes.Add(n1);
                nw.Nodes.Add(n2);

                var e1_2 = new CyEdge("e1", "Edge 1-2", n1, n2);
                nw.Edges.Add(e1_2);

                this.client.Networks.Add(nw);
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        public override CyNetwork GetNetwork(CyNetwork src)
        {
            CyNetwork res = new CyNetwork(src.Name);

            return res;
        }