protected void TextBox113_TextChanged(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection(@"Data Source=NIMBUS\SQLEXPRESS;Initial Catalog=soa;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
dataBucket d1 = new dataBucket();
string ins = "select name, category, brand, sellprice, quantity from inventory where id=(" + TextBox113.Text + ");";
SqlCommand com = new SqlCommand(ins, cn);
try
{
cn.Open();
using (SqlDataReader read = com.ExecuteReader())
{
while (read.Read())
{
d1.str[1] = (read["name"].ToString());
d1.str[2] = (read["category"].ToString());
d1.str[3] = (read["brand"].ToString());
d1.str[4] = (read["sellprice"].ToString());
d1.str[5] = (read["quantity"].ToString());
}
}
cn.Close();
}
catch (Exception e123)
{
Response.Write("Error Occured");
}
finally
{
cn.Close();
}
TextBox133.Text = d1.str[1];
TextBox114.Text = d1.str[2];
TextBox115.Text = d1.str[3];
TextBox116.Text = d1.str[4];
int quantity = int.Parse(TextBox117.Text);
if (int.Parse(d1.str[5]) < quantity)
{
Response.Write("<script>alert('Stock not available');</script>");
}
TextBox118.Text = (int.Parse(d1.str[4]) * int.Parse(TextBox117.Text)).ToString();
}
public dataBucket getUserData(float cid)
{
//String[] str = new String[11];
dataBucket d1 = new dataBucket();
string ins = "select CID,CustomerName,Address,AreaName,CityName,StateName,Mobile,PackageName,BillingDate,IsActive from main1 where CID=(" + cid + ");";
SqlCommand com = new SqlCommand(ins, cn);
try
{
cn.Open();
using (SqlDataReader read = com.ExecuteReader())
{
while (read.Read())
{
d1.str[1] = (read["CID"].ToString());
d1.str[2] = (read["CustomerName"].ToString());
d1.str[3] = (read["Address"].ToString());
d1.str[4] = (read["AreaName"].ToString());
d1.str[5] = (read["CityName"].ToString());
d1.str[6] = (read["StateName"].ToString());
d1.str[7] = (read["Mobile"].ToString());
d1.str[8] = (read["PackageName"].ToString());
d1.str[9] = (read["BillingDate"].ToString());
d1.str[10] = (read["IsActive"].ToString());
}
}
cn.Close();
return(d1);
}
finally
{
cn.Close();
}
}
