protected void Page_Load(object sender, EventArgs e) { if (!Page.User.Identity.IsAuthenticated) { FormsAuthentication.RedirectToLoginPage(); } if (!IsPostBack) { if (PreviousPage is DefaultScreen ds) { qcs.EmpID = ds.EmpID; qcs.PermID = ds.PermID; } else { Response.Redirect("~/DefaultScreen.aspx"); } QuoteGridView.DataBind(); PrintDetailsView.DataBind(); if (qcs.PermID < 4) { DeleteButton.Visible = true; } QuoteSelectedPanel.Visible = false; } if (QuoteGridView.SelectedIndex > -1) { PrintButton.Visible = true; } Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetExpires(DateTime.Now.AddSeconds(-1)); Response.Cache.SetNoStore(); }
protected void QuoteGridViewSortCommand(object source, GridViewSortEventArgs e) { DataView dv = new DataView((DataTable)Session[HeaderTableName.Value], "", e.SortExpression.ToString(), DataViewRowState.CurrentRows); QuoteGridView.DataSource = dv; QuoteGridView.DataBind(); }
protected void DeleteButton_Click(object sender, EventArgs e) { QuoteDataSource.Delete(); QuoteGridView.DataBind(); QuoteGridView.SelectedIndex = -1; QuoteSelectedPanel.Visible = false; }
protected void ShowQuotesSummary(string CustNo, object QuoteDate) { FilterShowingLabel.Text = string.Format("{0:MM/dd/yyyy}", QuoteDate); ds = ecommQuotes.GetDateSummary(CustNo, string.Format("{0:MM/dd/yyyy}", QuoteDate)); QuoteGridView.DataSource = ds.Tables[0]; QuoteGridView.DataBind(); Session[HeaderTableName.Value] = ds.Tables[0]; }
protected void ClearGrids() { DateGridView.DataBind(); QuoteGridView.DataBind(); FilterShowingLabel.Text = ""; HeaderUpdatePanel.Update(); DetailGridView.DataBind(); QuoteDetailUpdatePanel.Update(); //UpdateButton.Visible = false; //UpdateUpdatePanel.Update(); }
protected void DeleteQuoteButton_Click(object sender, EventArgs e) { if (Page.User.Identity.IsAuthenticated) { QuoteDataSource.Delete(); QuoteGridView.DataBind(); QuoteSelectedPanel.Visible = false; } else { FormsAuthentication.RedirectToLoginPage(); } }
protected void GetQuotes(string CustNo, string FilterField, string FilterValue, string GridToFill) { try { // get the quote data. string FreshQOH = "0"; if (GridToFill == "Detail") { FreshQOH = "1"; } ds = SqlHelper.ExecuteDataset(connectionString, "pSOEGetQuotes", new SqlParameter("@Organization", CustNo), new SqlParameter("@QuoteFilterField", FilterField), new SqlParameter("@QuoteFilterValue", FilterValue), new SqlParameter("@FreshQOH", FreshQOH)); if (ds.Tables.Count >= 1) { dt = ds.Tables[1]; if (dt.Rows.Count == 0) { DateGridView.DataBind(); DetailGridView.DataBind(); QuoteGridView.DataBind(); FilterShowingLabel.Text = ""; } else { if (GridToFill == "Header") { DataTable dtDates = new DataTable(); dtDates.Columns.Add("QuoteDate", typeof(DateTime)); dtDates.Columns.Add("QuoteCount", typeof(int)); int DateCtr = 0; string Lastdate = ""; string Newdate = ""; string LastQuote = ""; string NewQuote = ""; DataRow daterow; CustNameLabel.Text = dt.Rows[0]["CustomerName"].ToString(); Session["MasterTable"] = dt; Lastdate = string.Format("{0:yyyy-MM-dd}", dt.Rows[0]["QuotationDate"]); DateToGet = string.Format("{0:MM/dd/yyyy}", dt.Rows[0]["QuotationDate"]); foreach (DataRow drow in dt.Rows) { Newdate = string.Format("{0:yyyy-MM-dd}", drow["QuotationDate"]); NewQuote = drow["SessionID"].ToString(); if (Newdate != Lastdate) { daterow = dtDates.NewRow(); daterow["QuoteDate"] = Lastdate; daterow["QuoteCount"] = DateCtr; dtDates.Rows.Add(daterow); Lastdate = Newdate; DateCtr = 0; } if (NewQuote != LastQuote) { DateCtr++; LastQuote = NewQuote; } } daterow = dtDates.NewRow(); daterow["QuoteDate"] = Newdate; daterow["QuoteCount"] = DateCtr; dtDates.Rows.Add(daterow); DateGridView.DataSource = dtDates; DateGridView.DataBind(); FillGridView(dt); DetailGridView.DataBind(); } if (GridToFill == "Detail") { DetailGridView.DataSource = dt; DetailGridView.DataBind(); } //QuoteUpdatePanel.Update(); //DataView dv = new DataView(dt, "SubItem = '" + ItemNo + "'", "", DataViewRowState.CurrentRows); //AltAvailLabel.Text = String.Format("{0:#,##0}", dv[0]["AltQOH"]); } } } catch (Exception e2) { ErrorLabel.Text = e2.Message + ", " + e2.ToString(); } }
protected void FillGridView(DataTable Quotes) { DataTable dtQuotes = new DataTable(); try { string filter = ""; switch (SearchColumn.Text) { case "PFCItemNo": case "UserItemNo": if (SearchColumn.Text == "PFCItemNo") { FilterShowingLabel.Text = " PFC Item = " + txtSearchText.Text; filter = "PFCItemNo = '" + txtSearchText.Text + "'"; } else { FilterShowingLabel.Text = " Customer Item = " + txtSearchText.Text; filter = "UserItemNo = '" + txtSearchText.Text + "'"; } DataView dvItems = new DataView(Quotes, filter, "", DataViewRowState.CurrentRows); dtQuotes.Columns.Add("Quote", typeof(string)); dtQuotes.Columns.Add("QuoteDate", typeof(DateTime)); dtQuotes.Columns.Add("QuoteQty", typeof(int)); dtQuotes.Columns.Add("QuotePrice", typeof(decimal)); dtQuotes.Columns.Add("QuoteAmount", typeof(decimal)); dtQuotes.Columns.Add("Status", typeof(string)); for (int i = 0; i < dvItems.Count; i++) { quoterow = dtQuotes.NewRow(); quoterow["Quote"] = dvItems[i]["SessionID"].ToString(); quoterow["QuoteDate"] = dvItems[i]["QuotationDate"]; quoterow["QuoteQty"] = dvItems[i]["RequestQuantity"]; quoterow["QuoteAmount"] = dvItems[i]["TotalPrice"]; quoterow["QuotePrice"] = dvItems[i]["UnitPrice"]; dtQuotes.Rows.Add(quoterow); } ItemGridView.DataSource = dtQuotes; ItemGridView.DataBind(); ItemGridView.Visible = true; QuoteGridView.Visible = false; break; default: FilterShowingLabel.Text = DateToGet; filter = "QuotationDate = #" + FilterShowingLabel.Text + "#"; //filter = "QuotationDate = #03/05/2009#"; DataView dv = new DataView(Quotes, filter, "", DataViewRowState.CurrentRows); dtQuotes.Columns.Add("Quote", typeof(string)); dtQuotes.Columns.Add("QuoteLines", typeof(int)); dtQuotes.Columns.Add("QuoteWeight", typeof(decimal)); dtQuotes.Columns.Add("QuoteAmount", typeof(decimal)); dtQuotes.Columns.Add("Status", typeof(string)); int LineCtr = 0; decimal QuoteAmt = 0; decimal QuoteWght = 0; string LastQuote = ""; string NewQuote = ""; for (int i = 0; i < dv.Count; i++) { NewQuote = dv[i]["SessionID"].ToString(); if (NewQuote != LastQuote) { if (LastQuote != "") { quoterow = dtQuotes.NewRow(); quoterow["Quote"] = LastQuote; quoterow["QuoteLines"] = LineCtr; quoterow["QuoteAmount"] = QuoteAmt; quoterow["QuoteWeight"] = QuoteWght; dtQuotes.Rows.Add(quoterow); LineCtr = 0; QuoteAmt = 0; QuoteWght = 0; } LastQuote = NewQuote; } LineCtr++; QuoteAmt += (decimal)dv[i]["TotalPrice"]; QuoteWght += (decimal)dv[i]["LineWeight"]; } quoterow = dtQuotes.NewRow(); quoterow["Quote"] = LastQuote; quoterow["QuoteLines"] = LineCtr; quoterow["QuoteAmount"] = QuoteAmt; quoterow["QuoteWeight"] = QuoteWght; dtQuotes.Rows.Add(quoterow); QuoteGridView.DataSource = dtQuotes; QuoteGridView.DataBind(); QuoteGridView.Visible = true; ItemGridView.Visible = false; break; } } catch (Exception e2) { ErrorLabel.Text = e2.Message + ", " + e2.ToString(); } }