protected void DetailsViewOrganization_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { MembershipUser userDel = Membership.GetUser(); string userID = userDel.ProviderUserKey.ToString(); SqlDataSourceOrganization.DeleteParameters["original_UserID"].DefaultValue = userID; }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { XmlDataSource1.TransformFile = ""; XmlDocument xdoc = XmlDataSource1.GetXmlDocument(); XmlElement feed = xdoc.SelectSingleNode("/listaDeRSS/feed[name='" + e.Values["name"].ToString() + "']") as XmlElement; xdoc.DocumentElement.RemoveChild(feed); XmlDataSource1.Save(); XmlDataSource1.DataBind(); XmlDataSource1.TransformFile = "~/bla.xslt"; e.Cancel = true; DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); string path = HttpContext.Current.Server.MapPath("~/App_Data/public_feeds.xml"); XmlDocument source = new XmlDocument(); source.Load(path); XmlElement toRemove = source.SelectSingleNode("/channels/channel[@name='" + e.Values["name"].ToString() + "']") as XmlElement; source.DocumentElement.RemoveChild(toRemove); source.Save(path); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { mails.RemoveAt(e.RowIndex); Cache["mailList"] = mails; DetailsView1.DataSource = mails; DetailsView1.DataBind(); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { //Response.Write("<script language='javascript'>confirm('Are you sure?')</script>"); string query = "DELETE FROM PRODUCTS WHERE ID = " + (((Label)DetailsView1.FindControl("lblId")).Text.ToString()); using (SqlConnection cnn = new SqlConnection(myConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandType = CommandType.Text; cmd.CommandText = query; try { string image = Request.MapPath("Images/ProductImages/" + ((Label)DetailsView1.FindControl("lblImage")).Text); cnn.Open(); cmd.ExecuteNonQuery(); Response.Write("<script language='javascript'>alert('Product removed from Database.')</script>"); System.IO.File.Delete(image); DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); } catch (Exception er) { Response.Write("<script language='javascript'>alert('Error has occured.')</script>"); System.Diagnostics.Debug.WriteLine(er.Message); } finally { cnn.Close(); UpdateGridView(); DetailsView1.DataBind(); } } } }
protected void deleteItem1(object sender, DetailsViewDeleteEventArgs e) { Label id = DetailsView1.FindControl("lbl_userId") as Label; ClientHelper.deleteClientByID(int.Parse(id.Text)); Response.Redirect("logIn.aspx"); }
protected void dvContratos_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { try { DSConosudTableAdapters.ContratoEmpresasTableAdapter TAContratoEmpresa = new DSConosudTableAdapters.ContratoEmpresasTableAdapter(); DSConosud.ContratoEmpresasDataTable dtContEmp = TAContratoEmpresa.GetDataByIdContrato(Convert.ToInt64(this.gvContratos.SelectedValue)); foreach (DSConosud.ContratoEmpresasRow rowContEmp in dtContEmp) { rowContEmp.Delete(); } TAContratoEmpresa.Update(dtContEmp); } catch (Exception ex) { //if (-1 != ex.Message.IndexOf("FK_ContEmpLegajos",0)) //{ // string alert = "alert('El Contrato no puede ser eliminado, tiene legajos asociados')"; // System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "click", alert, true); //} e.Cancel = true; } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int recipeId = Convert.ToInt32(DetailsView1.DataKey.Value); string connectionstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; OracleConnection conn = new OracleConnection(); conn.ConnectionString = connectionstring; OracleCommand comm = conn.CreateCommand(); comm.CommandType = CommandType.Text; comm.CommandText = "delete from recipes where recipeID = :selected_recipe"; OracleParameter param = comm.Parameters.Add("selected_recipe", OracleDbType.Int32, ParameterDirection.Input); param.Value = recipeId; try { comm.Connection.Open(); OracleDataReader reader = comm.ExecuteReader(); reader.Close(); Response.Redirect("recipes.aspx"); } catch (Exception ex) { } finally { comm.Connection.Close(); } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int packetID = Convert.ToInt32(e.Keys["ID"]); List <PacketsInsuranceSubType> old_values = PacketsInsuranceSubType.GetByPacket(packetID); PacketsInsuranceSubType.Table.DeleteAllOnSubmit(old_values); PacketsInsuranceSubType.Table.Context.SubmitChanges(); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int id = Convert.ToInt16(DetailsView1.DataKey.Value); b.country_id = id; d.delete_COUNTRY(b); fillfetails(); }
protected void dvCustomer_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { if (e.Values["UnitPrice"] != null) { e.Values["UnitPrice"] = e.Values["UnitPrice"].ToString().Substring(1); } }
protected void DetailsEmpView_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { string t1 = DetailsEmpView.Rows[0].Cells[1].Text; obj.EmpId = int.Parse(t1); obj.DeleteEmployee(); Response.Redirect("frmEmployeeUpdation.aspx"); }
protected async void dvItalikas_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { BR_ITALIKASController c = new BR_ITALIKASController(); int idItalika = Int32.Parse(((DetailsView)sender).DataKey.Value.ToString()); await c.DeleteConfirmed(idItalika); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Aviso", "alert('Registro eliminado.')", true); this.obtenerItalikas(); }
protected void deleteItem1(object sender, DetailsViewDeleteEventArgs e) { Label id = DetailsView1.FindControl("lbl_userId") as Label; ClientHelper.deleteClientByID(int.Parse(id.Text)); DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); PopulateDropdown(); BindDetailsView(); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { //ReuseTech obj = mgr.getReuseTech(int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value)); ReuseTech obj = GetReuseTech(int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value)); String sqlReuseTechDel = " delete from ReuseTech where Id =@id "; OleDbCommand cmdReuseTechDel = new OleDbCommand(sqlReuseTechDel); cmdReuseTechDel.Parameters.Add("@id", OleDbType.Integer).Value = (int.Parse(((HiddenField)DetailsView1.FindControl("Id")).Value)); SQLUtil.ExecuteSql(cmdReuseTechDel); //at = SpringUtil.at(); String sql = "SELECT * FROM MatchList WHERE Rid1=@param1 "; //IDbParameters parameters = at.CreateDbParameters(); //parameters.Add("param1", OleDbType.Integer).Value = obj.Id; //DataSet ds = new DataSet(); //at.DataSetFillWithParameters(ds, CommandType.Text, sql, parameters); OleDbCommand cmd = new OleDbCommand(sql); cmd.Parameters.Add("@param1", OleDbType.Integer).Value = obj.Id; cmd.CommandType = CommandType.Text; DataSet ds = SQLUtil.QueryDS(cmd); ArrayList matchList = null; if (ds.Tables[0].Rows.Count > 0) { matchList = new ArrayList(); foreach (DataRow dRow in ds.Tables[0].Rows) { //Match match = mgrMatch.getMatch((int)dRow["Id"]); //match.Isdeleted = true; //match.Isdeleted1 = true; //match.Deletedate1 = DateTime.Now; //matchList.Add(match); String sqlMatchUp = " Update MatchList "; sqlMatchUp = sqlMatchUp + " Set Isdeleted=@Isdeleted,"; sqlMatchUp = sqlMatchUp + " Isdeleted1=@Isdeleted1, "; sqlMatchUp = sqlMatchUp + " Deletedate1=@Deletedate1 "; sqlMatchUp = sqlMatchUp + " where id=@id "; OleDbCommand cmdMatchDel = new OleDbCommand(sqlMatchUp); cmdMatchDel.Parameters.Add("@Deletedate1", OleDbType.Date).Value = DateTime.Now; cmdMatchDel.Parameters.Add("@Isdeleted", OleDbType.Boolean).Value = true; cmdMatchDel.Parameters.Add("@Isdeleted1", OleDbType.Boolean).Value = true; cmdMatchDel.Parameters.Add("@id", OleDbType.Integer).Value = (int)dRow["Id"]; SQLUtil.ExecuteSql(cmdMatchDel); } } //private IReuseTechService mgr = (IReuseTechService)BaseAction.Context.GetObject("ReuseTechService"); //mgr.Delete(obj, null, matchList); BindGrid(); MultiView1.ActiveViewIndex = 0; }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { string productID = DetailsView1.DataKey.Value.ToString(); string ProductName = e.Values["prod_name"].ToString(); _com_fun_delete_prod.prodid = productID; businessLogic.delete_prod_ID(_com_fun_delete_prod); DetailsViewDataBind(); lbl_delete_message.Text = "<span style='background:#800080; color:#ffffff; padding:7px 10px 7px 10px; '> Product ID : <u><b>" + productID + "</b></u> & Product Name : <u><b>" + ProductName + "</b></u> Deleted Successfully...</span>"; }
// On delete customer private void CustomerDetailView_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { try { } catch (Exception) { throw; } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { dl.id = Convert.ToInt16(DetailsView1.DataKey.Value); bl.delete_stud(dl); DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); DetailsView1.DataSource = bl.bind_grid(); // Chart1.Series["Series1"].XValueMember = "X"; // Chart1.Series["Series1"].Sort(System.Web.UI.DataVisualization.Charting.PointSortOrder.Descending, "Y"); DetailsView1.DataBind(); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { var productCount = productService.GetProductCountByCategoryId(int.Parse(DetailsView1.DataKey.Value.ToString())); if (productCount != 0) { Label1.Text = "Error:该分类下有商品,请先删除商品!"; e.Cancel = true; } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { //String sql = "update enrollment,student set enrollment.StdSSN="+"''"+" where student.StdSSN=enrollment.StdSSN"; //String sql = "delete from enrollment inner join student on enrollment.StdSSN = student.StdSSN where enrollment.StdSSN = student.StdSSN"; String sql = "delete enrollment from enrollment,student where student.StdSSN=enrollment.StdSSN"; ExecuteDB(sql); String deletesql = "delete from student where StdSSN='" + e.Values[0].ToString().Trim() + "'"; ExecuteDB(deletesql); }
protected void DetailsViewBankslipItem_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { if (e.Values["PaymentDescription"] == null) { e.Values["PaymentDescription"] = ""; } if (e.Values["CallOnPaymentNumber"] == null) { e.Values["CallOnPaymentNumber"] = ""; } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { try { txtMessage.Text = "Record Deleted."; } catch (Exception Ex) { txtMessage.Text = Ex.Message.ToString(); } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { try { txtMessage.Text = "Specialty pizza was deleted from the database."; } catch (Exception Ex) { txtMessage.Text = Ex.Message.ToString(); } }
protected void DetailsViewPodaciOfajlu_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { string fajl = e.Values["putanja"].ToString(); string putanja = Server.MapPath("~/fajlovi/" + fajl); FileInfo podaciOfajlu = new FileInfo(putanja); if (podaciOfajlu.Exists) { File.Delete(putanja); } }
protected void DetailsView1_ItemDeleting(Object sender, DetailsViewDeleteEventArgs e) { MyPetShopDataContext db = new MyPetShopDataContext(); var productCount = (from p in db.Product where p.SuppId == int.Parse(DetailsView1.DataKey.Value.ToString()) select p).Count(); if (productCount != 0) { lblError.Text = "Error:该分类下有商品,请先删除商品!"; e.Cancel = true; } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { var rec = e.Keys[0]; List<int> attendeeVolunteerIds = AttendeeVolunteerManager.I.Get(new AttendeeVolunteerQuery() { VolunteerJobId = Convert.ToInt32(rec) }).Select(a => a.Id).ToList(); AttendeeVolunteerManager.I.Delete(attendeeVolunteerIds); GridView1.DataBind(); GridViewVolunteerJobs.DataBind(); }
protected void DetailsView_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int clubId = (int)Session["ClubDetailsId"]; SqlCommand command = new SqlCommand(); command.CommandText = "DeleteClub"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("RegID", SqlDbType.Int); command.Parameters["RegID"].Value = clubId; DataConnection myConnection = new DataConnection(); myConnection.ExecuteNonQuery(command); Response.Redirect("Clubs.aspx"); }
protected void DetailsView_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { String PlayerName = (String)Session["PlayerDetailsName"]; SqlCommand command = new SqlCommand(); command.CommandText = "DeletePlayer"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("Name", SqlDbType.NVarChar); command.Parameters["Name"].Value = PlayerName; DataConnection myConnection = new DataConnection(); myConnection.ExecuteNonQuery(command); Response.Redirect("ClubDetails.aspx#Body"); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { Properties_xml.TransformFile = ""; XmlDocument xdoc = Properties_xml.GetXmlDocument(); XmlElement property = xdoc.SelectSingleNode("properties/property[@land_register_number=" + e.Values["land_register_number"].ToString() + "]") as XmlElement; xdoc.DocumentElement.RemoveChild(property); Properties_xml.Save(); Properties_xml.TransformFile = "~/App_Data/Property_XSL.xslt"; e.Cancel = true; DetailsView1.DataBind(); DetailsView1.ChangeMode(DetailsViewMode.ReadOnly); }
protected void dvProposal_OnItemDeleting(object sender, DetailsViewDeleteEventArgs e) { string deleteString = "delete from Proposal where ProposalNo=" + e.Values[0]; OleDbConnection MyConnection = new OleDbConnection(connectionString); OleDbCommand MyCommand = new OleDbCommand(deleteString, MyConnection); MyConnection.Open(); MyCommand.ExecuteNonQuery(); MyConnection.Close(); dvProposal_DataRebind(); }
protected void PostView_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { try { if (FooSessionHelper.IsValidRequest(HttpContext.Current, RequestToken.Value)) { using (var conn = new NpgsqlConnection()) { conn.ConnectionString = ConfigurationManager.ConnectionStrings["fooPostgreSQL"].ConnectionString; conn.Open(); var cmd = new NpgsqlCommand { CommandText = "DELETE FROM posts WHERE postid= @POSTID", CommandType = CommandType.Text, Connection = conn }; var param = new NpgsqlParameter { ParameterName = "@POSTID", NpgsqlDbType = NpgsqlDbType.Integer, Size = 8, Direction = ParameterDirection.Input, Value = Convert.ToInt32(postView.SelectedValue) }; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); } } else { errorLabel.Text = "Invalid request."; } } catch (Exception ex) { FooLogging.WriteLog(ex.ToString()); errorLabel.Text = "Something has gone wrong. A log has been forwarded to the site administrator."; } Reset_Page(-1); }
protected void friendDetailsGrid_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { System.Diagnostics.Debug.WriteLine("*****INSIDE FRIENDDETAILS:friendDetailsGrid_ItemDeleting*****"); int bookId = Convert.ToInt32(Request.QueryString["Friend_ID"]); OracleConnection oConn = GetConnection(); OracleCommand oCmd = oConn.CreateCommand(); oCmd.CommandText = "DELETE_FRIENDS_PRC"; oCmd.CommandType = CommandType.StoredProcedure; OracleParameter param1 = oCmd.Parameters.Add("P_FRIEND_ID", OracleDbType.Int32, ParameterDirection.Input); param1.Value = bookId; oCmd.Parameters.Add("OUT_ERR_MSG", OracleDbType.Varchar2, ParameterDirection.Output); oCmd.Parameters.Add("OUT_ERR_CODE", OracleDbType.Varchar2, ParameterDirection.Output); oCmd.Parameters["OUT_ERR_CODE"].Size = 500; oCmd.Parameters["OUT_ERR_MSG"].Size = 500; System.Diagnostics.Debug.WriteLine("*****INSIDE friendDetailsGrid_ItemDeleting:*****" + (oCmd.Parameters["OUT_ERR_MSG"].Value)); try { oConn.Open(); oCmd.ExecuteNonQuery(); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("*****Exception***** " + ex.Message); dbErrorMessage.Text = "Error while deleting friend!" + "Error Code: {0}" + oCmd.Parameters["OUT_ERR_CODE"].Value.ToString() + "Error Msg: {1}" + oCmd.Parameters["OUT_ERR_MSG"].Value.ToString(); } finally { oConn.Close(); } deletedLabel.Text = "The friend is deleted successfully!"; friendDetailsGrid.ChangeMode(DetailsViewMode.ReadOnly); BindDetails(); //Response.Redirect("Books.aspx"); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { using (var db = drvvv.drvvvSettings.GetDataContextInstance()) { var cProductsCategories = drvvv.drvvvSettings.GetDataContextInstance().Cities.Where(x => x.ID == (int)e.Keys[0]).SingleOrDefault(); if (cProductsCategories != null) { if (cProductsCategories.Cities.Count > 0) { // יש רשומות קשורות e.Cancel = true; // מבטל מחיקה Label1.Text = "יש ערים קשורות"; } } else { // התמונה לא קיימת במסד e.Cancel = true; // מבטל מחיקה Label1.Text = "העיר לא נמצאה"; } } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int selected_rec_id = (int)DetailsView1.SelectedValue; // rec_id to be targeted for deletion // 1. open the Connection object for the context SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["INFO3420_12ConnectionString"].ConnectionString); myConnection.Open(); // 2. create new sql command object to write to the database SqlCommand delete = new SqlCommand("delete_RECIPE", myConnection); // 3. set up sprocs with proper values and execute! delete.CommandType = CommandType.StoredProcedure; delete.Parameters.Add("@rec_id", SqlDbType.Int).Value = selected_rec_id; delete.ExecuteNonQuery(); //execute the sproc // 4. close the Connection object for the context myConnection.Close(); // 5. update the grid view GridView1.DataBind(); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int id = (int)e.Keys[0]; using (var db = drvvv.drvvvSettings.GetDataContextInstance()) { var cCoupons = db.Coupons.Where(x => x.ID == id).SingleOrDefault(); db.Clicks.DeleteAllOnSubmit(cCoupons.Clicks); if (!string.IsNullOrEmpty(cCoupons.ImgName)) { if (!drvvv.GetFile.DeleteFile(cCoupons.ImgName)) { e.Cancel = true; RegisterStartupScript("alert", "<script language='javascript'> { alert('You can not delete: the image will not be deleted');}</script>"); } } db.SubmitChanges(); } }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int id = (int)e.Keys[0]; using (var db = drvvv.drvvvSettings.GetDataContextInstance()) { var cBusinesses = db.Businesses.SingleOrDefault(x => x.ID == id); if (!string.IsNullOrEmpty(cBusinesses.ImgName)) { if (!drvvv.GetFile.DeleteFile(cBusinesses.ImgName)) RegisterStartupScript("alert", "<script language='javascript'> { alert('You can not delete: the image will not be deleted');}</script>"); } foreach (var x in cBusinesses.Discounts) drvvv.GetFile.DeleteFile(x.ImgName); db.Discounts.DeleteAllOnSubmit(cBusinesses.Discounts); db.SubmitChanges(); } }
protected void dtgv_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { }
protected void DetailsView1_ItemDeleting( object sender, DetailsViewDeleteEventArgs e) { e.Values["UnitPrice"] = e.Values["UnitPrice"].ToString().Substring(1); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { int id = (int)e.Keys[0]; using (var db = drvvv.drvvvSettings.GetDataContextInstance()) { var cBusinesses = db.CouponsSites.SingleOrDefault(x => x.ID == id); if (cBusinesses.Coupons.Count() > 0) { e.Cancel = true; RegisterStartupScript("alert", "<script language='javascript'> { alert('No file selected');}</script>"); } else { if (!string.IsNullOrEmpty(cBusinesses.ImageName)) { if (!drvvv.GetFile.DeleteFile(cBusinesses.ImageName)) RegisterStartupScript("alert", "<script language='javascript'> { alert('You can not delete, there are related content');}</script>"); } //foreach (var x in cBusinesses.Discounts) // drvvv.GetFile.DeleteFile(x.ImgName); //db.Discounts.DeleteAllOnSubmit(cBusinesses.Discounts); //db.SubmitChanges(); } } }
protected void ItemDetails_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { DBHelper.Update("Items", new Dictionary<string, object>(){ { "UPC", ItemDetails.SelectedValue }, { "Enabled", false } }); e.Cancel = true; SetDS(null); this.MainMV.SetActiveView(this.ItemGridView); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { GridView1.DataBind(); }
protected void DetailsView1_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { //e.Cancel = !DeleteItem((int)e.Keys[0]);//TODO:לוגיקת מחיקה }
protected void DetailsView_Route_has_Bus_ItemDeleting(object sender, DetailsViewDeleteEventArgs e) { String Route_has_Bus_ID = DetailsView_Route_has_Bus.SelectedValue.ToString(); delete_seat(Route_has_Bus_ID); }