public void addData(typesData typeData, string value) { switch (typeData) { case typesData.department: insertSQLCommand.CommandText = "INSERT INTO departments (title) VALUES(:value)"; break; case typesData.diagnose: insertSQLCommand.CommandText = "INSERT INTO diagnosis (title) VALUES(:value)"; break; case typesData.doctor: insertSQLCommand.CommandText = "INSERT INTO doctors (fio) VALUES(:value)"; break; case typesData.lkk: insertSQLCommand.CommandText = "INSERT INTO infedenceLKK (title) VALUES(:value)"; break; case typesData.region: insertSQLCommand.CommandText = "INSERT INTO regions (title) VALUES(:value)"; break; case typesData.lpz: insertSQLCommand.CommandText = "INSERT INTO lpz (title) VALUES(:value)"; break; } insertSQLCommand.Parameters.Add(":value", DbType.String); insertSQLCommand.Parameters[":value"].Value = value; connect(); insertSQLCommand.ExecuteNonQuery(); disconnect(); }
public void updateData(typesData typeData, string oldValue, string newValue) { switch (typeData) { case typesData.department: updateSQLCommand.CommandText = "UPDATE departments SET title=:newValue WHERE title=:oldValue"; break; case typesData.diagnose: updateSQLCommand.CommandText = "UPDATE diagnosis SET title=:newValue WHERE title=:oldValue"; break; case typesData.doctor: updateSQLCommand.CommandText = "UPDATE doctors SET fio=:newValue WHERE fio=:oldValue"; break; case typesData.lkk: updateSQLCommand.CommandText = "UPDATE infedenceLKK SET title=:newValue WHERE title=:oldValue"; break; case typesData.region: updateSQLCommand.CommandText = "UPDATE regions SET title=:newValue WHERE title=:oldValue"; break; } updateSQLCommand.Parameters.Add(":oldValue", DbType.String); updateSQLCommand.Parameters[":oldValue"].Value = oldValue; updateSQLCommand.Parameters.Add(":newValue", DbType.String); updateSQLCommand.Parameters[":newValue"].Value = newValue; connect(); updateSQLCommand.ExecuteNonQuery(); disconnect(); }
public void setDeleted(typesData typeData, string id) { SQLiteCommand deleteData = new SQLiteCommand(); deleteData.Connection = connection; switch (typeData) { case typesData.department: deleteData.CommandText = "UPDATE departments SET deleted='1' WHERE id=:id"; break; case typesData.diagnose: deleteData.CommandText = "UPDATE diagnosis SET deleted='1' WHERE id=:id"; break; case typesData.doctor: deleteData.CommandText = "UPDATE doctors SET deleted='1' WHERE id=:id"; break; case typesData.lkk: deleteData.CommandText = "UPDATE lkk SET deleted='1' WHERE id=:id"; break; case typesData.region: deleteData.CommandText = "UPDATE regions SET deleted='true' WHERE id=:id"; break; case typesData.town: deleteData.CommandText = "UPDATE towns SET deleted='1' WHERE id=:id"; break; case typesData.invalidityRedister: deleteData.CommandText = "UPDATE invalidity SET deleted='1' WHERE id=:id"; break; } connect(); deleteData.Parameters.Add(":id", DbType.String); deleteData.Parameters[":id"].Value = id; deleteData.ExecuteNonQuery(); disconnect(); }
public string getID(string parameter, typesData type) { string ID; ID = ""; switch (type) { case typesData.department: selectSQLCommand.CommandText = "SELECT id FROM departments WHERE title=:parameter"; break; case typesData.doctor: selectSQLCommand.CommandText = "SELECT id FROM doctors WHERE fio=:parameter"; break; case typesData.region: selectSQLCommand.CommandText = "SELECT id FROM regions WHERE title=:parameter"; break; case typesData.lpz: selectSQLCommand.CommandText = "SELECT id FROM lpz WHERE title=:parameter"; break; case typesData.diagnose: selectSQLCommand.CommandText = "SELECT codeMKB FROM diagnosis WHERE title=:parameter"; break; case typesData.mkbcode: selectSQLCommand.CommandText = "SELECT codeMKB FROM diagnosis WHERE codeMKB || ' ' || title =:parameter"; break; case typesData.headOfDepartment: selectSQLCommand.CommandText = "SELECT headOfDepartment FROM departments WHERE id =:parameter"; break; case typesData.invalidityGroupe: selectSQLCommand.CommandText = "SELECT id FROM invalidityGroups WHERE groupe =:parameter"; break; } selectSQLCommand.Parameters.Add(":parameter", DbType.String); selectSQLCommand.Parameters[":parameter"].Value = parameter; connect(); reader = selectSQLCommand.ExecuteReader(); if (reader.Read()) { ID = reader[0].ToString(); } reader.Close(); reader = null; disconnect(); return ID; }
public void deleteData(typesData typeData, string id) { switch (typeData) { case typesData.department: updateSQLCommand.CommandText = "SELECT count() FROM departments WHERE id=:id"; break; case typesData.diagnose: updateSQLCommand.CommandText = "SELECT count() FROM diagnosis WHERE id=:id"; break; case typesData.doctor: updateSQLCommand.CommandText = "SELECT count() FROM doctors WHERE id=:id"; break; case typesData.lkk: updateSQLCommand.CommandText = "UPDATE lkk SET deleted=0 WHERE id=:id"; break; case typesData.region: updateSQLCommand.CommandText = "SELECT count() FROM regions WHERE id=:id"; break; case typesData.town: updateSQLCommand.CommandText = "SELECT count() FROM towns WHERE id=:id"; break; } connect(); updateSQLCommand.Parameters.Add(":id", DbType.String); updateSQLCommand.Parameters[":id"].Value = id; reader = updateSQLCommand.ExecuteReader(); int count=1; if (reader.Read()) { count = Convert.ToInt32(reader[0].ToString()); } reader.Close(); reader = null; disconnect(); if (count > 0) setDeleted(typeData, id); else realyDelete(typeData, id); }
private void realyDelete(typesData typeData, string id) { switch (typeData) { case typesData.department: deleteSQLCommand.CommandText = "DELETE FROM departments WHERE id=:id"; break; case typesData.diagnose: deleteSQLCommand.CommandText = "DELETE FROM diagnosis WHERE id=:id"; break; case typesData.doctor: deleteSQLCommand.CommandText = "DELETE FROM doctors WHERE id=:id"; break; case typesData.lkk: deleteSQLCommand.CommandText = "DELETE FROM lkk WHERE id=:id"; break; case typesData.region: deleteSQLCommand.CommandText = "DELETE FROM regions WHERE id=:id"; break; case typesData.town: deleteSQLCommand.CommandText = "DELETE FROM towns WHERE id=:id"; break; } connect(); deleteSQLCommand.Parameters.Add(":id", DbType.String); deleteSQLCommand.Parameters[":id"].Value = id; deleteSQLCommand.ExecuteNonQuery(); disconnect(); }