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;
}
}
