public Response SaveClassMasterDetails(ClassMasterCustomModel objModel) { using (objDAL = new ClassMasterRepo()) { return(objDAL.SaveClassMasterDetails(objModel)); } }
public object DeleteClassRegistrationDetail(ClassMasterCustomModel objClassRegistrationModel) { using (objDAL = new ClassMasterRepo()) { return(objDAL.DeleteClassRegistrationDetail(objClassRegistrationModel)); } }
// // GET: /Class/Create public ActionResult Create(int id = 0) { ClassMasterCustomModel objModel = new ClassMasterCustomModel(); objBDCCommon = new CommonMasterDataBusiness(); SessionMasterModel objSessionModel = new SessionMasterModel(); var SessionType = objBDCCommon.GetSessionMaster(); objSessionModel.SessionList = new SelectList(SessionType, "SessionId", "Title"); ViewBag.SessionInfo = objSessionModel.SessionList; if (id != 0) { objBDC = new ClassMasterBusiness(); objModel = objBDC.GetById(id); ViewBag.SessionValue = Convert.ToString(objModel.SessionId); } else { ViewBag.SessionValue = Session[CommonStrings.DefaultSession].ToString(); } return(View(objModel)); }
public object GetClassMasterListing(ClassMasterCustomModel objClassRegistrationModel) { using (objDAL = new ClassMasterRepo()) { return(objDAL.GetClassMasterListing(objClassRegistrationModel)); } }
public ActionResult SearchSessionWiseResult(int?SessionId, int?ClassId) { ClassMasterCustomModel objModel = new ClassMasterCustomModel(); objBDC = new DashboardMasterBusiness(); objModel.SessionId = SessionId; ViewBag.EnquiryCount = objBDC.GetDashboardEnquiryCount(SessionId, ClassId); //@ViewBag.TotalStudents = rs.ToString().Count(); return(PartialView()); }
public ActionResult SearchSessionWiseResult(int?SessionId) { ClassMasterCustomModel objModel = new ClassMasterCustomModel(); objBDC = new ClassMasterBusiness(); objModel.SessionId = SessionId; var rs = objBDC.GetClassMasterListing(objModel); @ViewBag.TotalStudents = rs.ToString().Count(); return(PartialView(rs)); }
public ActionResult Edit(int id, ClassMasterCustomModel objModel) { try { // TODO: Add update logic here objBDC = new ClassMasterBusiness(); objModel.ClassId = id; objBDC.SaveClassMasterDetails(objModel); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(ClassMasterCustomModel objModel) { try { if (ModelState.IsValid) { Response _Result = new Response(); // TODO: Add insert logic here objBDC = new ClassMasterBusiness(); objModel.CreatedBy = ((School.Shared.CustomModels.UserLoginCustomModel)(Session[CommonStrings.UserSession])).Id; objModel.ModifiedBy = ((School.Shared.CustomModels.UserLoginCustomModel)(Session[CommonStrings.UserSession])).Id; _Result = objBDC.SaveClassMasterDetails(objModel); //TempData["Success"] = "Added Successfully!"; if (_Result.success == true) { TempData["Message"] = "Success^" + _Result.message; } else if (_Result.success == false) { TempData["Message"] = "Error^" + _Result.message; } return(RedirectToAction("Index")); } else { objBDCCommon = new CommonMasterDataBusiness(); SessionMasterModel objSessionModel = new SessionMasterModel(); var SessionType = objBDCCommon.GetSessionMaster(); objSessionModel.SessionList = new SelectList(SessionType, "SessionId", "Title"); ViewBag.SessionInfo = objSessionModel.SessionList; ViewBag.SessionValue = Session[CommonStrings.DefaultSession].ToString(); return(View()); } } catch { return(View()); } }
public Response DeleteClassRegistrationDetail(ClassMasterCustomModel objClassRegistrationModel) { _response = new Response(); try { _response.responseData = objBDC.DeleteClassRegistrationDetail(objClassRegistrationModel); _response.message = "Record Deleted Successfully !!"; _response.success = true; } catch (Exception ex) { _response.success = false; _response.message = ex.Message.ToString(); } finally { objBDC.Dispose(); } return(_response); }
public ClassMasterCustomModel GetById(int Id) { ClassMasterCustomModel objListModel = new ClassMasterCustomModel(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; objListModel = dbcontext.tblClasses.Where(x => x.IsDeleted == false && x.ClassId == Id) .Select(x => new ClassMasterCustomModel { ClassId = x.ClassId, SchoolId = x.SchoolId, SchoolName = x.SchoolId != null ? x.tblSchool.Name : "", SessionId = x.SessionId, SessionName = x.SessionId != null ? x.tblSession.Session : "", Title = x.Title, DDate = x.DDate, ShortDescription = x.ShortDescription, 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); }
// // GET: /Class/ public ActionResult Index() { ViewBag.SessionValue = Session[CommonStrings.DefaultSession].ToString(); SessionMasterModel objSessionModel = new SessionMasterModel(); objBDCCommon = new CommonMasterDataBusiness(); var SessionType = objBDCCommon.GetSessionMaster(); objSessionModel.SessionList = new SelectList(SessionType, "SessionId", "Title"); ViewBag.SessionInfo = objSessionModel.SessionList; ClassMasterCustomModel objModel = new ClassMasterCustomModel(); objBDC = new ClassMasterBusiness(); objModel.SessionId = Convert.ToInt32(Session[CommonStrings.DefaultSession]); var rs = objBDC.GetClassMasterListing(objModel); return(View(rs)); }
public JsonResult DeleteStatus(string id) { objBDC = new ClassMasterBusiness(); int Id = Convert.ToInt32(id); bool _Result = objBDC.FindById(Id); if (_Result == true) { _Result = false; } else { _Result = true; } ClassMasterCustomModel objModel = new ClassMasterCustomModel(); objModel.ClassId = Id; objBDC.DeleteClassRegistrationDetail(objModel); return(Json(new { result = _Result })); }
/// <summary> /// This method is used to delete particular farmer detail /// </summary> /// <param name="AssetId">Unique id of asset</param> /// <returns>Response</returns> public object DeleteClassRegistrationDetail(ClassMasterCustomModel objClassRegistrationModel) { object objClassResult = new object(); using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { var rs = dbcontext.tblClasses.FirstOrDefault(x => x.ClassId == objClassRegistrationModel.ClassId); if (rs != null) { rs.IsDeleted = true; rs.ModifiedDate = DateTime.Now; rs.ModifiedBy = objClassRegistrationModel.ModifiedBy; dbcontext.SaveChanges(); objClassResult = true; } else { objClassResult = false; } } catch (Exception ex) { dbcontext.Dispose(); objClassResult = null; throw ex; } } return(objClassResult); } }
public object GetClassMasterListing(ClassMasterCustomModel objClassRegistrationModel) { IList <ClassMasterCustomModel> ClassListModel = new List <ClassMasterCustomModel>(); IQueryable <ClassMasterCustomModel> ClassListDetail = null; int TotalRec = 0; int CurrentPageSize = 0; using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; ClassListDetail = dbcontext.tblClasses.Where(x => x.IsDeleted == false && (objClassRegistrationModel.SessionId == null || objClassRegistrationModel.SessionId == 0 || x.SessionId == objClassRegistrationModel.SessionId) ) .Select(x => new ClassMasterCustomModel { ClassId = x.ClassId, SchoolId = x.SchoolId, SchoolName = x.tblSchool != null ? x.tblSchool.Name : "", SessionId = x.SessionId, SessionName = x.SessionId != null ? x.tblSession.Session : "", Title = x.Title, DDate = x.DDate, ShortDescription = x.ShortDescription, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).OrderByDescending(x => x.ClassId); if (objClassRegistrationModel.pageModel != null) { if (objClassRegistrationModel.pageModel.SerachTerm != null && objClassRegistrationModel.pageModel.SerachTerm != "") { ClassListDetail = ClassListDetail.Where(x => (x.Title.ToLower().Trim().Contains(objClassRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objClassRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty) || (x.ShortDescription.ToLower().Trim().Contains(objClassRegistrationModel.pageModel.SerachTerm.ToLower().Trim()) || objClassRegistrationModel.pageModel.SerachTerm.Trim() == String.Empty) ); } if (!String.IsNullOrEmpty(objClassRegistrationModel.pageModel.SortBy)) { //ClassListDetail= objClassRegistrationModel.pageModel.SortDir.ToLower() == "desc" ? ClassListDetail.OrderByDescending(objClassRegistrationModel.pageModel.SortBy) // : ClassListDetail.OrderBy(objClassRegistrationModel.pageModel.SortBy); } TotalRec = ClassListDetail.Count(); if (objClassRegistrationModel.pageModel.PageSize > 0) { ClassListDetail = ClassListDetail.Skip(objClassRegistrationModel.pageModel.Skip); ClassListDetail = ClassListDetail.Take(objClassRegistrationModel.pageModel.PageSize); } ClassListModel = ClassListDetail.ToList() as IList <ClassMasterCustomModel>; } else { TotalRec = ClassListDetail.Count(); ClassListModel = ClassListDetail.ToList() as IList <ClassMasterCustomModel>; } //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(ClassListModel); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public Response SaveClassMasterDetails(ClassMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.ClassId == 0) { var rs = dbcontext.tblClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.Title == objModel.Title); if (rs == null) { tblClass objAddNew = new tblClass { SchoolId = Convert.ToInt32(CommonHelper.TaskSchoolId.SchoolId), SessionId = objModel.SessionId, Title = objModel.Title, ShortDescription = objModel.ShortDescription, DDate = objModel.DDate, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblClasses.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { ClassId = objAddNew.ClassId, Title = objAddNew.Title }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblClasses.FirstOrDefault(x => x.IsDeleted == false && x.SessionId == objModel.SessionId && x.Title == objModel.Title && x.ClassId != objModel.ClassId); if (rs == null) { var objUpdate = dbcontext.tblClasses.FirstOrDefault(m => m.ClassId == objModel.ClassId); if (objUpdate != null) { objUpdate.SessionId = objModel.SessionId; objUpdate.Title = objModel.Title; objUpdate.ShortDescription = objModel.ShortDescription; objUpdate.DDate = objModel.DDate; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { ClassId = objUpdate.ClassId, Title = objUpdate.Title }; 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); } } } }