public ActionResult DeleteConfirmed(int id)
        {
            tblOccasion tblOccasion = db.tblOccasions.Find(id);

            db.tblOccasions.Remove(tblOccasion);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "OccasionID,OccasionName")] tblOccasion tblOccasion)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tblOccasion).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(tblOccasion));
 }
        public ActionResult Create([Bind(Include = "OccasionID,OccasionName")] tblOccasion tblOccasion)
        {
            if (ModelState.IsValid)
            {
                db.tblOccasions.Add(tblOccasion);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(tblOccasion));
        }
        // GET: tblOccasions/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblOccasion tblOccasion = db.tblOccasions.Find(id);

            if (tblOccasion == null)
            {
                return(HttpNotFound());
            }
            return(View(tblOccasion));
        }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string dateInsert = DateTime.Now.ToString("yyyyMMdd");
        string timeInsert = DateTime.Now.ToString("hh:mm:ss");


        tblOccasion eventsTbl = new tblOccasion();

        if (txtTitle.Text.Trim().Length > 0)
        {
            eventsTbl.OccasionTitle = txtTitle.Text;

            string str = ckNews.Text;
            eventsTbl.OccasionDetails = Server.HtmlDecode(str);

            eventsTbl.MakeDate  = dateInsert;
            eventsTbl.StartDate = Convert.ToInt32(txtStartDeal.Text);
            eventsTbl.EndDate   = Convert.ToInt32(txtEndDeal.Text);
            eventsTbl.price     = Convert.ToInt32(txtPrice.Text);
            eventsTbl.allow     = "1";

            // file upload start
            string  filename = string.Empty;
            Boolean fileOK   = false;
            String  path     = Server.MapPath("~/images/event/");

            // if picture
            if (IsPostBack)
            {
                if (fuGallery.HasFile)
                {
                    String   fileExtension     = System.IO.Path.GetExtension(fuGallery.FileName).ToLower();
                    String[] allowedExtensions = { ".jpg", ".png", ".bmp", ".gif" };
                    for (int i = 0; i < allowedExtensions.Length; i++)
                    {
                        if (fileExtension == allowedExtensions[i])
                        {
                            fileOK = true;
                        }
                    }
                }

                if (fileOK)
                {
                    try
                    {
                        fuGallery.PostedFile.SaveAs(path + fuGallery.FileName);
                        filename = fuGallery.FileName;
                    }
                    catch (Exception ex)
                    {
                        lblError.Text = "A problem with uplouding picture";
                    }
                }
                else
                {
                    lblError.Text = "Not valid picture";
                }
            }

            //file upload end
            if (filename.Trim().Length > 0)
            {
                eventsTbl.picName = filename;
            }
            else
            {
                eventsTbl.picName = "default.jpg";
            }

            eventsTbl.picAddr = "images/events/";

            eventsTbl.Create();

            Response.Redirect("event-add.aspx");
        }
        else
        {
            lblError.Text = "* please enter title frist.";
        }
    }