private void BindPO() { DataTable dtRecord = MRPClass.PO_Table(); POTable.DataSource = dtRecord; POTable.KeyFieldName = "PK"; POTable.DataBind(); }
protected void POTable_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridViewCustomButtonCallbackEventArgs e) { if (Session["CreatorKey"] == null) { Response.RedirectLocation = "default.aspx"; return; } ASPxHiddenField text = POTable.FindHeaderTemplateControl(POTable.Columns[0], "HiddenVal") as ASPxHiddenField; text["hidden_value"] = ""; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string PK = POTable.GetRowValues(POTable.FocusedRowIndex, "PK").ToString(); string query = "SELECT COUNT(*) FROM " + MRPClass.POTableName() + " WHERE CreatorKey = '" + Session["CreatorKey"].ToString() + "' AND PK = '" + PK + "'"; SqlCommand comm = new SqlCommand(query, conn); int result = Convert.ToInt32(comm.ExecuteScalar()); if (result > 0) { if (e.ButtonID == "Edit") { if (POTable.FocusedRowIndex > -1) { Session["PO_PK"] = PK; string docNum = POTable.GetRowValues(POTable.FocusedRowIndex, "MRPNumber").ToString(); string poNumber = POTable.GetRowValues(POTable.FocusedRowIndex, "PONumber").ToString(); Session["MRP_Number"] = docNum; //query if po number already PO //string query_po = "SELECT COUNT(*) FROM[dbo].[tbl_POCreation_Details] WHERE PONumber = '" + poNumber + "'"; //SqlCommand cmd = new SqlCommand(query_po, conn); //int result_po = Convert.ToInt32(cmd.ExecuteScalar()); //MRPClass.PrintString(":" + result_po); //if (result_po > 0) // text["hidden_value"] = "AlreadyPO"; //else Response.RedirectLocation = "mrp_pocreatededit.aspx?PONum=" + poNumber.ToString(); // string query_po = "SELECT COUNT(*) FROM[dbo].[tbl_POCreation_Details] WHERE PONumber = '" + poNumber + "'"; // SqlCommand cmd = new SqlCommand(query_po, conn); // int result_po = Convert.ToInt32(cmd.ExecuteScalar()); // //MRPClass.PrintString(":" + result_po); // if (result_po > 0) // text["hidden_value"] = "AlreadyPO"; // else // Response.RedirectLocation = "mrp_poaddedit.aspx?DocNum=" + docNum.ToString(); } } if (e.ButtonID == "Delete") { if (POTable.FocusedRowIndex > -1) { string delete = "DELETE FROM " + MRPClass.POTableName() + " WHERE [PK] ='" + PK + "'"; SqlCommand cmd = new SqlCommand(delete, conn); cmd.ExecuteNonQuery(); BindPO(); } } } else { text["hidden_value"] = "InvalidCreator"; } }