protected void grdCustomerEnquiry_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int cId = Convert.ToInt16(grdCustomerEnquiry.DataKeys[e.RowIndex].Values[0]);
dbCommon.DeleteData("enquiryid", cId, "enquiry");
this.BindGrid();
}
public void DeleteImage(string eid)
{
int activityID = Convert.ToInt32(eid);
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("activityimage", "activityimagesrc", " activityimageid= " + activityID);
foreach (DataRow dr in dt.Rows)
{
string strPhysicalFolder = Server.MapPath("~/Images/Activity/");
if (dr["activityimagesrc"].ToString() != "" && File.Exists(strPhysicalFolder + dr["activityimagesrc"].ToString()))
{
File.Delete(strPhysicalFolder + dr["activityimagesrc"].ToString());
}
string strPhysicalFolderThumb = Server.MapPath("~/Images/ActivityThumb/");
if (dr["activityimagesrc"].ToString() != "" && File.Exists(strPhysicalFolderThumb + dr["activityimagesrc"].ToString()))
{
File.Delete(strPhysicalFolderThumb + dr["activityimagesrc"].ToString());
}
break;
}
bool i = dbCommon.DeleteData("activityimageid", Convert.ToInt32(eid), " activityimage ");
if (i == true)
{
ddActivity.SelectedValue = dbCommon.GetUpdateId("imageAddId");
BindImages();
}
}
protected void grdPackageType_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int packagecategoryID = Convert.ToInt16(grdPackageType.DataKeys[e.RowIndex].Values[0]);
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataParam("packagecategory", "pkgimgsrc", "packagecategoryid = " + packagecategoryID);
if (dbCommon.CheckDuplicateByQuery("select count(*) from package where packagecategoryid='" + packagecategoryID + "'") > 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Delete!','" + grdPackageType.Rows[e.RowIndex].Cells[0].Text + " exist in Package.', 'warning');", true);
}
else
{
foreach (DataRow dr in dt.Rows)
{
string strPhysicalFolder = Server.MapPath("~/Images/Package/");
if (dr["pkgimgsrc"].ToString() != "" && File.Exists(strPhysicalFolder + dr["pkgimgsrc"].ToString()))
{
File.Delete(strPhysicalFolder + dr["pkgimgsrc"].ToString());
}
break;
}
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Delete!', '" + grdPackageType.Rows[e.RowIndex].Cells[0].Text + " is Delete.', 'success');", true);
dbCommon.DeleteData("packagecategoryid", packagecategoryID, "packagecategory");
this.BindGrid();
}
}
protected void grdActivityFAQ_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
dbCommon.SetUpdateId("comboId", ddActivityName.SelectedValue.ToString());
int cId = Convert.ToInt16(grdActivityFAQ.DataKeys[e.RowIndex].Values[0]);
dbCommon.DeleteData("faqid", cId, "faqs");
this.BindGrid();
}
protected void grdCountry_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int cId = Convert.ToInt16(grdCountry.DataKeys[e.RowIndex].Values[0]);
string str = grdCountry.Rows[e.RowIndex].Cells[0].Text;
if (dbCommon.CheckDuplicateByQuery("select COUNT(*) from city where countryid='" + cId + "'") > 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Delete!', '" + str + " is exist in city!', 'warning');", true);
}
else if (dbCommon.CheckDuplicateByQuery("select COUNT(*) from user_details where countryid='" + cId + "'") > 0)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Delete!', '" + str + " is exist in user!', 'warning');", true);
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "SweetAlert", "swal('Delete!', '" + str + " is Delete !', 'success');", true);
dbCommon.DeleteData("countryid", cId, "country");
this.BindGrid();
}
}
