public void btnSearch_Click(object sender, EventArgs e) { lblMessage.Text = ""; pnlMessage.Update(); ClearCust(); ReleaseLock(); string tableName = "CustomerMaster (NoLock) INNER JOIN CustomerAddress (NoLock) ON pCustMstrID = fCustomerMasterID"; string columnName = "pCustMstrID, CustNo, CustName, AddrLine1, AddrLine2, City, State, PostCd, Country, PhoneNo, FaxPhoneNo, " + "ContractSchd1, ContractSchd2, ContractSchd3, ContractSchedule4, ContractSchedule5, ContractSchedule6, ContractSchedule7, " + "TargetGrossMarginPct, WebDiscountPct, WebDiscountInd, CustomerDefaultPrice, CustomerPriceInd" + ",TargetCostPlusPct"; string whereClause = "CustNo = '" + txtCustomer.Text.ToString() + "' AND (Type = 'P' OR Type = '')"; dtCust = CustContMaint.GetMaintData(tableName, columnName, whereClause); if (dtCust != null && dtCust.Rows.Count > 0) { hidCustId.Value = dtCust.Rows[0]["pCustMstrID"].ToString(); if (hidSecurity.Value.ToString() == "Full") { CheckLock(); if (Session["CustContLock"].ToString() == "L") { ClearCust(); hidCustId.Value = ""; smCustContMaint.SetFocus(txtCustomer); ScriptManager.RegisterClientScriptBlock(pnlCustData, typeof(UpdatePanel), "Script", "alert('Record Locked By " + lockUser.ToString() + "');", true); } else { DispCust(); } } else { DispCust(); } } else { ClearCust(); hidCustId.Value = ""; DisplaStatusMessage("Customer Record Not Found", "fail"); smCustContMaint.SetFocus(txtCustomer); } }