public void Update(StreetHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update streets set street_name = '{0}', areas = {1} where street_id = {2}; " +
"SET session_replication_role = DEFAULT;", table.NameLast, table.AreaLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update streets set street_name = '{0}', areas = {1} where street_id = {2}; " +
"SET session_replication_role = DEFAULT;", table.NameNow, table.AreaNow, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Update(DiagnosisHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update diagnosis set diagnosis_code = '{0}', diagnosis_description = '{1}' where diagnosis_id = {2}; " +
"SET session_replication_role = DEFAULT;", table.CodeLast, table.DescriptionLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update diagnosis set diagnosis_code = '{0}', diagnosis_description = '{1}' where diagnosis_id = {2}; " +
"SET session_replication_role = DEFAULT;", table.CodeNow, table.DescriptionNow, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(StreetHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into streets(street_id, street_name, areas) values({0}, '{1}', {2});" +
"SET session_replication_role = DEFAULT;", table.Id, table.NameLast, table.AreaLast);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into streets(street_id, street_name, areas) values({0}, '{1}', {2});" +
"SET session_replication_role = DEFAULT;", table.Id, table.NameNow, table.AreaNow);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Update(DoctorHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update doctors set doctor_surname = '{0}', doctor_name = '{1}', doctor_patronymic = '{2}', area = {3}, speciality = {4}, account = {5} where doctor_id = {6}; " +
"SET session_replication_role = DEFAULT;",
table.SurnameLast, table.NameLast, table.PatronymicLast, table.AreaLast, table.SpecialityLast, table.AccountLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update doctors set doctor_surname = '{0}', doctor_name = '{1}', doctor_patronymic = '{2}', area = {3}, speciality = {4}, account = {5} where doctor_id = {6}; " +
"SET session_replication_role = DEFAULT;",
table.SurnameNow, table.NameNow, table.PatronymicNow, table.AreaNow, table.SpecialityNow, table.AccountNow, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(DiagnosisHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into diagnosis(diagnosis_id, diagnosis_code, diagnosis_description) values({2}, '{0}', '{1}');" +
"SET session_replication_role = DEFAULT;", table.CodeLast, table.DescriptionLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into diagnosis(diagnosis_id, diagnosis_code, diagnosis_description) values({2}, '{0}', '{1}');" +
"SET session_replication_role = DEFAULT;", table.CodeNow, table.DescriptionNow, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Update(RecordHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update case_records set patient = {0}, diagnosis = {1}, therapy = '{2}' where case_id = {3}; " +
"SET session_replication_role = DEFAULT;", table.PatientLast, table.DiagnosisLast, table.TherapyLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update case_records set patient = {0}, diagnosis = {1}, therapy = '{2}' where case_id = {3}; " +
"SET session_replication_role = DEFAULT;", table.PatientNow, table.DiagnosisNow, table.TherapyNow, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(DoctorHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into doctors(doctor_id, doctor_surname, doctor_name, doctor_patronymic, area, speciality, account) values({0}, '{1}', '{2}', '{3}', {4}, {5}, {6});" +
"SET session_replication_role = DEFAULT;",
table.Id, table.SurnameLast, table.NameLast, table.PatronymicLast, table.AreaLast, table.SpecialityLast, table.AccountLast);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into doctors(doctor_id, doctor_surname, doctor_name, doctor_patronymic, area, speciality, account) values({0}, '{1}', '{2}', '{3}', {4}, {5}, {6});" +
"SET session_replication_role = DEFAULT;",
table.Id, table.SurnameNow, table.NameNow, table.PatronymicNow, table.AreaNow, table.SpecialityNow, table.AccountNow);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Update(PatientHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update patients set patient_surname = '{0}', patient_name = '{1}', patient_patronymic = '{2}', street = {3}, house = {4}, room = {5}, account = {6} where patient_id = {7}; " +
"SET session_replication_role = DEFAULT;",
table.SurnameLast, table.NameLast, table.PatronymicLast, table.StreetLast, table.HouseLast, table.RoomLast, table.AccountLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update patients set patient_surname = '{0}', patient_name = '{1}', patient_patronymic = '{2}', street = {3}, house = {4}, room = {5}, account = {6} where patient_id = {7}; " +
"SET session_replication_role = DEFAULT;",
table.SurnameNow, table.NameNow, table.PatronymicNow, table.StreetNow, table.HouseNow, table.RoomNow, table.AccountNow, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(RecordHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into case_records (case_id, patient, diagnosis, therapy) values ({0}, {1}, {3}, '{4}');" +
"SET session_replication_role = DEFAULT;",
table.Id, table.PatientLast, table.DiagnosisLast, table.TherapyLast);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into case_records (case_id, patient, diagnosis, therapy) values({0}, {1}, {3}, '{4}');" +
"SET session_replication_role = DEFAULT;",
table.Id, table.PatientNow, table.DiagnosisNow, table.TherapyNow);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(PatientHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into patients(patient_id, patient_surname, patient_name, patient_patronymic, street, house, room, account) values({0}, '{1}', '{2}', '{3}', {4}, {5}, {6}, {7});" +
"SET session_replication_role = DEFAULT;",
table.Id, table.SurnameLast, table.NameLast, table.PatronymicLast, table.StreetLast, table.HouseLast, table.RoomLast, table.AccountLast);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into patients(patient_id, patient_surname, patient_name, patient_patronymic, street, house, room, account) values({0}, '{1}', '{2}', '{3}', {4}, {5}, {6}, {7});" +
"SET session_replication_role = DEFAULT;",
table.Id, table.SurnameNow, table.NameNow, table.PatronymicNow, table.StreetNow, table.HouseNow, table.RoomNow, table.AccountNow);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(SpecialityHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into specialities(speciality_id, speciality_name) values({0}, '{1}');" +
"SET session_replication_role = DEFAULT;", table.Id, table.NameLast);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into specialities(speciality_id, speciality_name) values({0}, '{1}');" +
"SET session_replication_role = DEFAULT;", table.Id, table.NameNow);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Update(ReceptionHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update reception set reception_time = '{0}', patient = {1}, schedule = {2} where reception_id = {3}; " +
"SET session_replication_role = DEFAULT;", table.TimeLast, table.PatientLast, table.SheduleLast, table.Id);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"update reception set reception_time = '{0}', patient = {1}, schedule = {2} where reception_id = {3}; " +
"SET session_replication_role = DEFAULT;", table.TimeNow, table.PatientNow, table.SheduleLast, table.Id);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public void Insert(ReceptionHistory table, DoneStatusEnum done)
{
string sql = "";
if (done == DoneStatusEnum.Undone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into reception(reception_id, reception_time, patient, schedule) values({0}, '{1}', {2}, {3});" +
"SET session_replication_role = DEFAULT;",
table.Id, table.TimeLast, table.PatientLast, table.SheduleLast);
}
else if (done == DoneStatusEnum.Redone)
{
sql = String.Format("SET session_replication_role = replica;" +
"insert into reception(reception_id, reception_time, patient, schedule) values({0}, '{1}', {2}, {3});" +
"SET session_replication_role = DEFAULT;",
table.Id, table.TimeNow, table.PatientNow, table.SheduleLast);
}
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
public static int DiagnosisHistory(int current, DateTime time, DoneStatusEnum done)
{
string sql = String.Format("select * from {0} where operation_time < '{1}'", HistoryTableNamesEnum.diagnosis_history, time);
List <DiagnosisHistory> history = new List <DiagnosisHistory>();
DbWork db = new DbWork();
List <DbDataRecord> dbRecords = db.GetHistory(sql);
foreach (var record in dbRecords)
{
history.Add(new DiagnosisHistory(record));
}
history.Reverse();
CommonHistoryWork <DiagnosisHistory> common = new CommonHistoryWork <DiagnosisHistory>(current, time, history);
IBaseHistory <DiagnosisHistory> baseHistory = new DiagnosisBaseHistory();
if (done == DoneStatusEnum.Undone)
{
return(common.Undone(baseHistory));
}
else if (done == DoneStatusEnum.Redone)
{
return(common.Redone(baseHistory));
}
else
{
return(-1);
}
}
public void Delete(StreetHistory table, DoneStatusEnum done)
{
string sql = String.Format("SET session_replication_role = replica;" +
"delete from streets where street_id = {0};" +
"SET session_replication_role = DEFAULT;", table.Id);
try
{
DbWork db = new DbWork();
db.BaseOperation(sql);
}
catch (Exception ex)
{
}
}
