public List <DirectoryCategoryModel> GetDirectoryCategoryList(int?CategoryId, int page, int pagesize)
{
var model = new List <DirectoryCategoryModel>();
var collection = ent.tblDirectoryCategories.Where(x => true);
try
{
if (CategoryId != null)
{
collection = collection.Where(x => x.DirectoryCategoryId == CategoryId).OrderBy(x => x.DirectoryCategoryId).Skip((page - 1) * pagesize).Take(pagesize);
}
else
{
collection = collection.OrderBy(x => x.DirectoryCategoryId).Skip((page - 1) * pagesize).Take(pagesize);
}
foreach (var item in collection)
{
var data = new DirectoryCategoryModel()
{
DirectoryCategoryId = item.DirectoryCategoryId,
DirectoryCategoryName = item.DirectoryCategoryName,
};
model.Add(data);
}
}
catch (Exception ex)
{
}
return(model);
}
public ActionResult Edit(int id)
{
var model = new DirectoryCategoryModel();
model = pro.GetDirectoryCategoryData(id);
return(View(model));
}
public ActionResult Edit(DirectoryCategoryModel model)
{
if (ModelState.IsValid)
{
pro.Update(model);
TempData["SuccessMessage"] = "Updated Successfully";
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult Create(DirectoryCategoryModel model)
{
if (ModelState.IsValid)
{
pro.Insert(model);
TempData["SuccessMessage"] = "Saved Successfully";
return(RedirectToAction("Index", "DirectoryCategory"));
}
return(View(model));
}
public ActionResult Index(int page = 1)
{
int pagesize = 100;
var model = new DirectoryCategoryModel();
model.DirectoryCategoryModelList = pro.GetDirectoryCategoryList(page, pagesize);
ViewBag.currentPage = page;
ViewBag.TotalPages = Math.Ceiling((double)pro.GetTotalItemCount() / pagesize);
return(View(model));
}
public void Insert(DirectoryCategoryModel model)
{
try
{
var objToSave = new tblDirectoryCategory()
{
DirectoryCategoryId = model.DirectoryCategoryId,
DirectoryCategoryName = model.DirectoryCategoryName,
};
//objToSave.CreatedBy = Utility.GetCurrentLoginUser();
objToSave.CreatedDate = DateTime.Now.ToShortDateString().ToString();
ent.tblDirectoryCategories.Add(objToSave);
ent.SaveChanges();
}
catch (Exception ex)
{
}
}
public DirectoryCategoryModel GetDirectoryCategoryData(int DirectoryCategoryId)
{
var model = new DirectoryCategoryModel();
try
{
var item = ent.tblDirectoryCategories.Single(x => x.DirectoryCategoryId == DirectoryCategoryId);
model = new DirectoryCategoryModel()
{
DirectoryCategoryId = item.DirectoryCategoryId,
DirectoryCategoryName = item.DirectoryCategoryName,
};
}
catch (Exception ex)
{
}
return(model);
}
public void Update(DirectoryCategoryModel model)
{
try
{
var objToEdit = ent.tblDirectoryCategories.Single(x => x.DirectoryCategoryId == model.DirectoryCategoryId);
objToEdit.DirectoryCategoryId = model.DirectoryCategoryId;
objToEdit.DirectoryCategoryName = model.DirectoryCategoryName;
//objToEdit.UpdatedBy = Utility.GetCurrentLoginUser();
//objToEdit.UpdateDate = DateTime.Now.ToShortDateString().ToString();
ent.Entry(objToEdit).State = System.Data.Entity.EntityState.Modified;
ent.SaveChanges();
}
catch (Exception ex)
{
//Log.Error(string.Format("Error! on Update InventoryItemCategoryData Data Auction with error message: {0}",
// ex.Message));
//Log.Error(string.Format("Error with exception: {0}", ex.StackTrace));
}
}
public ActionResult Create()
{
var model = new DirectoryCategoryModel();
return(View(model));
}
