protected void btnsave_Click(object sender, EventArgs e)
{
objclb = new ClsBusiness();
objclb.InsertUser(TextBox1.Text, Int32.Parse(TextBox2.Text), TextBox3.Text, TextBox4.Text);
Label3.Text = "Created and saved in Database";
GridView1.DataSource = objclb.SelectUser();
GridView1.DataBind();
}
protected void ddlBusiness_SelectedIndexChanged(object sender, EventArgs e)
{
ddlProject.DataSource = ClsBusiness.spProjectMasterGetDataByBusinessId(Convert.ToString(ddlBusiness.SelectedValue));
ddlProject.DataMember = "ProjectMaster";
ddlProject.DataTextField = "ProjectName";
ddlProject.DataValueField = "ProjectId";
ddlProject.DataBind();
ddlProject.Items.Insert(0, "------Select-------");
}
protected void ddlStore_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlStore.SelectedIndex > 0)
{
ddlBusiness.Items.Clear();
ddlBusiness.DataSource = ClsBusiness.SpBusinessMasterGetData();
//ddlBusiness.DataSource = obj.selectBusinessByCompany(Int32.Parse(Session["Comid"].ToString()));
string k1 = "SELECT BusinessMaster.BusinessID as businessid,BusinessMaster.BusinessName + ' : ' +DepartmentmasterMNC.Departmentname as businessname, BusinessMaster.DepartmentId FROM BusinessMaster inner join DepartmentmasterMNC on DepartmentmasterMNC.id=BusinessMaster.DepartmentId WHERE BusinessMaster.company_id = '" + Session["Comid"] + "' ORDER BY BusinessMaster.BusinessName";
SqlCommand cmd1 = new SqlCommand(k1, con);
SqlDataAdapter adp1 = new SqlDataAdapter(cmd1);
DataTable dte = new DataTable();
adp1.Fill(dte);
ddlBusiness.DataSource = dte;
ddlBusiness.DataMember = "BusinessMaster";
ddlBusiness.DataTextField = "BusinessName";
ddlBusiness.DataValueField = "Businessid";
ddlBusiness.DataBind();
ddlBusiness.Items.Insert(0, "--Select--");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex][0].ToString());
string scon = "Data Source=DESKTOP-DV6JK3I;Initial Catalog=Balaji;User ID=balaji;Password=balaji";
using (SqlConnection con = new SqlConnection(scon))
{
using (SqlCommand cmd = new SqlCommand("DELETE FROM details WHERE ID =@ID"))
{
cmd.Parameters.AddWithValue("@ID", id);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
Label4.Text = "Created and saved in Database";
ClsBusiness objclb1 = new ClsBusiness();
GridView1.DataSource = objclb1.SelectUser();
GridView1.DataBind();
}
