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();
}
}
