public ActionResult Select()
{
string mode = Request.QueryString["Grid-mode"];
if (!string.IsNullOrEmpty(mode))
{
return(this.RedirectToAction("Create"));
}
else
{
List <DivisionVM> viewModels = new List <DivisionVM>();
DivisionBAL balObject = new DivisionBAL();
IQueryable <Entities.Division> entites = balObject.GetAll();
foreach (Entities.Division entity in entites)
{
DivisionVM viewModel = new DivisionVM();
viewModel.DivisionId = entity.DivisionId;
viewModel.DivisionName = entity.DivisionName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(this.View("Index", new GridModel <DivisionVM> {
Data = viewModels
}));
}
}
public ActionResult Edit(DivisionVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.Division entity = new Entities.Division();
entity.DivisionId = viewModel.DivisionId;
entity.DivisionName = viewModel.DivisionName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
DivisionBAL balObject = new DivisionBAL();
balObject.Edit(entity);
return(RedirectToAction("Index"));
}
else
{
return(View(viewModel));
}
}
catch
{
return(View());
}
}
public ActionResult Create(DivisionVM viewModel)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
Entities.Division entity = new Entities.Division();
entity.DivisionId = viewModel.DivisionId;
entity.DivisionName = viewModel.DivisionName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
DivisionBAL balObject = new DivisionBAL();
balObject.Add(entity);
return(RedirectToAction("Index"));
}
else
{
// AcademicYearBAL academicYearBAL = new AcademicYearBAL();
// viewModel.AcademicYears = from obj in academicYearBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
return(View(viewModel));
}
}
catch
{
//AcademicYearBAL academicYearBAL = new AcademicYearBAL();
//viewModel.AcademicYears = from obj in academicYearBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
return(View(viewModel));
}
}
/// <summary>
/// method for get divisions list
/// </summary>
/// <returns>divisions list</returns>
public JsonResult GetDivisionsList()
{
DivisionBAL divisionsBAL = new DivisionBAL();
var divisionesList = from obj in divisionsBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.DivisionName, Value = obj.DivisionId.ToString()
};
return(this.Json(divisionesList, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// method for get divisions list
/// </summary>
/// <returns>divisions list</returns>
public JsonResult GetCurrentDivisionsList(int CurrentClassId)
{
ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL();
IQueryable <Entities.ClassDivision> classDivisions = classDivisionBAL.FindBy(cd => cd.ClassId == CurrentClassId);
var divisionIds = from classDivisionObj in classDivisions select classDivisionObj.DivisionId;
DivisionBAL divisionsBAL = new DivisionBAL();
var divisions = divisionsBAL.GetAll().Where(d => d.Status == true);
var divisionesList = from obj in divisions from obj1 in divisionIds where obj.DivisionId == (obj1)select new SelectListItem()
{
Text = obj.DivisionName, Value = obj.DivisionId.ToString()
};
return(this.Json(divisionesList, JsonRequestBehavior.AllowGet));
}
//
// POST: /SysAdmin/Division/Delete/5
//[HttpPost]
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
DivisionBAL balObject = new DivisionBAL();
balObject.Delete(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
//
// GET: /SysAdmin/Division/Details/5
public ActionResult Details(int id)
{
DivisionVM viewModel = new DivisionVM();
DivisionBAL balObject = new DivisionBAL();
IQueryable <Entities.Division> entites = balObject.FindBy(a => a.DivisionId == id);
if (entites != null && entites.Count() > 0)
{
Entities.Division entity = entites.FirstOrDefault();
viewModel.DivisionId = entity.DivisionId;
viewModel.DivisionName = entity.DivisionName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
public static IQueryable <SelectListItem> GetDivisionsList(int ClassId)
{
IQueryable <SelectListItem> divisionesList = null;
if (ClassId > 0)
{
ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL();
IQueryable <Entities.ClassDivision> classDivisions = classDivisionBAL.FindBy(cd => cd.ClassId == ClassId);
var divisionIds = from classDivisionObj in classDivisions select classDivisionObj.DivisionId;
DivisionBAL divisionsBAL = new DivisionBAL();
var divisions = divisionsBAL.GetAll().Where(d => d.Status == true);
divisionesList = from obj in divisions from obj1 in divisionIds where obj.DivisionId == (obj1)select new SelectListItem()
{
Text = obj.DivisionName, Value = obj.DivisionId.ToString()
};
}
return(divisionesList);
}
public ActionResult Index()
{
List <DivisionVM> viewModels = new List <DivisionVM>();
DivisionBAL balObject = new DivisionBAL();
IQueryable <Entities.Division> entites = balObject.GetAll();
foreach (Entities.Division entity in entites)
{
DivisionVM viewModel = new DivisionVM();
viewModel.DivisionId = entity.DivisionId;
viewModel.DivisionName = entity.DivisionName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <DivisionVM> {
Data = viewModels
}));
}
