protected void Button1_Click(object sender, EventArgs e)
{
//the code to export excel.
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "utf-8";
string FileName = DateTime.Now + ".xls";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
ItemGridView.AllowPaging = false;
this.BindDate();
ItemGridView.HeaderStyle.BackColor = System.Drawing.Color.White;
ItemGridView.HeaderStyle.Font.Bold = true;
ItemGridView.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
//Populate dummy data
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("ITEMID"), new DataColumn("DSC"), new DataColumn("ACTIVE")
});
dt.Rows.Add("1", "Desc111111111111111111111111111111111", "Active22222222222222222222222222222222222222222222222222222222222222222");
dt.Rows.Add("2", "Desc2", "InActive");
dt.Rows.Add("3", "Desc3", "Active");
dt.Rows.Add("4", "Desc4", "Active");
dt.Rows.Add("5", "Desc6", "InActive");
dt.Rows.Add("6", "Desc9", "InActive");
dt.Rows.Add("7", "Desc9", "InActive");
dt.Rows.Add("8", "Desc9", "InActive");
dt.Rows.Add("89", "Desc9", "InActive");
dt.Rows.Add("9", "Desc9", "InActive");
dt.Rows.Add("1", "Desc9", "InActive"); dt.Rows.Add("6", "Desc9", "InActive");
dt.Rows.Add("67", "Desc9", "InActive");
dt.Rows.Add("60", "Desc9", "InActive");
dt.Rows.Add("64", "Desc9", "InActive");
ItemGridView.DataSource = dt;
ItemGridView.DataBind();
}
public void LoadItem()
{
int Id = Convert.ToInt32(CategoriesDropDownList.SelectedValue);
ItemGridView.DataSource = _ItemRepository.GetAll(Id);
ItemGridView.DataBind();
}
public void BindDate()
{
//Populate dummy data
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("ITEMID"), new DataColumn("DSC"), new DataColumn("ACTIVE")
});
dt.Rows.Add("1", "Desc111111111111111111111111111111111", "Active22222222222222222222222222222222222222222222222222222222222222222");
dt.Rows.Add("2", "Desc2", "InActive");
dt.Rows.Add("3", "Desc3", "Active");
dt.Rows.Add("4", "Desc4", "Active");
dt.Rows.Add("5", "Desc6", "InActive");
dt.Rows.Add("6", "Desc9", "InActive");
dt.Rows.Add("7", "Desc9", "InActive");
dt.Rows.Add("8", "Desc9", "InActive");
dt.Rows.Add("89", "Desc9", "InActive");
dt.Rows.Add("9", "Desc9", "InActive");
dt.Rows.Add("1", "Desc9", "InActive"); dt.Rows.Add("6", "Desc9", "InActive");
dt.Rows.Add("67", "Desc9", "InActive");
dt.Rows.Add("60", "Desc9", "InActive");
dt.Rows.Add("64", "Desc9", "InActive");
ItemGridView.DataSource = dt;
ItemGridView.DataBind();
}
private void RefreshTable()
{
DataSet itemDataSet = itemController.viewAllItems();
ItemGridView.DataSource = itemDataSet;
ItemGridView.DataBind();
}
protected void ItemGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
ItemGridView.PageIndex = e.NewPageIndex;
ArrayList arrayList = new ArrayList();
for (int i = 0; i < 1500; i++)
{
arrayList.Add(new { itemid = i, dsc = i, active = "active" });
}
ItemGridView.DataSource = arrayList;
ItemGridView.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArrayList arrayList = new ArrayList();
for (int i = 0; i < 1500; i++)
{
arrayList.Add(new { itemid = i, dsc = i, active = "active" });
}
ItemGridView.DataSource = arrayList;
ItemGridView.DataBind();
}
}
public void UpdateGridview()
{
try {
UpdateDropdown();
UpdateDropdownCat();
UpdateGridviewJokes();
ItemGridView.DataBind();
}
catch (Exception ex)
{
statusInfo.Text = ex.Message + ex.StackTrace;
}
finally
{
conn.Close(); // SqlDataAdapter closes connextion by itself; but can fail in case of errors
}
}
//protected void BindItemRepeaterITEM()
//{
// sqlConnectionOBJ.ConnectionString = "Data Source=DESKTOP-P0QRTM4;Initial Catalog=DatabaseSystems8490;Integrated Security=True";
// try
// {
// sqlConnectionOBJ.Open();
// sqlCommandOBJ.CommandText = "SELECT * FROM Item";
// sqlCommandOBJ.Connection = sqlConnectionOBJ;
// sqlDataAdapterOBJ.SelectCommand = sqlCommandOBJ;
// sqlDataAdapterOBJ.Fill(dataSetOBJ, "Item");//we are expecting a DataSet/ResultSet back
// if (dataSetOBJ.Tables[0].Rows.Count > 0)//run if there's more than one row in the dataset
// {
// ItemRepeater.DataSource = dataSetOBJ;
// ItemRepeater.DataBind();
// }
// else
// {
// }
// }
// catch (SqlException ex)
// {
// lblMessage.Visible = true;
// lblMessage.Text = "SqlException*** ERROR*** \n " + ex.Message;
// throw;
// }
// finally
// {
// sqlConnectionOBJ.Close();
// sqlConnectionOBJ.Dispose();
// }
//}
protected void BindItemGridViewITEM()
{
sqlConnectionOBJ.ConnectionString = "Data Source=DESKTOP-P0QRTM4;Initial Catalog=DatabaseSystems8490;Integrated Security=True";
try
{
sqlConnectionOBJ.Open();
sqlCommandOBJ.CommandText = "SELECT * FROM Item";
sqlCommandOBJ.Connection = sqlConnectionOBJ;
sqlDataAdapterOBJ.SelectCommand = sqlCommandOBJ;
dataSetOBJ = new DataSet();
sqlDataAdapterOBJ.Fill(dataSetOBJ, "Item"); //we are expecting a DataSet/ResultSet back
if (dataSetOBJ.Tables[0].Rows.Count > 0) //run if there's more than one row in the dataset
{
ItemGridView.DataSource = dataSetOBJ;
ItemGridView.DataBind();
}
else
{
}
}
catch (SqlException ex)
{
lblMessage.Visible = true;
lblMessage.Text = "SqlException*** ERROR*** \n " + ex.Message;
throw;
}
finally
{
sqlConnectionOBJ.Close();
sqlConnectionOBJ.Dispose();
}
}
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();
}
}
private void ItemGridViewDataBind()
{
ItemGridView.DataSource = componentsTable;
ItemGridView.DataBind();
}
