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