コード例 #1
0
 private Byte[] RetrieveProductImage(int countryId)
 {
     ContinentDBEntities db = new ContinentDBEntities();
     var country = db.Countries.Find(countryId);
     if (country != null)
     {
         return country.Flag;
     }
     return null;
 }
コード例 #2
0
        protected void grdCountries_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            ContinentDBEntities db = new ContinentDBEntities();
            using (db)
            {

                var countryId = int.Parse(grdCountries.DataKeys[e.RowIndex].Value.ToString());
                var towns = from t in db.Towns
                            where t.Country_Id == countryId
                            select t;

                db.Towns.RemoveRange(towns);
                db.SaveChanges();
            }
        }
コード例 #3
0
        protected void grdCountries_RowCommand(object sender, GridViewCommandEventArgs e)
        //protected void upload_Click(object sender, EventArgs e)
        {
            //int index = Convert.ToInt32(e.CommandArgument);
            //GridViewRow row = grdCountries.Rows[index];

            if (e.CommandName.ToLower() != "upload")
            {
                return;
            }

            //get index of clicked Item
            Button btn = (Button)e.CommandSource;
            GridViewRow gvRow = (GridViewRow)btn.NamingContainer;
            var itemIndex = int.Parse(grdCountries.DataKeys[gvRow.RowIndex].Value.ToString());


            Button bts = e.CommandSource as Button;
            Response.Write(bts.Parent.Parent.GetType().ToString());

            FileUpload fu = bts.FindControl("FileUpload") as FileUpload;//here 

            if (fu.HasFile)
            {
                bool upload = true;
                string fleUpload = Path.GetExtension(fu.FileName.ToString());
                if (fleUpload.Trim().ToLower() == ".png")
                {
                    ContinentDBEntities db = new ContinentDBEntities();
                    using (db)
                    {
                        //fu.SaveAs(Server.MapPath("~/UpLoadPath/" + fu.FileName.ToString()));
                        //string uploadedFile = (Server.MapPath("~/UpLoadPath/" + fu.FileName.ToString()));

                        byte[] buffer = new byte[fu.FileContent.Length];
                        Stream s = fu.FileContent;
                        s.Read(buffer, 0, buffer.Length);


                        var currCountry = db.Countries.Where(c => c.Id == itemIndex).FirstOrDefault();
                        currCountry.Flag = buffer;

                        db.SaveChanges();

                        //Someting to do?...
                    }
                }
                else
                {
                    upload = false;
                    // Something to do?...
                }
                if (upload)
                {
                    // somthing to do?...
                }
            }
            else
            {
                //Something to do?...
            }
        }