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