protected void Button2_Click(object sender, EventArgs e)
{
ProductService.IproductsClient client = new ProductService.IproductsClient();
ProductService.Product p = new ProductService.Product();
string t1 = TextBox1.Text;
string t2 = TextBox2.Text;
string t3 = TextBox3.Text;
string t4 = TextBox4.Text;
string t5 = TextBox5.Text;
if (t1 == "" || (t2 == "" || (t3 == "" || (t4 == "" || t5 == ""))))
{
Label1.Text = "Please fill All details!!";
Label1.BackColor = System.Drawing.Color.Red;
}
else
{
p.ProductId = Convert.ToInt32(t1);
p.ProductName = t2;
p.ProductPrice = Convert.ToInt32(t3);
p.Quantity = Convert.ToInt32(t4);
p.Description = t5;
client.UpdateProductDetails(p);
Label1.Text = "Product Updated!!";
Label1.BackColor = System.Drawing.Color.Green;
}
}
protected void Button6_Click(object sender, EventArgs e)
{
ProductService.IproductsClient client = new ProductService.IproductsClient();
ProductService.Bill b = new ProductService.Bill();
b.date = DateTime.Today;
b.total = total;
int id2 = client.StoreBill(b);
string connetionString;
SqlConnection cnn;
connetionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=ShopDatabase;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
cnn = new SqlConnection(connetionString);
cnn.Open();
foreach (var itm1 in lst1)
{
int p = client.GetProductPrice(itm1.Key);
ProductService.Product p1 = client.GetProduct(itm1.Key);
ProductService.Product p2 = new ProductService.Product();
p2.ProductId = p1.ProductId;
p2.ProductName = p1.ProductName;
p2.ProductPrice = p2.ProductPrice;
p2.Description = p1.Description;
p2.Quantity = itm1.Value;
client.UpdateProductDetails(p2);
var sql = "INSERT INTO History(BillNo,Productid,Price,Quantity,Total) VALUES(@billno,@pid,@pprice,@qun,@tot)";
using (var cmd = new SqlCommand(sql, cnn))
{
cmd.Parameters.AddWithValue("@billno", id2);
cmd.Parameters.AddWithValue("@pid", itm1.Key);
cmd.Parameters.AddWithValue("@pprice", p);
cmd.Parameters.AddWithValue("@qun", itm1.Value);
cmd.Parameters.AddWithValue("@tot", p * itm1.Value);
cmd.ExecuteNonQuery();
}
}
cnn.Close();
Label4.Text = "Wohoo! Purchase is successful!!! and Your Invoice number is:";
Label4.Text += id2.ToString();
total = 0;
Label5.Text = total.ToString();
foreach (ListItem itm3 in ListBox2.Items)
{
ListBox1.Items.Add(itm3);
}
ListBox2.Items.Clear();
lst1.Clear();
}
