protected void btnSaveNewSubCategory_Click(object sender, EventArgs e) { try { obj_MC = new clsManageMasterTables(); obj = new TBL_SUB_CATEGORY(); obj.SUBCAT_ID = 0; obj.MAIN_COURSE_ID = Convert.ToInt32(ddlMainCourse.SelectedValue); obj.SUBCAT_NAME = txtSubCategoryName.Text; obj.SUBCAT_DESC = txtSubCategoryDesc.Text; obj.CREATED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.CREATED_BY = 1000000001; obj.MODIFIED_ON = DbConnect.GetCurrentDateTimeIndia(); obj.MODIFIED_BY = 1000000001; obj.PURGEFLAG = "A"; obj_MC.SubCategoryInsertUpdate(obj); Bind_grdSubCategory(); txtSubCategoryName.Text = txtSubCategoryDesc.Text = string.Empty; ddlMainCourse.SelectedValue = "0"; } catch (Exception ex) { Response.Write(ex.Message); } }
public void SubCategoryInsertUpdate(TBL_SUB_CATEGORY obj) { DB.ExecScalerSP_Object(CommandType.StoredProcedure, "USP_TBL_SUB_CATEGORY_InsertUpdate", new SqlParameter("@SUBCAT_ID", obj.SUBCAT_ID), new SqlParameter("@MAIN_COURSE_ID", obj.MAIN_COURSE_ID), new SqlParameter("@SUBCAT_NAME", obj.SUBCAT_NAME), new SqlParameter("@SUBCAT_DESC", obj.SUBCAT_DESC), new SqlParameter("@CREATED_ON", obj.CREATED_ON), new SqlParameter("@CREATED_BY", obj.CREATED_BY), new SqlParameter("@MODIFIED_ON", obj.MODIFIED_ON), new SqlParameter("@MODIFIED_BY", obj.MODIFIED_BY), new SqlParameter("@PURGEFLAG", obj.PURGEFLAG)); CloseAll(); }