public ActionResult Select()
{
string mode = Request.QueryString["Grid-mode"];
if (!string.IsNullOrEmpty(mode))
{
return(this.RedirectToAction("Create"));
}
else
{
List <ClassVM> viewModels = new List <ClassVM>();
ClassBAL balObject = new ClassBAL();
IQueryable <Entities.Class> entites = balObject.GetAll();
foreach (Entities.Class entity in entites)
{
ClassVM viewModel = new ClassVM();
viewModel.ClassId = entity.ClassId;
viewModel.ClassName = entity.ClassName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(this.View("Index", new GridModel <ClassVM> {
Data = viewModels
}));
}
}
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));
}
}
public ActionResult Edit(ClassVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.Class entity = new Entities.Class();
entity.ClassId = viewModel.ClassId;
entity.ClassName = viewModel.ClassName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
ClassBAL balObject = new ClassBAL();
balObject.Edit(entity);
return(RedirectToAction("Index"));
}
else
{
return(View(viewModel));
}
}
catch
{
return(View(viewModel));
}
}
public ActionResult Create(ClassVM viewModel)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
Entities.Class entity = new Entities.Class();
entity.ClassId = viewModel.ClassId;
entity.ClassName = viewModel.ClassName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
ClassBAL balObject = new ClassBAL();
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 classes list
/// </summary>
/// <returns>classes list</returns>
public JsonResult GetCurrentClassesList()
{
ClassBAL classBAL = new ClassBAL();
var classesList = from obj in classBAL.GetAll() select new SelectListItem()
{
Text = obj.ClassName, Value = obj.ClassId.ToString()
};
return(this.Json(classesList, JsonRequestBehavior.AllowGet));
}
public ActionResult BonafideCertificate()
{
LeavingCertificateVM leavingCertificateVM = new LeavingCertificateVM();
ClassBAL classBAL = new ClassBAL();
leavingCertificateVM.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem()
{
Text = obj.ClassName, Value = obj.ClassId.ToString()
};
return(View(leavingCertificateVM));
}
//
// GET: /SysAdmin/StudentClassChange/
public ActionResult Index()
{
StudentClassChangeVM viewModel = new StudentClassChangeVM();
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 NirgamCertificate()
{
NirgamCertificateVM nirgamCertificateVM = new NirgamCertificateVM();
ClassBAL classBAL = new ClassBAL();
nirgamCertificateVM.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem()
{
Text = obj.ClassName, Value = obj.ClassId.ToString()
};
return(View(nirgamCertificateVM));
}
public static IQueryable <SelectListItem> GetClassesList()
{
IQueryable <SelectListItem> classesList = null;
ClassBAL classBAL = new ClassBAL();
classesList = from obj in classBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.ClassName, Value = obj.ClassId.ToString()
};
return(classesList);
}
//
// GET: /SysAdmin/Division/Create
public ActionResult Create()
{
StudentTransactionVM viewModel = new StudentTransactionVM();
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()
};
viewModel.Status = true;
return(View(viewModel));
}
//
// POST: /SysAdmin/Class/Delete/5
//[HttpPost]
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
ClassBAL balObject = new ClassBAL();
balObject.Delete(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
//
// GET: /SysAdmin/Class/Details/5
public ActionResult Details(int id)
{
ClassVM viewModel = new ClassVM();
ClassBAL balObject = new ClassBAL();
IQueryable <Entities.Class> entites = balObject.FindBy(a => a.ClassId == id);
if (entites != null && entites.Count() > 0)
{
Entities.Class entity = entites.FirstOrDefault();
viewModel.ClassId = entity.ClassId;
viewModel.ClassName = entity.ClassName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
//
// GET: /SysAdmin/SMS/
public ActionResult Index()
{
StudentVM viewModel = new StudentVM();
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()
};
//ReligionBAL religionBAL = new ReligionBAL();
//viewModel.Religions = from obj in religionBAL.GetAll().Where(c => c.Status == true) select new SelectListItem() { Text = obj.ReligionName, Value = obj.ReligionId.ToString() };
viewModel.Status = true;
return(View(viewModel));
}
public ActionResult Index()
{
List <ClassVM> viewModels = new List <ClassVM>();
ClassBAL balObject = new ClassBAL();
IQueryable <Entities.Class> entites = balObject.GetAll();
foreach (Entities.Class entity in entites)
{
ClassVM viewModel = new ClassVM();
viewModel.ClassId = entity.ClassId;
viewModel.ClassName = entity.ClassName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <ClassVM> {
Data = viewModels
}));
}
//
// GET: /SysAdmin/Division/Create
public ActionResult Create()
{
FeeClassDivisionVM viewModel = new FeeClassDivisionVM();
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()
};
FeeClassDivisionBAL feesClass = new FeeClassDivisionBAL();
viewModel.Fees = from obj in feesClass.GetAll() select new SelectListItem()
{
Text = obj.FeeHeadName, Value = obj.FeeHeadId.ToString()
};
viewModel.Status = true;
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 NirgamCertificate(FormCollection frm)
{
NirgamCertificateVM nirgamCertificateVM = new NirgamCertificateVM();
if (frm["RegisterId"] != null && !string.IsNullOrEmpty(frm["RegisterId"]))
{
nirgamCertificateVM.RegisterId = Convert.ToInt32(frm["RegisterId"]);
}
if (frm["ClassId"] != null && !string.IsNullOrEmpty(frm["ClassId"]))
{
nirgamCertificateVM.ClassId = Convert.ToInt32(frm["ClassId"]);
}
if (frm["DivisionId"] != null && !string.IsNullOrEmpty(frm["DivisionId"]))
{
nirgamCertificateVM.DivisionId = Convert.ToInt32(frm["DivisionId"]);
}
if (frm["StudentId"] != null && !string.IsNullOrEmpty(frm["StudentId"]))
{
nirgamCertificateVM.StudentId = Convert.ToInt32(frm["StudentId"]);
}
if (ModelState.IsValid)
{
PresentationLayer.Helpers.SessionHelper.ReportIndex = 3;
PresentationLayer.Helpers.SessionHelper.StudentId = nirgamCertificateVM.StudentId;
return(Redirect(@"~\Report.aspx"));
}
else
{
ClassBAL classBAL = new ClassBAL();
nirgamCertificateVM.Classes = from obj in classBAL.GetAll() where obj.Status == true select new SelectListItem()
{
Text = obj.ClassName, Value = obj.ClassId.ToString()
};
return(View(nirgamCertificateVM));
}
}
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));
}
}
