static void Main(string[] args)
{
Console.WriteLine("Check DB exists...");
if (Database.Exists("MedicalClinicDb"))
{
Console.WriteLine("DB exists. Deleting...");
Database.Delete("MedicalClinicDb");
}
else
{
Console.WriteLine("DB does not exist. Skip deleting.");
}
using (var db = new Db())
{
Console.WriteLine("Creating DB..");
Console.WriteLine("Employees...");
var belova = new Employee
{
FirstName = "Alina",
MiddleName = "Leonidovna",
LastName = "Belova",
LastLoginTime = DateTime.Now,
Login = "******",
Password = PasswordManager.CreateHash("123")
};
var admin = new Employee
{
FirstName = "-",
MiddleName = "-",
LastName = "-",
LastLoginTime = DateTime.Now,
Login = "******",
Password = PasswordManager.CreateHash("admin")
};
db.Employees.Add(belova);
db.Employees.Add(admin);
db.SaveChanges();
Console.WriteLine("Clients..");
var cl1 = new Client()
{
FirstName = "Ivan",
MiddleName = "Ivanovich",
LastName = "Ivanov",
BirthDate = new DateTime(2000, 01, 10),
Address = "Mira, 98",
Pasport = "1234567890",
Policy = "001122",
Disease = "Caries"
};
var cl2 = new Client()
{
FirstName = "Petr",
MiddleName = "Petrovich",
LastName = "Petrov",
BirthDate = new DateTime(1960, 05, 20),
Address = "Lenina, 74",
Pasport = "0987654312",
Policy = "213456",
Disease = "Poor eyesight"
};
var cl3 = new Client()
{
FirstName = "Petr",
MiddleName = "Ivanovich",
LastName = "Sidorov",
BirthDate = new DateTime(1971, 10, 11),
Address = "K.Marksa, 2",
Pasport = "4984654312",
Policy = "234567",
Disease = "/---/"
};
db.Clients.Add(cl1);
db.Clients.Add(cl2);
db.Clients.Add(cl3);
db.SaveChanges();
Console.WriteLine("Doctors...");
var doc1 = new Doctor()
{
Speciality = "Dentist",
FirstName = "Svetlana",
MiddleName = "Victorovna",
LastName = "Konova",
Cabinet = 15,
WorkHours = "10.00 - 15.00",
Cost = 750,
Talons = new List<Talon>
{
new Talon(){DateStart = new DateTime(2015, 07, 22, 10, 00, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 22, 10, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 22, 14, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 23, 10, 00, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 24, 10, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 25, 14, 30, 00)}
}
};
var doc2 = new Doctor()
{
Speciality = "Ophthalmologist",
FirstName = "Svetlana",
MiddleName = "Anatolyevna",
LastName = "Mangileva",
Cabinet = 2,
WorkHours = "8.00 - 13.00",
Cost = 600,
Talons = new List<Talon>
{
new Talon(){DateStart = new DateTime(2015, 07, 22, 8, 00, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 22, 8, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 22, 11, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 23, 8, 00, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 24, 8, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 25, 11, 30, 00)}
}
};
var doc3 = new Doctor()
{
Speciality = "Therapist",
FirstName = "Tatyana",
MiddleName = "Alexandrovna",
LastName = "Zavyalova",
Cabinet = 10,
WorkHours = "12.00 - 17.00",
Cost = 800,
Talons = new List<Talon>
{
new Talon(){DateStart = new DateTime(2015, 07, 22, 12, 00, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 22, 12, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 22, 16, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 28, 12, 00, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 29, 12, 30, 00)},
new Talon(){DateStart = new DateTime(2015, 07, 29, 16, 30, 00)}
}
};
db.Doctors.Add(doc1);
db.Doctors.Add(doc2);
db.Doctors.Add(doc3);
db.SaveChanges();
Console.WriteLine("Services..");
var s1 = new Service()
{
Name = "Whitening teeth",
Price = 1000
};
var s2 = new Service()
{
Name = "Injections",
Price = 300
};
var s3 = new Service()
{
Name="Massage",
Price = 2000
};
db.Services.Add(s1);
db.Services.Add(s2);
db.Services.Add(s3);
db.SaveChanges();
}
Console.WriteLine("Done! Cancel..");
Console.ReadKey();
}
private void Search()
{
using (StartOperation())
{
var query = RepositoryProvider.GetRepository<Doctor>().GetAll();
if (!Doctor.IsNullOrEmpty())
{
query = query.Where(d => d.Speciality.Contains(Doctor));
}
else if (!LastName.IsNullOrEmpty())
{
query = query.Where(d => d.LastName.Contains(LastName));
}
else
{
Doctors = new Doctor[] { };
return;
}
Doctors = query.ToList();
}
}