//Добавление группы
public bool add(Gruppa gruppa)
{
bool result = true;
Connect();
loger.Info("Вызван метод " + new StackTrace(false).GetFrame(0).GetMethod().Name);
try
{
SqlCommand cmd = new SqlCommand("INSERT INTO Gruppa(GroupName, Backlavr, KafedraId) VALUES (@GroupNmae, @Bakalavr, @KafedraId)", Connection);
cmd.Parameters.Add(new SqlParameter("@GroupNmae", gruppa.groupName));
cmd.Parameters.Add(new SqlParameter("@Bakalavr", gruppa.bakalavr));
cmd.Parameters.Add(new SqlParameter("@KafedraId", gruppa.kafedra));
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
result = false;
loger.Error("Произошла ошибка при добавлении группы");
loger.Trace(e.StackTrace);
}
finally
{
Disconnect();
}
return(result);
}
//Вывод информации о группе
public ActionResult GetGroupInfo(int id)
{
List <Student> students = sDAO.getAllStudentInProup(id);
Gruppa group = gDAO.getGroupInfo(id);
StudentsInGroupView sIGV = new StudentsInGroupView(group, students);
return(View(sIGV));
}
//**********************************************************************************************************
//Предоставление информации
//**********************************************************************************************************
//Подробная информация о студенте
public ActionResult getStudentInfo(int id)
{
Student student = sDAO.getStudentInfo(id);
Gruppa gruppa = gDAO.getGroupInfo(student.gruppaId);
GroupAndStudentView gASV = new GroupAndStudentView(student, gruppa);
return(View(student));
}
private void button1_Click(object sender, System.EventArgs e)
{
int i;
Gruppa a = new Gruppa();
i = comboBox1.SelectedIndex;
label1.Text = "rate = " + a.studenti[i].rt;
}
public ActionResult AddGroup([Bind(Exclude = "ID")] Gruppa grup, int id)
{
Gruppa group = grup;
group.kafedra = id;
if (gDAO.add(grup))
{
return(RedirectToAction("getKafedraInfo", new { id = id }));
}
else
{
return(View("AddGroup"));
}
}
private void button2_Click(object sender, System.EventArgs e)
{
Gruppa b = new Gruppa();
int max = 0;
for (int i = 0; i < 3; i++)
{
if (max < b.studenti[i].rt)
{
max = b.studenti[i].rt;
}
}
label2.Text = " " + max;
}
//Запрос информации о группе
public Gruppa getGroupInfo(int id)
{
loger.Info("Вызван метод " + new StackTrace(false).GetFrame(0).GetMethod().Name);
Connect();
Gruppa group = new Gruppa();
try
{
SqlCommand cmd = new SqlCommand("SELECT * FROM Gruppa WHERE Id = @id", Connection);
cmd.Parameters.Add(new SqlParameter("@id", id));
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
int gId = Convert.ToInt32(reader["Id"]);
string groupName = Convert.ToString(reader["GroupName"]);
int kafedraId = Convert.ToInt32(reader["KafedraId"]);
bool study = Convert.ToBoolean(reader["Study"]);
bool isHasPlan = Convert.ToBoolean(reader["IsHasPlan"]);
group.id = gId;
group.groupName = groupName;
group.kafedra = kafedraId;
group.study = study;
group.isHasPlan = isHasPlan;
loger.Info("Успешный запрос информации о группе");
}
}
catch (Exception e)
{
loger.Error("Произошла ошибка при запросе информации о группе");
loger.Trace(e.StackTrace);
}
finally
{
Disconnect();
}
return(group);
}
static void Main()
{
if (Auth())
{
do
{
main:
ShowMainMenu();
var i = Convert.ToInt16(Console.ReadLine());
switch (i)
{
case 1:
{
levelup:
var stud = new Student();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
var codePerson = Convert.ToInt32(Console.ReadLine());
var firstName = Console.ReadLine();
var midName = Console.ReadLine();
var lastName = Console.ReadLine();
var dateofBirth = Convert.ToDateTime(Console.ReadLine());
var grupCode = Convert.ToInt16(Console.ReadLine());
var roleStud = Console.ReadLine();
var addrr = Console.ReadLine();
var phoneNum = Convert.ToInt32(Console.ReadLine());
var email = Console.ReadLine();
var dateBegin = Convert.ToDateTime(Console.ReadLine());
var dateEnd = Convert.ToDateTime(Console.ReadLine());
stud.InsertStud(codePerson, firstName, midName,
lastName, dateofBirth, grupCode, roleStud,
addrr, phoneNum, email, dateBegin, dateEnd);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
stud.GetStud();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
stud.SearchStud(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 2:
{
levelup:
var subj = new Subjects();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter code of teacher\t");
var tabNumPerson = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter code of speciality\t");
var tabNumSpec = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter code of teacher\t");
var tabNumSubj = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter name of subject\t");
var subject = Console.ReadLine();
Console.Write("Enter amount of hours\t");
var hour = Convert.ToSingle(Console.ReadLine());
subj.InsertToTableSubj(tabNumPerson, tabNumSpec, tabNumSubj, subject, hour);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
subj.GetTableSubj();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
subj.SearchInTableSubject(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 3:
{
levelup:
var group = new Gruppa();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter specialization code\t");
var codeSpec = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter group code\t");
var codeGroup = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter group name\t");
var nameGroup = Console.ReadLine();
Console.Write("Enter group curator\t");
var teacher = Console.ReadLine();
group.InsertToTableGruppa(codeSpec, codeGroup, nameGroup, teacher);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
group.GetTableGroup();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
group.SearchInTableGroup(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 4:
{
levelup:
var group = new Person();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter personnel number\t");
int codePerson = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter first name\t");
string firstName = Console.ReadLine();
Console.Write("Enter last name\t");
string lastName = Console.ReadLine();
Console.Write("Enter middle name\t");
string midName = Console.ReadLine();
Console.Write("Enter birthday\t");
DateTime dateofBirth;
DateTime.TryParse(Console.ReadLine(), out dateofBirth);
Console.Write("Enter position code\t");
int positionCode = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter department code\t");
int departamentCode = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter address\t");
string addrr = Console.ReadLine();
Console.Write("enter phone number\t");
int phoneNum = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter email\t");
string email = Console.ReadLine();
Console.Write("enter date of getting into the university\t");
DateTime dateBegin;
DateTime.TryParse(Console.ReadLine(), out dateBegin);
Console.Write("enter date of expulsion\t");
DateTime dateEnd;
DateTime.TryParse(Console.ReadLine(), out dateEnd);
group.InsertPerson(codePerson, firstName, lastName, midName, dateofBirth, positionCode,
departamentCode, addrr, phoneNum, email, dateBegin, dateEnd);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
group.GetTablePerson();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
group.SearchPerson(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 5:
{
levelup:
var spec = new Position();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter code of position\t");
var code1 = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter name\t");
var name = Console.ReadLine();
spec.InsertToTablePositions(code1, name);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
spec.GetTablePositions();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
spec.SearchInTablePositions(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 6:
{
levelup:
var spec = new Department();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter code of department\t");
var code1 = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter name\t");
var name = Console.ReadLine();
Console.Write("Enter code of speciality\t");
var specCode = Convert.ToInt32(Console.ReadLine());
spec.InsertToTableDep(code1, name, specCode);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
spec.GetTableDep();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
spec.SearchInTableDepartament(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 7:
{
levelup:
var spec = new InfLogin();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter personnel number\t");
var code1 = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter login\t");
var name = Console.ReadLine();
Console.Write("Enter password\t");
var specCode = (Console.ReadLine());
spec.InsertToTableInfLogin(code1, name, specCode);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
spec.GetTableInfLogin();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
spec.SearchInTableInfLogin(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
}
case 8:
{
levelup:
var spec = new Specialization();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter code of speciality\t");
var code1 = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter code of specialization\t");
var code2 = Convert.ToInt32(Console.ReadLine());
Console.Write("Enter name of specialization");
var name = Console.ReadLine();
spec.InsertToTableSpecialization(code1, code2, name);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
spec.GetTableSpecialization();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
spec.SearchInTableSpecialization(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 9:
{
levelup:
var spec = new Speciality();
ShowDetailedMenu();
var j = Convert.ToInt16(Console.ReadLine());
if (j == 1)
{
Console.Clear();
Console.WriteLine("Enter data:");
Console.Write("Enter code of speciality\t");
var code1 = (Console.ReadLine());
Console.Write("Enter name of specialty");
var name = Console.ReadLine();
spec.InsertToTableSpeciality(code1, name);
Console.Write("added successfully");
Console.ReadKey(true);
goto main;
}
else if (j == 2)
{
Console.Clear();
spec.GetTableSpeciality();
Console.ReadKey(true);
goto main;
}
else if (j == 3)
{
Console.Write("Enter argument\t");
spec.SearchInTableSpeciality(Console.ReadLine());
Console.ReadKey(true);
goto main;
}
else if (j == 4)
{
goto main;
}
else if (j == 5)
{
Environment.Exit(0);
}
else
{
Console.WriteLine("wrong number");
goto levelup;
}
break;
}
case 10:
{
Environment.Exit(0);
break;
}
default: goto main;
}
} while (true);
}
MessageBox.Show("wrong pass"); //Environment.Exit(0);
}
