///
/// <param name="phone">Phone number of university</param>
/// <param name="site">Website of university</param>
/// <param name="address">Address of university</param>
public static bool AddContactInfo(string phone, string site, string address, Speciality spec){
try
{
string sql = String.Format("INSERT INTO 'CONTACTINFO' (ADDRESS, PHONENUMBER, WEBSITE, SPECID) VALUES ('{0}', '{1}', '{2}', {3});",
address, phone, site, spec.Code);
if (!GetInfo.ExecuteReadSql(sql))
return false;
}
catch (SQLiteException ex)
{
return false;
}
return true;
}
///
/// <param name="item">Head of the university</param>
/// <param name="dep">Department of university</param>
/// <param name="fac">Faculty of university</param>
/// <param name="spec">Speciality of university</param>
public static bool AddHead(Head item, Department dep, Faculty fac, Speciality spec, int year)
{
try
{
string sql = String.Format("INSERT INTO 'LEADER' (NAME, SCDEGREE, SCRANK, STARTDATE,SID,DPID,FCID) VALUES ('{0}', '{1}', '{2}', {3}, {4}, {5},{6});",
item.Name, item.ScDegree, item.ScRank, year, spec.Code, dep.Code, fac.Code);
if (!GetInfo.ExecuteReadSql(sql))
return false;
}
catch (SQLiteException ex)
{
return false;
}
return true;
}
///
/// <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;
}
///
/// <param name="amount">Amount of people in plan</param>
/// <param name="name">Name of speciality</param>
public static bool UpdatePlanOfAdmission(string name, int amount){
string sql = String.Format("UPDATE 'PLANOFADMISSION' SET AMOUNT= {0} WHERE SPECIID= " +
"(SELECT SPECID FROM 'SPECIALITY' WHERE SNAME = \"{1}\") ;", amount, name);
return (GetInfo.ExecuteReadSql(sql));
}
///
/// <param name="score">Passing score on subject</param>
/// <param name="name">Name of subject</param>
public static bool UpdateMaxScore(string name, int score){
string sql = String.Format("UPDATE 'SUBJECT' SET PASSINGSCORE= {0} WHERE SUBJNAME= \"{1}\";", score, name);
return (GetInfo.ExecuteReadSql(sql));
}
///
/// <param name="name">Name of leader</param>
/// <param name="year">Start date of working</param>
public static bool UpdateHistory(string name, int year){
string sql = String.Format("UPDATE 'LEADER' SET STARTDATE= {0} WHERE NAME= \"{1}\";", year, name);
return (GetInfo.ExecuteReadSql(sql));
}
