public ActionResult CategoryDeleteMulti(FormCollection frm)
{
string[] ids = frm["CategoryID"].Split(new char[] { ',' });
CategoryBL bl = new CategoryBL();
foreach (string item in ids)
{
CategoryDTO categoryDTO = new CategoryDTO();
int id = item.ParseInt32();
categoryDTO.id = id;
List <CategoryDTO> dtos = new List <CategoryDTO>();
int returncode = bl.SearchData(categoryDTO, out dtos);
if (returncode == 1)
{
Response.StatusCode = 404;
return(null);
}
else
{
int result = bl.DeleteData(id);
if (result == 1)
{
TempData["Error"] = "Delete badly";
TempData["Success"] = "";
}
else
{
TempData["Error"] = "";
TempData["Success"] = "Insert successfully";
}
}
}
return(RedirectToAction("CategorySearch"));
}
public ActionResult CategoryDelete(int id)
{
CategoryBL bl = new CategoryBL();
CategoryDTO categoryDTO = new CategoryDTO();
List <CategoryDTO> dtos = new List <CategoryDTO>();
categoryDTO.id = id;
bl.SearchData(categoryDTO, out dtos);
if (dtos.Count <= 0)
{
Response.StatusCode = 404;
return(null);
}
else
{
int result = bl.DeleteData(id);
if (result == 1)
{
TempData["Error"] = "Delete badly";
TempData["Success"] = "";
}
else
{
TempData["Error"] = "";
TempData["Success"] = "Delete successfully";
}
}
return(RedirectToAction("CategorySearch"));
}
public ActionResult Update(string id)
{
if (!id.IsNotNullOrEmpty())
{
TempData["Error"] = "Data has already been deleted by other user!";
return(RedirectToAction("Category"));
}
CategoryDTO model = new CategoryDTO();
if (id.IsNumber())
{
SelectList listCategory = new SelectList(categoryBL.SelectDropdownData(), "id", "name");
ViewBag.ListCategory = listCategory;
List <CategoryDTO> list;
categoryBL.SearchData(new CategoryDTO {
id = int.Parse(id)
}, out list);
if (list.Count > 0)
{
model = list[0];
}
else
{
TempData["Error"] = "Data has already been deleted by other user!";
return(RedirectToAction("Category"));
}
}
else
{
TempData["Error"] = "Error exception";
return(RedirectToAction("Category"));
}
return(View(model));
}
// GET: Caterogy
public ActionResult CategorySearch(string Page, CategorySearch model)
{
CategoryBL bl = new CategoryBL();
CategoryDTO dto = new CategoryDTO();
if (!string.IsNullOrEmpty(model.SearchButton) || Page.IsNotNullOrEmpty())
{
if (Page != null)
{
dto.page = int.Parse(Page);
model.Page = dto.page;
}
List <CategoryDTO> result = new List <CategoryDTO>();
if (model.CategoryCode.IsNotNullOrEmpty())
{
dto.code = model.CategoryCode;
}
if (model.CategoryName.IsNotNullOrEmpty())
{
dto.name = model.CategoryName;
}
bl.SearchData(dto, out result);
model.PageCount = bl.CountPage(dto);
model.SearchResults = new StaticPagedList <CategoryDTO>(result, model.Page, 20, model.PageCount);
}
return(View(model));
}
public ActionResult Category(string page, ResearchCategoryModel model)
{
ModelState.Clear();
CategoryBL bl = new CategoryBL();
if (model == null)
{
model = new ResearchCategoryModel();
model.Category = new CategoryDTO();
model.lstCategory = new List <CategoryDTO>();
}
else
{
if (model.Category == null)
{
model.Category = new CategoryDTO();
}
if (model.lstCategory == null)
{
model.lstCategory = new List <CategoryDTO>();
}
}
if (page == null)
{
page = "1";
}
model.page_count = bl.CountData(model.Category);
List <CategoryDTO> list;
model.Category.page = int.Parse(page);
bl.SearchData(model.Category, out list);
model.lstCategory = list;
TempData["Success"] = model.page_count + " row(s) has found.";
return(View(model));
}
// GET: Caterogy
public ActionResult CategorySearch(CategoryDTO caterogy)
{
CategoryBL bl = new CategoryBL();
CategoryList model = new CategoryList();
DataTable dt;
bl.SearchData(caterogy, out dt);
model.Caterogy = CommonMethod.DataTableToList <CategoryDTO>(dt);
return(View(model));
}
public ActionResult CategoryUpdate(int id)
{
ModelState.Clear();
CategoryBL bl = new CategoryBL();
CategoryDTO category = new CategoryDTO();
List <CategoryDTO> viewbag;
category.id = id;
List <CategoryDTO> dtos = new List <CategoryDTO>();
bl.SearchData(category, out dtos);
CategoryDTO model = new CategoryDTO();
model = dtos[0];
bl.SearchListUp(model, out viewbag);
ViewBag.CaterogyList = viewbag;
return(View(model));
}
public ActionResult CategoryDelete(int id)
{
CategoryBL bl = new CategoryBL();
DataTable dtResult;
CategoryDTO categoryDTO = new CategoryDTO();
categoryDTO.id = id;
bl.SearchData(categoryDTO, out dtResult);
int count = dtResult.Rows.Count;
if (count == 0)
{
Response.StatusCode = 404;
return(null);
}
bl.DeleteData(id);
return(RedirectToAction("CategorySearch"));
}
public ActionResult Category(CategoryModel model, int page = 1)
{
ModelState.Clear();
if (model == null)
{
model = new CategoryModel();
model.Category = new CategoryDTO();
model.Categorys = new StaticPagedList <CategoryDTO>(new List <CategoryDTO>(), 1, 20, 0);
}
else
{
if (model.Category == null)
{
if (Session["model.Category"] != null && page >= 1)
{
model.Category = Session["model.Category"] as CategoryDTO;
}
else
{
model.Category = new CategoryDTO();
}
}
else
{
Session["model.Category"] = model.Category;
}
}
CategoryBL bl = new CategoryBL();
model.Category.page = page;
model.Category.page_count = bl.CountData(model.Category);
TempData["SearchCount"] = model.Category.page_count + " row(s) has found.";
SelectList listCategory = new SelectList(categoryBL.SelectDropdownData(), "id", "name");
ViewBag.ListCategory = listCategory;
List <CategoryDTO> list;
bl.SearchData(model.Category, out list);
model.Categorys = new StaticPagedList <CategoryDTO>(list, model.Category.page, 20, model.Category.page_count);
return(View(model));
}
public ActionResult CategoryUpdate(int id)
{
CategoryBL bl = new CategoryBL();
DataTable dt;
CategoryDTO category = new CategoryDTO();
CategoryBL catelogy = new CategoryBL();
DataTable catelogydt;
catelogy.SearchList(out catelogydt);
ViewBag.CaterogyList = CommonMethod.DataTableToList <CategoryDTO>(catelogydt);
category.id = id;
bl.SearchData(category, out dt);
DataRow row = dt.Rows[0];
category.parent_id = int.Parse(row["parent_id"].ToString());
category.code = row["code"].ToString();
category.name = row["name"].ToString();
category.description = row["description"].ToString();
return(View(category));
}
public ActionResult Update(string id)
{
CategoryDTO dto = new CategoryDTO();
if (id.IsNumber())
{
List <CategoryDTO> list;
CategoryBL bl = new CategoryBL();
dto.id = int.Parse(id);
bl.SearchData(dto, out list);
if (list.Count > 0)
{
dto = list[0];
}
else
{
TempData["Success"] = "0 row(s) has found.";
return(RedirectToAction("Category"));
}
}
return(View(LoadCategoryAddForm(dto)));
}
