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;
}
