///
/// <param name="year"></param>
/// <param name="form"></param>
public void ShowPlanOfAdmission(int year, FormOfEducation form)
{
try
{
string sqlQuery = "SELECT SNAME,AMOUNT FROM 'PLANOFADMISSION'" +
" INNER JOIN 'SPECIALITY' ON SPECIID=SPECID " +
" WHERE PLAN_YEAR = " + year + " AND FORMID = " + (int)form + ";";
SQLiteDataReader reader = GetInfo.ExecuteSql(sqlQuery);
if (reader.HasRows)
{
while (reader.Read())
{
dataGridPlan.Rows.Add(new object[] {
reader.GetValue(0).ToString(),
reader.GetValue(1).ToString(),
});
}
}
else
{
dataGridPlan.Visible = false;
label2.Text = "Such information is not found!";
}
}
catch (SQLiteException ex)
{
MessageBox.Show("Oops...Something went wrong:(" + ex.ToString());
}
}
public string Save()
{
string error = "";
try
{
using (SQLDatabaseDataContext db = new SQLDatabaseDataContext(Program.Connectionstring))
{
FormOfEducation formOfEducation = new FormOfEducation();
if (this.ID > 0)
{
formOfEducation = (from foe in db.FormOfEducations where foe.ID == this.ID select foe).FirstOrDefault();
}
formOfEducation.Name = this.Name;
if (this.ID == 0)
{
db.FormOfEducations.InsertOnSubmit(formOfEducation);
}
db.SubmitChanges();
}
}
catch (Exception ex)
{
error = ex.Message;
}
return(error);
}
private void ButtonFind_Click(object sender, EventArgs e)
{
FormOfEducation form = FormOfEducation.partTimeForm;
if (!CheckingInfo.CheckCorectness(textYear.Text))
{
MessageBox.Show("Invalid year!");
}
else
{
if (RBExtramural.Checked)
{
form = FormOfEducation.extramuralForm;
}
else if (RBIntramural.Checked)
{
form = FormOfEducation.intramuralForm;
}
int year = Int32.Parse(textYear.Text);
Hide();
RequestFindForm reqForm = new RequestFindForm(form, year);
reqForm.Show();
}
}
public Student(string fullName, string group, int gpa, Gender gender, FormOfEducation formOfEducation, params int[] familySalary)
{
FullName = fullName;
Group = group;
GPA = gpa;
Gender = gender;
FormOfEducation = formOfEducation;
this.familySalary = familySalary.ToList();
}
public Student(string _name, string _group, double _averageScore, int _salary, Gender _gender, FormOfEducation _formOfEducation)
{
name = _name;
group = _group;
averageScore = _averageScore;
salary = _salary;
gender = _gender;
formOfEducation = _formOfEducation;
}
public Student(string nameStudent, string groupName, int averageMark, int incomeFamily, Gender gender, FormOfEducation formOfEducation)
{
FullName = nameStudent;
GroupName = groupName;
AverageMark = averageMark;
IncomeFamily = incomeFamily;
Gender = gender;
FormOfEducationStudent = formOfEducation;
}
public void Input()
{
WriteLine("Добавление студента\n");
Write("Введите ФИО: ");
FullName = ReadLine();
Write("Введите группу: ");
Group = ReadLine();
Write("Средний балл: ");
AverageScore = Int32.Parse(ReadLine());
Write("Доход(тг): ");
SalaryOnFamily = Int32.Parse(ReadLine());
WriteLine("Пол:\n\t1 - мужской\t2 - женский");
for (;;)
{
if (!Int32.TryParse(ReadLine(), out menu1))
{
continue;
}
if (menu1 == 1)
{
Sex = Sex.Male;
break;
}
else if (menu1 == 2)
{
Sex = Sex.Female;
break;
}
}
WriteLine("Форма обучения:\n\t1 - очное\t2 - заочное");
for (; ;)
{
if (!Int32.TryParse(ReadLine(), out menu2))
{
continue;
}
if (menu2 == 1)
{
Education = FormOfEducation.FullTime;
break;
}
else if (menu2 == 2)
{
Education = FormOfEducation.Distance;
break;
}
}
}
public RequestFindForm(FormOfEducation form, int reqYear)
{
InitializeComponent();
edForm = form;
year = reqYear;
}
public TFormOfEducation(FormOfEducation forme)
{
this.ID = forme.ID;
this.Name = forme.Name;
}
///
/// <param name="dep">Department of university</param>
/// <param name="fac">Faculty of university</param>
/// <param name="spec">Speciality of university</param>
/// <param name="form">Form of education</param>
public static bool AddEducationalUnit(Department dep, Faculty fac, Speciality spec, FormOfEducation form){
try
{
string sql = String.Format("INSERT INTO 'DEPARTMENT' (DEPCODE, DEPNAME, DEPSHORTNAME) VALUES ({0}, '{1}', '{2}');",
dep.Code, dep.Name, dep.ShortName);
if (!GetInfo.ExecuteReadSql(sql))
return false;
sql = String.Format("INSERT INTO 'FACULTY' (FACCODE, FACNAME, FACSHORTNAME, DEPRID) VALUES ({0}, '{1}', '{2}', {3});",
fac.Code, fac.Name, fac.ShortName, dep.Code);
if (!GetInfo.ExecuteReadSql(sql))
return false;
sql = String.Format("INSERT INTO 'SPECIALITY' (SCODE, SNAME, SSHORTNAME, FAID, FORMID, DEPARID) VALUES ({0}, '{1}', '{2}', {3}, {4}, {5});",
spec.Code, spec.Name, spec.ShortName, fac.Code, (int)form, dep.Code);
if (!GetInfo.ExecuteReadSql(sql))
return false;
}
catch(SQLiteException ex)
{
return false;
}
return true;
}
public static bool AddInfo(Department dep, Speciality spec, Faculty fac,Head head, string address, string phone, string site, int year, FormOfEducation form)
{
if (!AddContactInfo(phone, site, address, spec))
return false;
if (!AddEducationalUnit(dep, fac, spec, form))
return false;
if (!AddHead(head, dep, fac, spec, year))
return false;
return true;
}
public PlanOfAdmission(FormOfEducation edForm, int year)
{
InitializeComponent();
ShowPlanOfAdmission(year, edForm);
}
private void ButtonAdd_Click(object sender, EventArgs e)
{
Department dep = null;
Faculty fac = null;
Speciality spec = null;
Head head = null;
int year = 0;
string address = "";
string phone = "";
string site = "";
FormOfEducation edForm = FormOfEducation.intramuralForm;
if (textBoxDep.Text.Length != 0)
{
dep = new Department(GetInfo.DepMaxCode() + 1, textBoxDep.Text);
}
if (textBoxFac.Text.Length != 0)
{
fac = new Faculty(GetInfo.FacMaxCode() + 1, textBoxFac.Text);
}
if (textBoxSpec.Text.Length != 0)
{
spec = new Speciality(GetInfo.SpecMaxCode() + 1, textBoxFac.Text);
}
if (textBoxYear.Text.Length != 0 && CheckingInfo.CheckCorectness(textBoxYear.Text))
{
year = Int32.Parse(textBoxYear.Text);
}
if (textBoxName.Text.Length != 0 && textBoxRank.Text.Length != 0 && textBoxDegree.Text.Length != 0)
{
head = new Head(year, textBoxName.Text, textBoxDegree.Text, textBoxRank.Text);
}
if (textBoxAddress.Text.Length != 0)
{
address = textBoxAddress.Text;
}
if (textBoxPhone.Text.Length != 0)
{
phone = textBoxPhone.Text;
}
if (textBoxSite.Text.Length != 0)
{
site = textBoxSite.Text;
}
if (RBExtramural.Checked)
{
edForm = FormOfEducation.extramuralForm;
}
if (RBPart.Checked)
{
edForm = FormOfEducation.partTimeForm;
}
if (AddingInformation.AddInfo(dep, spec, fac, head, address, phone, site, year, edForm))
{
MessageBox.Show("Successfully added!");
}
else
{
MessageBox.Show("Error! Try again");
}
}
