protected void btnSaveVideo_Click(object sender, EventArgs e) { GetId(); PNK_UploadImage productcatObj = new PNK_UploadImage(); Generic <PNK_UploadImage> genericBLL = new Generic <PNK_UploadImage>(); //Get max id medical_product DBLibrary db = new DBLibrary(); productId = db.Timso_int("SELECT TOP 1 id FROM PNK_Product mp order by id desc") + 1; productimageID = db.Timso_int("SELECT TOP 1 ProductID FROM [PNK_UploadImage] mp where ProductID=" + imageID + " And Name='Youtube' "); //Update if (productimageID != 0) { DBHelper.ExcuteNonQuery("Update PNK_UploadImage set Name=" + "'Youtube',ImagePath=" + "'" + txtID.Value + "' Where ProductID=" + imageID + " ", null); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), string.Format("jAlert('{0}','Message');", Constant.UI.admin_msg_save_success), true); } else//Insert { productcatObj.Published = "1"; productcatObj.Updatedate = DateTime.Now; productcatObj.Name = "Youtube"; productcatObj.ImagePath = txtID.Value; productcatObj.ProductId = imageID == int.MinValue ? productId : imageID; productcatObj.PostDate = DateTime.Now; productcatObj.Ordering = genericBLL.getOrdering(); //excute if (genericBLL.Insert(productcatObj) != int.MinValue) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), string.Format("jAlert('{0}','Message');", Constant.UI.admin_msg_save_success), true); } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), string.Format("jAlert('{0}','Message');", Constant.UI.admin_msg_save_fail), true); } Session["ID"] = productId; } }
protected void grdImage_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int idImage = DBConvert.ParseInt(grdImage.DataKeys[e.RowIndex].Value); DBLibrary db = new DBLibrary(); productId = db.Timso_int(string.Format("SELECT TOP 1 productid FROM PNK_UploadImage mp where id={0} ORDER BY id desc", idImage)); db.Timso_int(string.Format("DELETE FROM PNK_UploadImage WHERE id={0}", idImage)); string imagePath = Server.MapPath(string.Format("{0}/{1}", grdImage.Rows[e.RowIndex].Cells[3].Text, grdImage.Rows[e.RowIndex].Cells[1].Text)); //if (File.Exists(imagePath)) //{ File.Delete(imagePath); BindAlbum(productId); //} } catch (Exception ex) { // throw; } }
/// <summary> /// Save location /// </summary> private int SaveNewsCategory() { GetId(); PNK_UploadImage productcatObj = new PNK_UploadImage(); Generic <PNK_UploadImage> genericBLL = new Generic <PNK_UploadImage>(); if (idImage == int.MinValue) { //Get max id medical_product DBLibrary db = new DBLibrary(); productId = db.Timso_int("SELECT TOP 1 id FROM PNK_Product mp ORDER BY id desc") + 1; //get data insert productcatObj = this.GetDataObjectParent(productcatObj); productcatObj.ProductId = productId; productcatObj.PostDate = DateTime.Now; productcatObj.Ordering = genericBLL.getOrdering(); //excute genericBLL.Insert(productcatObj); } else { productcatObj.Published = "1"; productcatObj.Updatedate = DateTime.Now; productcatObj.Name = fileNameUpload; productcatObj.ImagePath = ImagePath; productcatObj.ProductId = idImage; productcatObj.PostDate = DateTime.Now; productcatObj.Ordering = genericBLL.getOrdering(); //excute genericBLL.Insert(productcatObj); BindAlbum(idImage); // } //} } return(productId); }