void DbInit()
{
NHibernateHelper.CreateSessionFactory(NHibernateHelper.Dialect.Sqlite, true);
using (var session = NHibernateHelper.CreateSessionFactory())
{
using (var transaction = session.BeginTransaction())
{
// Add state
var state01 = new State { Name = "Federal Capital Territory", Active = true };
// Add locations
var state01Location01 = new Location { Name = "Abaji" };
var state01Location02 = new Location { Name = "Abuja" };
var state01Location03 = new Location { Name = "Gwagwalada" };
var state01Location04 = new Location { Name = "Kuje" };
var state01Location05 = new Location { Name = "Bwari" };
var state01Location06 = new Location { Name = "Kwali" };
// logical add of locations
AddLocationsToState(state01,
state01Location01,
state01Location02,
state01Location03,
state01Location04,
state01Location05,
state01Location06
);
// insert categories (3 categories)
var category01 = new Category { Name = "Urban"};
var category02 = new Category { Name = "Semi-Urban" };
var category03 = new Category { Name = "Informal" };
// add costing (insert some category prices for each)
var costing01 = new Costing { EffectiveDate = DateTime.Now, RegistrationCost = 300.00M, RenewalCost = 200.00M, Category = category01, State = state01,};
var costing02 = new Costing { EffectiveDate = DateTime.Now, RegistrationCost = 200.00M, RenewalCost = 100.00M, Category = category02, State = state01, };
var costing03 = new Costing { EffectiveDate = DateTime.Now, RegistrationCost = 100.00M, RenewalCost = 50.00M, Category = category03, State = state01, };
AddCostingToCategory(category01, costing01);
AddCostingToCategory(category02, costing02);
AddCostingToCategory(category03, costing03);
// insert permissions
var permission01 = new Permission { Name = "Search Registrations" };
var permission02 = new Permission { Name = "Perform Registrations" };
var permission03 = new Permission { Name = "Manage Payments" };
var permission04 = new Permission { Name = "Manage Masterfiles" };
session.SaveOrUpdate(permission01);
session.SaveOrUpdate(permission02);
session.SaveOrUpdate(permission03);
session.SaveOrUpdate(permission04);
// insert roles
var role01 = new Role { Name = "Admin"};
var role02 = new Role { Name = "Clerk" };
session.SaveOrUpdate(role01);
session.SaveOrUpdate(role02);
var perms = new List<Permission>(session.CreateCriteria(typeof(Permission)).List<Permission>());
foreach (var p in perms)
{
var rp = new RolePermission
{
Role = role01,
Permission = p
};
session.SaveOrUpdate(rp);
}
// insert user (state, role, permission)
var user01 = new User
{
FirstName = "FCT Admin",
LastName = "",
Username = "******",
Password = "******",
EmailAddress = "*****@*****.**",
Mobile = "",
Active = true,
Created = DateTime.Now,
Modified = DateTime.Now,
Roles = new List<Role>
{
role01,
role02
},
State = state01
};
var user02 = new User
{
FirstName = "Lyall",
LastName = "van der Linde",
Username = "******",
Password = "******",
EmailAddress = "*****@*****.**",
Mobile = "0793874802",
Active = true,
Created = DateTime.Now,
Modified = DateTime.Now,
Roles = new List<Role>
{
role02
},
State = state01
};
// add services
var service01 = new Service { Name = "Doctors" };
var service02 = new Service { Name = "Radiology" };
var service03 = new Service { Name = "Pathology" };
var service04 = new Service { Name = "Theatre" };
session.SaveOrUpdate(service01);
session.SaveOrUpdate(service02);
session.SaveOrUpdate(service03);
session.SaveOrUpdate(service04);
// add staffings
var staffings01 = new Staffing { Name = "Medical Doctor" };
var staffings02 = new Staffing { Name = "Nurse" };
var staffings03 = new Staffing { Name = "Medical Lab Assistant" };
var staffings04 = new Staffing { Name = "Pharmacist" };
session.SaveOrUpdate(staffings01);
session.SaveOrUpdate(staffings02);
session.SaveOrUpdate(staffings03);
session.SaveOrUpdate(staffings04);
// register establishment (location, category, renewal)
var categories = new List<Category>(session.CreateCriteria(typeof(Category)).List<Category>());
var category = categories.FirstOrDefault(x => x.Name.Equals("Urban"));
var locations = new List<Location>(session.CreateCriteria(typeof(Location)).List<Location>());
var location = locations.FirstOrDefault(x => x.State.Id == 1);
var estType = new TypeOfEstablishment ();
estType.Name = "Hospital";
estType.AddStaff (staffings01);
estType.AddStaff (staffings02);
estType.AddStaff (staffings03);
estType.AddStaff (staffings04);
session.Save (estType);
var body = new ProfessionalBody ();
body.Name = "MEDICAL AND DENTAL COUNCIL OF NIGERIA (MDCN)";
session.Save (body);
//Staffing
var registration = new Registration
{
Category = category,
Location = location,
LastRenewalDate = null,
ProfessionalBodyAttendance = "",
ProfessionalBodyFirstName = "",
ProfessionalBodyLastName = "",
ProfessionalBodyRemarks = "",
ProfessionalBodyPosition = "",
MedicalDirectorFirstName = "",
AddressLine1 = "",
AddressLine2 = "",
MedicalDirectorEmailAddress = "",
AcceptanceDetailsReason = "",
ProprietorGender = "",
ProprietorFirstName = "",
ProprietorNinNumber = "",
ProfessionalBodyInvolvement = "",
ProprietorEmailAddress = "",
Lga = "",
CacNumber = "",
MedicalDirectorNinNumber = "",
MedicalDirectorLastName = "",
RegistrationDate = DateTime.Now,
MedicalDirectorGender = "",
EstablishmentName = "",
PhermcRegistrationNumber = "",
AdministratorMobile1 = "",
ProprietorIsMedicalDirector = false,
AcceptanceDetailsAccepted = true,
ProprietorMobile1 = "",
MedicalDirectorMobile1 = "",
LandMark = "",
AdministratorFirstName = "",
AdministratorLastName = "",
AdministratorMobile2 = "",
AmountPaid = 200.00M,
Created = DateTime.Now,
Deleted = false,
MedicalDirectorMobile2 = "",
Modified = DateTime.Now,
NoOfBeds = 10,
PaymentMethod = null,
ProfessionalBodySignatureDate = DateTime.Now,
ProprietorLastName = "",
ProprietorMobile2 = "",
ReferenceNumber = "",
RegistrationCosts = 0,
TypeOfEstablishment = estType,
ProfessionalBody = body
};
// add services
var services = new List<Service>(session.CreateCriteria(typeof(Service)).List<Service>());
var servicesToInsert = services.Where(x => x.Id >= 1);
foreach (var s in servicesToInsert)
{
var rs = new RegistrationService
{
Registration = registration,
Service = s,
Selected = true
};
registration.AddRegistrationService(rs);
}
// add staffing
var numbersToAdd = 0;
foreach (var s in estType.Staffings) {
var rts = new RegistrationTypeOfEstablishmentStaffing ();
rts.TypeOfEstablishment = estType;
rts.Staffing = s;
rts.NumberOfStaff = ++numbersToAdd;
registration.AddRegistrationTypeOfEstablishmentStaffing (rts);
}
// insert transactionTypes
var renewalType01 = new RenewalType
{
Name = "Registration"
};
var renewalType02 = new RenewalType
{
Name = "Renewal"
};
session.SaveOrUpdate(renewalType01);
session.SaveOrUpdate(renewalType02);
// insert paymentTypes
var paymentTypes01 = new PaymentType
{
Name = "Cash"
};
var paymentTypes02 = new PaymentType
{
Name = "Bank Deposit"
};
session.SaveOrUpdate(paymentTypes01);
session.SaveOrUpdate(paymentTypes02);
var renewalType = new List<RenewalType>(session.CreateCriteria(typeof(RenewalType)).List<RenewalType>());
var renewalTypeToInsert = renewalType.FirstOrDefault(x => x.Id >= 1);
// insert a renewal
var renewal = new Renewal
{
Registration = registration,
Date = DateTime.Now,
Amount = 200.00M,
Paid = false,
RenewalType = renewalTypeToInsert
};
// insert transactionTypes
var transactionType01 = new TransactionType
{
Name = "Registration"
};
var transactionType02 = new TransactionType
{
Name = "Renewal"
};
session.SaveOrUpdate(transactionType01);
session.SaveOrUpdate(transactionType02);
// insert a payment
var transactionType = new List<TransactionType>(session.CreateCriteria(typeof(TransactionType)).List<TransactionType>());
var transactionTypeToInsert = transactionType.FirstOrDefault(x => x.Id >= 1);
var newTransaction = new Transaction
{
Amount = 200.00M,
Date = DateTime.Now,
Renewal = renewal,
TransactionType = transactionTypeToInsert,
PaymentType = paymentTypes01,
ReceivedFrom = "Alison"
};
session.SaveOrUpdate(state01);
session.SaveOrUpdate(category01);
session.SaveOrUpdate(category02);
session.SaveOrUpdate(category03);
session.SaveOrUpdate(user01);
session.SaveOrUpdate(user02);
session.SaveOrUpdate(registration);
//session.SaveOrUpdate(renewal);
//session.SaveOrUpdate(newTransaction);
// *************
var q1 = new Question();
q1.Query = "A";
var q2 = new Question();
q2.Query = "B";
session.SaveOrUpdate(q1);
session.SaveOrUpdate(q2);
var survey = new Survey();
survey.Name = "Lyall";
survey.Surname = "van der Linde";
survey.EmailAddress = "*****@*****.**";
survey.MobileNumber = "0716541254";
survey.Registration = registration;
session.SaveOrUpdate(survey);
var surveyQuestion = new SurveyQuestion();
surveyQuestion.Survey = survey;
surveyQuestion.Question = q1.Query;
surveyQuestion.Rating = 4.2;
session.SaveOrUpdate(surveyQuestion);
surveyQuestion = new SurveyQuestion();
surveyQuestion.Survey = survey;
surveyQuestion.Question = q2.Query;
surveyQuestion.Rating = 5.3;
session.SaveOrUpdate(surveyQuestion);
// *************
transaction.Commit();
}
}
}