Exemplo n.º 1
0
 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();
 }