private void RenumeratePlan_Click(object sender, EventArgs e) { var discList = Clipboard.GetText() .Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries) .ToList(); var plan = ((List <LearningPlan>)LearningPlanGridView.DataSource)[LearningPlanGridView.SelectedCells[0].RowIndex]; var disciplines = lpdRepo.learningPlanAll(plan.id); int newIndex = 1; for (int i = 0; i < discList.Count; i++) { LearningPlanDiscipline disc = null; do { disc = disciplines.FirstOrDefault(d => d.name == discList[i] && d.order == 0); if (disc != null) { disc.order = newIndex; lpdRepo.update(disc, disc.id); newIndex++; } } while (disc != null); } MessageBox.Show("Done"); }
public string update(LearningPlanDiscipline LearningPlanDiscipline, int id) { var response = ApiHelper.Post(ApiEndpoint + "/learningPlanDiscipline/" + id.ToString(), new Dictionary <string, string> { { "code", LearningPlanDiscipline.code }, { "name", LearningPlanDiscipline.name }, { "total_hours", LearningPlanDiscipline.total_hours.ToString() }, { "contact_work_hours", LearningPlanDiscipline.contact_work_hours.ToString() }, { "independent_work_hours", LearningPlanDiscipline.independent_work_hours.ToString() }, { "control_hours", LearningPlanDiscipline.control_hours.ToString() }, { "z_count", LearningPlanDiscipline.z_count.ToString() }, { "learning_plan_id", LearningPlanDiscipline.learning_plan_id.ToString() }, { "order", LearningPlanDiscipline.order.ToString() } }); return(response); }
private void addLPD_Click(object sender, EventArgs e) { var total_hours = 0; var contact_work_hours = 0; var independent_work_hours = 0; var control_hours = 0; var z_count = 0; try { total_hours = int.Parse(lpdTotalHours.Text); contact_work_hours = int.Parse(lpdContactWorkHours.Text); independent_work_hours = int.Parse(lpdIndependentWorkHours.Text); control_hours = int.Parse(lpdControlHours.Text); z_count = int.Parse(lpdZCount.Text); } catch { } if (LearningPlanGridView.SelectedCells.Count > 0) { var planId = ((List <LearningPlan>)LearningPlanGridView.DataSource)[LearningPlanGridView.SelectedCells[0].RowIndex].id; var newLearningPlanDiscipline = new LearningPlanDiscipline() { code = lpdCode.Text, name = lpdName.Text, total_hours = total_hours, contact_work_hours = contact_work_hours, independent_work_hours = independent_work_hours, control_hours = control_hours, z_count = z_count, learning_plan_id = planId, order = decimal.ToInt32(order.Value) }; lpdRepo.add(newLearningPlanDiscipline); RefreshLearningPlanDisciplinesList(planId); } }
private void importXLSPlanSpec_Click(object sender, EventArgs e) { var text = Clipboard.GetText(TextDataFormat.UnicodeText); var controlTask = ControlTaskExists.Checked; var split = text.Split(new string[] { Environment.NewLine }, StringSplitOptions.None) .Select(line => line.Split('\t').ToList()) .Where(line => line.Count > 2) .ToList(); var cti = 0; int planId = -1; if (LearningPlanGridView.SelectedCells.Count > 0) { planId = ((List <LearningPlan>)LearningPlanGridView.DataSource)[LearningPlanGridView.SelectedCells[0].RowIndex].id; } else { return; } for (int i = 0; i < split.Count; i++) { var disSplit = split[i]; if (disSplit[2].Trim() == "") { continue; } var newLearningPlanDiscipline = new LearningPlanDiscipline() { code = disSplit[1], name = disSplit[2], total_hours = string.IsNullOrEmpty(disSplit[10 + cti]) ? 0 : int.Parse(disSplit[10 + cti]), contact_work_hours = string.IsNullOrEmpty(disSplit[12 + cti]) ? 0 : int.Parse(disSplit[12 + cti]), independent_work_hours = string.IsNullOrEmpty(disSplit[13 + cti]) ? 0 : int.Parse(disSplit[13 + cti]), control_hours = string.IsNullOrEmpty(disSplit[14 + cti]) ? 0 : int.Parse(disSplit[14 + cti]), z_count = string.IsNullOrEmpty(disSplit[16 + cti]) ? 0 : int.Parse(disSplit[16 + cti]), learning_plan_id = planId }; var examSemesterList = ParseAttestationSemesters(disSplit[5]); var zachSemesterList = ParseAttestationSemesters(disSplit[6]); var zachWithMarkSemesterList = ParseAttestationSemesters(disSplit[7]); var courseProjectSemesterList = ParseAttestationSemesters(disSplit[8]); var courseTaskSemesterList = ParseAttestationSemesters(disSplit[9]); var controlTaskList = new List <int>(); if (controlTask) { controlTaskList = ParseAttestationSemesters(disSplit[10]); } var discIdString = lpdRepo.add(newLearningPlanDiscipline); var disciplineId = int.Parse(discIdString); int currentSemester; var SemesterFieldsDict = new Dictionary <int, List <int> > { { 1, new List <int> { 17 + cti, 18 + cti, 19 + cti, 20 + cti, 21 + cti, 22 + cti, 23 + cti } }, { 2, new List <int> { 24 + cti, 25 + cti, 26 + cti, 27 + cti, 28 + cti, 29 + cti, 30 + cti } }, { 3, new List <int> { 31 + cti, 32 + cti, 33 + cti, 34 + cti, 35 + cti, 36 + cti, 37 + cti } }, { 4, new List <int> { 38 + cti, 39 + cti, 40 + cti, 41 + cti, 42 + cti, 43 + cti, 44 + cti } }, { 5, new List <int> { 45 + cti, 46 + cti, 47 + cti, 48 + cti, 49 + cti, 50 + cti, 51 + cti } }, { 6, new List <int> { 52 + cti, 53 + cti, 54 + cti, 55 + cti, 56 + cti, 57 + cti, 58 + cti } }, { 7, new List <int> { 59 + cti, 60 + cti, 61 + cti, 62 + cti, 63 + cti, 64 + cti, 65 + cti } }, { 8, new List <int> { 66 + cti, 67 + cti, 68 + cti, 69 + cti, 70 + cti, 71 + cti, 72 + cti } }, }; for (int j = 1; j <= 8; j++) { currentSemester = j; var semesterFields = SemesterFieldsDict[j]; if (disSplit[semesterFields[6]] != "") // Z count { var newLearningPlanDisciplineSemester = new LearningPlanDisciplineSemester() { semester = currentSemester, lecture_hours = IntParseOrZero(disSplit[semesterFields[0]]), lab_hours = IntParseOrZero(disSplit[semesterFields[1]]), practice_hours = IntParseOrZero(disSplit[semesterFields[2]]), individual_hours = IntParseOrZero(disSplit[semesterFields[3]]), independent_work_hours = IntParseOrZero(disSplit[semesterFields[4]]), control_hours = IntParseOrZero(disSplit[semesterFields[5]]), z_count = IntParseOrZero(disSplit[semesterFields[6]]), zachet = zachSemesterList.Contains(currentSemester), exam = examSemesterList.Contains(currentSemester), zachet_with_mark = zachWithMarkSemesterList.Contains(currentSemester), course_project = courseProjectSemesterList.Contains(currentSemester), course_task = courseTaskSemesterList.Contains(currentSemester), control_task = controlTaskList.Contains(currentSemester), learning_plan_discipline_id = disciplineId }; lpdsRepo.add(newLearningPlanDisciplineSemester); } } } RefreshLearningPlanDisciplinesList(planId); var eprst = 999; }
private void importXLSPlanMag_Click(object sender, EventArgs e) { var text = Clipboard.GetText(TextDataFormat.UnicodeText); var Essay = EssayExists.Checked; var LawM = lawDM.Checked; var split = text.Split(new string[] { Environment.NewLine }, StringSplitOptions.None) .Select(line => line.Split('\t').ToList()) .Where(line => line.Count > 2) .ToList(); var essayI = Essay ? 1 : 0; var lawI = LawM ? -1 : 0; int planId = -1; if (LearningPlanGridView.SelectedCells.Count > 0) { planId = ((List <LearningPlan>)LearningPlanGridView.DataSource)[LearningPlanGridView.SelectedCells[0].RowIndex].id; } else { return; } for (int i = 0; i < split.Count; i++) { var disSplit = split[i]; if (disSplit[2].Trim() == "") { continue; } var newLearningPlanDiscipline = new LearningPlanDiscipline() { code = disSplit[1], name = disSplit[2], total_hours = string.IsNullOrEmpty(disSplit[13 + essayI + lawI]) ? 0 : int.Parse(disSplit[13 + essayI + lawI]), contact_work_hours = string.IsNullOrEmpty(disSplit[14 + essayI + lawI]) ? 0 : int.Parse(disSplit[14 + essayI + lawI]), independent_work_hours = string.IsNullOrEmpty(disSplit[15 + essayI + lawI]) ? 0 : int.Parse(disSplit[15 + essayI + lawI]), control_hours = string.IsNullOrEmpty(disSplit[16 + essayI + lawI]) ? 0 : int.Parse(disSplit[16 + essayI + lawI]), z_count = string.IsNullOrEmpty(disSplit[18 + essayI + lawI]) ? 0 : int.Parse(disSplit[18 + essayI + lawI]), learning_plan_id = planId }; var examSemesterList = ParseAttestationSemesters(disSplit[5 + lawI]); var zachSemesterList = ParseAttestationSemesters(disSplit[6 + lawI]); var zachWithMarkSemesterList = ParseAttestationSemesters(disSplit[7 + lawI]); var courseProjectSemesterList = ParseAttestationSemesters(disSplit[8 + lawI]); var courseTaskSemesterList = ParseAttestationSemesters(disSplit[9 + lawI]); var controlTaskList = ParseAttestationSemesters(disSplit[10 + lawI]); var referatSemesterList = ParseAttestationSemesters(disSplit[11 + lawI]); var essayTaskList = new List <int>(); if (Essay) { essayTaskList = ParseAttestationSemesters(disSplit[12]); } var discIdString = lpdRepo.add(newLearningPlanDiscipline); var disciplineId = int.Parse(discIdString); int currentSemester; var SemesterFieldsDict = new Dictionary <int, List <int> > { { 1, new List <int> { 19 + essayI + lawI, 20 + essayI + lawI, 21 + essayI + lawI, 22 + essayI + lawI, 23 + essayI + lawI, 24 + essayI + lawI } }, { 2, new List <int> { 25 + essayI + lawI, 26 + essayI + lawI, 27 + essayI + lawI, 28 + essayI + lawI, 29 + essayI + lawI, 30 + essayI + lawI } }, { 3, new List <int> { 31 + essayI + lawI, 32 + essayI + lawI, 33 + essayI + lawI, 34 + essayI + lawI, 35 + essayI + lawI, 36 + essayI + lawI } }, { 4, new List <int> { 37 + essayI + lawI, 38 + essayI + lawI, 39 + essayI + lawI, 40 + essayI + lawI, 41 + essayI + lawI, 42 + essayI + lawI } } }; for (int j = 1; j <= 4; j++) { currentSemester = j; var semesterFields = SemesterFieldsDict[j]; if (disSplit[semesterFields[5]] != "") // Z count { var newLearningPlanDisciplineSemester = new LearningPlanDisciplineSemester() { semester = currentSemester, lecture_hours = IntParseOrZero(disSplit[semesterFields[0]]), lab_hours = IntParseOrZero(disSplit[semesterFields[1]]), practice_hours = IntParseOrZero(disSplit[semesterFields[2]]), independent_work_hours = IntParseOrZero(disSplit[semesterFields[3]]), control_hours = IntParseOrZero(disSplit[semesterFields[4]]), z_count = IntParseOrZero(disSplit[semesterFields[5]]), zachet = zachSemesterList.Contains(currentSemester), exam = examSemesterList.Contains(currentSemester), zachet_with_mark = zachWithMarkSemesterList.Contains(currentSemester), course_project = courseProjectSemesterList.Contains(currentSemester), course_task = courseTaskSemesterList.Contains(currentSemester), control_task = controlTaskList.Contains(currentSemester), referat = referatSemesterList.Contains(currentSemester), essay = essayTaskList.Contains(currentSemester), learning_plan_discipline_id = disciplineId }; lpdsRepo.add(newLearningPlanDisciplineSemester); } } } RefreshLearningPlanDisciplinesList(planId); var eprst = 999; }