public invalidityData selectinvalidity(string id)
{
invalidityData result = new invalidityData();
SQLiteCommand selectData = new SQLiteCommand();
SQLiteDataReader reader = null;
selectData.Connection = connection;
selectData.CommandText = "SELECT fio, sex, dateBirth, age, region, town, address, addressWork, position, lpz, invalidityDate, groupe, mkbCode, diagnose,"
+" addition FROM invalidityView WHERE id=:id";
selectData.Parameters.Add(":id", DbType.String);
selectData.Parameters[":id"].Value = id;
connect();
reader = selectData.ExecuteReader();
if (reader.Read())
{
result.fio = reader["fio"].ToString();
result.sex = reader["sex"].ToString();
result.dateBirth = Convert.ToDateTime(reader["dateBirth"].ToString());
result.age = reader["age"].ToString();
result.region = reader["region"].ToString();
result.town = reader["town"].ToString();
result.address = reader["address"].ToString();
result.addressWork = reader["addressWork"].ToString();
result.position = reader["position"].ToString();
result.LPZ = reader["lpz"].ToString();
result.InvalidityDate = Convert.ToDateTime(reader["invalidityDate"].ToString());
result.invalidityGroupe = reader["groupe"].ToString();
result.mkbCode = reader["mkbCode"].ToString();
result.diagnose = reader["diagnose"].ToString();
result.addition = reader["addition"].ToString();
}
reader.Close();
reader = null;
return result;
}
public void updateINdalidityData(invalidityData data, string id)
{
updateSQLCommand.CommandText = "UPDATE invalidity SET fio=:fio,sex=:sex,dateBirth=:dateBirth,age=:age,region_id=:region_id,town_id=:town_id,address=:town_id,"
+ "addressWork=:addressWork,position=:position,lpz_id=:lpz_id,invalidityDate=:invalidityDate,mkbCode=:mkbCode,diagnose=:diagnose"
+ ",addition=:addition,groupe=:groupe WHERE id=:id;";
updateSQLCommand.Parameters.Add(":id", DbType.String);
updateSQLCommand.Parameters[":id"].Value = id;
updateSQLCommand.Parameters.Add(":fio", DbType.String);
updateSQLCommand.Parameters[":fio"].Value = data.fio;
updateSQLCommand.Parameters.Add(":sex", DbType.String);
updateSQLCommand.Parameters[":sex"].Value = data.sex;
updateSQLCommand.Parameters.Add(":dateBirth", DbType.Date);
updateSQLCommand.Parameters[":dateBirth"].Value = data.dateBirth;
updateSQLCommand.Parameters.Add(":age", DbType.String);
updateSQLCommand.Parameters[":age"].Value = data.age;
updateSQLCommand.Parameters.Add(":region_id", DbType.String);
updateSQLCommand.Parameters[":region_id"].Value = getID(data.region, typesData.region);
updateSQLCommand.Parameters.Add(":town_id", DbType.String);
updateSQLCommand.Parameters[":town_id"].Value = getID(updateSQLCommand.Parameters[":region_id"].Value.ToString(), data.town);
updateSQLCommand.Parameters.Add(":address", DbType.String);
updateSQLCommand.Parameters[":address"].Value = data.address;
updateSQLCommand.Parameters.Add(":addressWork", DbType.String);
updateSQLCommand.Parameters[":addressWork"].Value = data.addressWork;
updateSQLCommand.Parameters.Add(":position", DbType.String);
updateSQLCommand.Parameters[":position"].Value = data.position;
updateSQLCommand.Parameters.Add(":lpz_id", DbType.String);
updateSQLCommand.Parameters[":lpz_id"].Value = getID(data.LPZ, typesData.lpz);
updateSQLCommand.Parameters.Add(":invalidityDate", DbType.Date);
updateSQLCommand.Parameters[":invalidityDate"].Value = data.InvalidityDate;
updateSQLCommand.Parameters.Add(":mkbCode", DbType.String);
updateSQLCommand.Parameters[":mkbCode"].Value = data.mkbCode;
updateSQLCommand.Parameters.Add(":diagnose", DbType.String);
updateSQLCommand.Parameters[":diagnose"].Value = data.diagnose;
updateSQLCommand.Parameters.Add(":addition", DbType.String);
updateSQLCommand.Parameters[":addition"].Value = data.addition;
updateSQLCommand.Parameters.Add(":groupe", DbType.String);
updateSQLCommand.Parameters[":groupe"].Value = getID(data.invalidityGroupe, typesData.invalidityGroupe);
connect();
updateSQLCommand.ExecuteNonQuery();
disconnect();
}
public void insertInvalidityData(invalidityData data)
{
insertSQLCommand.CommandText = "INSERT INTO invalidity (fio,sex,dateBirth,age,region_id,town_id,address,addressWork,position,lpz_id,invalidityDate,mkbCode,diagnose,addition,groupe)" +
"VALUES(:fio,:sex,:dateBirth,:age,:region_id,:town_id,:address,:addressWork,:position,:lpz_id,:invalidityDate,:mkbCode,:diagnose,:addition,:groupe);";
insertSQLCommand.Parameters.Add(":fio", DbType.String);
insertSQLCommand.Parameters[":fio"].Value = data.fio;
insertSQLCommand.Parameters.Add(":sex", DbType.String);
insertSQLCommand.Parameters[":sex"].Value = data.sex;
insertSQLCommand.Parameters.Add(":dateBirth", DbType.Date);
insertSQLCommand.Parameters[":dateBirth"].Value = data.dateBirth;
insertSQLCommand.Parameters.Add(":age", DbType.String);
insertSQLCommand.Parameters[":age"].Value = data.age;
insertSQLCommand.Parameters.Add(":region_id", DbType.String);
insertSQLCommand.Parameters[":region_id"].Value = getID(data.region, typesData.region);
insertSQLCommand.Parameters.Add(":town_id", DbType.String);
insertSQLCommand.Parameters[":town_id"].Value = getID(insertSQLCommand.Parameters[":region_id"].Value.ToString(), data.town);
insertSQLCommand.Parameters.Add(":address", DbType.String);
insertSQLCommand.Parameters[":address"].Value = data.address;
insertSQLCommand.Parameters.Add(":addressWork", DbType.String);
insertSQLCommand.Parameters[":addressWork"].Value = data.addressWork;
insertSQLCommand.Parameters.Add(":position", DbType.String);
insertSQLCommand.Parameters[":position"].Value = data.position;
insertSQLCommand.Parameters.Add(":lpz_id", DbType.String);
insertSQLCommand.Parameters[":lpz_id"].Value = getID(data.LPZ, typesData.lpz);
insertSQLCommand.Parameters.Add(":invalidityDate", DbType.Date);
insertSQLCommand.Parameters[":invalidityDate"].Value = data.InvalidityDate;
insertSQLCommand.Parameters.Add(":mkbCode", DbType.String);
insertSQLCommand.Parameters[":mkbCode"].Value = data.mkbCode;
insertSQLCommand.Parameters.Add(":diagnose", DbType.String);
insertSQLCommand.Parameters[":diagnose"].Value = data.diagnose;
insertSQLCommand.Parameters.Add(":addition", DbType.String);
insertSQLCommand.Parameters[":addition"].Value = data.addition;
insertSQLCommand.Parameters.Add(":groupe", DbType.String);
insertSQLCommand.Parameters[":groupe"].Value = getID(data.invalidityGroupe, typesData.invalidityGroupe);
connect();
insertSQLCommand.ExecuteNonQuery();
disconnect();
}
