protected void Page_Load(object sender, EventArgs e) { //Initializing AJAX.NET Library Ajax.Utility.RegisterTypeForAjax(typeof(CatPriceSchedMaint)); CPSMScriptManager.SetFocus("txtCustNo"); if (!IsPostBack) { SubmitUpdatePanel.Visible = false; ApproveUpdatePanel.Visible = false; ExcelUpdatePanel.Visible = false; ApprovalOKHidden.Value = MaintUtil.GetSecurityCode(Session["UserName"].ToString(), MaintenaceTable.CatPriceSchedMaintApproval); hidShowCostBasis.Value = MaintUtil.GetSecurityCode(Session["UserName"].ToString(), MaintenaceTable.CatPriceSchedMaintSetCost); hidPriceAnalysis.Value = MaintUtil.GetSecurityCode(Session["UserName"].ToString(), MaintenaceTable.PriceAnalysisReportAccess); rdoPackage.Visible = (MaintUtil.GetSecurityCode(Session["UserName"].ToString(), MaintenaceTable.CatPriceSchedulePKGOption) != "" ? true : false); if (ApprovalOKHidden.Value.ToString() != "") { ApprovalOKHidden.Value = "TRUE"; } if (hidShowCostBasis.Value.ToString() != "") { hidShowCostBasis.Value = "TRUE"; } if (hidPriceAnalysis.Value.ToString() != "") { hidPriceAnalysis.Value = "TRUE"; } if ((MaintUtil.GetSecurityCode(Session["UserName"].ToString(), MaintenaceTable.CatPriceSchedMaintAccess) == "") && (ApprovalOKHidden.Value.ToUpper() != "TRUE")) { txtCustNo.Enabled = false; btnSearch.Visible = false; lblErrorMessage.Text = "You do not have sufficient security to access this application."; MessageUpdatePanel.Update(); } if (Request.QueryString["CustNo"] != null && Request.QueryString["CustNo"].ToString() != "") { txtCustNo.Text = Request.QueryString["CustNo"].ToString(); btnSearch_Click(btnSearch, new EventArgs()); } } }
public void ProcessWork(string SuccessText, string source) { try { ProcessError = false; dt = (DataTable)Session["CPSMData"]; dt.DefaultView.RowFilter = hidRowFilter.Value; foreach (DataRow dr in dt.DefaultView.ToTable().Rows) { string _Action = ""; if (CPSMRecTypeHidden.Value.ToString() == "0") { _Action = "I"; } if (CPSMRecTypeHidden.Value.ToString() == "1") { _Action = "U"; } try { if (_Action != "") { ds = SqlHelper.ExecuteDataset(ConnectionString, "pCustPriceWorkUnprocessed", new SqlParameter("@Action", "I"), new SqlParameter("@Branch", dr["Branch"].ToString()), new SqlParameter("@CustomerNo", dr["CustomerNo"].ToString()), new SqlParameter("@CustomerName", dr["CustomerName"].ToString()), new SqlParameter("@GroupType", dr["GroupType"].ToString()), new SqlParameter("@GroupNo", dr["GroupNo"].ToString()), new SqlParameter("@GroupDesc", dr["GroupDesc"].ToString()), new SqlParameter("@BuyGroupNo", dr["BuyGroupNo"].ToString()), new SqlParameter("@BuyGroupDesc", dr["BuyGroupDesc"].ToString()), new SqlParameter("@SalesHistory", dr["SalesHistory"].ToString()), new SqlParameter("@GMPctPriceCost", dr["GMPctPriceCost"].ToString()), new SqlParameter("@GMPctAvgCost", dr["GMPctAvgCost"].ToString()), new SqlParameter("@SalesHistoryTot", dr["SalesHistoryTot"].ToString()), new SqlParameter("@GMPctPriceCostTot", dr["GMPctPriceCostTot"].ToString()), new SqlParameter("@GMPctAvgCostTot", dr["GMPctAvgCostTot"].ToString()), new SqlParameter("@SalesHistoryEComm", dr["SalesHistoryEComm"].ToString()), new SqlParameter("@GMPctPriceCostEComm", dr["GMPctPriceCostEComm"].ToString()), new SqlParameter("@GMPctAvgCostEComm", dr["GMPctAvgCostEComm"].ToString()), new SqlParameter("@SalesHistory12Mo", dr["SalesHistory12Mo"].ToString()), new SqlParameter("@GMPctPriceCost12Mo", dr["GMPctPriceCost12Mo"].ToString()), new SqlParameter("@GMPctAvgCost12Mo", dr["GMPctAvgCost12Mo"].ToString()), new SqlParameter("@TargetGMPct", dr["TargetGMPct"].ToString()), new SqlParameter("@ExistingCustPricePct", dr["ExistingCustPricePct"].ToString()), new SqlParameter("@Approved", dr["Approved"].ToString()), new SqlParameter("@EntryID", Session["UserName"].ToString()), new SqlParameter("@priceMethod", (rdoPackage.Checked == true ? "M" : "G")), new SqlParameter("@GMPctSmthAvgCost", dr["GMPctSmthAvgCost"].ToString()), new SqlParameter("@GMPctReplCost", dr["GMPctReplCost"].ToString()), new SqlParameter("@contractSales", dr["ContractSales"].ToString()), new SqlParameter("@nonContractSales", dr["NonContractSales"].ToString()), new SqlParameter("@contractGMPct", dr["ContractGMPct"].ToString()), new SqlParameter("@nonContractGMPct", dr["NonContractGMPct"].ToString())); } } catch (SqlException ex) { StringBuilder errorMessages = new StringBuilder(); for (int i = 0; i < ex.Errors.Count; i++) { errorMessages.Append("Index #" + i + "\n" + "Message: " + ex.Errors[i].Message + "\n" + "LineNumber: " + ex.Errors[i].LineNumber + "\n" + "Source: " + ex.Errors[i].Source + "\n" + "Procedure: " + ex.Errors[i].Procedure + "\n"); } lblErrorMessage.Text = "pCustPriceWorkUnprocessed Error " + errorMessages.ToString(); MessageUpdatePanel.Update(); ProcessError = true; break; } } if (!ProcessError) { if (source == "submit") { bool result = SendCPMAwaitingApprovalEmail(); } lblErrorMessage.Text = ""; lblSuccessMessage.Text = SuccessText; MessageUpdatePanel.Update(); txtCustNo.Text = ""; ClearDisplay(); CPSMScriptManager.SetFocus("txtCustNo"); CPSMGridView.DataBind(); } } catch (NullReferenceException ex0) { lblErrorMessage.Text = "Null Reference " + ex0.ToString(); MessageUpdatePanel.Update(); } catch (Exception ex1) { lblErrorMessage.Text = ex1.ToString(); MessageUpdatePanel.Update(); } }