public object DeleteFeeRegistrationDetail(FeeMasterCustomModel objModel) { using (objDAL = new FeeMasterRepo()) { return(objDAL.DeleteFeeRegistrationDetail(objModel)); } }
public object GetFeeMasterListing(FeeMasterCustomModel objModel) { using (objDAL = new FeeMasterRepo()) { return(objDAL.GetFeeMasterListing(objModel)); } }
public Response SaveFeeMasterDetails(FeeMasterCustomModel objModel) { using (objDAL = new FeeMasterRepo()) { return(objDAL.SaveFeeMasterDetails(objModel)); } }
// // GET: /FeeMaster/Create public ActionResult Create(int id = 0) { ClassMasterModel objClassModel = new ClassMasterModel(); SessionMasterModel objSessionModel = new SessionMasterModel(); objBDCCommon = new CommonMasterDataBusiness(); var SessionType = objBDCCommon.GetSessionMaster(); objSessionModel.SessionList = new SelectList(SessionType, "SessionId", "Title"); ViewBag.SessionInfo = objSessionModel.SessionList; var ClassType = objBDCCommon.GetClassMaster(Convert.ToInt32(Session[CommonStrings.DefaultSession])); objClassModel.ClassList = new SelectList(ClassType, "ClassId", "Title"); ViewBag.ClassInfo = objClassModel.ClassList; FeeMasterCustomModel objModel = new FeeMasterCustomModel(); if (id != 0) { objBDC = new FeeMasterBusiness(); objModel = objBDC.GetById(id); } return(View(objModel)); }
public ActionResult Edit(int id, FeeMasterCustomModel objModel) { try { if (ModelState.IsValid) { Response response = new Response(); // TODO: Add update logic here objBDC = new FeeMasterBusiness(); objModel.FeeMasterId = id; response = objBDC.SaveFeeMasterDetails(objModel); if (response.success == false) { return(new JavaScriptResult() { Script = "alert('Record already exists');" }); } else { return(RedirectToAction("Index")); } } else { return(View()); } } catch { return(View()); } }
public ActionResult SearchSessionWiseResult(int?SessionId) { FeeMasterCustomModel objModel = new FeeMasterCustomModel(); objBDC = new FeeMasterBusiness(); objModel.SessionId = SessionId; var rs = objBDC.GetFeeMasterListing(objModel); @ViewBag.TotalStudents = rs.ToString().Count(); return(PartialView(rs)); }
public ActionResult Create(FeeMasterCustomModel objModel) { try { if (ModelState.IsValid) { Response _Result = new Response(); // TODO: Add insert logic here objBDC = new FeeMasterBusiness(); objModel.CreatedBy = ((School.Shared.CustomModels.UserLoginCustomModel)(Session[CommonStrings.UserSession])).Id; objModel.ModifiedBy = ((School.Shared.CustomModels.UserLoginCustomModel)(Session[CommonStrings.UserSession])).Id; _Result = objBDC.SaveFeeMasterDetails(objModel); if (_Result.success == true) { TempData["Message"] = "Success^" + _Result.message; } else if (_Result.success == false) { TempData["Message"] = "Error^" + _Result.message; } return(RedirectToAction("Index")); } else { SessionMasterModel objSessionModel = new SessionMasterModel(); ClassMasterModel objClassModel = new ClassMasterModel(); objBDCCommon = new CommonMasterDataBusiness(); var SessionType = objBDCCommon.GetSessionMaster(); objSessionModel.SessionList = new SelectList(SessionType, "SessionId", "Title"); ViewBag.SessionInfo = objSessionModel.SessionList; var ClassType = objBDCCommon.GetClassMaster(Convert.ToInt32(Session[CommonStrings.DefaultSession])); objClassModel.ClassList = new SelectList(ClassType, "ClassId", "Title"); ViewBag.ClassInfo = objClassModel.ClassList; return(View()); } } catch { return(View()); } }
// // GET: /FeeMaster/ public ActionResult Index() { SessionMasterModel objSessionModel = new SessionMasterModel(); objBDCCommon = new CommonMasterDataBusiness(); var SessionType = objBDCCommon.GetSessionMaster(); objSessionModel.SessionList = new SelectList(SessionType, "SessionId", "Title"); ViewBag.SessionInfo = objSessionModel.SessionList; FeeMasterCustomModel objModel = new FeeMasterCustomModel(); objBDC = new FeeMasterBusiness(); var rs = objBDC.GetFeeMasterListing(objModel); return(View(rs)); }
public FeeMasterCustomModel GetById(int Id) { FeeMasterCustomModel objListModel = new FeeMasterCustomModel(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; objListModel = dbcontext.tblFeeMasters.Where(x => x.IsDeleted == false && x.FeeMasterId == Id) .Select(x => new FeeMasterCustomModel { FeeMasterId = x.FeeMasterId, SessionId = x.SessionId, SessionName = x.SessionId != null ? x.tblSession.Session : "", ClassId = x.ClassId, ClassName = x.ClassId != null ? x.tblClass.Title : "", SchoolId = x.SchoolId, TotalFee = x.TotalFee, Discount = x.Discount, NetFee = x.NetFee, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).SingleOrDefault(); } catch (Exception ex) { response.success = false; response.message = ex.Message; objListModel = null; } } } return(objListModel); }
public JsonResult UpdateStatus(string id) { objBDC = new FeeMasterBusiness(); int Id = Convert.ToInt32(id); bool _Result = objBDC.FindById(Id); if (_Result == true) { _Result = false; } else { _Result = true; } FeeMasterCustomModel objModel = new FeeMasterCustomModel(); objModel.FeeMasterId = Id; objBDC.SetActiveFeeRegistrationDetail(objModel); return(Json(new { result = _Result })); }
public ActionResult DeleteStatus(string id) { objBDC = new FeeMasterBusiness(); int Id = Convert.ToInt32(id); bool _Result = objBDC.FindById(Id); if (_Result == true) { _Result = false; } else { _Result = true; } FeeMasterCustomModel objModel = new FeeMasterCustomModel(); objModel.FeeMasterId = Id; objBDC.DeleteFeeRegistrationDetail(objModel); return(RedirectToAction("Index")); }
public object DeleteFeeRegistrationDetail(FeeMasterCustomModel objModel) { object objFeeResult = new object(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { var rs = dbcontext.tblFeeMasters.FirstOrDefault(x => x.FeeMasterId == objModel.FeeMasterId); if (rs != null) { rs.IsDeleted = true; rs.ModifiedDate = DateTime.Now; rs.ModifiedBy = objModel.ModifiedBy; dbcontext.SaveChanges(); objFeeResult = true; } else { objFeeResult = false; } } catch (Exception ex) { dbcontext.Dispose(); objFeeResult = null; throw ex; } } return(objFeeResult); } }
public object GetFeeMasterListing(FeeMasterCustomModel objModel) { IList <FeeMasterCustomModel> FeeListModel = new List <FeeMasterCustomModel>(); IQueryable <FeeMasterCustomModel> FeeListDetail = null; int TotalRec = 0; int CurrentPageSize = 0; using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; FeeListDetail = dbcontext.tblFeeMasters.Where(x => x.IsDeleted == false && (objModel.SessionId == null || objModel.SessionId == 0 || x.tblClass.SessionId == objModel.SessionId) && (objModel.ClassId == null || objModel.ClassId == 0 || x.ClassId == objModel.ClassId) ) .Select(x => new FeeMasterCustomModel { FeeMasterId = x.FeeMasterId, SessionId = x.SessionId, SessionName = x.SessionId != null ? x.tblSession.Session : "", ClassId = x.ClassId, ClassName = x.ClassId != null ? x.tblClass.Title : "", SchoolId = x.SchoolId, TotalFee = x.TotalFee, Discount = x.Discount, NetFee = x.NetFee, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).OrderByDescending(x => x.FeeMasterId); if (objModel.pageModel != null) { if (objModel.pageModel.SerachTerm != null && objModel.pageModel.SerachTerm != "") { //FeeListDetail = FeeListDetail.Where(x => //(x.TotalFee.ToLower().Trim().Contains(objModel.pageModel.SerachTerm.ToLower().Trim()) || objModel.pageModel.SerachTerm.Trim() == String.Empty) //|| (x.ShortDescription.ToLower().Trim().Contains(objClassRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objClassRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty) //); } if (!String.IsNullOrEmpty(objModel.pageModel.SortBy)) { //ClassListDetail= objClassRegistrationModel.pageModel.SortDir.ToLower() == "desc" ? ClassListDetail.OrderByDescending(objClassRegistrationModel.pageModel.SortBy) // : ClassListDetail.OrderBy(objClassRegistrationModel.pageModel.SortBy); } TotalRec = FeeListDetail.Count(); if (objModel.pageModel.PageSize > 0) { FeeListDetail = FeeListDetail.Skip(objModel.pageModel.Skip); FeeListDetail = FeeListDetail.Take(objModel.pageModel.PageSize); } FeeListModel = FeeListDetail.ToList() as IList <FeeMasterCustomModel>; } else { TotalRec = FeeListDetail.Count(); FeeListModel = FeeListDetail.ToList() as IList <FeeMasterCustomModel>; } //CurrentPageSize = objClassRegistrationModel.pageModel.PageSize; //if (ClassListModel.Count() > 0 && CurrentPageSize > 0) //{ // ClassListModel[0].pageModel = new PagingViewModel(); // ClassListModel[0].pageModel.TotalRecords = TotalRec; // if ((TotalRec % CurrentPageSize) == 0) // { // ClassListModel[0].pageModel.TotalPages = TotalRec / CurrentPageSize; // } // else // { // ClassListModel[0].pageModel.TotalPages = (TotalRec / CurrentPageSize) + 1; // } //} return(FeeListModel); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveFeeMasterDetails(FeeMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.FeeMasterId == 0) { var rs = dbcontext.tblFeeMasters.FirstOrDefault(x => x.IsDeleted == false && x.ClassId == objModel.ClassId); if (rs == null) { tblFeeMaster objAddNew = new tblFeeMaster { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), SessionId = objModel.SessionId, ClassId = objModel.ClassId, TotalFee = objModel.TotalFee, Discount = objModel.Discount, NetFee = objModel.NetFee, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblFeeMasters.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { FeeMasterId = objAddNew.FeeMasterId, TotalFee = objAddNew.TotalFee }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblFeeMasters.FirstOrDefault(x => x.IsDeleted == false && x.ClassId == objModel.ClassId && x.FeeMasterId != objModel.FeeMasterId); if (rs == null) { var objUpdate = dbcontext.tblFeeMasters.FirstOrDefault(m => m.FeeMasterId == objModel.FeeMasterId); if (objUpdate != null) { objUpdate.SessionId = objModel.SessionId; objUpdate.ClassId = objModel.ClassId; objUpdate.TotalFee = objModel.TotalFee; objUpdate.Discount = objModel.Discount; objUpdate.NetFee = objModel.NetFee; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { FeeMasterId = objUpdate.FeeMasterId, TotalFee = objUpdate.TotalFee }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }