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