protected void grdDiscos_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
foreach (DataControlFieldCell cell in grdDiscos.Rows[e.RowIndex].Cells)
{
for (int w = 0; w < USel.Rows.Count; w++)
{
if (USel.Rows[w][0].ToString() == cell.Text)
{
BLSoftware sw = new BLSoftware();
int Srv_Id = 0;
int.TryParse(ddlServidor.SelectedItem.Value, out Srv_Id);
if (Srv_Id > 0)
{
USel.Rows[w].Delete();
USel.AcceptChanges();
ddlUnidad.DataSource = MinusDT(LetrasUnidad(), "SrvD_Unidad", USel, "SrvD_Unidad");
ddlUnidad.DataBind();
sw.BorrarDiscosServidorApp(Srv_Id, cell.Text);
//CargaDiscos(Srv_Id);
Response.Redirect("ModificarDiscos.aspx?Srv=" + Srv_Id.ToString());
}
break;
}
}
}
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string bvin = (string)GridView1.DataKeys[e.RowIndex].Value;
MTApp.OrderServices.ShippingMethods.Delete(bvin);
LoadMethods();
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string u = Session["username"].ToString();
string p = Session["password"].ToString();
var = new DataTable();
SqlDataAdapter vAR = new SqlDataAdapter("select Name from scrum_master1 where Username = '******' and Password = '******' ", con);
vAR.Fill(var);
if (var.Rows.Count == 0)
{
Response.Write("<script>alert('You are not allowed to delete')</script>");
con.Close();
}
else
{
con.Open();
Label idd1 = GridView1.Rows[e.RowIndex].FindControl("idd") as Label;
SqlCommand cmd4 = new SqlCommand(@"delete from sprints where id = '" + Convert.ToInt32(idd1.Text) + "'", con);
cmd4.ExecuteNonQuery();
con.Close();
ShowData();
}
}
protected void dgvSliders_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SliderBL sliderBL = new SliderBL();
int status = sliderBL.DeleteSlider(int.Parse(dgvSliders.DataKeys[e.RowIndex].Values[0].ToString()));
Response.Redirect("/administrator/sliders.aspx");
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
workStation = dataWorkStation.readWorkStationEDIT(id);
dataWorkStation.deleteWorkStation(id, workStation.IdLab);
Response.Redirect("/CRUDWorkStation.aspx");
}
protected void InventoryTable_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
Debug.WriteLine("InventoryTable_RowDeleting");
if (e.Keys.Contains("IdI"))
{
var selectedInventoryId = (int)e.Keys["IdI"];
Debug.WriteLine($"selectedInventoryId = {selectedInventoryId}");
using (var db = new AGRODataContext(Server.MapPath("\\")))
{
var deletingEntity = db.Inventory.FirstOrDefault(i => i.IdI == selectedInventoryId);
if (deletingEntity != null)
{
db.Inventory.DeleteOnSubmit(deletingEntity);
try
{
db.SubmitChanges();
BindGrid();
}
catch (Exception exception)
{
Debug.WriteLine($"Somethig wrong: {exception.Message}");
}
}
}
}
}
protected void ProductsGridView_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string key = (string)ProductsGridView.DataKeys[e.RowIndex].Value;
ProductFile file = MTApp.CatalogServices.ProductFiles.Find((string)ViewState["id"]);
MTApp.CatalogServices.ProductFiles.RemoveAssociatedProduct(file.Bvin, key);
BindProductsGrid();
}
protected void grdGameLists_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string text = this.grdGameLists.DataKeys[e.RowIndex].Value.ToString();
if (!string.IsNullOrEmpty(text))
{
try
{
bool flag = GameHelper.Delete(new int[]
{
int.Parse(text)
});
if (!flag)
{
throw new System.Exception("操作失败！");
}
this.ShowMsg("操作成功！", true);
this.BindData();
}
catch (System.Exception ex)
{
this.ShowMsg(ex.Message, false);
}
}
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
con.Open();
Label Id = GridView1.Rows[e.RowIndex].FindControl("idd") as Label;
SqlCommand retrieve = new SqlCommand("select Name from auth1 where id = '" + Convert.ToInt32(Id.Text) + "'", con);
SqlDataAdapter dta = new SqlDataAdapter();
DataTable dtretrive = new DataTable();
dta.SelectCommand = retrieve;
dta.SelectCommand.Connection = con;
dta.Fill(dtretrive);
if (dtretrive.Rows.Count > 0)
{
string del = dtretrive.Rows[0][0].ToString();
SqlCommand cmdx = new SqlCommand("delete from scrum_master1 where Name = '" + del + "'", con);
cmdx.ExecuteNonQuery();
}
SqlCommand cmd4 = new SqlCommand(@"delete from auth1 where id = '" + Convert.ToInt32(Id.Text) + "'", con);
cmd4.ExecuteNonQuery();
con.Close();
ShowData();
}
private void grdProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
if (!this.order.CheckAction(OrderActions.SELLER_MODIFY_TRADE))
{
this.ShowMsg("你当前订单的状态不能进行修改订单费用操作", false);
}
else
{
if (this.order.LineItems.Values.Count <= 1)
{
this.ShowMsg("订单的最后一件商品不允许删除", false);
}
else
{
if (OrderHelper.DeleteLineItem(this.grdProducts.DataKeys[e.RowIndex].Value.ToString(), this.order))
{
this.order = OrderHelper.GetOrderInfo(this.orderId);
this.BindProductList(this.order);
this.BindTatolAmount(this.order);
this.ShowMsg("成功删除了一件商品", true);
}
else
{
this.ShowMsg("删除商品失败", false);
}
}
}
}
private void grdSuggestProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
if (ProductHelper.RemoveSuggestProduct((int)this.grdSuggestProducts.DataKeys[e.RowIndex].Value, ClientType.PC))
{
base.Response.Redirect(System.Web.HttpContext.Current.Request.Url.ToString(), true);
}
}
protected void m_grid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
//int id = e.RowIndex;
//m_grid.EditIndex = id;
//Guid delId = new Guid(m_grid.DataKeys[e.RowIndex].Value.ToString());
//if (m_grid.DataKeys[e.RowIndex].Value.ToString() != "")
//{
// clsKho objKho = new clsKho();
// objKho.Kho_Id = m_grid.DataKeys[e.RowIndex].Value.ToString();
// int status_Delete = objKho.Delete();
// if (status_Delete == 1)
// {
// }
// if (status_Delete <= 0)
// {
// }
//}
}
catch (Exception ex)
{
}
bindData(-1);
}
protected void m_grid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = e.RowIndex;
m_grid.EditIndex = id;
Guid delId = new Guid(m_grid.DataKeys[e.RowIndex].Value.ToString());
if (m_grid.DataKeys[e.RowIndex].Value.ToString() != "")
{
clsThanhPhamChiTiet objThanhPhamChiTiet = new clsThanhPhamChiTiet();
objThanhPhamChiTiet.ThanhPhamChiTiet_Id = m_grid.DataKeys[e.RowIndex].Value.ToString();
int status_Delete = objThanhPhamChiTiet.Delete();
if (status_Delete == 1)
{
ltlAnnouncement.Text = "Xóa thành công thành phẩm chi tiết!";
}
if (status_Delete <= 0)
{
ltlAnnouncement.Text = "Không xóa được thành phẩm chi tiết đã chọn.";
}
}
}
catch (Exception ex)
{
ltlAnnouncement.Text = "Lỗi trong quá trình xóa nhóm người dùng: " + ex.ToString();
}
bindData(-1);
}
protected void grDS_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int madv = int.Parse(grDS.DataKeys[e.RowIndex].Value.ToString());
dv.XoaDonVi(madv);
int ma = int.Parse(drNBH.SelectedValue);
loadDS(ma);
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
//Store which row was clicked
Int32 selectedRow = e.RowIndex;
//get the selected sudent ID using the grids data key collection
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[selectedRow].Values["StudentID"]);
//use entity to find the object and remove it
using (GetWreckedEntities db = new GetWreckedEntities())
{
Student s = (from objs in db.Students where objs.StudentID == StudentID select objs).FirstOrDefault();
//now we need to do the delete
db.Students.Remove(s);
db.SaveChanges();
}
//refresh the grid
getStudents();
}
catch (System.Exception)
{
Response.Redirect("/Error.aspx");
}
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//store which row was clicked
Int32 selectedRow = e.RowIndex;
//get the selected StudentID using the grid's Data Key collection
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[selectedRow].Values["StudentID"]);
//use EF to remove the selected student from the db
try
{
using (comp2007Entities db = new comp2007Entities())
{
Student s = (from objS in db.Students
where objS.StudentID == StudentID
select objS).FirstOrDefault();
//do the delete
db.Students.Remove(s);
db.SaveChanges();
}
//refresh the grid
GetStudents();
}
catch(Exception ep)
{
Response.Redirect("~/ErrorPage.aspx?handler=Application_Error%20-%20Global.asax");
}
}
protected void grdOrders_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
//connect
using (sales db = new sales())
{
//get order id from grid
Int32 orderID = Convert.ToInt32(grdOrders.DataKeys[e.RowIndex].Values["orderID"]);
//find order
var order = (from o in db.Orders
where o.orderID == orderID
select o).FirstOrDefault();
//delete it
db.Orders.Remove(order);
db.SaveChanges();
//reload
getOrders();
}
}
catch (Exception ex)
{
Response.Redirect("/error.aspx");
}
}
protected void gvReviews_RowDeleting(Object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
//get clicked row index from gridview
int rowIndex = e.RowIndex;
//get the review id of row clicked
string reviewID = gvReviews.Rows[rowIndex].Cells[ID_COL].Text;
string restaurantName = gvReviews.Rows[rowIndex].Cells[RESTAURANT_NAME_COL].Text;
//perform delete from database
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "DeleteReview";
objCommand.Parameters.AddWithValue("@reviewID", Int32.Parse(reviewID));
if (objDB.DoUpdateUsingCmdObj(objCommand) != -1)
{
lblDisplay.Text = "Successfully Deleted Review";
}
updateAverageRatings(restaurantName);
//show new gridview with changes
populateReviews();
}
protected void gvAssurance_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
setAssurancedelete = e.Keys[0].ToString();
mdlpopupmsg.Show();
}
private void grdConfigedItems_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string openIdType = this.grdConfigedItems.DataKeys[e.RowIndex]["FullName"].ToString();
SubSiteOpenIdHelper.DeleteSettings(openIdType);
this.BindData();
}
protected void GrdCamera_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//int selectedRow = e.RowIndex;
//Label FacilityID = (Label)grdCamera.Rows[selectedRow].FindControl("cameraID1");
//string facilityID = FacilityID.Text;
// BindGridView();
}
protected void grdActivities_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
using (DefaultConnectionAL conn = new DefaultConnectionAL())
{
var user = HttpContext.Current.GetOwinContext().Authentication.User.Identity.GetUserId();
Int32 ActivityID = Convert.ToInt32(grdActivities.DataKeys[e.RowIndex].Values["id"]);
var activityItem = (from a in conn.activities
where a.id == ActivityID
select a).FirstOrDefault();
//save
conn.activities.Remove(activityItem);
conn.SaveChanges();
//redirect to updated departments page
GetActivities();
}
}
catch (Exception e2)
{
Response.Redirect("~/error.aspx");
}
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get the Department Id
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[e.RowIndex].Values["StudentID"]);
var s = (from stud in conn.Students
where stud.StudentID == StudentID
select stud).FirstOrDefault();
//process the delete
conn.Students.Remove(s);
conn.SaveChanges();
//update the grid
GetStudents();
}
}
catch (System.IO.IOException e2)
{
Server.Transfer("/error.aspx", true);
}
}
protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
//connect
using (DefaultConnectionEF conn = new DefaultConnectionEF())
{
//get the selected DepartmentID
Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[e.RowIndex].Values["DepartmentID"]);
var d = (from dep in conn.Departments
where dep.DepartmentID == DepartmentID
select dep).FirstOrDefault();
//process the delete
conn.Departments.Remove(d);
conn.SaveChanges();
//update the grid
GetDepartments();
}
}
catch (System.Data.Entity.Core.EntityCommandExecutionException ECEE)
{
Server.Transfer("/ErrorPage.aspx", true);
}
catch (System.Data.SqlClient.SqlException SqlE)
{
Server.Transfer("/ErrorPage.aspx", true);
}
}
protected void grdDatos_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
ProcesarUSel();
foreach (DataControlFieldCell cell in grdDatos.Rows[e.RowIndex].Cells)
{
for (int w = 0; w < USel.Rows.Count; w++)
{
if (USel.Rows[w][0].ToString() == cell.Text)
{
BLCatalogos objCatalogo = new BLCatalogos();
USel.Rows[w].Delete();
USel.AcceptChanges();
ddlBD.DataSource = MinusDT(objCatalogo.ListaBDConServerInstanciaRel(), "AppBD_Id", USel, "AppBD_Id");
ddlBD.DataBind();
grdDatos.DataSource = USel;
grdDatos.DataBind();
break;
}
}
}
}
private void grdTopicProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
if (StoreManagementHelper.RemoveReleatesProductByStore(this.StoreId, (int)this.grdTopicProducts.DataKeys[e.RowIndex].Value))
{
base.Response.Redirect(System.Web.HttpContext.Current.Request.Url.ToString(), true);
}
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
Label lbl_ID = (Label)GridView1.Rows[e.RowIndex].FindControl("lblID");
con.Open();
string cmdstr = "delete from book where id=@Id";
SqlCommand cmd = new SqlCommand(cmdstr, con);
cmd.Parameters.AddWithValue("@Id", lbl_ID.Text);
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 1)
{
//Adding book back to stock
lblMesage.Visible = true;
lblMesage.CssClass = "alert alert-success";
lblMesage.Text = "Old Books more than 1 years deleted!";
}
else
{
//Error notification
lblMesage.Visible = true;
lblMesage.CssClass = "alert alert-danger";
lblMesage.Text = "Sorry! Couldn't delete old books";
}
con.Close();
gvbind();
}
protected void gvUnvanlar_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
GridView gridView = sender as GridView;
var unvanId = Convert.ToInt32(gridView.DataKeys[e.RowIndex].Values["UnvanId"]);
using (SqlConnection dbConnection = new SqlConnection(_connString))
{
dbConnection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = dbConnection;
command.CommandText = "DELETE FROM Unvan WHERE UnvanId = @UnvanId";
command.Parameters.AddWithValue("@UnvanId", unvanId);
try
{
command.ExecuteNonQuery();
Session.Add("UNVANSILINDI", "Unvan silindi.");
}
catch (SqlException ex)
{
if (ex.Message.Contains("FK_"))
{
string error = "alert('Unvan Personel tablosu tarafından kullanıldığı için silinemez.');";
if (!Page.ClientScript.IsStartupScriptRegistered("ErrorUnvan"))
{
ClientScript.RegisterStartupScript(GetType(), "ErrorUnvan", error, true);
return;
}
}
}
Response.Redirect("Unvan.aspx");
}
}
}
private void grdPromotionProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
if (SubsitePromoteHelper.DeletePromotionProducts(this.activityId, new int?((int)this.grdPromotionProducts.DataKeys[e.RowIndex].Value)))
{
base.Response.Redirect(System.Web.HttpContext.Current.Request.Url.ToString(), true);
}
}
protected void gvCustomFees_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (this.Request["x"] != null && this.Request["y"] != null)
{
gvCustomFees.EditIndex = -1;
RefreshFeeGrid();
}
else
{
int customFeeId = (int)gvCustomFees.DataKeys[e.RowIndex].Value;
var fee = new CustomFee(customFeeId);
var response = InvoicingService.RemoveCustomFee(fee);
if (response.IsSuccessful)
{
gvCustomFees.EditIndex = -1;
RefreshFeeGrid();
UserMessage.SetSuccess("Custom Fee deleted.");
}
else
{
UserMessage.SetFailure(response.Message);
}
}
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//get the selected studentID using the grid's data key collection
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[e.RowIndex].Values["StudentID"]);
try
{
//use Entity Framework to remove the selected student from the db
using (comp2007Entities db = new comp2007Entities())
{
Student s = (from objS in db.Students
where objS.StudentID == StudentID
select objS).FirstOrDefault();
//do the delete
db.Students.Remove(s);
db.SaveChanges();
}
}
catch (Exception)
{
Server.Transfer("/error.aspx");
}
//refresh the grid
GetStudents();
}
private void grdMemberList_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
int num = (int)this.grdMemberList.DataKeys[e.RowIndex].Value;
base.Response.Write(num);
base.Response.End();
ManagerHelper.CheckPrivilege(Privilege.DeleteMember);
if (!MemberHelper.Delete(num))
{
this.ShowMsg("未知错误", false);
return;
}
try
{
this.myNotifier.updateAction = UpdateAction.MemberUpdate;
this.myNotifier.actionDesc = "删除会员";
this.myNotifier.RecDateUpdate = System.DateTime.Today;
this.myNotifier.DataUpdated += new StatisticNotifier.DataUpdatedEventHandler(this.myEvent.Update);
this.myNotifier.UpdateDB();
}
catch (System.Exception)
{
}
this.BindData();
this.ShowMsg("成功删除了选择的会员", true);
}
protected void grdCourses_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//get selected course ID
Int32 CourseID = Convert.ToInt32(grdCourses.DataKeys[e.RowIndex].Values["CourseID"]);
try
{
using (comp2007Entities db = new comp2007Entities())
{
//get selected course
Course objC = (from c in db.Courses
where c.CourseID == CourseID
select c).FirstOrDefault();
//delete
db.Courses.Remove(objC);
db.SaveChanges();
//refresh grid
GetCourses();
}
}
catch (Exception q)
{
Response.Redirect("~/error.aspx");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SqlConnection con = new SqlConnection(connectionString);
con.Open();
int a = e.RowIndex;
GridViewRow r = GridView1.Rows[a];
string x = r.Cells[1].Text;
string q = "SELECT UsuarioId FROM Usuarios WHERE UsuarioNombre='"+x+"'";
SqlDataAdapter adp = new SqlDataAdapter(q, con);
DataTable tb = new DataTable();
adp.Fill(tb);
string id="";
foreach (DataRow row in tb.Rows)
{
id = row[0].ToString();
}
q = "DELETE RolesXUsuario WHERE UsuarioId='" + id + "'";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
con.Close();
}
private void grdHomeProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
if (VShopHelper.RemoveHomeTopic((int)this.grdHomeTopics.DataKeys[e.RowIndex].Value))
{
base.Response.Redirect(System.Web.HttpContext.Current.Request.Url.ToString(), true);
}
}
private void GvSearchOrder_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
GridViewRow row = gvSearchOrder.Rows[e.RowIndex];
DtSearchOrder.Rows[row.DataItemIndex].Delete();
gvSearchOrder.DataBind();
}
private void grdHotKeywords_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
int hid = (int)this.grdHotKeywords.DataKeys[e.RowIndex].Value;
StoreHelper.DeleteHotKeywords(hid);
this.BindData();
}
protected void RepeaterTests_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
new BLL.TestComponents().DeleteTest(Tests[e.RowIndex]);
Tests = new BLL.TestComponents().GetTests();
RepeaterTests.DataSource = Tests;
DataBind();
}
protected void grdContact_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(commentsGrid.DataKeys[e.RowIndex].Values[0].ToString());
var comment = new Comment(id);
comment.Delete();
FillGrid();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
lblMensaje.Text = String.Empty;
int intFolioSolicitud = (int)GridView1.DataKeys[e.RowIndex].Values[0];
GridViewRow Fila = GridView1.Rows[e.RowIndex];
NegDetalleSolicitud DetalleSolicitud = new NegDetalleSolicitud();
int EstaTomada = DetalleSolicitud.SolicitudTomada(intFolioSolicitud);
if (EstaTomada.Equals(0))
{
lblMensaje.Text = "La Solicitud con Folio " + intFolioSolicitud +" ya se esta ejecutando o se resolvio. No se puede anular";
return;
}
NegSolicitud NegAnulaSolicitud = new NegSolicitud();
int existe = NegAnulaSolicitud.EstaAnulado(intFolioSolicitud);
if (existe.Equals(0))
{
int id = NegAnulaSolicitud.AnulaSolicitud(intFolioSolicitud);
lee_grilla(StrRutAlumno);
}
else
{
lblMensaje.Text = "La Solicitud con Folio " + intFolioSolicitud +" ya se encuentra Anulada";
return;
}
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// identify the department id to be deleted from the row the user selected
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[e.RowIndex].Values["StudentID"]);
try
{
//connect
using (DefaultConnection db = new DefaultConnection())
{
Student stud = (from s in db.Students
where s.StudentID == StudentID
select s).FirstOrDefault();
// delete
db.Students.Remove(stud);
db.SaveChanges();
//refresh the grid
GetStudents();
}
}
catch
{
Response.Redirect("~/error.aspx");
}
}
protected void grdCourses_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Int32 CourseID = Convert.ToInt32(grdCourses.DataKeys[e.RowIndex].Values["CourseID"]);
using (comp2007Entities db = new comp2007Entities())
{
// Check for any enrollments in the course to be deleted, and remove them. Otherwise, it'll
// throw a foreign key exception
foreach (Enrollment en in db.Enrollments)
{
if (en.CourseID == CourseID)
{
db.Enrollments.Remove(en);
}
}
// Find the selected course
Course c = (from objS in db.Courses
where objS.CourseID == CourseID
select objS).FirstOrDefault(); // Using First would get an error if no data comes back, FirstOrDefault won't throw an error
// Do the delete
db.Courses.Remove(c);
db.SaveChanges();
//Refresh the data on the page
GetDepartment();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
objdept.ID = Convert.ToInt32(this.GridView1.DataKeys[e.RowIndex].Value);
DataTable dtDept = dept.SelectDepartmentByID(objdept);
employee emp = new employee();
MEmployee objemp = new MEmployee();
objemp.Dept = dtDept.Rows[0]["name"].ToString();
DataTable dtEmp = emp.SelectEmployeeByDept(objemp);
if (dtEmp.Rows.Count > 0)
{
string myscript = @"alert('此部门内尚有员工，不能删除！');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "myscript", myscript, true);
}
else
{
dept.DeleteDepartmentByID(objdept);
}
GridView1.DataSource = dept.SelectAllDepartment();
GridView1.DataBind();
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + ex.Message + "');</script>");
}
}
private void grdHomeProducts_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (VShopHelper.RemoveHomeTopic((int) this.grdHomeTopics.DataKeys[e.RowIndex].Value))
{
base.Response.Redirect(HttpContext.Current.Request.Url.ToString(), true);
}
}
protected void gvCart_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
List<CartItem> cart = (List<CartItem>)Session["cart"];
cart.RemoveAt(e.RowIndex);
ShowCart();
}
protected void gvBooks_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = gvBooks.Rows[e.RowIndex];
TextBox txtDelete=(TextBox)row.Cells[0].Controls[0];
BookOperation.DeleteBook(txtDelete.Text);
gvBind();
}
protected void grvUser_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(grvUser.DataKeys[e.RowIndex].Value);
CustormerImpl.Instance.Delete(id);
BindGrid();
}
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//store which row was clicked
Int32 selectedRow = e.RowIndex;
//get the selected StudentID using the grid's Data Key collection
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[selectedRow].Values["StudentID"]);
try
{
//use EF to remove the selected student from the db
using (DefaultConnectionEF db = new DefaultConnectionEF())
{
Student s = (from objS in db.Students
where objS.StudentID == StudentID
select objS).FirstOrDefault();
//do the delete
db.Students.Remove(s);
db.SaveChanges();
}
}
catch (System.Data.SqlClient.SqlException e1)
{
Server.Transfer("/error.aspx", true);
}
catch (System.Data.Entity.Core.EntityException e1)
{
Server.Transfer("/error.aspx", true);
}
//refresh the grid
GetStudents();
}
protected void grdContractors_RowDeleting(object sender, GridViewDeleteEventArgs g)
{
try
{
//Store which row was clicked
Int32 selectedRow = g.RowIndex;
//get the selected sudent ID using the grids data key collection
Int32 ContractorID = Convert.ToInt32(grdContractors.DataKeys[selectedRow].Values["ContractorID"]);
//use entity to find the object and remove it
using (ErmagerdEntities db = new ErmagerdEntities())
{
Contractor j = (from objs in db.Contractors where objs.ContractorID == ContractorID select objs).FirstOrDefault();
//now we need to do the delete
db.Contractors.Remove(j);
db.SaveChanges();
}
//refresh the grid
getContractors();
}
catch (FileNotFoundException e)
{
Server.Transfer("/ErrorPage.aspx", true);
}
catch (System.IO.IOException e)
{
Server.Transfer("/ErrorPage.aspx", true);
}
catch(Exception e)
{
Server.Transfer("/ErrorPage.aspx", true);
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if ((sender as GridView).Rows.Count > 1)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0].ToString());
var delTest = from test in _eJDataContext.Tests.ToList()
where test.Id == id
select test;
_eJDataContext.Tests.DeleteOnSubmit(delTest.First());
try
{
_eJDataContext.SubmitChanges();
}
catch
{
_eJDataContext.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
{
try
{
_eJDataContext.SubmitChanges();
}
catch (Exception exept)
{
Console.WriteLine("Error: " + exept);
}
}
}
FillCustomerInGrid();
}
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
//this.GridView1.Columns[2].Visible = false;
conn.Open();
Label l1 = GridView1.Rows[e.RowIndex].FindControl("lbl_ID") as Label;
SqlCommand cmd = new SqlCommand("delete from tbl_medicines where MedID=@id", conn);
// cmd.CommandText = "delete from tbl_Pharmacy where PharmacyID=@id";
cmd.Parameters.AddWithValue("@id", l1.Text);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("delete from tbl_MedicinesDetails where MedID=@id", conn);
// cmd.CommandText = "delete from tbl_Pharmacy where PharmacyID=@id";
cmd1.Parameters.AddWithValue("@id", l1.Text);
cmd1.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("delete from tbl_MedicinesDate where MedID=@id", conn);
// cmd.CommandText = "delete from tbl_Pharmacy where PharmacyID=@id";
cmd2.Parameters.AddWithValue("@id", l1.Text);
cmd2.ExecuteNonQuery();
conn.Close();
ShowData();
}
protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//identify the DepartmentID to be deleted from the row the user selected
Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[e.RowIndex].Values["DepartmentID"]);
try
{
//connect
using (DefaultConnection db = new DefaultConnection())
{
Department dep = (from d in db.Departments
where d.DepartmentID == DepartmentID
select d).FirstOrDefault();
//delete
db.Departments.Remove(dep);
db.SaveChanges();
//refresh grid
GetDepartments();
}
}
catch (Exception ex)
{
Response.Redirect("error.aspx");
}
}
private void grdProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
if (ProductHelper.RemoveProduct(this.grdProducts.DataKeys[e.RowIndex].Value.ToString()) > 0)
{
this.ShowMsg("删除商品成功", true);
this.ReloadProductOnSales(false);
}
}
private void grdProducts_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string productIds = this.grdProducts.DataKeys[e.RowIndex].Value.ToString();
ProductHelper.DeleteProduct(productIds, true);
this.ShowMsg("删除商品成功", true);
this.BindProducts();
}
private void grdExpresscomputors_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string text = (string)this.grdExpresscomputors.DataKeys[e.RowIndex].Value;
ExpressHelper.DeleteExpress(text);
this.ShowMsg("删除物流公司" + text + "成功", true);
this.LoadDataSource();
}
protected void gvwSetObjectives_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(delegate()
{
tblObjectives.Rows.RemoveAt(e.RowIndex);
Refresh_Objectives_grid();
});
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
this.msg.ClearMessage();
string bvin = string.Empty;
bvin = ((GridView)sender).DataKeys[e.RowIndex].Value.ToString();
MTApp.ContentServices.Policies.DeleteBlock(bvin);
LoadPolicy();
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string bvin = string.Empty;
//this.GridView1.UpdateAfterCallBack = true;
bvin = ((GridView)sender).DataKeys[e.RowIndex].Value.ToString();
MyPage.MTApp.ContentServices.Columns.DeleteBlock(bvin);
LoadColumn();
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
int maHoaDon = int.Parse(((Label)row.FindControl("maHoaDon")).Text);
PhieuHd del = PhieuHd_BUS.GetAll().Where(m => m.MaPhieuHd == maHoaDon).FirstOrDefault();
PhieuHd_BUS.Delete(del);
this.BindGrid();
}
protected void GridView1_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
Label idd1 = GridView1.Rows[e.RowIndex].FindControl("idd") as Label;
SqlCommand cmd4 = new SqlCommand(@"delete from sprints where id = '" + Convert.ToInt32(idd1.Text) + "'", con);
cmd4.ExecuteNonQuery();
con.Close();
ShowData();
}
