Beispiel #1
0
        // GET: image/Create
        public ActionResult addimage()
        {
            PieceJoint b1 = new PieceJoint();

            List <file> list = new List <file>();



            const string connect = @"Server=WAHID;Database=HELPDESK3;Trusted_Connection=True;";

            using (var conn = new SqlConnection(connect))
            {
                var qry = "SELECT [IdPiece],[filename] FROM PieceJoint ";
                var cmd = new SqlCommand(qry, conn);

                conn.Open();
                SqlDataReader result = cmd.ExecuteReader();
                while (result.Read())
                {
                    list.Add(new file(
                                 result.GetInt32(0),
                                 result.GetString(1)
                                 ));
                }
            }


            ViewBag.list = list;



            return(View(b1));
        }
Beispiel #2
0
        public ActionResult addimage(PieceJoint model, HttpPostedFileBase image1)
        {
            var db = new HELPDESK3Entities();

            if (image1 != null)
            {
                model.img      = new byte[image1.ContentLength];
                model.filename = image1.FileName;
                model.type     = "" + image1.GetType();
                image1.InputStream.Read(model.img, 0, image1.ContentLength);
            }

            db.PieceJoint.Add(model);
            db.SaveChanges();
            ViewBag.filename = image1.FileName;
            List <file> list = new List <file>();

            const string connect = @"Server=WAHID;Database=HELPDESK3;Trusted_Connection=True;";

            using (var conn = new SqlConnection(connect))
            {
                var qry = "SELECT [IdPiece],[filename] FROM PieceJoint ";
                var cmd = new SqlCommand(qry, conn);

                conn.Open();
                SqlDataReader result = cmd.ExecuteReader();
                while (result.Read())
                {
                    list.Add(new file(
                                 result.GetInt32(0),
                                 result.GetString(1)
                                 ));
                }
            }


            ViewBag.list = list;


            return(View(model));
        }