public ActionResult _GetStudentDetails(int ClassId, int DivisionId) { List <StudentClassChangeSubVM> studentClassChangeSubVMs = new List <StudentClassChangeSubVM>(); int ClassDivisionId = 0; ClassDivisionBAL balObject = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> ClassDivisions = balObject.FindBy(cd => cd.ClassId == ClassId && cd.DivisionId == DivisionId); if (ClassDivisions != null && ClassDivisions.Count() > 0) { ClassDivisionId = ClassDivisions.FirstOrDefault().ClassDivisionId; } StudentBAL studentBAL = new StudentBAL(); IQueryable <Entities.StudentClassChange> studentClassChanges = studentBAL.GetStudentClassChange(ClassDivisionId, SessionHelper.SchoolId); if (studentClassChanges != null && studentClassChanges.Count() > 0) { foreach (Entities.StudentClassChange studentLedgersGroupItem in studentClassChanges) { StudentClassChangeSubVM studentTransactionSubVM = new StudentClassChangeSubVM(); studentTransactionSubVM.StudentId = studentLedgersGroupItem.StudentId; studentTransactionSubVM.RegisterId = studentLedgersGroupItem.RegisterId; studentTransactionSubVM.StudentFullNameWithTitle = studentLedgersGroupItem.StudentFullNameWithTitle; studentTransactionSubVM.CheckedValues = true; studentClassChangeSubVMs.Add(studentTransactionSubVM); } } return(PartialView("_GetStudentDetails", new GridModel <StudentClassChangeSubVM> { Data = studentClassChangeSubVMs })); //return PartialView("_GetStudentsList", studentClassChanges.AsEnumerable()); }
public ActionResult Edit(StudentTransactionVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.StudentTransaction entity = new Entities.StudentTransaction(); entity.StudentTransactionId = viewModel.StudentTransactionId; entity.ClassDivisionId = viewModel.ClassDivisionId; ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); entity.ClassDivisionId = classDivisionBAL.FindBy(cd => cd.ClassId == viewModel.ClassId && cd.DivisionId == viewModel.DivisionId).FirstOrDefault().ClassDivisionId; entity.StudentId = viewModel.StudentId; entity.TransactionDate = viewModel.TransactionDate; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; StudentTransactionBAL balObject = new StudentTransactionBAL(); balObject.Edit(entity); return(RedirectToAction("Index")); } else { return(View(viewModel)); } } catch { return(View()); } }
public ActionResult Select() { string mode = Request.QueryString["Grid-mode"]; if (!string.IsNullOrEmpty(mode)) { return(this.RedirectToAction("Create")); } else { List <ClassDivisionVM> viewModels = new List <ClassDivisionVM>(); ClassDivisionBAL balObject = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> entites = balObject.GetAll(); foreach (Entities.ClassDivision entity in entites) { ClassDivisionVM viewModel = new ClassDivisionVM(); viewModel.ClassDivisionId = entity.ClassDivisionId; viewModel.ClassId = entity.ClassId; viewModel.DivisionId = entity.DivisionId; viewModel.ClassName = entity.ClassName; viewModel.DivisionName = entity.DivisionName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(this.View("Index", new GridModel <ClassDivisionVM> { Data = viewModels })); } }
public ActionResult Index() { List <ClassDivisionVM> viewModels = new List <ClassDivisionVM>(); ClassDivisionBAL balObject = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> entites = balObject.GetAll(); foreach (Entities.ClassDivision entity in entites) { ClassDivisionVM viewModel = new ClassDivisionVM(); viewModel.ClassDivisionId = entity.ClassDivisionId; viewModel.ClassId = entity.ClassId; viewModel.DivisionId = entity.DivisionId; viewModel.ClassName = entity.ClassName; viewModel.DivisionName = entity.DivisionName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <ClassDivisionVM> { Data = viewModels })); }
public ActionResult Edit(ClassDivisionVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.ClassDivision entity = new Entities.ClassDivision(); entity.ClassDivisionId = viewModel.ClassDivisionId; entity.ClassId = viewModel.ClassId; entity.ClassName = viewModel.ClassName; entity.DivisionId = viewModel.DivisionId; entity.DivisionName = viewModel.DivisionName; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; ClassDivisionBAL balObject = new ClassDivisionBAL(); balObject.Edit(entity); return(RedirectToAction("Index")); } else { return(View(viewModel)); } } catch { return(View()); } }
/// <summary> /// Get Student name list by class and division /// </summary> /// <param name="ClassId">Classs id</param> /// <param name="DivisionId">Division id</param> /// <returns>List of Student name</returns> public static IQueryable <SelectListItem> GetStudentNameList(int ClassId, int DivisionId, int schoolId) { IQueryable <SelectListItem> studentNameList = null; if (ClassId > 0 && DivisionId > 0) { ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> classDivisions = classDivisionBAL.FindBy(cd => cd.ClassId == ClassId && cd.DivisionId == DivisionId); int ClassDivisionId = 0; if (classDivisions != null && classDivisions.Count() > 0) { ClassDivisionId = classDivisionBAL.FindBy(cd => cd.ClassId == ClassId && cd.DivisionId == DivisionId).FirstOrDefault().ClassDivisionId; } if (ClassDivisionId != null && Convert.ToInt32(ClassDivisionId) > 0) { StudentBAL studentObject = new StudentBAL(); IQueryable <Entities.Student> getStudents = studentObject.GetAll(schoolId).Where(s => s.ClassDivisionId == ClassDivisionId && s.Status == true); studentNameList = from obj in getStudents select new SelectListItem() { Text = string.Concat(obj.FirstName, " ", obj.MiddleName, " ", obj.LastName).Trim(), Value = obj.StudentId.ToString() };; } } return(studentNameList); }
public ActionResult Create(FeeClassDivisionVM viewModel) { try { //Set default value viewModel.PeriodInMonthly = 12; viewModel.AmountInMonthly = viewModel.AmountInYearly; // TODO: Add insert logic here if (ModelState.IsValid) { Entities.FeeClassDivision entity = new Entities.FeeClassDivision(); entity.FeeClassDivisionId = viewModel.FeeClassDivisionId; entity.FeeHeadId = viewModel.FeeHeadId; ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); entity.ClassDivisionId = classDivisionBAL.FindBy(cd => cd.ClassId == viewModel.ClassId && cd.DivisionId == viewModel.DivisionId).FirstOrDefault().ClassDivisionId; entity.PeriodInMonthly = viewModel.PeriodInMonthly; entity.AmountInMonthly = viewModel.AmountInMonthly; entity.AmountInYearly = viewModel.AmountInYearly; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; FeeClassDivisionBAL balObject = new FeeClassDivisionBAL(); balObject.Add(entity); return(RedirectToAction("Index")); } else { ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll().Where(c => c.Status == true) select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; FeeHeadBAL balObject = new FeeHeadBAL(); viewModel.Fees = from obj in balObject.GetAll() select new SelectListItem() { Text = obj.FeeHeadName, Value = obj.FeeHeadId.ToString() }; return(View(viewModel)); } } catch { ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll().Where(c => c.Status == true) select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; FeeHeadBAL balObject = new FeeHeadBAL(); viewModel.Fees = from obj in balObject.GetAll() select new SelectListItem() { Text = obj.FeeHeadName, Value = obj.FeeHeadId.ToString() }; return(View(viewModel)); } }
/// <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/ClassDivision/Delete/5 //[HttpPost] public ActionResult Delete(int id) { try { // TODO: Add delete logic here ClassDivisionBAL balObject = new ClassDivisionBAL(); balObject.Delete(id); return(RedirectToAction("Index")); } catch { return(View()); } }
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); }
// // GET: /SysAdmin/ClassDivision/Details/5 public ActionResult Details(int id) { ClassDivisionVM viewModel = new ClassDivisionVM(); ClassDivisionBAL balObject = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> entites = balObject.FindBy(a => a.ClassDivisionId == id); if (entites != null && entites.Count() > 0) { Entities.ClassDivision entity = entites.FirstOrDefault(); viewModel.ClassDivisionId = entity.ClassDivisionId; viewModel.ClassId = entity.ClassId; viewModel.DivisionId = entity.DivisionId; viewModel.ClassName = entity.ClassName; viewModel.DivisionName = entity.DivisionName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } return(View(viewModel)); }
public ActionResult Create(ClassDivisionVM viewModel) { try { // TODO: Add insert logic here if (ModelState.IsValid) { Entities.ClassDivision entity = new Entities.ClassDivision(); entity.ClassDivisionId = viewModel.ClassDivisionId; entity.ClassId = viewModel.ClassId; entity.DivisionId = viewModel.DivisionId; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; ClassDivisionBAL balObject = new ClassDivisionBAL(); balObject.Add(entity); //this.TempData["AlertMessage"] = "Successfully Save !!!"; return(RedirectToAction("Index")); } else { ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; return(View(viewModel)); } } catch { ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; return(View(viewModel)); } }
public ActionResult Index(FormCollection formCollection, StudentClassChangeVM viewModel) { if (formCollection["PreviousClassId"] != null && formCollection["PreviousClassId"] != "") { viewModel.PreviousClassId = Convert.ToInt32(formCollection["PreviousClassId"]); } if (formCollection["PreviousDivisionId"] != null && formCollection["PreviousDivisionId"] != "") { viewModel.PreviousDivisionId = Convert.ToInt32(formCollection["PreviousDivisionId"]); } if (viewModel.PreviousClassId > 0 && viewModel.PreviousDivisionId > 0) { ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> classDivistions = classDivisionBAL.FindBy(cd => cd.ClassId == viewModel.PreviousClassId && cd.DivisionId == viewModel.PreviousDivisionId); if (classDivistions != null && classDivistions.Count() > 0) { viewModel.PreviousClassDivisionId = classDivistions.FirstOrDefault().ClassDivisionId; } } if (formCollection["CurrentClassId"] != null && formCollection["CurrentClassId"] != "") { viewModel.CurrentClassId = Convert.ToInt32(formCollection["CurrentClassId"]); } if (formCollection["CurrentDivisionId"] != null && formCollection["CurrentDivisionId"] != "") { viewModel.CurrentDivisionId = Convert.ToInt32(formCollection["CurrentDivisionId"]); } if (viewModel.CurrentClassId > 0 && viewModel.CurrentDivisionId > 0) { ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); IQueryable <Entities.ClassDivision> classDivistions = classDivisionBAL.FindBy(cd => cd.ClassId == viewModel.CurrentClassId && cd.DivisionId == viewModel.CurrentDivisionId); if (classDivistions != null && classDivistions.Count() > 0) { viewModel.CurrentClassDivisionId = classDivistions.FirstOrDefault().ClassDivisionId; } } string assignChkBx = string.Empty; if (formCollection["assignChkBx"] != null && formCollection["assignChkBx"] != "") { assignChkBx = Convert.ToString(formCollection["assignChkBx"]); } if (!string.IsNullOrEmpty(assignChkBx)) { viewModel.StudentClassChangeSubList = new List <StudentClassChangeSubVM>(); string[] strArrFeeId = assignChkBx.Split(','); if (strArrFeeId.Length > 0) { for (int i = 0; i < strArrFeeId.Length; i++) { StudentClassChangeSubVM studentClassChangeSubVM = new StudentClassChangeSubVM(); studentClassChangeSubVM.StudentId = Convert.ToInt32(strArrFeeId[i]); viewModel.StudentClassChangeSubList.Add(studentClassChangeSubVM); } } } //if (viewModel.StudentClassChangeSubList != null) //{ // viewModel.NoOfSelectedRecords = viewModel.StudentClassChangeSubList.Count; //} TryUpdateModel <StudentClassChangeVM>(viewModel); if (ModelState.IsValid) { Entities.StudentClassChange entity = new Entities.StudentClassChange(); entity.PreviousClassDivisionId = viewModel.PreviousClassDivisionId; entity.CurrentClassDivisionId = viewModel.CurrentClassDivisionId; entity.Remark = myRes.Studenttransferfrompreviousclass; entity.SelectedStudent = new int[viewModel.StudentClassChangeSubList.Count()]; int i = 0; foreach (var item in viewModel.StudentClassChangeSubList) { entity.SelectedStudent[i] = item.StudentId; i++; } StudentBAL balObject = new StudentBAL(); balObject.StudentChangeClassDivision(entity, SessionHelper.SchoolId); } ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll() select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; return(View(viewModel)); }
public ActionResult Create(FormCollection formCollection) { StudentTransactionVM viewModel = new StudentTransactionVM(); try { if (formCollection["ReceiptNo"] != null) { viewModel.ReceiptNo = Convert.ToInt32(formCollection["ReceiptNo"]); } if (formCollection["StudentTransactionId"] != null && formCollection["StudentTransactionId"] != "") { viewModel.StudentTransactionId = Convert.ToInt32(formCollection["StudentTransactionId"]); } if (formCollection["ClassId"] != null && formCollection["ClassId"] != "") { viewModel.ClassId = Convert.ToInt32(formCollection["ClassId"]); } if (formCollection["DivisionId"] != null && formCollection["DivisionId"] != "") { viewModel.DivisionId = Convert.ToInt32(formCollection["DivisionId"]); } if (formCollection["StudentId"] != null && formCollection["StudentId"] != "") { viewModel.StudentId = Convert.ToInt32(formCollection["StudentId"]); } if (formCollection["TransactionDate"] != null) { viewModel.TransactionDate = Convert.ToDateTime(formCollection["TransactionDate"]); } viewModel.Remark = Convert.ToString(formCollection["Remark"]); if (formCollection["ReceiptTotal"] != null && formCollection["ReceiptTotal"] != "") { viewModel.ReceiptTotal = Convert.ToDecimal(formCollection["ReceiptTotal"]); } viewModel.BankName = Convert.ToString(formCollection["BankName"]); viewModel.ChequeNumber = Convert.ToString(formCollection["ChequeNumber"]); TryUpdateModel <StudentTransactionVM>(viewModel); // TODO: Add insert logic here if (ModelState.IsValid) { Entities.StudentTransaction entity = new Entities.StudentTransaction(); if (formCollection["ReceiptNo"] != null) { entity.ReceiptNo = Convert.ToInt32(formCollection["ReceiptNo"]); } if (formCollection["StudentTransactionId"] != null && formCollection["StudentTransactionId"] != "") { entity.StudentTransactionId = Convert.ToInt32(formCollection["StudentTransactionId"]); } if (formCollection["ClassId"] != null && formCollection["ClassId"] != "" && formCollection["DivisionId"] != null && formCollection["DivisionId"] != "") { ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); entity.ClassDivisionId = classDivisionBAL.FindBy(cd => cd.ClassId == Convert.ToInt32(formCollection["ClassId"]) && cd.DivisionId == Convert.ToInt32(formCollection["DivisionId"])).FirstOrDefault().ClassDivisionId; } if (formCollection["StudentId"] != null && formCollection["StudentId"] != "") { entity.StudentId = Convert.ToInt32(formCollection["StudentId"]); } if (formCollection["TransactionDate"] != null) { entity.TransactionDate = Convert.ToDateTime(formCollection["TransactionDate"]); } entity.Status = true; entity.Remark = Convert.ToString(formCollection["Remark"]); if (formCollection["ReceiptTotal"] != null && formCollection["ReceiptTotal"] != "") { entity.ReceiptTotal = Convert.ToDecimal(formCollection["ReceiptTotal"]); } entity.BankName = Convert.ToString(formCollection["BankName"]); entity.ChequeNumber = Convert.ToString(formCollection["ChequeNumber"]); entity.StudentTransactionSubList = new List <Entities.StudentTransactionSub>(); //item.StudentTransactionId string itemFeeId = Convert.ToString(formCollection["item.FeeHeadId"]); string itemCr = Convert.ToString(formCollection["item.Cr"]); string itemDr = Convert.ToString(formCollection["item.Dr"]); string itemBalance = Convert.ToString(formCollection["item.Balance"]); if (!string.IsNullOrEmpty(itemFeeId)) { string[] strArrFeeId = itemFeeId.Split(','); string[] strArrCr = itemCr.Split(','); string[] strArrDr = itemDr.Split(','); string[] strArrBalance = itemBalance.Split(','); if (itemFeeId.Length > 0) { for (int i = 0; i < strArrFeeId.Length; i++) { Entities.StudentTransactionSub entitySub = new Entities.StudentTransactionSub(); entitySub.FeeHeadId = Convert.ToInt32(strArrFeeId[i]); entitySub.Cr = Convert.ToDecimal(strArrCr[i]); entitySub.Dr = Convert.ToDecimal(strArrDr[i]); entitySub.Balance = Convert.ToDecimal(strArrBalance[i]); entity.StudentTransactionSubList.Add(entitySub); } } } StudentTransactionBAL balObject = new StudentTransactionBAL(); balObject.Add(entity, SessionHelper.SchoolId); PresentationLayer.Helpers.SessionHelper.ReportIndex = 2; return(Redirect(@"~\Report.aspx")); //return RedirectToAction("Index"); } else { ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; return(View(viewModel)); } } catch { ClassBAL classBAL = new ClassBAL(); viewModel.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem() { Text = obj.ClassName, Value = obj.ClassId.ToString() }; return(View(viewModel)); } }
public static int GetClassDivisionId(string ClassName, string DivisionName) { ClassDivisionBAL classDivisionBAL = new ClassDivisionBAL(); return(classDivisionBAL.GetClassDivisionId(ClassName, DivisionName)); }