/// <summary>
/// удалить пациента из БД
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Delete_Button(object sender, RoutedEventArgs e)
{
try
{
if (ListOrder.SelectedItems.Count > 0)
{
for (int i = 0; i < ListOrder.SelectedItems.Count; i++)
{
if (check_alco == true)
{
Alco alco = ListOrder.SelectedItems[i] as Alco;
if (alco != null)
{
db.Alcos.Remove(alco);
}
}
if (check_narco == true)
{
Narcoman narco = ListOrder.SelectedItems[i] as Narcoman;
if (narco != null)
{
db.Narcomans.Remove(narco);
}
}
if (check_poliz == true)
{
Polizavis poli = ListOrder.SelectedItems[i] as Polizavis;
if (poli != null)
{
db.Polizaviss.Remove(poli);
}
}
}
db.SaveChanges();
}
ListOrder.ItemsSource = null;
MessageBox.Show("Пациент удален");
}
catch (Exception ex)
{
ExcepLog.Excep(ex);
MessageBox.Show(ex.Message);
}
}
public static bool Download_Alco()
{
db = new ApplicationContext();
bool check = false;
int a = 0;
for (int i = 0; i < AlcoholismPersona.Count; i++)
{
Alco newAlcoPerson = new Alco
{
Id = Convert.ToInt32(AlcoholismPersona[i].Id),
FIO = AlcoholismPersona[i].FIO,
Sex = AlcoholismPersona[i].Sex,
Date = AlcoholismPersona[i].Date,
RegionCenterBLR = AlcoholismPersona[i].RegionCenterBLR,
RaenCenterBLR = AlcoholismPersona[i].RaenCenterBLR,
Life = AlcoholismPersona[i].Life,
Age = AlcoholismPersona[i].Age,
FamilyStatus = AlcoholismPersona[i].FamilyStatus,
CostOfKids = AlcoholismPersona[i].CostOfKids,
FamilyComposition = AlcoholismPersona[i].FamilyComposition,
Education = AlcoholismPersona[i].Education,
Profession = AlcoholismPersona[i].Profession,
TheSkillLevelOfTheProfession = AlcoholismPersona[i].TheSkillLevelOfTheProfession,
AddressOfRegistration = AlcoholismPersona[i].AddressOfRegistration,
AddressAtTheTimeOfDeath = AlcoholismPersona[i].AddressAtTheTimeOfDeath,
DataOfRegistration = AlcoholismPersona[i].DataOfRegistration,
ReRegistrationData = AlcoholismPersona[i].ReRegistrationData,
TypeOfRegistration = AlcoholismPersona[i].TypeOfRegistration,
Heredity = AlcoholismPersona[i].Heredity,
DisabilityGroup = AlcoholismPersona[i].DisabilityGroup,
DisabilityStatus = AlcoholismPersona[i].DisabilityStatus,
ReasonForDisability = AlcoholismPersona[i].ReasonForDisability,
WorksStatus = AlcoholismPersona[i].WorksStatus,
AdmOtv = AlcoholismPersona[i].AdmOtv,
UgOtv = AlcoholismPersona[i].UgOtv,
DlitsMLS = AlcoholismPersona[i].DlitsMLS,
Stat107 = AlcoholismPersona[i].Stat107,
StatUKRB = AlcoholismPersona[i].StatUKRB,
RodPrav = AlcoholismPersona[i].RodPrav,
NomLTP = AlcoholismPersona[i].NomLTP,
LTPKol = AlcoholismPersona[i].LTPKol,
Hospitel = AlcoholismPersona[i].Hospitel,
EK = AlcoholismPersona[i].EK,
DateOfDeregistration = AlcoholismPersona[i].DateOfDeregistration,
DateOfDead = AlcoholismPersona[i].DateOfDead,
PlaceOfDead = AlcoholismPersona[i].PlaceOfDead,
DeathCertificate = AlcoholismPersona[i].DeathCertificate,
CauseOfDead = AlcoholismPersona[i].CauseOfDead,
DeathCategory = AlcoholismPersona[i].DeathCategory,
OpeningPlace = AlcoholismPersona[i].OpeningPlace,
HistoryOfParasucicides = AlcoholismPersona[i].HistoryOfParasucicides,
FeaturesOfObservation = AlcoholismPersona[i].FeaturesOfObservation,
ExperienceAbuse = AlcoholismPersona[i].ExperienceAbuse,
AlcoholicDrinks = AlcoholismPersona[i].AlcoholicDrinks,
IK = AlcoholismPersona[i].IK,
DrugDiagnosisAlc = AlcoholismPersona[i].DrugDiagnosisAlc,
AgeOfRegistration = AlcoholismPersona[i].AgeOfRegistration,
AgeOfDead = AlcoholismPersona[i].AgeOfDead,
DataInfo = AlcoholismPersona[i].DataInfo,
Registrotor = Other.Regis,
};
db.Alcos.Add(newAlcoPerson);
db.SaveChanges();
a++;
}
db.Dispose();
if (a > 0)
{
check = true;
}
else
{
check = false;
}
AlcoholismPersona.Clear();
return(check);
}
public static void ReadExcel_Alco()
{
try
{
string ExcelFilePath = OpenFile.Open_File();
excelApp = new Excel.Application();
workBook = excelApp.Workbooks.Open(ExcelFilePath);
workSheet = (Worksheet)workBook.Worksheets.get_Item(1);
range = workSheet.UsedRange;
for (int cCnt = 2; cCnt <= range.Rows.Count; cCnt++)
{
Alco alcos = new Alco
{
FIO = Convert.ToString(workSheet.Cells[cCnt, 2].Value),
Sex = Convert.ToString(workSheet.Cells[cCnt, 3].Value),
Date = Convert.ToString(workSheet.Cells[cCnt, 4].Value),
RegionCenterBLR = Convert.ToString(workSheet.Cells[cCnt, 5].Value),
RaenCenterBLR = Convert.ToString(workSheet.Cells[cCnt, 6].Value),
Life = Convert.ToString(workSheet.Cells[cCnt, 7].Value),
Age = Convert.ToString(workSheet.Cells[cCnt, 8].Value),
FamilyStatus = Convert.ToString(workSheet.Cells[cCnt, 9].Value),
CostOfKids = Convert.ToString(workSheet.Cells[cCnt, 10].Value),
FamilyComposition = Convert.ToString(workSheet.Cells[cCnt, 11].Value),
Education = Convert.ToString(workSheet.Cells[cCnt, 12].Value),
Profession = Convert.ToString(workSheet.Cells[cCnt, 13].Value),
TheSkillLevelOfTheProfession = Convert.ToString(workSheet.Cells[cCnt, 14].Value),
AddressOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 15].Value),
AddressAtTheTimeOfDeath = Convert.ToString(workSheet.Cells[cCnt, 16].Value),
DataOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 17].Value),
ReRegistrationData = Convert.ToString(workSheet.Cells[cCnt, 18].Value),
TypeOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 19].Value),
Heredity = Convert.ToString(workSheet.Cells[cCnt, 20].Value),
DisabilityGroup = Convert.ToString(workSheet.Cells[cCnt, 21].Value),
DisabilityStatus = Convert.ToString(workSheet.Cells[cCnt, 22].Value),
ReasonForDisability = Convert.ToString(workSheet.Cells[cCnt, 23].Value),
WorksStatus = Convert.ToString(workSheet.Cells[cCnt, 24].Value),
AdmOtv = Convert.ToString(workSheet.Cells[cCnt, 25].Value),
UgOtv = Convert.ToString(workSheet.Cells[cCnt, 26].Value),
DlitsMLS = Convert.ToString(workSheet.Cells[cCnt, 27].Value),
Stat107 = Convert.ToString(workSheet.Cells[cCnt, 28].Value),
StatUKRB = Convert.ToString(workSheet.Cells[cCnt, 29].Value),
RodPrav = Convert.ToString(workSheet.Cells[cCnt, 30].Value),
NomLTP = Convert.ToString(workSheet.Cells[cCnt, 31].Value),
LTPKol = Convert.ToString(workSheet.Cells[cCnt, 32].Value),
Hospitel = Convert.ToString(workSheet.Cells[cCnt, 33].Value),
EK = Convert.ToString(workSheet.Cells[cCnt, 34].Value),
DateOfDeregistration = Convert.ToString(workSheet.Cells[cCnt, 35].Value),
DateOfDead = Convert.ToString(workSheet.Cells[cCnt, 36].Value),
PlaceOfDead = Convert.ToString(workSheet.Cells[cCnt, 37].Value),
DeathCertificate = Convert.ToString(workSheet.Cells[cCnt, 38].Value),
CauseOfDead = Convert.ToString(workSheet.Cells[cCnt, 39].Value),
DeathCategory = Convert.ToString(workSheet.Cells[cCnt, 40].Value),
OpeningPlace = Convert.ToString(workSheet.Cells[cCnt, 41].Value),
HistoryOfParasucicides = Convert.ToString(workSheet.Cells[cCnt, 42].Value),
FeaturesOfObservation = Convert.ToString(workSheet.Cells[cCnt, 43].Value),
ExperienceAbuse = Convert.ToString(workSheet.Cells[cCnt, 44].Value),
AlcoholicDrinks = Convert.ToString(workSheet.Cells[cCnt, 45].Value),
IK = Convert.ToString(workSheet.Cells[cCnt, 46].Value),
DrugDiagnosisAlc = Convert.ToString(workSheet.Cells[cCnt, 47].Value),
AgeOfRegistration = Convert.ToString(workSheet.Cells[cCnt, 48].Value),
AgeOfDead = Convert.ToString(workSheet.Cells[cCnt, 49].Value),
DataInfo = Convert.ToString(workSheet.Cells[cCnt, 50].Value),
Registrotor = Convert.ToString(workSheet.Cells[cCnt, 51].Value)
};
AlcoholismPersona.Add(alcos);
}
}
catch (Exception excep)
{
MessageBox.Show(excep.Message);
ExcepLog.Excep(excep);
}
finally
{
workBook.Close();
excelApp.Quit();
}
}
/// <summary>
/// записываем алкоголика в бд
/// </summary>
public static void Patient_Сreation_Alco(string fio, string sex, string data, string regionCenterBLR, string raenCenterBLR, string life, string age, string familyStatus,
string costOfKids, string familyComposition, string education, string profession, string theSkillLevelOfTheProfession, string addressOfRegistration,
string addressAtTheTimeOfDeath, string dataOfRegistration, string reRegistrationData, string typeOfRegistration, string heredity, string disabilityGroup,
string disabilityStatus, string reasonForDisability, string socialStatus, string admOtv, string ugOtv, string dlitMLS, string statja107, string statUKRB,
string rodPrav, string nomLTP, string LTPkol, string hosp, string EK, string dateOfDeregistration, string dateOfDead, string placeOfDead,
string deathCertificate, string causeOfDeat, string deathCategory, string openingPlace, string historyOfParasucicides, string featuresOfObservation,
string DrugDiagnosisAlc, string experienceAbuse, string AlcoholicDrinks, string IComorbidity, string ageOfDead, string ageOfRegistration, string dataInfo)
{
try
{
ApplicationContext db = new ApplicationContext();
//считываем из бд в массив данных
foreach (var item in db.Alcos)
{
Alco.AlcoholismPersona.Add(item);
}
//иницилизируем переменную Id
int IntId = 0;
//считаем сколько записей в бд
for (int i = 0; i < Alco.AlcoholismPersona.Count; i++)
{
IntId++;
}
Alco newAlcoPerson = new Alco
{
Id = IntId,
FIO = fio,
Sex = sex,
Date = data,
RegionCenterBLR = regionCenterBLR,
RaenCenterBLR = raenCenterBLR,
Life = life,
Age = age,
FamilyStatus = familyStatus,
CostOfKids = costOfKids,
FamilyComposition = familyComposition,
Education = education,
Profession = profession,
TheSkillLevelOfTheProfession = theSkillLevelOfTheProfession,
AddressOfRegistration = addressOfRegistration,
AddressAtTheTimeOfDeath = addressAtTheTimeOfDeath,
DataOfRegistration = dataOfRegistration,
ReRegistrationData = reRegistrationData,
TypeOfRegistration = typeOfRegistration,
Heredity = heredity,
DisabilityGroup = disabilityGroup,
DisabilityStatus = disabilityStatus,
ReasonForDisability = reasonForDisability,
WorksStatus = socialStatus,
AdmOtv = admOtv,
UgOtv = ugOtv,
DlitsMLS = dlitMLS,
Stat107 = statja107,
StatUKRB = statUKRB,
RodPrav = rodPrav,
NomLTP = nomLTP,
LTPKol = LTPkol,
Hospitel = hosp,
EK = EK,
DateOfDeregistration = dateOfDeregistration,
DateOfDead = dateOfDead,
PlaceOfDead = placeOfDead,
DeathCertificate = deathCertificate,
CauseOfDead = causeOfDeat,
DeathCategory = deathCategory,
OpeningPlace = openingPlace,
HistoryOfParasucicides = historyOfParasucicides,
FeaturesOfObservation = featuresOfObservation,
ExperienceAbuse = experienceAbuse,
AlcoholicDrinks = AlcoholicDrinks,
IK = IComorbidity,
DrugDiagnosisAlc = DrugDiagnosisAlc,
AgeOfRegistration = ageOfRegistration,
AgeOfDead = ageOfDead,
DataInfo = dataInfo,
Registrotor = Other.Regis,
};
db.Alcos.Add(newAlcoPerson);
db.SaveChanges();
db.Dispose();
Alco.AlcoholismPersona.Clear();
MessageBox.Show("Данные записаны");
}
catch (Exception excep)
{
MessageBox.Show("Произошла ошибка при добавленни данных в БД");
ExcepLog.Excep(excep);
return;
}
}
