protected void Button2_Click(object sender, EventArgs e)
{
try
{
string temp = "";
temp = Label6.Text;
con = new SqlDbConnect();
//Inserting information into purchase table
con.SqlQuery("INSERT INTO Purchase_Table (Purchase_Date, Purchase_Price, Purchase_Desc, Cust_ID) VALUES(@Date,@Price,@Desc, @ID)");
con.cmd.Parameters.Add("@Date", DateTime.Today);
con.cmd.Parameters.Add("@Price", float.Parse(TextBox5.Text));
con.cmd.Parameters.Add("@Desc", temp);
con.cmd.Parameters.Add("@ID", this.id);
con.NonQuery();
//resets textboxes incase user wants to purcahse more goods
TextBox1.Text = "";
TextBox2.Text = "";
ListBox1.Items.Clear();
TextBox5.Text = "";
}
catch {
Response.Write("<script>alert('An error has occured')</script>");
}
Response.Write("<script>alert('Your order has been recieved - Thank you')</script>"); //successful request
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null) //if no user session created, revert to login page
{
Response.Redirect("~/Pages/LoginPage.aspx");
}
//load customer ID
con = new SqlDbConnect();
con.SqlQuery("SELECT Customer_ID FROM Cust_Table WHERE Customer_Username= '******'"); //finding the users unique ID
this.id = int.Parse(con.ExecuteScalar().Trim());
LabelDate.Text = this.id.ToString();
}
private void loadUserCB()
{
SqlDbConnect sdc = new SqlDbConnect();
DataSet ds = new DataSet();
sdc.SqlQuery("select * from TUser");
ds = sdc.QueryEx("TUserDS");
UserCB.DataContext = ds;
//Here, the ComboBox just set ItemsSource
//But you haven't set an selected item
//ComboBox won't auto select anything after reset ItemsSource
//Even if you're set it in xaml
string selUserName = UserCB.SelectedItem.ToString(); //this code failed to get the selected item
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Boolean proceed = true;
//if validation is correct then proceed
if (TextBox1.Text == "")
{
Label7.Visible = true;
proceed = false;
}
if (TextBox2.Text == "")
{
Label8.Visible = true;
proceed = false;
}
if (proceed == true)
{
float price = 0;
con = new SqlDbConnect();
//finding item price
con.SqlQuery("SELECT Item_Price FROM Item_Table WHERE Item_ID=" + int.Parse(TextBox1.Text));
price = float.Parse(con.ExecuteScalar().Trim());
//finding item name
con.SqlQuery("SELECT Item_Name FROM Item_Table WHERE Item_ID=" + int.Parse(TextBox1.Text));
this.name = con.ExecuteScalar().Trim();
this.nameArr.Add(this.name);
Label6.Text = Label6.Text + ", " + this.name;
TextBox3.Text = ((float)price * int.Parse(TextBox2.Text)).ToString(); //price of item * quantity
ListBox1.Items.Add(setText(this.name, float.Parse(TextBox3.Text), int.Parse(TextBox2.Text))); //prints the receipt of purchase
float temp = 0;
if (TextBox5.Text == "")
{
TextBox5.Text = temp.ToString();
}
TextBox5.Text = (float.Parse(TextBox3.Text) + float.Parse(TextBox5.Text)).ToString();//calculation for total amount
TextBox1.Text = "";
TextBox2.Text = "";
} //end proceed
} //ends try
catch {
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["User"] == null)
{
Response.Redirect("~/Pages/LoginPage.aspx");//if no session is created, reverts to login page
}
Label1.Text = Session["User"].ToString();
con = new SqlDbConnect();
con.SqlQuery("SELECT Customer_ID FROM Cust_Table WHERE Customer_Username= '******' ");//selects customer ID (FOREIGN KEY) to identify the customers products
this.id = int.Parse(con.ExecuteScalar());
Label2.Text = this.id.ToString();
}
catch { }
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
Boolean proceed = false;
string Email = "";
//validation cell number
//validation email
con = new SqlDbConnect();
con.SqlQuery("SELECT Customer_Email FROM Cust_Table ");//selecting email from customer table for validation
Email = con.ExecuteScalar();
if (TextBox3.Text == Email)
{
Label2.Visible = true;
proceed = false;
}
else
{
Label2.Visible = false;
proceed = true;
}
if (proceed == true)
{
con = new SqlDbConnect();
con.SqlQuery("INSERT INTO Cust_Table (Customer_Name, Customer_Surname, Customer_Email, Customer_Cell, Customer_Username, Customer_Password) VALUES(@NameP,@SurnameP,@EmailP, @CellP,@UserP,@PassP )");
con.cmd.Parameters.Add("@NameP", TextBox1.Text.Trim());
con.cmd.Parameters.Add("@SurnameP", TextBox2.Text.Trim());
con.cmd.Parameters.Add("@EmailP", TextBox3.Text.Trim());
con.cmd.Parameters.Add("@CellP", TextBox4.Text.Trim());
con.cmd.Parameters.Add("@UserP", TextBox5.Text.Trim());
con.cmd.Parameters.Add("@PassP", TextBox6.Text.Trim());
con.NonQuery();
//inserting new details into db
Response.Redirect("~/Pages/LoginPage.aspx");
}
}
catch {
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
con = new SqlDbConnect();
con.SqlQuery("SELECT Customer_Username , Customer_Password FROM Cust_Table WHERE Customer_Username = '******' AND Customer_Password= '******'");
Uname = con.ExecuteScalar();
if (Uname.Equals(TextBox1.Text.Trim()))
{
// Label1.Text = "Found";
Label1.Visible = false;
Session["User"] = TextBox1.Text.Trim();
Response.Redirect("~/Pages/Home.aspx");
}
}
catch {
Label1.Visible = true;
}
}
