public tbl_Images POST([FromBody] tbl_Images images) { using (ClaimyWebServies_dbEntities2 entity = new ClaimyWebServies_dbEntities2()) { entity.Configuration.ProxyCreationEnabled = false; entity.tbl_Images.Add(images); entity.SaveChanges(); return(images); } }
protected void dgImages_ItemCommand(object source, DataGridCommandEventArgs e) { try { if (e.CommandName == "AddANewRow") { var db = new Pizza15Model(); var AddImage = new tbl_Images(); TextBox txtImageHeaderF = e.Item.FindControl("txtImageHeaderF") as TextBox; TextBox txtNamesF = e.Item.FindControl("txtNamesF") as TextBox; TextBox txtImageURLF = e.Item.FindControl("txtImageURLF") as TextBox; FileUpload ImageuploadF = e.Item.FindControl("ImageuploadF") as FileUpload; if (ddlImageCategory.SelectedItem.Text == "Season Specials") { ImageuploadF.PostedFile.SaveAs(Server.MapPath("~/images/GalleryPhotos/Season Specials/Season Specials" + "/" + ImageuploadF.FileName)); } else { ImageuploadF.PostedFile.SaveAs(Server.MapPath("~/images/GalleryPhotos/" + ddlImageCategory.SelectedItem.Text + "/" + ddlImageSubCategory.SelectedItem.Text + "/" + ImageuploadF.FileName)); } var maxid = (from q in db.tbl_Images select new { q.ID }).ToList(); if (maxid.Count != 0) { AddImage.ID = maxid.Max(x => x.ID) + 1; } AddImage.CategoryID = Convert.ToInt32(ddlImageCategory.SelectedValue); AddImage.SubCategoryID = Convert.ToInt32(ddlImageSubCategory.SelectedValue); AddImage.ImageHeader = txtImageHeaderF.Text; AddImage.Name = txtNamesF.Text; if (ddlImageCategory.SelectedItem.Text == "Season Specials") { AddImage.ImageUrl = ("/images/GalleryPhotos/Season Specials/Season Specials" + "/" + ImageuploadF.FileName); AddImage.ImageLink = ("/images/GalleryPhotos/Season Specials/Season Specials" + "/" + ImageuploadF.FileName); } else { AddImage.ImageUrl = ("/images/GalleryPhotos/" + ddlImageCategory.SelectedItem.Text + "/" + ddlImageSubCategory.SelectedItem.Text + "/" + ImageuploadF.FileName); AddImage.ImageLink = ("/images/GalleryPhotos/" + ddlImageCategory.SelectedItem.Text + "/" + ddlImageSubCategory.SelectedItem.Text + "/" + ImageuploadF.FileName); } db.tbl_Images.Add(AddImage); db.SaveChanges(); Getdata(); } } catch (Exception ex) { lblError.Text = ex.Message; lblError.ForeColor = System.Drawing.Color.Red; } }
protected void dgImages_UpdateCommand(object source, DataGridCommandEventArgs e) { try { string strID = dgImages.DataKeys[e.Item.ItemIndex].ToString(); int nStrID = Convert.ToInt32(strID); TextBox txtImageHeaderE = e.Item.FindControl("txtImageHeaderE") as TextBox; TextBox txtNamesE = e.Item.FindControl("txtNamesE") as TextBox; TextBox txtImageURLE = e.Item.FindControl("txtImageURLE") as TextBox; FileUpload ImageuploadE = e.Item.FindControl("ImageuploadE") as FileUpload; var db = new Pizza15Model(); tbl_Images imgtbl = db.tbl_Images.FirstOrDefault(x => x.ID == nStrID); var infoimgid = (from q in db.tbl_Images join r in db.tbl_ImageCategory on q.CategoryID equals r.CategoryID where q.ID == nStrID where q.CategoryID == r.CategoryID select new { r.SubCategoryName, r.CategoryName }).FirstOrDefault(); string rowcatname = infoimgid.CategoryName; string rowsubcatname = infoimgid.SubCategoryName; if (imgtbl != null) { imgtbl.ImageHeader = txtImageHeaderE.Text; imgtbl.Name = txtNamesE.Text; if (ImageuploadE.FileName != string.Empty) { if (rowcatname == "Season Specials") { ImageuploadE.PostedFile.SaveAs(Server.MapPath("~/images/GalleryPhotos/Season Specials/Season Specials/" + ImageuploadE.FileName)); imgtbl.ImageUrl = ("images/GalleryPhotos/Season Specials/Season Specials/" + ImageuploadE.FileName); imgtbl.ImageLink = ("images/GalleryPhotos/Season Specials/Season Specials/" + ImageuploadE.FileName); } else { ImageuploadE.PostedFile.SaveAs(Server.MapPath("~/images/GalleryPhotos/" + ddlImageCategory.SelectedItem.Text + "/" + ddlImageSubCategory.SelectedItem.Text + "/" + ImageuploadE.FileName)); imgtbl.ImageUrl = ("images/GalleryPhotos/" + ddlImageCategory.SelectedItem.Text + "/" + ddlImageSubCategory.SelectedItem.Text + "/" + ImageuploadE.FileName); imgtbl.ImageLink = ("images/GalleryPhotos/" + ddlImageCategory.SelectedItem.Text + "/" + ddlImageSubCategory.SelectedItem.Text + "/" + ImageuploadE.FileName); } } else { imgtbl.ImageUrl = txtImageURLE.Text; imgtbl.ImageLink = txtImageURLE.Text; } imgtbl.CategoryID = Convert.ToInt32(ddlImageCategory.SelectedValue); imgtbl.SubCategoryID = Convert.ToInt32(ddlImageSubCategory.SelectedValue); db.SaveChanges(); lblError.Text = "Record Updated Successfully"; lblError.ForeColor = System.Drawing.Color.ForestGreen; } dgImages.EditItemIndex = -1; dgImages.ShowFooter = true; Getdata(); } catch (Exception ex) { lblError.Text = ex.Message; lblError.ForeColor = System.Drawing.Color.Red; } }