protected void BtnDelete_Click(object sender, EventArgs e) { if (!sec.UserRight("2540", "004")) { Response.Redirect("~/Test.aspx"); } string StrPartsTransLocCode = ""; bool Check = false; TextBox[] textBoxes = { txtAutoPartLocCode, txtAutoPartsSubLocCode, txtPartsTransLocCode }; if (!MasterValidation(textBoxes)) { return; } try { StrPartsTransLocCode = txtAutoPartLocCode.Text + txtAutoPartsSubLocCode.Text + txtPartsTransLocCode.Text; if (SysFunc.CodeExists("ItemStock", "PartsTransLocCode", StrPartsTransLocCode)) { SysFunc.UserMsg(LbErr, Color.Red, "Can not delete location its used in ItemStock", txtPartsTransLocCode); return; } if (SysFunc.CodeExists("ItemStatus", "PartsTransLocCode", StrPartsTransLocCode)) { SysFunc.UserMsg(LbErr, Color.Red, "Can not delete location its used in ItemStatus", txtPartsTransLocCode); return; } if (SysFunc.CodeExists("GRNDetail", "PartsTransLocCode", StrPartsTransLocCode)) { SysFunc.UserMsg(LbErr, Color.Red, "Can not delete location its used in GRNDetail", txtPartsTransLocCode); return; } SqlParameter[] param = { new SqlParameter("@DealerCode", Session["DealerCode"].ToString()), //0 new SqlParameter("@PartsTransLocCode", StrPartsTransLocCode) //1 }; Check = SysFunc.SP_Spare_Delete_PartsTransLocation(param); GVTransLocFill(); txtPartsTransLocCode.Text = string.Empty; txtPartsTransLocDesc.Text = string.Empty; } catch (Exception ex) { SysFunc.UserMsg(LbErr, Color.Red, "Error :" + ex.Message); } }