public ActionResult Registration(RegistrationDTO registrationDTO, string SubjectSelected) { if (!ModelState.IsValid) { return(Json(new ReturnFormat(400, "failed", null), JsonRequestBehavior.AllowGet)); } var school = (T_DM_Truong)Session[Constant.SCHOOL_SESSION]; if (school == null) { return(Json(new ReturnFormat(400, "failed", null), JsonRequestBehavior.AllowGet)); } using (var registrationService = new HDHocTapTraiNghiemService()) { Registration registration = registrationService.GetRegistrationsById(registrationDTO.Id); Mapper.Map(registrationDTO, registration); registration.SchoolName = school.TenTruong; registration.CreatedAt = DateTime.Now; registration.SchoolId = school.SchoolID; string[] arraySubject = SubjectSelected.Split(new char[] { ',' }); var inserted = registrationService.UpdateRegistration(registration); foreach (var item in arraySubject) { using (var subjectRegisted = new SubjectRegistedService()) { SubjectsRegisted subjectsRegisted = new SubjectsRegisted(); subjectsRegisted.SubjectId = Convert.ToInt32(item); subjectsRegisted.RegistrationId = registrationDTO.Id; subjectRegisted.CreateSubjectRegisted(subjectsRegisted); } } return(Json(new ReturnFormat(200, "success", null), JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> ExportHDHocTapTraiNghiem(DateTime dateFrom, DateTime dateTo) { Account account = (Account)Session[Utils.Constant.MANAGER_SESSION]; if (account == null) { return(RedirectToRoute("login")); } using (var social = new HDHocTapTraiNghiemService()) { List <Registration> registrations = social.GetRegistrations(dateFrom, dateTo); string fileName = string.Concat("ds-hdhoctaptrainghiem.xlsx"); string filePath = System.Web.HttpContext.Current.Server.MapPath("~/Utils/Files/" + fileName); List <SubjectsRegisted> subjectsRegisteds = new List <SubjectsRegisted>(); foreach (var item in registrations) { using (var subjectRegistedService = new SubjectRegistedService()) { List <SubjectsRegisted> subjectsRegistedsTmp = subjectRegistedService.GetSubjectsRegistedsByRegistrationId(item.Id); foreach (var item01 in subjectsRegistedsTmp) { subjectsRegisteds.Add(item01); } } } await Utils.ExportExcel.GenerateXLSHoatDongHocTapTraiNghiem(registrations, subjectsRegisteds, dateFrom, dateTo, filePath); return(File(filePath, "application/vnd.ms-excel", fileName)); } }
public ActionResult GetSubjectRegistedByRegistrationId(int id) { using (var subjectRegistedService = new SubjectRegistedService()) { var subject = subjectRegistedService.GetSubjectsRegistedsByRegistrationId(id); var subjectJson = JsonConvert.SerializeObject(subject, Formatting.None, new JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore }); return(Json(new ReturnFormat(200, "success", subjectJson), JsonRequestBehavior.AllowGet)); } }