protected void Page_Load(object sender, EventArgs e)
{
LabelOrderID.Text = Session["OrderID"].ToString();
SqlConnection ProgramFilesCon = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ProgramFilesDB;Data Source=ACER-PC\\SQLEXPRESS");
SqlDataAdapter ProgramFilesAdapter = new SqlDataAdapter();
DataTable ProgramFilesTable = new DataTable();
ProgramFilesCon.Open();
string OrderID = Session["OrderID"].ToString();
string CartID = Session["SessionCartID"].ToString();
if (!IsPostBack)
{
//Repeater
SqlCommand PopulateOSubRepeater = new SqlCommand("select * from Cart c, Orders o, Users u WHERE c.CartID=o.CartID and u.UserID=c.UserID AND o.OrderID='" + OrderID + "'", ProgramFilesCon);
ProgramFilesAdapter.SelectCommand = PopulateOSubRepeater;
ProgramFilesAdapter.Fill(ProgramFilesTable);
ProgramFilesAdapter.Dispose();
PopulateOSubRepeater.Dispose();
ProgramFilesCon.Close();
RepeaterOrderDetails.DataSource = ProgramFilesTable;
RepeaterOrderDetails.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckUserGroup();
SqlConnection ProgramFilesCon = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ProgramFilesDB;Data Source=ACER-PC\\SQLEXPRESS");
SqlDataAdapter ProgramFilesAdapter = new SqlDataAdapter();
DataTable ProgramFilesTable = new DataTable();
ProgramFilesCon.Open();
string OrderID = Request.QueryString["OrderID"].ToString();
string CartID = Request.QueryString["CartID"].ToString();
if (!IsPostBack)
{
//Repeater
SqlCommand PopulateODRepeater = new SqlCommand("select * from Cart c, Orders o, Users u WHERE c.CartID=o.CartID and u.UserID=c.UserID AND o.OrderID='" + OrderID + "'", ProgramFilesCon);
ProgramFilesAdapter.SelectCommand = PopulateODRepeater;
ProgramFilesAdapter.Fill(ProgramFilesTable);
ProgramFilesAdapter.Dispose();
PopulateODRepeater.Dispose();
ProgramFilesCon.Close();
RepeaterOrderDetails.DataSource = ProgramFilesTable;
RepeaterOrderDetails.DataBind();
//Listview
SqlDataAdapter ProgramFilesAdapter2 = new SqlDataAdapter();
DataTable ProgramFilesTable2 = new DataTable();
ProgramFilesCon.Open();
//ListView DataSource
SqlCommand PopulateODListView = new SqlCommand("select * from CartDetail cd, Products p where p.ProductID=cd.ProductID and cd.CartID=" + CartID + "", ProgramFilesCon);
ProgramFilesAdapter2.SelectCommand = PopulateODListView;
ProgramFilesAdapter2.Fill(ProgramFilesTable2);
ProgramFilesAdapter2.Dispose();
PopulateODListView.Dispose();
ListViewCheckout.DataSource = ProgramFilesTable2;
ListViewCheckout.DataBind();
string OrderStatus = ProgramFilesTable.Rows[0]["OrderStatus"].ToString();
switch (OrderStatus)
{
case "Awaiting Payment":
RadioButtonListStatusOption.SelectedIndex = 0;
break;
case "On Process":
RadioButtonListStatusOption.SelectedIndex = 1;
break;
case "Completed":
RadioButtonListStatusOption.SelectedIndex = 2;
break;
}
}
}