protected void Button5_Click(object sender, EventArgs e)
{
conn = new MySqlConnection(GetConnectionString());
String cbid = TextBox1.Text;
String stock = TextBox3.Text;
String amt = TextBox2.Text;
String validfrom = TextBox4.Text;
String validto = TextBox5.Text;
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand("Insert into Combopack values ('" + cbid + "'," + stock + "," + amt + ",STR_TO_DATE('" + validfrom + "','%d-%m-%Y'),STR_TO_DATE('" + validto + "','%d-%m-%Y'))", conn);
comm.ExecuteNonQuery();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
int count = 0;
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand("Select count(*) from Combopack", conn);
MySqlDataReader dr = comm.ExecuteReader();
dr.Read();
count = dr.GetInt32(0);
dr.Close();
}
catch (Exception ex)
{ Response.Write(ex.Message); }
finally { conn.Close(); }
count++;
TextBox1.Text = "CB" + count.ToString();
TextBox2.Text = "";
TextBox3.Text = "";
TextBox7.Text = "";
Label9.Text = "0";
Label10.Text = "Rs.";
TextBox3.Text = "10";
GridView1.DataSource = null;
GridView1.DataBind();
ComboProductsList.DataSource = null;
ComboProductsList.DataBind();
RadioButtonList1.ClearSelection();
}
protected void Button3_Click(object sender, EventArgs e)
{
String parameter = RadioButtonList1.SelectedValue.ToString();
String prparam = TextBox7.Text;
String sql = "";
if (parameter.Equals("By Product ID"))
{
sql = "Select Product_ID,CONCAT(Company_Name,' ',Product_Name,' ',Retail_Price) from Current_Store_Products where Product_ID='" + prparam + "' and Stock<>0";
}
if (parameter.Equals("By Product Name"))
{
sql = "Select Product_ID,CONCAT(Company_Name,' ',Product_Name,' ',Retail_Price) from Current_Store_Products where Product_Name like'%" + prparam + "%' and Stock<>0";
}
conn = new MySqlConnection(GetConnectionString());
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand(sql, conn);
MySqlDataReader dr = comm.ExecuteReader();
ComboProductsList.DataSource = dr;
ComboProductsList.DataTextField = "CONCAT(Company_Name,' ',Product_Name,' ',Retail_Price)";
ComboProductsList.DataValueField = "Product_ID";
ComboProductsList.DataBind();
dr.Close();
}
catch (Exception ex)
{ Response.Write("InButton3Click" + ex.Message); }
finally { conn.Close(); }
BulletedList1.DataSource = null;
BulletedList1.DataBind();
}