public CategoryEntryModel CategoryModel_Select(CategoryEntryModel categoryModel) { BaseDL bdl = new BaseDL(); categoryModel.Sqlprms = new SqlParameter[2]; categoryModel.Sqlprms[0] = new SqlParameter("@ParentCatCD", SqlDbType.VarChar) { Value = categoryModel.ParentCategoryCD }; categoryModel.Sqlprms[1] = new SqlParameter("@CategoryCD", SqlDbType.VarChar) { Value = categoryModel.CategoryCD }; DataTable dt = bdl.SelectDatatable("Category_Select", categoryModel.Sqlprms); DataRow dr = dt.Rows[0]; categoryModel.CategoryName = dr["CategoryName"].ToString(); categoryModel.RakutenDirectoryID = dr["RakutenDirectoryID"].ToString(); categoryModel.YahooCategoryID = dr["YahooCategoryID"].ToString(); categoryModel.PonpareCategoryID = dr["PonpareCategoryID"].ToString(); categoryModel.WowmaCategoryID = dr["WowmaCategoryID"].ToString(); categoryModel.RakutenCategorySetNo = dr["RakutenCategorySetNo"].ToString(); categoryModel.R_RacketCategoryID = dr["R_RacketCategoryID"].ToString(); categoryModel.R_SportsPlazaCategoryID = dr["R_SportsPlazaCategoryID"].ToString(); categoryModel.R_LuckpieceCategoryID = dr["R_LuckpieceCategoryID"].ToString(); categoryModel.R_HonpoCategoryID = dr["R_HonpoCategoryID"].ToString(); return(categoryModel); }
public string Category_CUD(CategoryEntryModel categoryModel) { BaseDL bdl = new BaseDL(); categoryModel.Sqlprms = new SqlParameter[13]; categoryModel.Sqlprms[0] = new SqlParameter("@CategoryCD", SqlDbType.VarChar) { Value = categoryModel.CategoryCD }; categoryModel.Sqlprms[1] = new SqlParameter("@CategoryName", SqlDbType.VarChar) { Value = categoryModel.CategoryName }; categoryModel.Sqlprms[2] = new SqlParameter("@ParentCategoryCD", SqlDbType.VarChar) { Value = categoryModel.ParentCategoryCD }; categoryModel.Sqlprms[3] = new SqlParameter("@RakutenDirectoryID", SqlDbType.VarChar) { Value = categoryModel.RakutenDirectoryID }; categoryModel.Sqlprms[4] = new SqlParameter("@YahooCategoryID", SqlDbType.VarChar) { Value = categoryModel.YahooCategoryID }; categoryModel.Sqlprms[5] = new SqlParameter("@PonpareCategoryID", SqlDbType.VarChar) { Value = categoryModel.PonpareCategoryID }; categoryModel.Sqlprms[6] = new SqlParameter("@WowmaCategoryID", SqlDbType.VarChar) { Value = categoryModel.WowmaCategoryID }; categoryModel.Sqlprms[7] = new SqlParameter("@RakutenCategorySetNo", SqlDbType.VarChar) { Value = categoryModel.RakutenCategorySetNo }; categoryModel.Sqlprms[8] = new SqlParameter("@R_RacketCategoryID", SqlDbType.VarChar) { Value = categoryModel.R_RacketCategoryID }; categoryModel.Sqlprms[9] = new SqlParameter("@R_SportsPlazaCategoryID", SqlDbType.VarChar) { Value = categoryModel.R_SportsPlazaCategoryID }; categoryModel.Sqlprms[10] = new SqlParameter("@R_LuckpieceCategoryID", SqlDbType.VarChar) { Value = categoryModel.R_LuckpieceCategoryID }; categoryModel.Sqlprms[11] = new SqlParameter("@R_HonpoCategoryID", SqlDbType.VarChar) { Value = categoryModel.R_HonpoCategoryID }; categoryModel.Sqlprms[12] = new SqlParameter("@Mode", SqlDbType.VarChar) { Value = categoryModel.Mode }; return(bdl.InsertUpdateDeleteData("Category_CUD", categoryModel.Sqlprms)); }
public ActionResult CategoryEntry(CategoryEntryModel categoryModel) { if (categoryModel.Mode == null) { categoryModel = new CategoryEntryModel(); categoryModel.Mode = "New"; } CategoryBL bl = new CategoryBL(); if (categoryModel.Mode.Equals("Edit")) { categoryModel = bl.CategoryModel_Select(categoryModel); } return(View(categoryModel)); }
public IHttpActionResult Category_CUD([FromBody] CategoryEntryModel categoryModel) { CategoryBL categoryBL = new CategoryBL(); return(Ok(categoryBL.Category_CUD(categoryModel))); }