protected void btnaddproduct_Click(object sender, EventArgs e)
{
try
{
string qry1 = "Select * from Productdata where productname ='" + txtproductname.Text + "'";
if (ExecuteQuery(qry1) == false)
{
if (txtproductname.Text != "" && txtproductqty.Text != "")
{
string str;
str = "Insert into Productdata values ('" + Session["dealerid"].ToString() + "','" + txtproductname.Text + "','" + txtproductqty.Text + "')";
Global_c.Runquery(str);
txtproductname.Text = "";
txtproductqty.Text = "";
txtproductname.Focus();
}
else
{
Response.Write("<script language=\"javascript\">alert(\"Please Enter Product Name!!\");</Script>");
}
}
else
{
Response.Write("<script language=\"javascript\">alert(\"Please product Quntity!\");</Script>");
}
refreshdata();
}
catch (Exception ex)
{
lblerror.Text = ex.Message;
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
try
{
//here front end is actually getting connected with backend in background
string qry;
if (ddlpost.SelectedItem.ToString() == "User")
{
qry = "insert into regagri values ('" + txtname.Text + "','" + txtage.Text + "','" + ddlgender.Text + "','" + txtpasssword.Text + "','" + txtmailid.Text + "','" + ddlpost.Text + "','" + ddlsque.Text + "','" + txtsans.Text + "','0', '0')";
Global_c.Runquery(qry);
}
if (ddlpost.SelectedItem.ToString() == "Shop Owner")
{
qry = "insert into regagri values ('" + txtname.Text + "','" + txtage.Text + "','" + ddlgender.Text + "','" + txtpasssword.Text + "','" + txtmailid.Text + "','" + ddlpost.Text + "','" + ddlsque.Text + "','" + txtsans.Text + "','" + ddlarea.Text + "', '0')";
Global_c.Runquery(qry);
}
if (ddlpost.SelectedItem.ToString() == "Professional Adviser")
{
qry = "insert into regagri values ('" + txtname.Text + "','" + txtage.Text + "','" + ddlgender.Text + "','" + txtpasssword.Text + "','" + txtmailid.Text + "','" + ddlpost.Text + "','" + ddlsque.Text + "','" + txtsans.Text + "','0', '0')";
Global_c.Runquery(qry);
}
txtname.Text = "";
txtage.Text = "";
txtpasssword.Text = "";
txtmailid.Text = "";
txtsans.Text = "";
Response.Redirect("Waiting_Page.aspx");
}
catch (Exception ex)
{
lblerror.Text = ex.Message;
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if (FileUpload1.PostedFile != null && txtname.Text != "")
{
try
{
string FileName = txtname.Text + ".mp4";
FileUpload1.PostedFile.SaveAs(Server.MapPath("videodatabase/" + FileName));
string CS = ConfigurationManager.ConnectionStrings["cnstr1"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
string filepathvideo = "videodatabase/" + FileName;
string str;
str = "Insert into videodata values ('" + FileName + "','" + filepathvideo + "')";
Global_c.Runquery(str);
BindGrid();
lblMessage.Text = "Your file uploaded successfully";
lblMessage.ForeColor = System.Drawing.Color.Green;
txtname.Text = "";
}
}
catch (Exception)
{
lblMessage.Text = "Your file not uploaded";
lblMessage.ForeColor = System.Drawing.Color.Red;
txtname.Text = "";
}
}
else
{
lblMessage.Text = "Enter Proper Name and select Proepr File";
lblMessage.ForeColor = System.Drawing.Color.Red;
txtname.Focus();
}
}
protected void btndelet_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvrow in GridView1.Rows)
{
CheckBox chck = gvrow.FindControl("CheckBox1") as CheckBox;
if (chck.Checked)
{
var Label = gvrow.FindControl("Label1") as Label;
string qry2 = "delete from videodata where videoId= '" + Label.Text + "'";
// SqlCommand cmd = new SqlCommand(qry2, con);
//cmd.Parameters.AddWithValue("Idproduct", int.Parse(Label.Text));
//con.Open();
//int id = cmd.ExecuteNonQuery();
//con.Close();
//refreshdata();
Global_c.Runquery(qry2);
BindGrid();
}
}
}
