public async Task SaveAsync(StudyForm entity)
{
try
{
if (entity == null)
{
return;
}
using (var timeLineContext = _contextFactory.GetTimeLineContext())
{
var entityModel = await timeLineContext
.StudyForms
.FirstOrDefaultAsync(item => item.Id.Equals(entity.Id));
if (entityModel == null)
{
entityModel = new DA.StudyForm();
MapForUpdateentity(entity, entityModel);
await timeLineContext.StudyForms.AddAsync(entityModel);
}
else
{
MapForUpdateentity(entity, entityModel);
}
timeLineContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void StudyFormEntityForm_Load(object sender, EventArgs e)
{
try
{
if (StudyFormId == 0)
{
this.Text = "Добавление формы обучения";
MesAccept = "Запись успешно добавлена";
}
else
{
this.Text = "Редактирование формы обучения";
using (ApplicationDbContext context = new ApplicationDbContext())
{
studyform = context.StudyForms.Find(StudyFormId);
metroTextBoxStudyFormName.Text = studyform.StudyFormName;
}
MesAccept = "Запись успешно изменена";
}
}
catch (Exception gg)
{
MessageBox.Show(gg.Message, "SWA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public Student(string name, string group, double averageMark, double familyMemberIncome, Gender gender, StudyForm studyForm)
{
Name = name;
Group = group;
AverageMark = averageMark;
FamilyMemberIncome = familyMemberIncome;
Gender = gender;
StudyForm = studyForm;
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
StudyForm studyForm = await db.StudyForms.FindAsync(id);
db.StudyForms.Remove(studyForm);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public Student(string FIO, string Group, double Average_score, int Min_salary)
{
Random rnd = new Random();
this.FIO = FIO;
this.Group = Group;
this.Average_score = Average_score;
Income_per_family_member = new int[2];
this.StudyForm = (StudyForm)rnd.Next(2);
}
public void WriteXml(XmlWriter writer)
{
writer.WriteString(Abbrevation);
writer.WriteString(Year.ToString());
writer.WriteString(Semester.ToString());
writer.WriteString(NumberOfStudents.ToString());
writer.WriteString(StudyForm.ToString());
writer.WriteString(StudyType.ToString());
writer.WriteString(Language.ToString());
}
public Group(string abbrevation, int year, Semester semester, int numberOfStudents, StudyForm studyForm, StudyType studyType, Language language)
{
Abbrevation = abbrevation;
Year = year;
Semester = semester;
NumberOfStudents = numberOfStudents;
StudyForm = studyForm;
StudyType = studyType;
Language = language;
}
public async Task <ActionResult> Edit([Bind(Include = "Form")] StudyForm studyForm)
{
if (ModelState.IsValid)
{
db.Entry(studyForm).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(studyForm));
}
public async Task <ActionResult> Create([Bind(Include = "Form")] StudyForm studyForm)
{
if (ModelState.IsValid)
{
db.StudyForms.Add(studyForm);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(studyForm));
}
protected override void Seed(SWA.ApplicationDbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
var dt1 = new DocumentType {
DocumentTypeName = "Входящий"
};
var dt2 = new DocumentType {
DocumentTypeName = "Исходящий"
};
var dt3 = new DocumentType {
DocumentTypeName = "Внутренний"
};
context.DocumentTypes.Add(dt1);
context.DocumentTypes.Add(dt2);
context.DocumentTypes.Add(dt3);
var sf = new StudyForm {
StudyFormName = "Дневная"
};
var s = new Specialty {
SpecialtyId = "Default", SpecialtyName = "Default"
};
var g1 = new Group {
GroupName = "Абитурьенты"
};
var g2 = new Group {
GroupName = "Отчисленные"
};
context.Groups.Add(g1);
context.Groups.Add(g2);
s.Groups.Add(g1);
s.Groups.Add(g2);
context.Specialties.Add(s);
sf.Specialties.Add(s);
context.StudyForms.Add(sf);
context.SaveChanges();
}
public async Task <IActionResult> Put([FromBody] StudyForm value)
{
try
{
var entity = _mapper.Map <BL.StudyForm>(value);
var id = _service.SaveAsync(entity);
return(Ok(id));
}
catch (Exception)
{
return(BadRequest());
}
}
// GET: StudyForms/Edit/5
public async Task <ActionResult> Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudyForm studyForm = await db.StudyForms.FindAsync(id);
if (studyForm == null)
{
return(HttpNotFound());
}
return(View(studyForm));
}
/**
* <summary> Constructor from known parameters. </summary>
* <param name="id"> Group's ID in the DB. </param>
* <param name="abbreviation"> Abbreaviation of the program the students are in. </param>
* <param name="name"> Name of the program the students are in. </param>
* <param name="year"> Year/grade to which students belong to. </param>
* <param name="semester"> Semester in which the students are. </param>
* <param name="form"> Form of study the students attend. </param>
* <param name="type"> Type of study the students are in. </param>
* <param name="language"> Language of study in which the student use. </param>
* <param name="studentCount"> Number of student's in a study group. </param>
*/
public StudentGroup(UInt32 id, string abbreviation, string name, StudyYear year,
StudySemester semester, StudyForm form, StudyType type, StudyLanguage language,
UInt16 studentCount)
{
this.Id = id;
this.Abbreviation = abbreviation;
this.Name = name;
this.Year = year;
this.Semester = semester;
this.Form = form;
this.Type = type;
this.Language = language;
this.StudentCount = studentCount;
this.Subjects = new Dictionary <UInt32, Subject>();
}
private void UpdateCollections(object sender, SelectionChangedEventArgs e)
{
var institutes = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential,
"GetInstitutes", "Institutes").Tables["Institutes"].Rows;
Institutes = Institute.GetCollection(institutes);
InstitutesComboBox.ItemsSource = Institutes.Select(i => i.InstituteSName).ToList();
var qualificationLevels = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential,
"GetQualificationLevels", "QualificationLevels").Tables["QualificationLevels"].Rows;
QualificationLevels = QualificationLevel.GetCollection(qualificationLevels);
var studyForms = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential,
"GetStudyForms", "StudyForms").Tables["StudyForms"].Rows;
StudyForms = StudyForm.GetCollection(studyForms);
var academicRanks = SqlServer.SqlServer.ExecuteStoredProcedure(_connectionString, _userCredential,
"GetAcademicRanks", "AcademicRanks").Tables["AcademicRanks"].Rows;
AcademicRanks = AcademicRank.GetCollection(academicRanks);
}
private void MapForUpdateentity(StudyForm entity, DA.StudyForm daEntity)
{
daEntity.Id = entity.Id;
}
static void Main(string[] args)
{
//1 HomeWork
Employee[] employees = new Employee[SetEmployeesCount()];
for (int i = 0; i < employees.Length; i++)
{
Console.WriteLine($"Заполнение данных о {i+Constants.LENTH_TO_INDEX} работнике");
string name = SetEmploeeName();
int receptiYear = SetRecepitDateYear();
Month receptiMonth = SetRecepitDateMonth();
int receptiDay = SetRecepitDateDay(receptiMonth, receptiYear);
Vacancies vacancies = SetEmploeeVacanci();
int salary = SetEmploeeSalary();
employees[i] = new Employee(name, vacancies, salary, receptiYear, receptiMonth, receptiDay);
}
Console.WriteLine();
Console.WriteLine("----------------------------------------");
//a
for (int i = 0; i < employees.Length; i++)
{
Console.WriteLine($"Информация про {i+Constants.LENTH_TO_INDEX} сотрудника");
Console.WriteLine(employees[i].GetFullInormation());
}
Console.WriteLine();
Console.WriteLine("----------------------------------------");
//b
int clercCout = Constants.NULL;
int allClerSalary = Constants.NULL;
for (int i = 0; i < employees.Length; i++)
{
if (employees[i].Vacancy == Vacancies.Clerk)
{
++clercCout;
allClerSalary += employees[i].Salary;
}
}
if (clercCout != Constants.NULL)
{
double averageClercSalary = allClerSalary / clercCout;
for (int i = 0; i < employees.Length; i++)
{
if (employees[i].Vacancy == Vacancies.Manager && employees[i].Salary >= averageClercSalary)
{
Console.WriteLine(employees[i].GetFullInormation());
}
}
Console.WriteLine();
Console.WriteLine("----------------------------------------");
}
bool flag = true;
while (flag)
{
flag = false;
for (int i = 0; i < employees.Length - Constants.LENTH_TO_INDEX; ++i)
{
if (employees[i].Name.CompareTo(employees[i + Constants.LENTH_TO_INDEX].Name) > 0)
{
string name = employees[i].Name;
Vacancies vacancies = employees[i].Vacancy;
int salary = employees[i].Salary;
int recepitYear = employees[i].RecepitDate[Constants.DATE_YEAR];
int recepitMonth = employees[i].RecepitDate[Constants.DATE_MONTH];
int recepitDay = employees[i].RecepitDate[Constants.DATE_DAY];
employees[i].Name = employees[i + Constants.LENTH_TO_INDEX].Name;
employees[i].Vacancy = employees[i + Constants.LENTH_TO_INDEX].Vacancy;
employees[i].Salary = employees[i + Constants.LENTH_TO_INDEX].Salary;
employees[i].RecepitDate[Constants.DATE_YEAR] = employees[i + Constants.LENTH_TO_INDEX].RecepitDate[Constants.DATE_YEAR];
employees[i].RecepitDate[Constants.DATE_MONTH] = employees[i + Constants.LENTH_TO_INDEX].RecepitDate[Constants.DATE_MONTH];
employees[i].RecepitDate[Constants.DATE_DAY] = employees[i + Constants.LENTH_TO_INDEX].RecepitDate[Constants.DATE_DAY];
employees[i + Constants.LENTH_TO_INDEX].Name = name;
employees[i + Constants.LENTH_TO_INDEX].Vacancy = vacancies;
employees[i + Constants.LENTH_TO_INDEX].Salary = salary;
employees[i + Constants.LENTH_TO_INDEX].RecepitDate[Constants.DATE_YEAR] = recepitYear;
employees[i + Constants.LENTH_TO_INDEX].RecepitDate[Constants.DATE_MONTH] = recepitMonth;
employees[i + Constants.LENTH_TO_INDEX].RecepitDate[Constants.DATE_DAY] = recepitDay;
flag = true;
}
}
}
for (int i = 0; i < employees.Length; i++)
{
if (employees[i].Vacancy == Vacancies.Manager)
{
Console.WriteLine(employees[i].GetFullInormation());
}
}
Console.WriteLine();
Console.WriteLine("----------------------------------------");
//c
int bossRecepitYear = Constants.NULL;
int bossRecepitMonth = Constants.NULL;
int bossRecepitDay = Constants.NULL;
for (int i = 0; i < employees.Length; i++)
{
if (employees[i].Vacancy == Vacancies.Boss)
{
bossRecepitDay = employees[i].RecepitDate[Constants.DATE_DAY];
bossRecepitMonth = employees[i].RecepitDate[Constants.DATE_MONTH];
bossRecepitYear = employees[i].RecepitDate[Constants.DATE_YEAR];
break;
}
}
for (int i = 0; i < employees.Length; i++)
{
if (employees[i].Vacancy == Vacancies.Manager)
{
if (employees[i].RecepitDate[Constants.DATE_YEAR] > bossRecepitYear)
{
Console.WriteLine(employees[i].GetFullInormation());
}
else if (employees[i].RecepitDate[Constants.DATE_YEAR] == bossRecepitYear)
{
if (employees[i].RecepitDate[Constants.DATE_MONTH] > bossRecepitMonth)
{
Console.WriteLine(employees[i].GetFullInormation());
}
else if (employees[i].RecepitDate[Constants.DATE_MONTH] == bossRecepitMonth)
{
if (employees[i].RecepitDate[Constants.DATE_DAY] > bossRecepitDay)
{
Console.WriteLine(employees[i].GetFullInormation());
}
}
}
}
}
Console.WriteLine("----------------------------------------");
Console.WriteLine();
Console.WriteLine();
Console.WriteLine();
//2 HomeWork
Student[] students = new Student[SetStudentCount()];
for (int i = 0; i < students.Length; i++)
{
string name = SetStudentName();
string group = SetStudentGroup();
double averageMark = SetStudentAverageMark();
double familyMemberIncome = SetStudentFamilyMemberIncome();
Gender gender = SetStudentGender();
StudyForm studyForm = SetStudentStudyForm();
students[i] = new Student(name, group, averageMark, familyMemberIncome, gender, studyForm);
}
bool flag_ = true;
while (flag_)
{
flag_ = false;
for (int i = 0; i < students.Length - Constants.LENTH_TO_INDEX; ++i)
{
if (students[i].FamilyMemberIncome.CompareTo(students[i + Constants.LENTH_TO_INDEX].FamilyMemberIncome) < 0)
{
string name = students[i].Name;
string group = students[i].Group;
double familyMemberIncome = students[i].FamilyMemberIncome;
double averageMark = students[i].AverageMark;
Gender gender = students[i].Gender;
StudyForm studyForm = students[i].StudyForm;
students[i].Name = students[i + Constants.LENTH_TO_INDEX].Name;
students[i].Group = students[i + Constants.LENTH_TO_INDEX].Group;
students[i].FamilyMemberIncome = students[i + Constants.LENTH_TO_INDEX].FamilyMemberIncome;
students[i].AverageMark = students[i + Constants.LENTH_TO_INDEX].AverageMark;
students[i].Gender = students[i + Constants.LENTH_TO_INDEX].Gender;
students[i].StudyForm = students[i + Constants.LENTH_TO_INDEX].StudyForm;
students[i + Constants.LENTH_TO_INDEX].Name = name;
students[i + Constants.LENTH_TO_INDEX].Group = group;
students[i + Constants.LENTH_TO_INDEX].FamilyMemberIncome = familyMemberIncome;
students[i + Constants.LENTH_TO_INDEX].AverageMark = averageMark;
students[i + Constants.LENTH_TO_INDEX].Gender = gender;
students[i + Constants.LENTH_TO_INDEX].StudyForm = studyForm;
flag_ = true;
}
}
}
for (int i = 0; i < students.Length; ++i)
{
if (students[i].FamilyMemberIncome <= Constants.MINIMAl_SALARY * Constants.DOUBLE)
{
Console.WriteLine(students[i].GetFullInfomation());
}
}
for (int i = 0; i < students.Length; ++i)
{
if (students[i].FamilyMemberIncome > Constants.MINIMAl_SALARY * Constants.DOUBLE)
{
Console.WriteLine(students[i].GetFullInfomation());
}
}
}
