public void SortDetailGrid(Object sender, GridViewSortEventArgs e)
{
try
{
if (hidSort.Attributes["sortType"] != null)
{
if (hidSort.Attributes["sortType"].ToString() == "ASC")
{
hidSort.Attributes["sortType"] = "DESC";
}
else
{
hidSort.Attributes["sortType"] = "ASC";
}
}
else
{
hidSort.Attributes.Add("sortType", "DESC");
}
hidSort.Value = e.SortExpression + " " + hidSort.Attributes["sortType"].ToString();
dt = (DataTable)Session["CPSMData"];
DataView dv = new DataView(dt, hidRowFilter.Value.ToString(), hidSort.Value.ToString(), DataViewRowState.CurrentRows);
CPSMGridView.DataSource = dv;
CPSMGridView.DataBind();
DetailGridPanel.Height = new Unit(double.Parse(DetailGridHeightHidden.Value), UnitType.Pixel);
DetailGridPanel.Width = new Unit(double.Parse(DetailGridWidthHidden.Value), UnitType.Pixel);
}
catch (Exception e2)
{
lblErrorMessage.Text = "Sort Error " + e2.Message + ", " + e2.ToString();
MessageUpdatePanel.Update();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
lblErrorMessage.Text = "";
lblSuccessMessage.Text = "";
MessageUpdatePanel.Update();
string Track = "Timer" + DateTime.Now.ToString("mm:ss");
if (txtCustNo.Text.Trim().Length == 0)
{
lblErrorMessage.Text = "You must enter a Customer Number.";
MessageUpdatePanel.Update();
}
else
{
try
{
lblErrorMessage.Text = "";
ClearDisplay();
//Get the data using pCustPriceGetHist
Track += "|DataBeg" + DateTime.Now.ToString("mm:ss");
ds = SqlHelper.ExecuteDataset(ConnectionString, "pCustPriceGetHist",
new SqlParameter("@CustNo", txtCustNo.Text.Trim()),
new SqlParameter("@itemType", (rdoBulk.Checked ? "Bulk" : "Package")));
Track += "|DataEnd" + DateTime.Now.ToString("mm:ss");
if (ds.Tables.Count == 2)
{
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
lblCustName.Text = dt.Rows[0]["CustomerName"].ToString();
lblBranch.Text = dt.Rows[0]["Branch"].ToString();
lblRecType.Text = "";
CPSMRecTypeHidden.Value = dt.Rows[0]["RecType"].ToString();
if (CPSMRecTypeHidden.Value.ToString() == "0")
{
lblRecType.Text = "These are New records wating for Targets.";
}
if (CPSMRecTypeHidden.Value.ToString() == "1")
{
lblRecType.Text = "These are Unprocessed waiting for Appproval.";
}
hidSort.Value = "";
hidSort.Attributes["sortType"] = "DESC";
hidRowFilter.Value = "GroupType = 'C'";
// Change Target column header based on item type
CPSMGridView.Columns[7].HeaderText = (rdoBulk.Checked ? "Target" : "Bulk +");
DataView dv = new DataView(dt, hidRowFilter.Value.ToString(), hidSort.Value.ToString(), DataViewRowState.CurrentRows);
CPSMGridView.DataSource = dv;
Session["CPSMData"] = dt;
Track += "|Session" + DateTime.Now.ToString("mm:ss");
CPSMGridView.DataBind();
Track += "|DataBind" + DateTime.Now.ToString("mm:ss");
if (ApprovalOKHidden.Value.ToUpper() == "TRUE")
{
ApproveUpdatePanel.Visible = true;
SubmitUpdatePanel.Visible = false;
}
else
{
ApproveUpdatePanel.Visible = false;
SubmitUpdatePanel.Visible = true;
}
if (hidShowCostBasis.Value == "TRUE")
{
ibtnSetBasis.Visible = true;
}
else
{
ibtnSetBasis.Visible = false;
}
if (hidPriceAnalysis.Value == "TRUE")
{
btnPriceAnalysis.Visible = true;
}
else
{
btnPriceAnalysis.Visible = false
;
}
ExcelUpdatePanel.Visible = true;
SelectorUpdatePanel.Update();
DetailUpdatePanel.Update();
}
else
{
lblErrorMessage.Text = "No Price Schedule Data For Customer " + txtCustNo.Text.Trim();
MessageUpdatePanel.Update();
Session["CPSMData"] = null;
CPSMGridView.DataBind();
}
Track += "|HdrBeg" + DateTime.Now.ToString("mm:ss");
dtSched = ds.Tables[1];
if (dtSched.Rows.Count > 0)
{
if (string.IsNullOrEmpty(lblCustName.Text.ToString()))
{
lblCustName.Text = dtSched.Rows[0]["CustomerName"].ToString();
}
if (string.IsNullOrEmpty(lblBranch.Text.ToString()))
{
lblBranch.Text = dtSched.Rows[0]["Branch"].ToString();
}
lblSched1.Text = dtSched.Rows[0]["ContractSchd1"].ToString();
lblSched2.Text = dtSched.Rows[0]["ContractSchd2"].ToString();
lblSched3.Text = dtSched.Rows[0]["ContractSchd3"].ToString();
lblSched4.Text = dtSched.Rows[0]["ContractSchedule4"].ToString();
lblSched5.Text = dtSched.Rows[0]["ContractSchedule5"].ToString();
lblSched6.Text = dtSched.Rows[0]["ContractSchedule6"].ToString();
lblSched7.Text = dtSched.Rows[0]["ContractSchedule7"].ToString();
lblTargetGross.Text = String.Format("{0:0.0}", dtSched.Rows[0]["TargetGrossMarginPct"]);
lblWebDiscPct.Text = String.Format("{0:0.00}", dtSched.Rows[0]["WebDiscountPct"]);
chkWebDiscInd.Checked = (dtSched.Rows[0]["WebDiscountInd"].ToString().ToUpper().Trim() == "1");
lblCustDefPrice.Text = dtSched.Rows[0]["CustomerDefaultPrice"].ToString();
lblCustPriceInd.Text = dtSched.Rows[0]["CustomerPriceInd"].ToString();
lblCreditInd.Text = dtSched.Rows[0]["CreditInd"].ToString();
lblActGrossMgnPct.Text = dtSched.Rows[0]["ActGrossMgnPct"].ToString();
lblDefaultCostPct.Text = dtSched.Rows[0]["TargetCostPlusPct"].ToString();
}
else
{
lblErrorMessage.Text = "Customer " + txtCustNo.Text.Trim() + " Not On File";
MessageUpdatePanel.Update();
}
Track += "|HdrEnd" + DateTime.Now.ToString("mm:ss");
lblSuccessMessage.Text = Track;
MessageUpdatePanel.Update();
}
}
catch (Exception e3)
{
lblErrorMessage.Text = "pCustPriceGetHist Error " + e3.Message + ", " + e3.ToString();
MessageUpdatePanel.Update();
}
}
}
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();
}
}
