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