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"; } } }