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