protected void btnSubcategoryadd_Click(object sender, EventArgs e)
    {
        int userid = Convert.ToInt16(drpUserList.SelectedValue);
        //first check user exist or not if exist then update else add
        int categoryid    = Convert.ToInt32(drpCategory.SelectedValue);
        int subcateogryid = Convert.ToInt32(drpSubCategory.SelectedValue);

        if (IsUserExist(categoryid, subcateogryid))
        {
            int updated = objCategoryAssignToUser.Update(categoryid, subcateogryid, userid);
            if (updated == 1)
            {
                lblerrmsg.Text = "Technician Updated";
            }
        }
        else
        {
            objCategoryAssignToUser.Categoryid    = categoryid;
            objCategoryAssignToUser.Subcategoryid = subcateogryid;
            objCategoryAssignToUser.Userid        = userid;
            int added = objCategoryAssignToUser.Insert();
            if (added == 1)
            {
                lblerrmsg.Text = "Technician Assigned";
            }
            else
            {
                lblerrmsg.Text = "Technician not Assigned";
            }
        }
    }