private async Task <bool> AddEntity(TrainingPlanViewModel model, ICollection <TrainingPlanRaceDefinition> TrainingPlanRaceDefinitions, IQueryable <RaceDefinition> referralEntityList) { bool isSaveSuccess = true; List <TrainingPlanRaceDefinition> TrainingPlanRaceDefinitionList = new List <TrainingPlanRaceDefinition>(); foreach (var record in model.RaceDefinitionIds) { var currentRolePermission = referralEntityList.Any(a => a.Id == record); if (currentRolePermission) { TrainingPlanRaceDefinition TrainingPlanRaceDefinition = new TrainingPlanRaceDefinition(); TrainingPlanRaceDefinitionList.Add(TrainingPlanRaceDefinition.ToEntity(record, model.Id, model.SessionUserId)); } } if (TrainingPlanRaceDefinitionList.Count > 0) { await _context.TrainingPlanRaceDefinition.AddRangeAsync(TrainingPlanRaceDefinitionList); await _context.SaveChangesAsync(); isSaveSuccess = true; } return(isSaveSuccess); }
private async Task <bool> AddTrainingPlanMemberWherePreviousExists(TrainingPlanViewModel model, ICollection <TrainingPlanMember> TrainingPlanMembers, IQueryable <Member> regions) { bool isSaveSuccess = true; List <TrainingPlanMember> assignedTrainingPlanMembers = new List <TrainingPlanMember>(); foreach (var recordId in model.MemberIds) { var currentRolePermission = regions.Where(a => a.Id == recordId).FirstOrDefault(); if (currentRolePermission != null) { if (!TrainingPlanMembers.Any(a => a.MemberId == recordId)) { // var currentUserRoleID = currentMenuRoles.First(a => a.Member.RoleID == currentRolePermission.RoleID).RegionID; var TrainingPlanMemberRepo = new TrainingPlanMember(); assignedTrainingPlanMembers.Add(TrainingPlanMemberRepo.ToEntity(recordId, model.Id, model.SessionUserId)); } } } if (assignedTrainingPlanMembers.Count > 0) { await _context.TrainingPlanMember.AddRangeAsync(assignedTrainingPlanMembers); await _context.SaveChangesAsync(); isSaveSuccess = true; } return(isSaveSuccess); }
public ExcelFileResult ExportExcel(int year, int Quarter) { TrainingPlanViewModel obj = new TrainingPlanViewModel(); TrainingPlanModel objModel = new TrainingPlanModel(); objModel.Year = year; objModel.Quarter = Quarter; //obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objModel); DataTable dt = _ItrainingService.GetTrainingPlanDataSet(objModel); dt.Columns.Remove("TrainingPlanId"); dt.Columns.Remove("Quarter"); dt.Columns.Remove("TrainingId"); dt.Columns.Remove("TrainingTypeId"); dt.Columns.Remove("month"); dt.Columns.Remove("isActive"); // DataTable dt = -- > get your data ExcelFileResult actionResult = new ExcelFileResult(dt) { FileDownloadName = "TrainingPlan.xls" }; //ExcelFileResult actionResult = new ExcelFileResult(dt) { FileDownloadName = string.Format("TrainingPlan{0}.xls", trainingcourseid) }; return(actionResult); }
public PartialViewResult EditPlan(int TrainingPlanId, int Year, int Quarter) { TrainingPlanViewModel obj = new TrainingPlanViewModel(); TrainingPlanModel objModel = new TrainingPlanModel(); objModel.Mode = "U"; objModel.Year = Year; objModel.Quarter = Quarter; objModel.TrainingPlanId = TrainingPlanId; obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objModel); obj.ListMonth = GetMonth(Quarter); obj.Mode = "U"; obj.Year = Year; obj.Quarter = Quarter; if (objModel.TrainingPlanId > 0) { obj.TrainingName = obj.ListTrainingPan[0].TrainingId; obj.Hrs = obj.ListTrainingPan[0].TrainingHour; obj.TrainingType = obj.ListTrainingPan[0].TrainingTypeId; obj.Month = obj.ListTrainingPan[0].Month; obj.Target = obj.ListTrainingPan[0].Target; } //Load ListPlan TrainingPlanModel objList = new TrainingPlanModel(); objList.Year = Year; objList.Quarter = Quarter; objList.TrainingPlanId = 0; obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objList); //obj.ListTrainingPan = obj.ListTrainingPan; obj.FlagEdit = true; return(PartialView(CommonConstants._PartialViewAddPlan, obj)); }
private async Task <bool> AddEntity(TrainingPlanViewModel model, ICollection <TrainingPlanMember> TrainingPlanMembers, IQueryable <Member> regions) { bool isSaveSuccess = true; List <TrainingPlanMember> TrainingPlanMemberList = new List <TrainingPlanMember>(); foreach (var record in model.MemberIds) { var currentRolePermission = regions.Any(a => a.Id == record); if (currentRolePermission) { TrainingPlanMember TrainingPlanMember = new TrainingPlanMember(); TrainingPlanMemberList.Add(TrainingPlanMember.ToEntity(record, model.Id, model.SessionUserId)); } } if (TrainingPlanMemberList.Count > 0) { await _context.TrainingPlanMember.AddRangeAsync(TrainingPlanMemberList); await _context.SaveChangesAsync(); isSaveSuccess = true; } return(isSaveSuccess); }
private async Task <SaveResult> ManageExistingTrainingPlanMember(TrainingPlanViewModel model, ICollection <TrainingPlanMember> currentEntityList, IQueryable <Member> roleAppPage) { SaveResult saveResult = new SaveResult { IsSuccess = true }; List <TrainingPlanMember> assignedTrainingPlanMembers = new List <TrainingPlanMember>(); foreach (var record in currentEntityList) { if (saveResult.IsSuccess) { if (!model.MemberIds.Any(a => a == record.MemberId)) { var deleteTrainingPlanMember = await _context.TrainingPlanMember.FindAsync(record.Id); if (saveResult.IsSuccess) { _context.Remove(deleteTrainingPlanMember); await _context.SaveChangesAsync(); saveResult.IsSuccess = true; } } else { saveResult = await EditEntityAsync(model, record); } } } return(saveResult); }
public ActionResult AddTrainingPlan() { TrainingPlanViewModel objVModel = new TrainingPlanViewModel(); int CurrentMonth = DateTime.Today.Month; int CurrentYear = DateTime.Today.Year; // Set Current Year if (CurrentMonth == 1 || CurrentMonth == 2 || CurrentMonth == 3) { objVModel.Year = CurrentYear - 1; } else { objVModel.Year = CurrentYear; } // Set Current Quarter switch (CurrentMonth) { case 1: case 2: case 3: objVModel.Quarter = 4; break; case 4: case 5: case 6: objVModel.Quarter = 1; break; case 7: case 8: case 9: objVModel.Quarter = 2; break; case 10: case 11: case 12: objVModel.Quarter = 3; break; default: break; } objVModel.Month = CurrentMonth; objVModel.Mode = "I"; objVModel.FlagEdit = true; TrainingPlanModel objSingle = new TrainingPlanModel(); objSingle.Year = objVModel.Year; objSingle.Quarter = objVModel.Quarter; objVModel.ListTrainingPan = _ItrainingService.GetTrainingPlan(objSingle); return(View(Common.Constants.CommonConstants.AddTrainingPlan, objVModel)); }
public ActionResult GetTrainingPLanByFacultyID(int ID) { Dictionary <int, List <Subject> > TrainingPlans = BUSProgram.GetShortContentDescriptionByFacultyID(ID); //List<GetTrainingPlanByFacultyID_Result> TrainingPlans = BUSProgram.GetTrainingPlanByFacultyID(ID); List <TrainingPlanViewModel> TrainingPlanViewModels = new List <TrainingPlanViewModel>(); foreach (KeyValuePair <int, List <Subject> > item in TrainingPlans) { TrainingPlanViewModel TrainPlaContVM = new TrainingPlanViewModel(); TrainPlaContVM.SemesterNumber = item.Key; TrainPlaContVM.Subjects = item.Value; foreach (var itemSub in item.Value) { TrainPlaContVM.CreditNumberTotal += itemSub.CreditNumber; TrainPlaContVM.LessonNumber += (itemSub.PracticeNumber + itemSub.TheoryNumber); } TrainingPlanViewModels.Add(TrainPlaContVM); } //foreach (var TrainPla in TrainingPlans) //{ // TrainingPlanViewModel TrainPlaViMo = new TrainingPlanViewModel(); // TrainPlaViMo.SemesterNumber = TrainPla.SemesterNumber; // TrainPlaViMo.LessonNumber = TrainPla.LessonNumber.Value; // TrainPlaViMo.CreditNumberTotal = TrainPla.CreditNumberTotal.Value; // string StrSubjectList = TrainPla.SubjectsList.TrimEnd(new[] { '|' }); // string[] ArrSubjectList = Regex.Split(StrSubjectList, @"\|\|"); // for (int i = 0; i < ArrSubjectList.Length; i++) // { // SubjectViewModel Subject = new SubjectViewModel(); // Subject.ID = Int32.Parse(Regex.Split(ArrSubjectList[i], @"\|")[0]); // Subject.PartialCode = Regex.Split(ArrSubjectList[i], @"\|")[1]; // Subject.Name = Regex.Split(ArrSubjectList[i], @"\|")[2]; // Subject.CreditNumber = Int32.Parse(Regex.Split(ArrSubjectList[i], @"\|")[3]); // Subject.TheoryNumber = Int32.Parse(Regex.Split(ArrSubjectList[i], @"\|")[4]); // Subject.PracticeNumber = Int32.Parse(Regex.Split(ArrSubjectList[i], @"\|")[5]); // Subject.TheoryPraciceNumberTotal = Subject.TheoryNumber + Subject.PracticeNumber; // Subject.SemesterNumber = TrainPla.SemesterNumber; // TrainPlaViMo.SubjectsList.Add(Subject); // } // TrainingPlanViewModels.Add(TrainPlaViMo); //} string HtmlResult = HelperAttribute.ViewUltility.RenderViewToString(this, "~/Views/Partials/TrainingPlan.cshtml", TrainingPlanViewModels); return(Json(new { HtmlResult = HtmlResult }, JsonRequestBehavior.AllowGet)); }
public async Task <IActionResult> Add([FromBody] TrainingPlanViewModel viewModel) { var entity = _mapper.Map <TrainingPlan>(viewModel); await _trainingPlanRepository.AddAsync(entity); return(Ok()); //TODO //return Created(); }
public async Task <SaveResult> SaveEntityList(TrainingPlanViewModel model, TrainingPlan parentEntity) { SaveResult saveResult = new SaveResult(); //List<int> MemberIds = new List<int> //{ // model.MemberId //}; //model.MemberIds = MemberIds; var currentEntities = parentEntity.TrainingPlanMembers; if (model.MemberIds == null) { if (currentEntities.Any()) { var TrainingPlanMemberIds = currentEntities.ToList().ToList().Select(b => b.Id); var toDeleteList = _context.TrainingPlanMember.Where(a => TrainingPlanMemberIds.Contains(a.Id)); _context.TrainingPlanMember.RemoveRange(toDeleteList); await _context.SaveChangesAsync(); saveResult.IsSuccess = true; } else { saveResult.IsSuccess = true; } } else { var regions = _context.Member.Where(a => model.MemberIds.Contains(a.Id)); if (currentEntities.Any()) { saveResult.IsSuccess = await AddTrainingPlanMemberWherePreviousExists(model, currentEntities, regions); if (saveResult.IsSuccess) { saveResult = await ManageExistingTrainingPlanMember(model, currentEntities, regions); } } else { saveResult.IsSuccess = await AddEntity(model, currentEntities, regions); } } return(saveResult); }
private async Task <SaveResult> EditEntityAsync(TrainingPlanViewModel model, TrainingPlanMember record) { var saveResult = new SaveResult(); var editTrainingPlanMember = await _context.TrainingPlanMember.FindAsync(record.Id); editTrainingPlanMember.ToEntity(record.MemberId, model.Id, model.SessionUserId); _context.Update(editTrainingPlanMember); await _context.SaveChangesAsync(); saveResult.IsSuccess = true; return(saveResult); }
public async Task <IActionResult> Edit([FromBody] TrainingPlanViewModel viewModel) { var contextEntry = await _trainingPlanRepository.GetAsync(viewModel.Id); if (contextEntry == null) { return(BadRequest()); } _mapper.Map(viewModel, contextEntry); await _trainingPlanRepository.EditAsync(contextEntry); return(Ok()); }
/// <summary> /// Convert TrainingPlan Entity into TrainingPlan Object /// </summary> ///<param name="model">TrainingPlanViewModel</param> ///<param name="TrainingPlanEntity">DataAccess.TrainingPlan</param> ///<returns>TrainingPlanViewModel</returns> public static TrainingPlanViewModel ToViewModel( this DataAccess.TrainingPlan entity, TrainingPlanViewModel model) { model.Id = entity.Id; model.EventId = entity.EventId; model.FinYearId = entity.FinYearId; model.Name = entity.Name; model.Objective = entity.Objective; model.FinYear = entity.FinYear.Name; model.Event = entity.Event.Name; model.MemberIds = entity.TrainingPlanMembers.Select(a => a.MemberId).ToArray(); model.DistanceIds = entity.TrainingPlanDistances.Select(a => a.DistanceId).ToArray(); model.RaceDefinitionIds = entity.TrainingPlanRaceDefinitions.Select(a => a.RaceDefinitionId).ToArray(); return(model); }
public PartialViewResult DeletePlan(int TrainingPlanId, int Year, int Quarter) { TrainingPlanViewModel obj = new TrainingPlanViewModel(); //TrainingPlanModel objModel = new TrainingPlanModel(); //objModel.Mode = "U"; //objModel.Year = Year; //objModel.Quarter = Quarter; obj.ListTrainingPan = _ItrainingService.DeleteTrainingPlan(TrainingPlanId, Convert.ToInt32(Session["EmpID"])); //Load ListPlan TrainingPlanModel objList = new TrainingPlanModel(); objList.Year = Year; objList.Quarter = Quarter; objList.TrainingPlanId = 0; obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objList); //obj.ListTrainingPan = obj.ListTrainingPan; obj.FlagEdit = true; return(PartialView(CommonConstants._PartialViewAddPlan, obj)); //obj.ListMonth = GetMonth(Quarter); //obj.Mode = "U"; //obj.Year = Year; //obj.Quarter = Quarter; //if (objModel.TrainingPlanId > 0) //{ // obj.TrainingName = obj.ListTrainingPan[0].TrainingId; // obj.Hrs = obj.ListTrainingPan[0].TrainingHour; // obj.TrainingType = obj.ListTrainingPan[0].TrainingTypeId; // obj.Month = obj.ListTrainingPan[0].Month; // obj.Target = obj.ListTrainingPan[0].Target; //} ////Load ListPlan //TrainingPlanModel objList = new TrainingPlanModel(); //objList.Year = Year; //objList.Quarter = Quarter; //objList.TrainingPlanId = 0; //obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objList); //obj.ListTrainingPan = obj.ListTrainingPan; //obj.FlagEdit = true; //return PartialView(CommonConstants._PartialViewAddPlan, obj); }
/// <summary> /// Convert TrainingPlan Object into TrainingPlan Entity /// </summary> ///<param name="model">TrainingPlan</param> ///<param name="TrainingPlanEntity">DataAccess.TrainingPlan</param> ///<returns>DataAccess.TrainingPlan</returns> public static DataAccess.TrainingPlan ToEntity(this TrainingPlanViewModel model, DataAccess.TrainingPlan entity) { if (entity.Id == 0) { entity.CreatedUserId = model.SessionUserId; entity.IsActive = model.IsActive; } else { entity.UpdatedUserId = model.SessionUserId; entity.UpdatedTimestamp = DateTime.Now; } entity.Name = model.Name; entity.Objective = model.Objective; entity.FinYearId = model.FinYearId; entity.EventId = model.EventId; return(entity); }
public async Task <TrainingPlanViewModel> GetPlanByIdAndDay(int Id, int Day, List <ExcerciseInPlan> userExser) { List <ExscercisePlanViewModel> excercises = new List <ExscercisePlanViewModel>(); var days = new List <int>(); for (int i = 0; i < userExser.Count; i++) { ExscercisePlanViewModel excer = new ExscercisePlanViewModel(); excer.setsNumber = userExser[i].SetsNumber; excer.Id = userExser[i].Excercise.Id; excer.Name = userExser[i].Excercise.Name; excer.TargetMuscleId = userExser[i].Excercise.TargetMuscleId; excer.AssistantMuscleId = userExser[i].Excercise.AssistantMuscleId; excer.Description = userExser[i].Excercise.Description; excer.TargetMuscle = userExser[i].Excercise.TargetMuscle; excer.AssistantMuscle = userExser[i].Excercise.AssistantMuscle; excer.Photo = userExser[i].Excercise.Photo; excercises.Add(excer); } var userExserDays = await _context.ExcercisesInPlan.Where(p => p.PlanId == Id).ToListAsync(); for (int i = 1; i < 7; i++) { var day = userExserDays.Find(x => x.Day == i); if (day != null) { days.Add(day.Day); } } var trainingPlan = new TrainingPlanViewModel() { planId = userExser[0].PlanId, muscleGroupId = userExser[0].MuscleGroupId, excercises = excercises, muscleGroupName = userExser[0].MuscleGroup.Name, planDiscription = userExser[0].TrainingPlan.Discription, day = userExser[0].Day, activeDays = days }; return(trainingPlan); }
public async Task <IActionResult> CreatePlan(TrainingPlanViewModel vm) { var planCreated = await trainingPlanService.CreateAsync(new PlanCreateRequestDto { PlanName = vm.PlanName, StartDate = vm.StartDate, Email = vm.Email }); return(RedirectToAction()); }
public ActionResult InsertUpdateTrainingPlan(TrainingPlanViewModel objTrPlan) { bool IsSuccess = false; TrainingPlanModel objTrainingPlan = new TrainingPlanModel(); if (ModelState.IsValid) { Master m = new Master(); if (objTrPlan.Mode == "I") { objTrainingPlan.TrainingPlanId = 0; } else { objTrainingPlan.TrainingPlanId = objTrPlan.TrainingPlanId; } objTrainingPlan.Quarter = objTrPlan.Quarter; objTrainingPlan.TrainingId = objTrPlan.TrainingName; if (objTrainingPlan.TrainingId == 1260) { objTrainingPlan.TrainingNameOther = objTrPlan.TrainingNameOther; } else { objTrainingPlan.TrainingNameOther = string.Empty; } objTrainingPlan.TrainingHour = objTrPlan.Hrs; objTrainingPlan.TrainingTypeId = objTrPlan.TrainingType; objTrainingPlan.Month = objTrPlan.Month; objTrainingPlan.Target = objTrPlan.Target; objTrainingPlan.Year = objTrPlan.Year; objTrainingPlan.Mode = objTrPlan.Mode; objTrainingPlan.CreatedById = m.GetEmployeeIDByEmailID(); if (!ModelState.IsValid) { return(View(objTrPlan)); } else { int savetStatus = _ItrainingService.InsertUpdateTrainingPlan(objTrainingPlan); if (savetStatus == 1) { IsSuccess = true; } } } else { return(View(objTrPlan)); } if (IsSuccess) { if (objTrPlan.Mode == "I") { TempData["Message"] = "Training created successfully."; } else { TempData["Message"] = "Training updated successfully."; } TrainingPlanModel objModel1 = new TrainingPlanModel(); objModel1.Year = objTrPlan.Year; objModel1.Quarter = objTrPlan.Quarter; objTrPlan.ListTrainingPan = _ItrainingService.GetTrainingPlan(objModel1); objTrPlan.FlagEdit = true; objTrPlan.ListTrainingName = CommonRepository.FillMasterDropDownList(CommonConstants.TrainingName); if (objTrPlan.ListTrainingPan.Count > 0) { objTrPlan.TrainingId = 0; objTrPlan.Hrs = null; objTrPlan.Target = ""; objTrPlan.Month = 0; objTrPlan.TrainingTypeId = 0; return(PartialView(CommonConstants._PartialViewAddPlan, objTrPlan)); } return(new EmptyResult()); } else { return(View(objTrPlan)); } }
public ActionResult ViewTrainingPlanned() { TrainingPlanViewModel objVModel = new TrainingPlanViewModel(); int CurrentMonth = DateTime.Today.Month; int CurrentYear = DateTime.Today.Year; // Set Current Year int Nextyear = CurrentYear; int NextQuarter = 0; if (CurrentMonth == 1 || CurrentMonth == 2 || CurrentMonth == 3) { objVModel.Year = CurrentYear - 1; Nextyear = CurrentYear; } else { objVModel.Year = CurrentYear; } //int Nextyear = objVModel.Year; // Set Current Quarter switch (CurrentMonth) { case 1: objVModel.Quarter = 4; NextQuarter = 4; break; case 2: objVModel.Quarter = 4; NextQuarter = 4; break; case 3: objVModel.Quarter = 4; NextQuarter = 1; break; case 4: objVModel.Quarter = 1; NextQuarter = 1; break; case 5: objVModel.Quarter = 1; NextQuarter = 1; break; case 6: objVModel.Quarter = 1; NextQuarter = 2; break; case 7: objVModel.Quarter = 2; NextQuarter = 2; break; case 8: objVModel.Quarter = 2; NextQuarter = 2; break; case 9: objVModel.Quarter = 2; NextQuarter = 3; break; case 10: objVModel.Quarter = 3; NextQuarter = 3; break; case 11: objVModel.Quarter = 3; NextQuarter = 3; break; case 12: objVModel.Quarter = 3; NextQuarter = 4; break; default: break; } objVModel.Month = CurrentMonth; objVModel.FlagEdit = false; objVModel.FlagEmployeePage = true; TrainingPlanModel objSingle = new TrainingPlanModel(); //objModel.ListTrainingPan; objSingle.Year = objVModel.Year; objSingle.Quarter = objVModel.Quarter; //List<TrainingPlanModel> objs = new List<TrainingPlanModel>(); //objModel.ListTrainingPan; objVModel.ListTrainingPan = _ItrainingService.GetTrainingPlanEmployees(objSingle, NextQuarter, Nextyear); return(View("TrainingPlanned", objVModel)); }
public PartialViewResult ShowPlan(int year, int Quarter, string Mode) { TrainingPlanViewModel obj = new TrainingPlanViewModel(); obj.ListMonth = GetMonth(Quarter); obj.Mode = Mode; obj.Year = year; obj.Quarter = Quarter; //Check Editable or not as per Current Month int CurrentMonth = DateTime.Today.Month; int CurrentYear = DateTime.Today.Year; if (CurrentMonth == 1 || CurrentMonth == 2 || CurrentMonth == 3) { CurrentYear = DateTime.Today.Year - 1; } int CurrentQuarter = 1; switch (CurrentMonth) { case 1: case 2: case 3: CurrentQuarter = 4; break; case 4: case 5: case 6: CurrentQuarter = 1; break; case 7: case 8: case 9: CurrentQuarter = 2; break; case 10: case 11: case 12: CurrentQuarter = 3; break; default: break; } if (year == CurrentYear && (Quarter == CurrentQuarter)) { obj.FlagEdit = true; } else { obj.FlagEdit = false; } TrainingPlanModel objModel = new TrainingPlanModel(); objModel.Mode = Mode; objModel.Year = year; objModel.Quarter = Quarter; obj.ListTrainingPan = _ItrainingService.GetTrainingPlan(objModel); return(PartialView(CommonConstants._PartialViewAddPlan, obj)); }