public void TypeCompany_CreatesSuccessfully()
{
var organisation = new Organisation(AnyString, BusinessType.LimitedCompany, null);
Assert.Equal(AnyString, organisation.Name);
Assert.Equal(BusinessType.LimitedCompany, organisation.Type);
}
public Invoice(int invoice_id, int entity_id, int invoice_type_id, int booking_id, int payer_organisation_id, int payer_patient_id, int non_booking_invoice_organisation_id, string healthcare_claim_number, int reject_letter_id, string message,
int staff_id, int site_id, DateTime invoice_date_added, decimal total, decimal gst, decimal receipts_total, decimal vouchers_total, decimal credit_notes_total, decimal refunds_total,
bool is_paid, bool is_refund, bool is_batched, int reversed_by, DateTime reversed_date, DateTime last_date_emailed)
{
this.invoice_id = invoice_id;
this.entity_id = entity_id;
this.invoice_type = new IDandDescr(invoice_type_id);
this.booking = booking_id == -1 ? null : new Booking(booking_id);
this.payer_organisation = payer_organisation_id == 0 ? null : new Organisation(payer_organisation_id);
this.payer_patient = payer_patient_id == -1 ? null : new Patient(payer_patient_id);
this.non_booking_invoice_organisation = non_booking_invoice_organisation_id == -1 ? null : new Organisation(non_booking_invoice_organisation_id);
this.healthcare_claim_number = healthcare_claim_number;
this.reject_letter = reject_letter_id == -1 ? null : new Letter(reject_letter_id);
this.message = message;
this.staff = new Staff(staff_id);
this.site = site_id == -1 ? null : new Site(site_id);
this.invoice_date_added = invoice_date_added;
this.total = total;
this.gst = gst;
this.receipts_total = receipts_total;
this.vouchers_total = vouchers_total;
this.credit_notes_total = credit_notes_total;
this.refunds_total = refunds_total;
this.is_paid = is_paid;
this.is_refund = is_refund;
this.is_batched = is_batched;
this.reversed_by = reversed_by == -1 ? null : new Staff(reversed_by);
this.reversed_date = reversed_date;
this.last_date_emailed = last_date_emailed;
}
public RegisterPatient(int register_patient_id, int organisation_id, int patient_id, DateTime register_patient_date_added)
{
this.register_patient_id = register_patient_id;
this.organisation = new Organisation(organisation_id);
this.patient = new Patient(patient_id);
this.register_patient_date_added = register_patient_date_added;
}
public Fantassin(string nom, Organisation etatMajor) : base(nom, etatMajor)
{
ComportementCombat = new ComportementApiedAvecHache();
ComportementEmettreUnSon = new ComportementCrier();
ComportementDeplace = new ComportementDeplaceApied();
ComportementAffichage = new ComportementAffichageHumble();
}
/// <summary>
/// Add a new client
/// </summary>
/// <param name="oHostSecurityToken">HostSecurityToken obtained when security provider of IWS is called</param>
/// <param name="client">client details</param>
/// <param name="person">Person details</param>
/// <param name="organisation">Organisation details</param>
/// <param name="addresses">Addresses</param>
/// <param name="addressInformation"></param>
/// <returns></returns>
public ClientReturnValue AddClient(HostSecurityToken oHostSecurityToken, Client client,
Person person,
Organisation organisation,
List<Address> addresses,
List<AdditionalAddressElement> addressInformation)
{
ClientReturnValue returnValue = null;
try
{
if (Functions.ValidateIWSToken(oHostSecurityToken))
{
oClientService = new ClientService();
returnValue = oClientService.AddClient(Functions.GetLogonIdFromToken(oHostSecurityToken), client, person, organisation, addresses, addressInformation);
}
else
{
returnValue = new ClientReturnValue();
returnValue.Success = false;
returnValue.Message = "Invalid Token";
}
}
catch (Exception ex)
{
returnValue = new ClientReturnValue();
returnValue.Success = false;
returnValue.Message = ex.Message;
}
return returnValue;
}
public Chevalier(string nom, Organisation etatMajor) : base(nom, etatMajor)
{
ComportementCombat = new ComportementAcheval();
ComportementEmettreUnSon = new ComportementParler();
ComportementDeplace = new ComportementDeplaceAcheval();
ComportementAffichage = new ComportementAffichageNoble();
}
public override string ToString()
{
if (string.IsNullOrWhiteSpace (FName))
throw new ApplicationException ("First name is mandatory.");
Organisation organisation = new Organisation ("");
return string.Format ("[Employee: FName={0}, LName={1} belonogs to department {3} with registered id Id={2}]", FName, LName, Id,organisation.Department);
}
public Stock(int stock_id, int organisation_id, int offering_id, int qty, int warning_amt)
{
this.stock_id = stock_id;
this.organisation = new Organisation(organisation_id);
this.offering = new Offering(offering_id);
this.qty = qty;
this.warning_amt = warning_amt;
}
public OrganisationOfferings(int organisation_offering_id, int organisation_id, int offering_id, decimal price, DateTime date_active)
{
this.organisation_offering_id = organisation_offering_id;
this.organisation = new Organisation(organisation_id);
this.offering = new Offering(offering_id);
this.price = price;
this.date_active = date_active;
}
public PatientReferrer(int patient_referrer_id, int patient_id, int register_referrer_id, int organisation_id, DateTime patient_referrer_date_added, bool is_debtor)
{
this.patient_referrer_id = patient_referrer_id;
this.patient = new Patient(patient_id);
this.registerReferrer = register_referrer_id == -1 ? null : new RegisterReferrer(register_referrer_id);
this.organisation = organisation_id == 0 ? null : new Organisation(organisation_id);
this.patient_referrer_date_added = patient_referrer_date_added;
this.is_debtor = is_debtor;
}
public void CanLinkToOrganisation()
{
var address = new Address("address1", "address2", "town", "region", "postcode", "country");
var org = new Organisation("name", AnyType, "123");
anyUser.LinkToOrganisation(org);
Assert.NotNull(anyUser.Organisation);
}
public Scheme(Organisation organisation)
{
Guard.ArgumentNotNull(() => organisation, organisation);
Organisation = organisation;
OrganisationId = organisation.Id;
SchemeStatus = SchemeStatus.Pending;
ApprovalNumber = string.Empty;
}
public static Booking[] GetBetween(bool debugPageLoadTime, DateTime date_start, DateTime date_end, Staff[] staff, Organisation[] organisations, Patient patient, Staff added_by, bool incDeleted = false, string statusIDsToInclude = null, bool onlyUnavailabilities = false, string booking_id_serach = "")
{
DataTable tbl = GetDataTable_Between(debugPageLoadTime, date_start, date_end, staff, organisations, patient, added_by, incDeleted, statusIDsToInclude, onlyUnavailabilities, booking_id_serach);
Booking[] bookings = new Booking[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
bookings[i] = LoadFull(tbl.Rows[i]);
return bookings;
}
public static Organisation[] GetAll(bool showDeleted = false, bool exclGroupOrg = true, bool exclClinics = false, bool exclAgedCareFacs = false, bool exclIns = true, bool exclExternal = false, string matchName = "", bool searchNameOnlyStartsWith = false, string org_type_ids = "")
{
DataTable tbl = GetDataTable(0, showDeleted, exclGroupOrg, exclClinics, exclAgedCareFacs, exclIns, exclExternal, matchName, searchNameOnlyStartsWith, org_type_ids);
Organisation[] list = new Organisation[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
list[i] = Load(tbl.Rows[i]);
return list;
}
public StockUpdateHistory(int stock_update_history_id, int organisation_id, int offering_id, int qty_added, bool is_created, bool is_deleted, int added_by, DateTime date_added)
{
this.stock_update_history_id = stock_update_history_id;
this.organisation = new Organisation(organisation_id);
this.offering = new Offering(offering_id);
this.qty_added = qty_added;
this.is_created = is_created;
this.is_deleted = is_deleted;
this.added_by = added_by == -1 ? null : new Staff(added_by);
this.date_added = date_added;
}
public OfferingOrder(int offering_order_id, int offering_id, int organisation_id, int staff_id, int patient_id, int quantity,
DateTime date_ordered, DateTime date_filled, DateTime date_cancelled, string descr)
{
this.offering_order_id = offering_order_id;
this.offering = new Offering(offering_id);
this.organisation = new Organisation(organisation_id);
this.staff = new Staff(staff_id);
this.patient = new Patient(patient_id);
this.quantity = quantity;
this.date_ordered = date_ordered;
this.date_filled = date_filled;
this.date_cancelled = date_cancelled;
this.descr = descr;
}
public void CannotLinkToSecondOrganisation()
{
var address = new Address("address1", "address2", "town", "region", "postcode", "country");
var org = new Organisation("name", AnyType, "123");
anyUser.LinkToOrganisation(org);
var secondAddress = new Address("address12", "address22", "town2", "region2", "postcode2", "country2");
var secondOrg = new Organisation("name2", AnyType, "1232");
Action linkToOrganisation = () => anyUser.LinkToOrganisation(secondOrg);
Assert.Throws<InvalidOperationException>(linkToOrganisation);
}
static void CreateRelationship(RestClient client, Root root, int zephyrTestCaseId, int zephyrRequirementId, Options options, Organisation org)
{
Script script = client.GetScriptByZephyrId(root, zephyrTestCaseId);
Requirement requirement = client.GetRequirementByZephyrId(root, zephyrRequirementId);
try
{
client.CreateRelationshipBetweenScriptAndRequirement(options.Server, org.Id, script.Id, requirement.Id);
}
catch (RelationshipExistsException)
{
Console.WriteLine(" => Relationship already exists!");
}
}
public Booking(int booking_id, int entity_id, DateTime date_start, DateTime date_end, int organisation_id, int provider, int patient_id,
int offering_id, int booking_type_id, int booking_status_id, int booking_unavailability_reason_id,
int added_by, DateTime date_created, int booking_confirmed_by_type_id, int confirmed_by, DateTime date_confirmed,
int deleted_by, DateTime date_deleted, int cancelled_by, DateTime date_cancelled,
bool is_patient_missed_appt, bool is_provider_missed_appt, bool is_emergency,
bool need_to_generate_first_letter, bool need_to_generate_last_letter, bool has_generated_system_letters,
DateTime arrival_time, string sterilisation_code, int informed_consent_added_by, DateTime informed_consent_date,
bool is_recurring, DayOfWeek recurring_day_of_week, TimeSpan recurring_start_time, TimeSpan recurring_end_time,
int note_count, int inv_count)
{
this.booking_id = booking_id;
this.entity_id = entity_id;
this.date_start = date_start;
this.date_end = date_end;
this.organisation = organisation_id == 0 ? null : new Organisation(organisation_id);
this.provider = provider == -1 ? null : new Staff(provider);
this.patient = patient_id == -1 ? null : new Patient(patient_id);
this.offering = offering_id == -1 ? null : new Offering(offering_id);
this.booking_type_id = booking_type_id;
this.booking_status = booking_status_id == -2 ? null : new IDandDescr(booking_status_id);
this.booking_unavailability_reason = booking_unavailability_reason_id == -1 ? null : new IDandDescr(booking_unavailability_reason_id);
this.added_by = added_by == -1 ? null :new Staff(added_by);
this.date_created = date_created;
this.booking_confirmed_by_type = booking_confirmed_by_type_id == -1 ? null : new IDandDescr(booking_confirmed_by_type_id);
this.confirmed_by = confirmed_by == -1 ? null : new Staff(confirmed_by);
this.date_confirmed = date_confirmed;
this.deleted_by = deleted_by == -1 ? null : new Staff(deleted_by);
this.date_deleted = date_deleted;
this.cancelled_by = cancelled_by == -1 ? null : new Staff(cancelled_by);
this.date_cancelled = date_cancelled;
this.is_patient_missed_appt = is_patient_missed_appt;
this.is_provider_missed_appt = is_provider_missed_appt;
this.is_emergency = is_emergency;
this.need_to_generate_first_letter = need_to_generate_first_letter;
this.need_to_generate_last_letter = need_to_generate_last_letter;
this.has_generated_system_letters = has_generated_system_letters;
this.arrival_time = arrival_time;
this.sterilisation_code = sterilisation_code;
this.informed_consent_added_by = informed_consent_added_by == -1 ? null : new Staff(informed_consent_added_by);
this.informed_consent_date = informed_consent_date;
this.is_recurring = is_recurring;
this.recurring_day_of_week = recurring_day_of_week;
this.recurring_start_time = recurring_start_time;
this.recurring_end_time = recurring_end_time;
this.note_count = note_count;
this.inv_count = inv_count;
}
static void CreateAllRelationships(RestClient client, Root root, Options options, Organisation org)
{
var source = new DataSource();
List<RequirementToScriptRel> data = source.GetRequirementToScriptRelationships().ToList();
for (int i = 0; i < data.Count; i++)
{
int zephyrTestCaseId = data[i].TestCaseId;
int zephyrRequirementId = data[i].RequirementId;
Console.WriteLine("{0} of {1}: Creating relationship between test case #{2} and requirement #{3}", i + 1, data.Count, zephyrTestCaseId, zephyrRequirementId);
CreateRelationship(client, root, zephyrTestCaseId, zephyrRequirementId, options, org);
}
}
public Letter(int letter_id, int organisation_id, int letter_type_id, int site_id, string code, string reject_message, string docname, bool is_send_to_medico, bool is_allowed_reclaim,
bool is_manual_override, int num_copies_to_print, bool is_deleted)
{
this.letter_id = letter_id;
this.organisation = organisation_id == 0 ? null : new Organisation(organisation_id);
this.letter_type = new IDandDescr(letter_type_id);
this.site = new Site(site_id);
this.code = code;
this.reject_message = reject_message;
this.docname = docname;
this.is_send_to_medico = is_send_to_medico;
this.is_allowed_reclaim = is_allowed_reclaim;
this.is_manual_override = is_manual_override;
this.num_copies_to_print = num_copies_to_print;
this.is_deleted = is_deleted;
}
public LetterPrintHistory(int letter_print_history_id, int letter_id, int letter_print_history_send_method_id,
int booking_id, int patient_id, int organisation_id, int register_referrer_id,
int staff_id, int health_card_action_id, DateTime date, string doc_name, bool has_doc)
{
this.letter_print_history_id = letter_print_history_id;
this.letter = letter_id == -1 ? null : new Letter(letter_id);
this.send_method = new IDandDescr(letter_print_history_send_method_id);
this.booking = new Booking(booking_id);
this.patient = patient_id == -1 ? null : new Patient(patient_id);
this.organisation = organisation_id == 0 ? null : new Organisation(organisation_id);
this.register_referrer = register_referrer_id == -1 ? null : new RegisterReferrer(register_referrer_id);
this.staff = staff_id == -1 ? null : new Staff(staff_id);
this.health_card_action = new HealthCardAction(health_card_action_id);
this.date = date;
this.doc_name = doc_name;
this.has_doc = has_doc;
}
public RegisterStaff(int register_staff_id, DateTime register_staff_date_added, int organisation_id, int staff_id,
string provider_number, bool main_provider_for_clinic,
bool excl_sun, bool excl_mon, bool excl_tue, bool excl_wed, bool excl_thu, bool excl_fri, bool excl_sat)
{
this.register_staff_id = register_staff_id;
this.register_staff_date_added = register_staff_date_added;
this.organisation = new Organisation(organisation_id);
this.staff = new Staff(staff_id);
this.provider_number = provider_number;
this.main_provider_for_clinic = main_provider_for_clinic;
this.excl_sun = excl_sun;
this.excl_mon = excl_mon;
this.excl_tue = excl_tue;
this.excl_wed = excl_wed;
this.excl_thu = excl_thu;
this.excl_fri = excl_fri;
this.excl_sat = excl_sat;
}
public ActionResult Create([Bind(Include = "Id,Name,Description,OwnerId,CreatedOn,ModifiedOn,IsDeleted,DeletedOn")] OrganisationCreateModel organisation)
{
if (ModelState.IsValid)
{
var entity = new Organisation()
{
Name = organisation.Name,
Description = organisation.Description,
OwnerId = this.User.Identity.GetUserId()
};
this.Organisations.Add(entity);
this.Organisations.SaveChanges();
return this.RedirectToAction("Index");
}
return View(organisation);
}
public string ReplaceMergeFields(string text, Hashtable patientIDHash, int patientID,
Organisation org, string orgAddressText, string orgPhoneText, string orgFaxText, string orgWebText, string orgEmailText)
{
if (text.Contains("{pt_name}") ||
text.Contains("{pt_title}") ||
text.Contains("{pt_firstname}") ||
text.Contains("{pt_middlename}") ||
text.Contains("{pt_surname}") ||
text.Contains("{org_name}") ||
text.Contains("{org_addr}") ||
text.Contains("{org_phone}") ||
text.Contains("{org_office_fax}") ||
text.Contains("{org_web}") ||
text.Contains("{org_email}"))
{
Patient patient = (Patient)patientIDHash[patientID];
string title = string.Empty;
if (patient.Person.Title.ID != 0)
title = patient.Person.Title.Descr;
else if (patient.Person.Title.ID == 0 && patient.Person.Gender == "M")
title = "Mr.";
else if (patient.Person.Title.ID == 0 && patient.Person.Gender == "F")
title = "Ms.";
text = text
.Replace("{pt_name}", patient.Person.FullnameWithoutMiddlename)
.Replace("{pt_title}", title)
.Replace("{pt_firstname}", patient.Person.Firstname)
.Replace("{pt_middlename}", patient.Person.Middlename)
.Replace("{pt_surname}", patient.Person.Surname)
.Replace("{org_name}", org.Name)
.Replace("{org_addr}", orgAddressText)
.Replace("{org_phone}", orgPhoneText)
.Replace("{org_office_fax}", orgFaxText)
.Replace("{org_web}", orgWebText)
.Replace("{org_email}", orgEmailText)
;
}
return text;
}
public HealthCard(int health_card_id, int patient_id, int organisation_id, string card_name, string card_nbr, string card_family_member_nbr, DateTime expiry_date,
DateTime date_referral_signed, DateTime date_referral_received_in_office, bool is_active,
int added_or_last_modified_by, DateTime added_or_last_modified_date,
string area_treated)
{
this.health_card_id = health_card_id;
this.patient = new Patient(patient_id);
this.organisation = new Organisation(organisation_id);
this.card_name = card_name;
this.card_nbr = card_nbr;
this.card_family_member_nbr = card_family_member_nbr;
this.expiry_date = expiry_date;
this.date_referral_signed = date_referral_signed;
this.date_referral_received_in_office = date_referral_received_in_office;
this.is_active = is_active;
this.added_or_last_modified_by = added_or_last_modified_by == -1 ? null : new Staff(added_or_last_modified_by);
this.added_or_last_modified_date = added_or_last_modified_date;
this.area_treated = area_treated;
}
protected WeeeContext GetPreparedContext()
{
WeeeContext context = A.Fake<WeeeContext>();
var organisations = A.Fake<DbSet<Organisation>>();
A.CallTo(() => organisations.Add(A<Organisation>._)).Invokes((Organisation o) =>
{
addedOrganisation = o;
addedOrganisationId = Guid.NewGuid();
dbHelper.SetId(o, addedOrganisationId);
});
var organisationUsers = A.Fake<DbSet<OrganisationUser>>();
A.CallTo(() => organisationUsers.Add(A<OrganisationUser>._)).Invokes((OrganisationUser ou) => addedOrganisationUser = ou);
A.CallTo(() => context.Organisations).Returns(organisations);
A.CallTo(() => context.OrganisationUsers).Returns(organisationUsers);
return context;
}
protected void Add(ref ArrayList list, Staff staff, Organisation org, DateTime start, DateTime end)
{
Tuple<Organisation, DateTime, DateTime> t = new Tuple<Organisation, DateTime, DateTime>(org, start, end);
bool providerFound = false;
for (int i = 0; i < list.Count; i++)
{
if (((Tuple<Staff, ArrayList>)list[i]).Item1.StaffID == staff.StaffID)
{
((ArrayList)((Tuple<Staff, ArrayList>)list[i]).Item2).Add(t);
providerFound = true;
}
}
if (!providerFound)
{
Tuple<Staff, ArrayList> t2 = new Tuple<Staff, ArrayList>(staff, new ArrayList());
((ArrayList)((Tuple<Staff, ArrayList>)t2).Item2).Add(t);
list.Add(t2);
}
}
public static FaceToFaceCommunicationBuilder WithDefaults(this FaceToFaceCommunicationBuilder @this, Organisation internalOrganisation)
{
var faker = @this.Session.Faker();
var administrator = (Person) new UserGroups(@this.Session).Administrators.Members.First;
@this.WithDescription(faker.Lorem.Sentence(20));
@this.WithSubject(faker.Lorem.Sentence(5));
@this.WithEventPurpose(new CommunicationEventPurposes(@this.Session).Meeting);
@this.WithFromParty(internalOrganisation.ActiveEmployees.First);
@this.WithToParty(internalOrganisation.ActiveCustomers.First);
@this.WithOwner(administrator);
@this.WithActualStart(DateTime.UtcNow);
return(@this);
}
protected Employer GetEmployer(Employer employer, Organisation organisation)
{
employer.Organisation = organisation;
return(employer);
}
public async Task <IEnumerable <Organisation> > GetUnrelatedOrganisations(Organisation organisation)
{
return(await context.Organisations.Where(o => o != organisation && !o.ParentRelatedOrganisations.Contains(organisation)).ToListAsync());
}
public void Remove(Organisation organisation)
{
OrganisationRepository.Remove(organisation);
}
public string UpdateOrganization(Organisation orginfo)
{
try
{
UserLoginInformation loggedinUser = (UserLoginInformation)LoginController.ActiveUser;
if (orginfo.OrganisationId == 0)
{
orginfo.ModifiedById = loggedinUser.USERID.ToString();
orginfo.CreatedById = loggedinUser.USERID.ToString();
orginfo.CreatedDate = DateTime.Now;
orginfo.ModifiedDate = DateTime.Now;
orginfo.Status = 1;
_context.Organisations.Add(orginfo);
_context.SaveChanges();
}
else
{
try
{
using (TransactionScope transactionScope = new TransactionScope())
{
try
{
using (kryptoEntities1 db = new kryptoEntities1())
{
orginfo = Updateobject(orginfo.OrganisationId, orginfo);
orginfo.ModifiedById = loggedinUser.USERID.ToString();
orginfo.ModifiedDate = DateTime.Now;
db.Entry(orginfo).State = EntityState.Modified;
db.SaveChanges();
List <MyNode> responseNodes =
JsonConvert.DeserializeObject <List <MyNode> >(orginfo.UserSelections);
List <UserLoginInformation> usersInDb = new List <UserLoginInformation>();
foreach (FacilityMaster @facility in orginfo.GetAssocaitedFacilities())
{
usersInDb.AddRange(@facility.GetAssocaitedOrganisationAdmins());
}
List <int> indb = usersInDb.Select(x => x.USERID).ToList();
List <int> inselections = responseNodes.Select(x => x.value).ToList();
var toInclude = UserDatatablesController.ExcludedRight(indb, inselections);
var toExclude = UserDatatablesController.ExcludedLeft(indb, inselections);
foreach (int @in in toInclude)
{
UserLoginInformation current = db.UserLoginInformations.Find(@in);
current.IsOrganisationAdmin = true;
current.IsFacilityAdmin = true;
db.Entry(current).State = EntityState.Modified;
}
foreach (int @out in toExclude)
{
UserLoginInformation current = db.UserLoginInformations.Find(@out);
current.IsOrganisationAdmin = false;
db.Entry(current).State = EntityState.Modified;
}
db.SaveChanges();
}
transactionScope.Complete();
}
catch (Exception ee)
{
return("FAIL");
}
}
}
catch (Exception exception)
{
return("FAIL");
}
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
return("FAIL");
}
return("SUCESS");
}
public JsonResult getMatchingOrganization(int selectedOrg)
{
Organisation orginfo = _context.Organisations.SingleOrDefault(x => x.OrganisationId.Equals(selectedOrg) && x.Status == 1);
return(Json(orginfo, JsonRequestBehavior.AllowGet));
}
public Organisation PostSave(Organisation org)
{
org = OrganisationDbService.Instance.SaveOrganisation(org);
org.Contacts = new ContactApiController().GetByOrganisationId(org.Id);
return(org);
}
private void AddSampleData(SurveyContext context)
{
var userManager = new ApplicationUserManager(new ApplicationUserStore(context));
var roleManager = new ApplicationRoleManager(new ApplicationRoleStore(context));
try
{
Project CurrentProject = null;
var org = new Organisation()
{
Id = Guid.Parse("cfa81eb0-9fc7-4932-a3e8-1c822370d034"), // this is the ID on our production database
Name = "OnRecord",
TelNumber = "0209390499",
AddressLine1 = "110 Kings road",
AddressLine2 = "Regent street",
Town = "London",
County = "London",
Postcode = "EC23 4AD",
DefaultLanguageId = LanguagesRepository.English.Id,
DefaultCalendarId = CalendarsRepository.Gregorian.Id,
IsActive = true,
SubscriptionEnabled = true,
SubscriptionMonthlyRate = 6M
};
context.Organisations.AddOrUpdate(org);
var user = new OrgUser()
{
Id = Guid.Parse("b3c19356-d11d-48f2-a3a8-69392a7b4e7b"), OrganisationId = org.Id, IsRootUser = true, Email = "*****@*****.**", UserName = "******", TypeId = OrgUserTypesRepository.Administrator.Id, LastLogin = new DateTime(2015, 1, 1), IsWebUser = true, IsMobileUser = true
};
userManager.AddOrUpdateUser(user, "Test1234");
OrgUserTypesRepository.Administrator.GetRoles().ToList().ForEach(role => userManager.AddToRole(user.Id, role));
context.SaveChanges();
org.RootUser = user;
context.SaveChanges();
CurrentProject = new Project()
{
Id = Guid.Parse("cb7f09a2-1823-4f60-820e-3fedc462fe76"), Number = "123", Name = "Test Project 1", StartDate = new DateTime(2015, 1, 1), Flagged = true, OrganisationId = org.Id
};
context.Projects.AddOrUpdate(CurrentProject);
context.SaveChanges();
var dataList = new DataList()
{
Id = Guid.Parse("884505e1-97c8-4602-8c00-f75ae08d99ab"), OrganisationId = org.Id, Name = "Colors"
};
context.DataLists.AddOrUpdate(dataList);
context.DataListItems.AddOrUpdate(new DataListItem {
Id = Guid.Parse("0a138f19-2e98-4030-b9e9-78527043c1c2"), DataListId = dataList.Id, Text = "Black", Value = 0, Order = 1
});
context.DataListItems.AddOrUpdate(new DataListItem {
Id = Guid.Parse("32d75f9b-7da6-43b5-8f3f-b7830dc6e5f7"), DataListId = dataList.Id, Text = "White", Value = 1, Order = 2
});
context.DataListItems.AddOrUpdate(new DataListItem {
Id = Guid.Parse("298cdd84-4cd1-481f-875e-c2c9adce43bc"), DataListId = dataList.Id, Text = "Blue", Value = 2, Order = 3
});
context.DataListItems.AddOrUpdate(new DataListItem {
Id = Guid.Parse("8e63ad2d-6872-4e6d-86e6-55782450f991"), DataListId = dataList.Id, Text = "Red", Value = 3, Order = 4
});
context.SaveChanges();
var cat = new FormTemplateCategory()
{
Id = Guid.Parse("8DBFEC4D-96E0-4135-A726-D144D5707858"), Title = "Recordings", OrganisationId = org.Id
};
context.FormTemplateCategories.AddOrUpdate(cat);
context.SaveChanges();
var adviceThreadsCat = new FormTemplateCategory()
{
Id = Guid.Parse("F4284C22-1FB4-4187-AD0F-B8FEB059C842"), Title = "Advice Recordings", OrganisationId = org.Id
};
context.FormTemplateCategories.AddOrUpdate(adviceThreadsCat);
context.SaveChanges();
var template = new FormTemplate()
{
Id = Guid.Parse("52692cf5-fd17-4fc6-b72b-b65b7e8d4e98"), ProjectId = CurrentProject.Id, Code = "101", Title = "First Form", Description = "This is the first from.", Colour = "#ddff00", Version = 1.0, FormTemplateCategoryId = cat.Id, IsPublished = true, Discriminator = FormTemplateDiscriminators.RegularThread, OrganisationId = org.Id, CreatedById = user.Id
};
context.FormTemplates.AddOrUpdate(template);
context.SaveChanges();
var category1 = new MetricGroup()
{
Id = Guid.Parse("bedb627d-155d-4807-93dd-40cbb1fa335d"), Title = "First questions", FormTemplateId = template.Id, Order = template.GetMaxGroupOrder()
};
template.AddGroup(category1);
context.MetricGroups.AddOrUpdate(category1);
var category2 = new MetricGroup()
{
Id = Guid.Parse("45ca1db0-820b-4271-8f26-7a75e7e73c80"), Title = "Second questions", FormTemplateId = template.Id, Order = template.GetMaxGroupOrder()
};
template.AddGroup(category2);
context.MetricGroups.AddOrUpdate(category2);
var category3 = new MetricGroup()
{
Id = Guid.Parse("0b76ee76-405a-434a-9bca-4e5b3f1eb5e7"), Title = "Third questions", FormTemplateId = template.Id, Order = template.GetMaxGroupOrder()
};
template.AddGroup(category3);
context.MetricGroups.AddOrUpdate(category3);
context.SaveChanges();
var metric1 = new FreeTextMetric()
{
Id = Guid.Parse("f6e5b494-d845-48dc-a783-e3e93b340b3a"), ShortTitle = "q1", Description = "What is the answer1", NumberOfLine = 1, MaxLength = 10, Order = category1.GetMaxMetricOrder(), Mandatory = true
};
category1.AddMetric(metric1);
context.FreeTextMetrics.AddOrUpdate(metric1);
var metric2 = new FreeTextMetric()
{
Id = Guid.Parse("8a85e16c-9abb-4f99-83fc-564605bbd52f"), ShortTitle = "q2", Description = "What is the answer2", NumberOfLine = 3, Order = category1.GetMaxMetricOrder(), Mandatory = true
};
category1.AddMetric(metric2);
context.FreeTextMetrics.AddOrUpdate(metric2);
var metric3 = new FreeTextMetric()
{
Id = Guid.Parse("b2f747bc-b403-47de-95c2-2efd8e1ebeb6"), ShortTitle = "q3", Description = "What is the answer3", NumberOfLine = 3, Order = category2.GetMaxMetricOrder()
};
category2.AddMetric(metric3);
context.FreeTextMetrics.AddOrUpdate(metric3);
var metric4 = new FreeTextMetric()
{
Id = Guid.Parse("a8373528-0d92-4d91-bff0-5397700644c8"), ShortTitle = "q4", Description = "What is the answer4", NumberOfLine = 2, Order = category2.GetMaxMetricOrder()
};
category2.AddMetric(metric4);
context.FreeTextMetrics.AddOrUpdate(metric4);
var metric5 = new FreeTextMetric()
{
Id = Guid.Parse("14531856-8b05-4711-850e-d0ac00173732"), ShortTitle = "q5", Description = "What is the answer5", NumberOfLine = 2, Order = category3.GetMaxMetricOrder()
};
category3.AddMetric(metric5);
context.FreeTextMetrics.AddOrUpdate(metric5);
var metric6 = new RateMetric()
{
Id = Guid.Parse("ae9399eb-80b2-4944-be22-55b561f10bc5"), ShortTitle = "r1", Description = "What is the rate1", MinValue = 1, MaxValue = 5, DefaultValue = 1, Order = category1.GetMaxMetricOrder()
};
category1.AddMetric(metric6);
context.RateMetrics.AddOrUpdate(metric6);
var metric7 = new DateMetric()
{
Id = Guid.Parse("68ce9679-14b5-4e00-97d6-38ad6db54f54"), ShortTitle = "d1", Description = "Date of Event", Order = category1.GetMaxMetricOrder(), HasTimeValue = false
};
category1.AddMetric(metric7);
context.DateMetrics.AddOrUpdate(metric7);
var metric8 = new DichotomousMetric()
{
Id = Guid.Parse("e254bf53-2ddb-4817-a9d7-6d8513696a2f"), ShortTitle = "yn1", Description = "Are you ok?", Order = category1.GetMaxMetricOrder()
};
category1.AddMetric(metric8);
context.DichotomousMetrics.AddOrUpdate(metric8);
context.SaveChanges();
// default advice thread template.
var adviceTemplate = new FormTemplate()
{
Id = Guid.Parse("780f4d2d-524f-4714-a5b2-a43c8eaff3c3"), ProjectId = CurrentProject.Id, Code = "202", Title = "Advice Form", Description = "This is the default advice form.", Colour = "#08874b", DescriptionFormat = "{{comment}}", Version = 1.0, FormTemplateCategoryId = adviceThreadsCat.Id, IsPublished = true, Discriminator = FormTemplateDiscriminators.AdviceThread, OrganisationId = org.Id, CreatedById = user.Id
};
context.FormTemplates.AddOrUpdate(adviceTemplate);
context.SaveChanges();
var adviceFormCategory1 = new MetricGroup()
{
Id = Guid.Parse("3b940609-0e1c-4542-87be-f69f2b3faa79"), Title = "Advice Form", FormTemplateId = adviceTemplate.Id, Order = adviceTemplate.GetMaxGroupOrder()
};
adviceTemplate.AddGroup(adviceFormCategory1);
context.MetricGroups.AddOrUpdate(adviceFormCategory1);
var adviceFormMetric1 = new FreeTextMetric()
{
Id = Guid.Parse("bbb60c5f-cc29-473f-994e-3a04d25c9b60"), ShortTitle = "Comment", Description = "Write your advice or comment here", NumberOfLine = 2, MaxLength = 500, Order = adviceFormCategory1.GetMaxMetricOrder(), Mandatory = true
};
adviceFormCategory1.AddMetric(adviceFormMetric1);
context.FreeTextMetrics.AddOrUpdate(adviceFormMetric1);
var adviceFormMetric2 = new AttachmentMetric()
{
Id = Guid.Parse("a48e8139-4608-4b72-a85b-b9908714f242"), ShortTitle = "Attachments", Description = "Upload any supporting evidence or media", AllowMultipleFiles = true, Order = adviceFormCategory1.GetMaxMetricOrder()
};
adviceFormCategory1.AddMetric(adviceFormMetric2);
context.AttachmentMetrics.AddOrUpdate(adviceFormMetric2);
context.SaveChanges();
//var data = new FilledForm() { Id = Guid.Parse("390f8abc-dc99-411a-a22f-8cf43313337a"), FormTemplateId = template.Id, ProjectId = CurrentProject.Id, FilledById = user.Id };
//context.FilledForms.AddOrUpdate(data);
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("24bacf38-52ee-40e5-916c-a3f81a84eea5"), FilledFormId = data.Id, MetricId = metric1.Id, TextValue = "answer 1" });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("cdb38534-f412-4397-aa1e-51a587db402f"), FilledFormId = data.Id, MetricId = metric2.Id, TextValue = "answer 2" });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("b3d3dc58-5467-42ac-8d2a-3e327635a72d"), FilledFormId = data.Id, MetricId = metric3.Id, TextValue = "answer 3" });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("d3efb64f-8bf1-4916-9dd0-07fc11ec171e"), FilledFormId = data.Id, MetricId = metric4.Id, TextValue = "answer 4" });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("9a0e941e-f28a-4bf3-9a23-edeecf4368df"), FilledFormId = data.Id, MetricId = metric5.Id, TextValue = "answer 5" });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("a00e12d0-92a5-4737-9dd3-b83f8a71e320"), FilledFormId = data.Id, MetricId = metric6.Id, NumericValue = 3 });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("b2f46bdc-f987-4a2d-bcc7-bb7c4f592f21"), FilledFormId = data.Id, MetricId = metric7.Id, DateValue = DateTime.Now });
//context.FormValues.AddOrUpdate(new FormValue() { Id = Guid.Parse("747a6bbf-c439-40e4-a76e-d03b68ed1614"), FilledFormId = data.Id, MetricId = metric8.Id, BoolValue = true });
//context.SaveChanges();
var reportCat = new ReportTemplateCategory()
{
Id = Guid.Parse("00b2ea95-dcaf-480a-b470-6d012a5f1d6e"), OrganisationId = org.Id, Title = "First report category"
};
context.ReportTemplateCategories.AddOrUpdate(reportCat);
var reportTemplate = new ReportTemplate()
{
Id = Guid.Parse("04d3727c-738a-44b7-952d-7c74e2383c4b"), OrganisationId = org.Id, Name = "First sample report", CategoryId = reportCat.Id, Description = "", IsPublished = true
};
context.ReportTemplates.AddOrUpdate(reportTemplate);
context.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
public Organisation FindOrganisationById(int organisationId)
{
Organisation organisation = DbContext.Organisations.Find(organisationId);
return(organisation);
}
public void SaveNewOrganisation(Organisation organisation)
{
DbContext.Organisations.Add(organisation);
DbContext.SaveChanges();
}
public static int Save(Organisation org)
{
int rowsaffected = 0;
DbTransaction trans = null;
try
{
trans = Database.BeginTransaction(cs);
if (org.ID == 0)
{
string sql =
@"INSERT INTO Organisation
(OrganisationName, Address, Email, Phone, Login, Password, DbName, DbLogin, DbPassword)
VALUES (@Org, @Address, @Email, @Phone, @Login, @Password, @DbName, @DbLogin, @DbPassword)";
DbParameter par1 = Database.AddParameter(cs, "@Org", org.OrganisationName);
DbParameter par2 = Database.AddParameter(cs, "@Address", org.Address);
DbParameter par3 = Database.AddParameter(cs, "@Email", org.Email);
DbParameter par4 = Database.AddParameter(cs, "@Phone", org.Phone);
DbParameter par5 = Database.AddParameter(cs, "@Login", Cryptography.Encrypt(org.Login));
DbParameter par6 = Database.AddParameter(cs, "@Password", Cryptography.Encrypt(org.Password));
DbParameter par7 = Database.AddParameter(cs, "@DbName", Cryptography.Encrypt(org.DbName));
DbParameter par8 = Database.AddParameter(cs, "@DbLogin", Cryptography.Encrypt(org.DbLogin));
DbParameter par9 = Database.AddParameter(cs, "@DbPassword", Cryptography.Encrypt(org.DbPassword));
rowsaffected += Database.InsertData(trans, sql, par1, par2, par3, par4, par5, par6, par7, par8, par9);
org.ID = rowsaffected;
CreateDatabase(org);
}
else
{
DbParameter parPass = null;
string sql = "UPDATE Organisation SET Login = @Login, OrganisationName = @Org, Address = @Address, Email = @Email, Phone = @Phone";
if (org.Password != null)
{
sql += ", Password = @Password";
parPass = Database.AddParameter(cs, "@Password", Cryptography.Encrypt(org.Password));
}
sql += " WHERE ID = @ID";
DbParameter par1 = Database.AddParameter(cs, "@ID", org.ID);
DbParameter par2 = Database.AddParameter(cs, "@Login", Cryptography.Encrypt(org.Login));
DbParameter par3 = Database.AddParameter(cs, "@Org", org.OrganisationName);
DbParameter par4 = Database.AddParameter(cs, "@Address", org.Address);
DbParameter par5 = Database.AddParameter(cs, "@Email", org.Email);
DbParameter par6 = Database.AddParameter(cs, "@Phone", org.Phone);
rowsaffected += Database.ModifyData(trans, sql, par1, par2, par3, par4, par5, par6, parPass);
}
trans.Commit();
}
catch (Exception)
{
if (trans != null)
{
trans.Rollback();
}
}
finally
{
if (trans != null)
{
Database.ReleaseConnection(trans.Connection);
}
}
return(rowsaffected);
}
/// <summary>
/// Update a Organisation
/// </summary>
/// <param name="currentUser"></param>
/// <param name="user"></param>
/// <param name="appID"></param>
/// <param name="overrideID"></param>
/// <param name="code"></param>
/// <param name="lockID"></param>
/// <param name="dataRepository"></param>
/// <param name="uow"></param>
public void DeleteOrganisation(string currentUser, string user, string appID, string overrideID, string code, string lockID, IRepository <Organisation> dataRepository, IUnitOfWork uow, IExceptionManager exceptionManager, IMappingService mappingService)
{
try
{
#region Parameter validation
// Validate parameters
if (string.IsNullOrEmpty(currentUser))
{
throw new ArgumentOutOfRangeException("currentUser");
}
if (string.IsNullOrEmpty(user))
{
throw new ArgumentOutOfRangeException("user");
}
if (string.IsNullOrEmpty(appID))
{
throw new ArgumentOutOfRangeException("appID");
}
if (string.IsNullOrEmpty(code))
{
throw new ArgumentOutOfRangeException("code");
}
if (string.IsNullOrEmpty(lockID))
{
throw new ArgumentOutOfRangeException("lockID");
}
if (null == dataRepository)
{
throw new ArgumentOutOfRangeException("dataRepository");
}
if (null == uow)
{
throw new ArgumentOutOfRangeException("uow");
}
if (null == exceptionManager)
{
throw new ArgumentOutOfRangeException("exceptionManager");
}
if (null == mappingService)
{
throw new ArgumentOutOfRangeException("mappingService");
}
#endregion
using (uow)
{
// Convert string to guid
Guid codeGuid = Guid.Parse(code);
// Find item based on ID
Organisation dataEntity = dataRepository.Single(x => x.Code == codeGuid);
// Delete the item
dataRepository.Delete(dataEntity);
// Commit unit of work
uow.Commit();
}
}
catch (Exception e)
{
//Prevent exception from propogating across the service interface
exceptionManager.ShieldException(e);
}
}
/// <summary>
/// Retrieve a Organisation with associated lookups
/// </summary>
/// <param name="currentUser"></param>
/// <param name="user"></param>
/// <param name="appID"></param>
/// <param name="overrideID"></param>
/// <param name="code"></param>
/// <param name="dataRepository"></param>
/// <param name="uow"></param>
/// <returns></returns>
public OrganisationVMDC GetOrganisation(string currentUser, string user, string appID, string overrideID, string code, IUnitOfWork uow, IRepository <Organisation> dataRepository
, IRepository <OrganisationType> organisationTypeRepository
, IExceptionManager exceptionManager, IMappingService mappingService)
{
try
{
#region Parameter validation
// Validate parameters
if (string.IsNullOrEmpty(currentUser))
{
throw new ArgumentOutOfRangeException("currentUser");
}
if (string.IsNullOrEmpty(user))
{
throw new ArgumentOutOfRangeException("user");
}
if (string.IsNullOrEmpty(appID))
{
throw new ArgumentOutOfRangeException("appID");
}
if (null == dataRepository)
{
throw new ArgumentOutOfRangeException("dataRepository");
}
if (null == uow)
{
throw new ArgumentOutOfRangeException("uow");
}
if (null == exceptionManager)
{
throw new ArgumentOutOfRangeException("exceptionManager");
}
if (null == mappingService)
{
throw new ArgumentOutOfRangeException("mappingService");
}
#endregion
using (uow)
{
OrganisationDC destination = null;
// If code is null then just return supporting lists
if (!string.IsNullOrEmpty(code))
{
// Convert code to Guid
Guid codeGuid = Guid.Parse(code);
// Retrieve specific Organisation
Organisation dataEntity = dataRepository.Single(x => x.Code == codeGuid);
// Convert to data contract for passing through service interface
destination = mappingService.Map <Organisation, OrganisationDC>(dataEntity);
}
IEnumerable <OrganisationType> organisationTypeList = organisationTypeRepository.GetAll(x => x.Name);
List <OrganisationTypeDC> organisationTypeDestinationList = mappingService.Map <List <OrganisationTypeDC> >(organisationTypeList);
// Create aggregate contract
OrganisationVMDC returnObject = new OrganisationVMDC();
returnObject.OrganisationItem = destination;
returnObject.OrganisationTypeList = organisationTypeDestinationList;
return(returnObject);
}
}
catch (Exception e)
{
//Prevent exception from propogating across the service interface
exceptionManager.ShieldException(e);
return(null);
}
}
public void Restore(Organisation org)
{
org.Archived = false;
DbService.db().Save(org);
}
public void Archive(Organisation org)
{
org.Archived = true;
DbService.db().Save(org);
}
void CreateTestData(int recordCount = 500, int yearCount = 3)
{
var organisations = DataRepository.GetAll <Organisation>();
var sicCodes = DataRepository.GetAll <SicCode>();
while (organisations.Count() < recordCount)
{
var sector = Numeric.Rand(0, 1) == 0 ? SectorTypes.Private : SectorTypes.Public;
string searchText = Text.AlphabetChars[Numeric.Rand(0, 1)].ToString();
var organisation = new Organisation();
PagedResult <EmployerRecord> result;
if (sector == SectorTypes.Public)
{
try
{
result = PublicSectorRepository.Search(searchText, Numeric.Rand(1, recordCount), 10);
}
catch (Exception ex)
{
continue;
}
if (result == null || result.RowCount == 0 || result.Results == null || result.Results.Count == 0)
{
continue;
}
foreach (var employer in result.Results)
{
if (organisations.Any(o => o.OrganisationName == employer.Name))
{
continue;
}
organisation = new Organisation();
organisation.OrganisationName = employer.Name;
organisation.SectorType = sector;
organisation.Status = OrganisationStatuses.Active;
organisation.StatusDetails = "TEST DATA";
DataRepository.Insert(organisation);
DataRepository.SaveChanges();
DataRepository.Insert(new OrganisationAddress()
{
OrganisationId = organisation.OrganisationId,
Address1 = "Address line " + organisation.OrganisationId,
Address3 = "City" + organisation.OrganisationId,
Country = "Country" + organisation.OrganisationId,
PostCode = "Post Code" + organisation.OrganisationId,
Status = AddressStatuses.Active
});
employer.SicCodes = PublicSectorRepository.GetSicCodes(employer.CompanyNumber);
foreach (var sicCode in employer.SicCodes.SplitI())
{
var code = sicCode.ToInt32();
if (!sicCodes.Any(s => s.SicCodeId == code))
{
MvcApplication.WarningLog.WriteLine($"Invalid SIC code '{code}' received from companies house");
continue;
}
if (organisation.OrganisationSicCodes.Any(a => a.SicCodeId == code))
{
continue;
}
DataRepository.Insert(new OrganisationSicCode()
{
OrganisationId = organisation.OrganisationId,
SicCodeId = code
});
}
DataRepository.SaveChanges();
}
}
else if (sector == SectorTypes.Private)
{
try
{
result = PrivateSectorRepository.Search(searchText, Numeric.Rand(1, recordCount), 10);
}
catch (Exception ex)
{
continue;
}
if (result == null || result.RowCount == 0 || result.Results == null || result.Results.Count == 0)
{
continue;
}
foreach (var employer in result.Results)
{
if (organisations.Any(o => o.OrganisationName == employer.Name))
{
continue;
}
organisation = new Organisation();
organisation.OrganisationName = employer.Name;
organisation.SectorType = sector;
organisation.Status = OrganisationStatuses.Active;
organisation.StatusDetails = "TEST DATA";
organisation.PrivateSectorReference = employer.CompanyNumber;
DataRepository.Insert(organisation);
DataRepository.SaveChanges();
DataRepository.Insert(new OrganisationAddress()
{
OrganisationId = organisation.OrganisationId,
Address1 = employer.Address1,
Address2 = employer.Address2,
Address3 = employer.Address3,
Country = employer.Country,
PostCode = employer.PostCode,
PoBox = employer.PoBox,
Status = AddressStatuses.Active
});
employer.SicCodes = PrivateSectorRepository.GetSicCodes(employer.CompanyNumber);
foreach (var sicCode in employer.SicCodes.SplitI())
{
var code = sicCode.ToInt32();
if (!sicCodes.Any(s => s.SicCodeId == code))
{
MvcApplication.WarningLog.WriteLine($"Invalid SIC code '{code}' received from companies house");
continue;
}
if (organisation.OrganisationSicCodes.Any(a => a.SicCodeId == code))
{
continue;
}
DataRepository.Insert(new OrganisationSicCode()
{
OrganisationId = organisation.OrganisationId,
SicCodeId = code
});
}
DataRepository.SaveChanges();
}
}
}
foreach (var organisation in organisations.ToList())
{
for (var year = DateTime.Now.Year; year >= (DateTime.Now.Year - yearCount); year--)
{
var returns = organisation.Returns.ToList();
var accountingDate = GetAccountYearStartDate(organisation.SectorType, year);
var @return = returns.FirstOrDefault(r => r.AccountingDate == accountingDate);
if (@return != null)
{
continue;
}
DataRepository.Insert(new Return()
{
OrganisationId = organisation.OrganisationId,
AccountingDate = accountingDate,
Status = ReturnStatuses.Submitted,
StatusDate = accountingDate.AddDays(Numeric.Rand(0, 365)),
CompanyLinkToGPGInfo = "https://" + organisation.OrganisationName.ReplaceI(" ", "") + ".co.uk/GPGData",
DiffMeanBonusPercent = Numeric.Rand(0, 100),
DiffMeanHourlyPayPercent = Numeric.Rand(0, 100),
DiffMedianBonusPercent = Numeric.Rand(0, 100),
DiffMedianHourlyPercent = Numeric.Rand(0, 100),
FemaleLowerPayBand = Numeric.Rand(0, 100),
FemaleMedianBonusPayPercent = Numeric.Rand(0, 100),
FemaleMiddlePayBand = Numeric.Rand(0, 100),
FemaleUpperPayBand = Numeric.Rand(0, 100),
FemaleUpperQuartilePayBand = Numeric.Rand(0, 100),
FirstName = "Firstname" + organisation.OrganisationId,
LastName = "Lastname" + organisation.OrganisationId,
JobTitle = "Jobtitle " + organisation.OrganisationId,
MaleLowerPayBand = Numeric.Rand(0, 100),
MaleMedianBonusPayPercent = Numeric.Rand(0, 100),
MaleUpperQuartilePayBand = Numeric.Rand(0, 100),
MaleMiddlePayBand = Numeric.Rand(0, 100),
MaleUpperPayBand = Numeric.Rand(0, 100)
});
}
}
DataRepository.SaveChanges();
}
public ActionResult Result(int currentrecord)
{
Organisation currentOrganisation = _context.Organisations.Find(currentrecord);
List <int> participantsIds = null;
if (currentrecord != 0)
{
List <UserLoginInformation> usersInDb = new List <UserLoginInformation>();
foreach (FacilityMaster @facility in currentOrganisation.GetAssocaitedFacilities())
{
usersInDb.AddRange(@facility.GetAssocaitedOrganisationAdmins());
}
participantsIds = usersInDb.Select(x => x.USERID).ToList();
}
List <MyNode> nodes = new List <MyNode>();
MyOrganisation @org = new MyOrganisation();
@org.Name = currentOrganisation.Name;
@org.Value = currentOrganisation.OrganisationId;
MyNode orgNode = new MyNode
{
text = org.Name,
value = org.Value,
icon = "glyphicon glyphicon-home",
backColor = "#ffffff",
color = "#428bca",
//state = new state() { @checked = true, disabled = false, expanded = true, selected = false },
nodetype = MyNodeType.Organisation
};
List <MyFacility> facilities = @org.GetAllMatchingFacilities();
if (facilities != null && facilities.Count > 0)
{
orgNode.nodes = new List <MyNode>();
foreach (MyFacility @fac in facilities)
{
MyNode facNode = new MyNode
{
parent = orgNode.value,
text = fac.Name,
value = fac.Value,
icon = "glyphicon glyphicon-th-list",
backColor = "#ffffff",
color = "#66512c",
//state = new state() { @checked = true, disabled = false, expanded = true, selected = false },
nodetype = MyNodeType.Facility
};
List <MyUser> users = @fac.GetAllMatchingUsers();
if (users != null && users.Count > 0)
{
facNode.nodes = new List <MyNode>();
foreach (MyUser @user in users)
{
MyNode userNode = new MyNode
{
parent = facNode.value,
text = user.Name,
value = user.Value,
icon = "glyphicon glyphicon-user",
backColor = "#ffffff",
color = "#31708f",
nodetype = MyNodeType.User
};
if (ChatGroupController.CheckIfMatchingMyUserExists(participantsIds, userNode) != null)
{
userNode.state = new state
{
@checked = true,
disabled = false,
expanded = true,
selected = false
};
}
facNode.nodes.Add(userNode);
}
}
if (users.Count > 0)
{
orgNode.nodes.Add(facNode);
}
}
}
if (facilities.Count > 0 && orgNode.nodes.Count > 0)
{
nodes.Add(orgNode);
}
return(Json(nodes, JsonRequestBehavior.AllowGet));
}
public void Add(Organisation organisation)
{
OrganisationRepository.Add(organisation);
}
public Organisation Updateobject(int id, Organisation filled)
{
Organisation obj = _context.Organisations.Find(id);
PropertyInfo[] props = obj.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (PropertyInfo prop in props)
{
object currentprop = prop.GetValue(filled);
if (currentprop is Int32)
{
int currentint = (int)currentprop;
if (currentint == 0)
{
prop.SetValue(filled, prop.GetValue(obj), null);
}
}
else if (currentprop is Int16)
{
Int16 currentInt16 = (Int16)currentprop;
if (currentInt16 == 0)
{
prop.SetValue(filled, prop.GetValue(obj), null);
}
}
else if (currentprop is Byte)
{
Byte currentByte = (Byte)currentprop;
if (currentByte == 0)
{
prop.SetValue(filled, prop.GetValue(obj), null);
}
}
else if (currentprop is Boolean)
{
Boolean currentBoolean = (Boolean)currentprop;
if (currentBoolean == (Boolean)prop.GetValue(obj))
{
prop.SetValue(filled, prop.GetValue(obj), null);
}
}
else if (currentprop is String)
{
prop.SetValue(filled, (String)currentprop, null);
}
else if (currentprop is DateTime)
{
DateTime currentDateTime = (DateTime)currentprop;
if (currentDateTime == new DateTime())
{
prop.SetValue(filled, prop.GetValue(obj), null);
}
}
else
{
if (currentprop == null)
{
prop.SetValue(filled, prop.GetValue(obj), null);
}
}
}
return(filled);
}
public void OrganisationMarkedAsDemoTest()
{
Organisation organisation = Api.Organisation;
Assert.IsTrue((bool)organisation.IsDemoCompany, "Demo Organisation was not marked as Demo");
}
public async Task <IActionResult> ReviewRequest(OrganisationViewModel model, string command)
{
//Ensure user has completed the registration process
var checkResult = await CheckUserRegisteredOkAsync();
if (checkResult != null)
{
return(checkResult);
}
//Make sure we can load employers from session
var m = UnstashModel <OrganisationViewModel>();
if (m == null)
{
return(View("CustomError", WebService.ErrorViewModelFactory.Create(1112)));
}
model.ManualEmployers = m.ManualEmployers;
//Unwrap code
UserOrganisation userOrg;
var result = UnwrapRegistrationRequest(model, out userOrg, true);
if (result != null)
{
return(result);
}
//Check model is valid
//Exclude the address details
var excludes = new HashSet <string>();
excludes.AddRange(
nameof(model.Address1),
nameof(model.Address2),
nameof(model.Address3),
nameof(model.City),
nameof(model.County),
nameof(model.Country),
nameof(model.Postcode),
nameof(model.PoBox));
//Exclude the contact details
excludes.AddRange(
nameof(model.ContactFirstName),
nameof(model.ContactLastName),
nameof(model.ContactJobTitle),
nameof(model.ContactEmailAddress),
nameof(model.ContactPhoneNumber));
//Exclude the SIC Codes
excludes.Add(nameof(model.SicCodeIds));
excludes.Add(nameof(model.SearchText));
excludes.Add(nameof(model.OrganisationName));
excludes.AddRange(
nameof(model.CompanyNumber),
nameof(model.CharityNumber),
nameof(model.MutualNumber),
nameof(model.OtherName),
nameof(model.OtherValue));
//Exclude the DUNS number when declining
if (command.EqualsI("decline"))
{
excludes.Add(nameof(model.DUNSNumber));
}
ModelState.Exclude(excludes.ToArray());
if (!ModelState.IsValid)
{
this.CleanModelErrors <OrganisationViewModel>();
return(View(nameof(ReviewRequest), model));
}
if (command.EqualsI("decline"))
{
result = RedirectToAction("ConfirmCancellation");
}
else if (command.EqualsI("approve"))
{
//Check for DUNS number conflicts
Organisation conflictOrg = null;
if (!string.IsNullOrWhiteSpace(model.DUNSNumber))
{
conflictOrg = await SharedBusinessLogic.DataRepository.GetAll <Organisation>()
.FirstOrDefaultAsync(
o => userOrg.OrganisationId != o.OrganisationId &&
o.DUNSNumber.ToLower() == model.DUNSNumber.ToLower());
if (conflictOrg != null)
{
ModelState.AddModelError(3030, nameof(model.DUNSNumber));
}
}
//Check for company number conflicts
if (!string.IsNullOrWhiteSpace(model.CompanyNumber))
{
conflictOrg = await SharedBusinessLogic.DataRepository.GetAll <Organisation>()
.FirstOrDefaultAsync(
o => userOrg.OrganisationId != o.OrganisationId &&
o.CompanyNumber.ToLower() == model.CompanyNumber.ToLower());
if (conflictOrg != null)
{
ModelState.AddModelError(
3031,
nameof(model.CompanyNumber),
new { organisationName = conflictOrg.OrganisationName, referenceName = "Company number" });
}
}
//Check for charity number conflicts
if (!string.IsNullOrWhiteSpace(model.CharityNumber))
{
var orgRef = await SharedBusinessLogic.DataRepository.GetAll <OrganisationReference>()
.FirstOrDefaultAsync(
o => userOrg.OrganisationId != o.OrganisationId &&
o.ReferenceName.ToLower() == nameof(model.CharityNumber).ToLower() &&
o.ReferenceValue.ToLower() == model.CharityNumber.ToLower());
conflictOrg = orgRef?.Organisation;
if (conflictOrg != null)
{
ModelState.AddModelError(
3031,
nameof(model.CharityNumber),
new { organisationName = conflictOrg.OrganisationName, referenceName = "Charity number" });
}
}
//Check for mutual number conflicts
if (!string.IsNullOrWhiteSpace(model.MutualNumber))
{
var orgRef = await SharedBusinessLogic.DataRepository.GetAll <OrganisationReference>()
.FirstOrDefaultAsync(
o => userOrg.OrganisationId != o.OrganisationId &&
o.ReferenceName.ToLower() == nameof(model.MutualNumber).ToLower() &&
o.ReferenceValue.ToLower() == model.MutualNumber.ToLower());
conflictOrg = orgRef?.Organisation;
if (conflictOrg != null)
{
ModelState.AddModelError(
3031,
nameof(model.MutualNumber),
new
{
organisationName = conflictOrg.OrganisationName,
referenceName = "Mutual partnership number"
});
}
}
//Check for other reference conflicts
if (!string.IsNullOrWhiteSpace(model.OtherValue))
{
var orgRef = await SharedBusinessLogic.DataRepository.GetAll <OrganisationReference>()
.FirstOrDefaultAsync(
o => userOrg.OrganisationId != o.OrganisationId &&
o.ReferenceName.ToLower() == model.OtherName.ToLower() &&
o.ReferenceValue.ToLower() == model.OtherValue.ToLower());
conflictOrg = orgRef?.Organisation;
if (conflictOrg != null)
{
ModelState.AddModelError(
3031,
nameof(model.OtherValue),
new { organisationName = conflictOrg.OrganisationName, referenceName = model.OtherValue });
}
}
if (!ModelState.IsValid)
{
this.CleanModelErrors <OrganisationViewModel>();
return(View("ReviewRequest", model));
}
//Activate the org user
userOrg.PINConfirmedDate = VirtualDateTime.Now;
//Activate the organisation
userOrg.Organisation.SetStatus(
OrganisationStatuses.Active,
OriginalUser == null ? VirtualUser.UserId : OriginalUser.UserId,
"Manually registered");
// Save the DUNS Number
if (string.IsNullOrWhiteSpace(userOrg.Organisation.DUNSNumber) &&
!string.IsNullOrWhiteSpace(model.DUNSNumber))
{
userOrg.Organisation.DUNSNumber = model.DUNSNumber;
}
//Delete the DUNS reference
if (model.IsDUNS && userOrg.Organisation.DUNSNumber == model.OtherValue)
{
var dunsRef =
userOrg.Organisation.OrganisationReferences.FirstOrDefault(r =>
r.ReferenceName == nameof(model.OtherName));
if (dunsRef != null)
{
userOrg.Organisation.OrganisationReferences.Remove(dunsRef);
}
}
//Set the latest registration
userOrg.Organisation.LatestRegistration = userOrg;
// save any sic codes
if (!string.IsNullOrEmpty(model.SicCodeIds))
{
var newSicCodes = model.SicCodeIds.Split(',').Cast <int>().OrderBy(sc => sc);
foreach (var sc in newSicCodes)
{
userOrg.Organisation.OrganisationSicCodes.Add(
new OrganisationSicCode
{
SicCodeId = sc, OrganisationId = userOrg.OrganisationId, Created = VirtualDateTime.Now
});
}
}
//Retire the old address
if (userOrg.Organisation.LatestAddress != null &&
userOrg.Organisation.LatestAddress.AddressId != userOrg.Address.AddressId)
{
userOrg.Organisation.LatestAddress.SetStatus(
AddressStatuses.Retired,
OriginalUser == null ? VirtualUser.UserId : OriginalUser.UserId,
"Replaced by Manual registration");
}
//Activate the address
userOrg.Address.SetStatus(
AddressStatuses.Active,
OriginalUser == null ? VirtualUser.UserId : OriginalUser.UserId,
"Manually registered");
userOrg.Organisation.LatestAddress = userOrg.Address;
//Send the approved email to the applicant
if (!await SendRegistrationAcceptedAsync(
userOrg.User.ContactEmailAddress.Coalesce(userOrg.User.EmailAddress),
userOrg.User.EmailAddress.StartsWithI(SharedBusinessLogic.SharedOptions.TestPrefix)))
{
ModelState.AddModelError(1132);
this.CleanModelErrors <OrganisationViewModel>();
return(View("ReviewRequest", model));
}
//Log the approval
if (!userOrg.User.EmailAddress.StartsWithI(SharedBusinessLogic.SharedOptions.TestPrefix))
{
await _adminService.RegistrationLog.WriteAsync(
new RegisterLogModel
{
StatusDate = VirtualDateTime.Now,
Status = "Manually registered",
ActionBy = VirtualUser.EmailAddress,
Details = "",
Sector = userOrg.Organisation.SectorType,
Organisation = userOrg.Organisation.OrganisationName,
CompanyNo = userOrg.Organisation.CompanyNumber,
Address = userOrg?.Address.GetAddressString(),
SicCodes = userOrg.Organisation.GetLatestSicCodeIdsString(),
UserFirstname = userOrg.User.Firstname,
UserLastname = userOrg.User.Lastname,
UserJobtitle = userOrg.User.JobTitle,
UserEmail = userOrg.User.EmailAddress,
ContactFirstName = userOrg.User.ContactFirstName,
ContactLastName = userOrg.User.ContactLastName,
ContactJobTitle = userOrg.User.ContactJobTitle,
ContactOrganisation = userOrg.User.ContactOrganisation,
ContactPhoneNumber = userOrg.User.ContactPhoneNumber
});
}
//Show confirmation
if (VirtualUser.EmailAddress.StartsWithI(SharedBusinessLogic.SharedOptions.TestPrefix))
{
TempData["TestUrl"] = Url.Action("Impersonate", "Admin",
new { emailAddress = userOrg.User.EmailAddress });
}
result = RedirectToAction("RequestAccepted");
}
else
{
return(new HttpBadRequestResult($"Invalid command on '{command}'"));
}
//Save the changes and redirect
await SharedBusinessLogic.DataRepository.SaveChangesAsync();
//Send notification email to existing users
_adminService.SharedBusinessLogic.NotificationService.SendUserAddedEmailToExistingUsers(userOrg.Organisation,
userOrg.User);
//Ensure the organisation has an employer reference
if (userOrg.PINConfirmedDate.HasValue && string.IsNullOrWhiteSpace(userOrg.Organisation.EmployerReference))
{
await _adminService.OrganisationBusinessLogic.SetUniqueEmployerReferenceAsync(userOrg.Organisation);
}
//Add or remove this organisation to/from the search index
await _adminService.SearchBusinessLogic.UpdateSearchIndexAsync(userOrg.Organisation);
//Save the model for the redirect
StashModel(model);
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utilities.SetNoCache(Response);
}
try
{
if (Session == null || Session["DB"] == null)
{
throw new SessionTimedOutException();
}
string type = Request.QueryString["type"];
string id = Request.QueryString["staff"];
string weekday = Request.QueryString["weekday"];
string start_time = Request.QueryString["start_time"];
string end_time = Request.QueryString["end_time"];
string outside = Request.QueryString["outside"];
if (type == null || (type != "provider" && type != "org") ||
id == null || (id != "-1" && !Regex.IsMatch(id, @"^\d+$")) ||
weekday == null || (weekday != "monday" && weekday != "tuesday" && weekday != "wednesday" && weekday != "thursday" && weekday != "friday" && weekday != "saturday" && weekday != "sunday") ||
start_time == null || !Regex.IsMatch(start_time, @"^\d{4}$") ||
end_time == null || !Regex.IsMatch(end_time, @"^\d{4}$") ||
outside == null || (outside != "0" && outside != "1"))
{
throw new CustomMessageException();
}
Organisation org = type == "org" ? OrganisationDB.GetByID(Convert.ToInt32(id)) : null;
Staff staff = type == "provider" ? StaffDB.GetByID(Convert.ToInt32(id)) : null;
if ((type == "provider" && staff == null) ||
(type == "org" && org == null))
{
throw new CustomMessageException();
}
Booking[] bookings = BookingDB.GetFutureBookings(staff, org, weekday, ConvertToTimeSpan(start_time), ConvertToTimeSpan(end_time), Request.QueryString["outside"] == "1");
string bookingDates = string.Empty;
for (int i = 0; i < bookings.Length; i++)
{
bookingDates += bookings[i].DateStart.ToString(@"ddd MMM d yyy HH:mm") + ",";
}
if (bookingDates.Length > 0)
{
Response.Write(bookingDates.Substring(0, bookingDates.Length - 1));
}
else
{
Response.Write("NONE");
}
}
catch (SessionTimedOutException)
{
Utilities.UnsetSessionVariables();
Response.Write("SessionTimedOutException");
}
catch (Exception ex)
{
Response.Write("Exception: " + (Utilities.IsDev() ? ex.ToString() : "Error - please contact system administrator."));
}
}
public void OneTimeSetUp()
{
this.accounts = FakeServiceFactory.Create <Account>();
this.organisations = FakeServiceFactory.Create <Organisation>();
this.sessions = FakeServiceFactory.Create <Session>();
this.subthemes = FakeServiceFactory.Create <Subtheme>();
this.themes = FakeServiceFactory.Create <Theme>();
this.unauthorized = "unauthorizedusersecret";
this.authorized = "authorizedusersecret";
Account account1 = new Account("*****@*****.**", "name1", "surname1", "picture1", this.authorized)
{
Organisations = new List <Organisation>(),
OrganisedSessions = new List <Session>(),
ParticipatingSessions = new List <Session>(),
Subthemes = new List <Subtheme>(),
Themes = new List <Theme>()
};
account1 = this.accounts.Add(account1);
Account account2 = new Account("*****@*****.**", "name2", "surname2", "picture2", this.unauthorized);
account2 = this.accounts.Add(account2);
Organisation organisation = new Organisation("name", account1.Id)
{
Sessions = new List <Session>(),
Themes = new List <Theme>()
};
organisation = this.organisations.Add(organisation);
account1.Organisations.Add(organisation);
this.accounts.Change(account1);
Theme theme = new Theme("name", "descr", organisation.Id, organisation.OrganiserId, "tag")
{
Subthemes = new List <Subtheme>()
};
theme = this.themes.Add(theme);
organisation.Themes.Add(theme);
this.organisations.Change(organisation);
account1.Themes.Add(theme);
this.accounts.Change(account1);
Subtheme subtheme = new Subtheme("name", theme.OrganiserId, theme.Id)
{
Sessions = new List <Session>()
};
subtheme = this.subthemes.Add(subtheme);
theme.Subthemes.Add(subtheme);
this.themes.Change(theme);
account1.Subthemes.Add(subtheme);
this.accounts.Change(account1);
Session session = new Session(true, 0, "descr", false, 10, 10, organisation.Id, 0, subtheme.Id, DateTime.Now, DateTime.Now.AddDays(5))
{
Organisers = new List <Account>(),
Participants = new List <Account>()
};
session = this.sessions.Add(session);
subtheme.Sessions.Add(session);
this.subthemes.Change(subtheme);
account1.OrganisedSessions.Add(session);
session.Organisers.Add(account1);
account1.ParticipatingSessions.Add(session);
session.Participants.Add(account1);
this.accounts.Change(account1);
this.sessions.Change(session);
}
public static ErrorType WithOrganisation(this ErrorType errorType, Organisation organisation)
{
errorType.Organisation = organisation;
return(errorType);
}
private static bool OrganisationIsNewThisYearAndHasNotProvidedScopeForLastYear(Organisation organisation)
{
DateTime currentYearSnapshotDate = organisation.SectorType.GetAccountingStartDate();
bool organisationCreatedInCurrentReportingYear = organisation.Created >= currentYearSnapshotDate;
if (organisationCreatedInCurrentReportingYear)
{
int previousReportingYear = currentYearSnapshotDate.AddYears(-1).Year;
OrganisationScope scope = organisation.GetScopeForYear(previousReportingYear);
if (scope.IsScopePresumed())
{
return(true);
}
}
return(false);
}
public void MyAccount_NavigationTest(IWebDriver driver)
{
try
{
Thread.Sleep(900);
CommonUtils CookiesAction = new CommonUtils(driver);
CookiesAction.RejectAll_Cookies();
Thread.Sleep(900);
SignIn_Page.Click();
Excel_Suite userEmail = new Excel_Suite(Env.EXCEL_TEST_URL);
userEmail.getCellData("SPP_TestData", true);
UserEmail.SendKeys(Env.Email_Id);
Password.SendKeys("Test@123");
WebDriverWait wait = new WebDriverWait(driver, TimeSpan.FromSeconds(800));
Thread.Sleep(800);
SubmitButton.Click();
MyAccount_Toggle.Click();
Organisation.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "dropdown is working fine");
wait = new WebDriverWait(driver, TimeSpan.FromSeconds(800));
AJAXCall.WaitForAjax();
MyAccount_Toggle.Click();
ServiceProvider_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "dropdown is working fine");
Thread.Sleep(1000);
MyAccount_Toggle.Click();
userRoles_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "pageload is working fine");
MyAccount_Toggle.Click();
BankAccount_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "pageload is working fine");
MyAccount_Toggle.Click();
TuslaCertificate_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "pageload is working fine");
Thread.Sleep(500);
MyAccount_Toggle.Click();
FeesList_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "pageload is working fine");
MyAccount_Toggle.Click();
ServiceCalendar_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "pageload is working fine");
MyAccount_Toggle.Click();
ECCEPreContracting_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "pageload is working fine");
MyAccount_Toggle.Click();
CapitalWorksEquipment_Page.Click();
ReportsGeneration._test.Log(Status.Pass, " " + " " + driver.Url + " " + "dropdown is working fine");
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
private ParseOrderLineResult ParseOrderLine(Organisation org, List <string> catalogIds, string orderLinesAsString)
{
var olElements = orderLinesAsString.Split(new string[] { " x " }, StringSplitOptions.None).ToList();
if (olElements.Count != 2)
{
return(new ParseOrderLineResult(ParseOrderLineResultState.ParseError));
}
string quantityString = olElements[0].Trim();
decimal quantity = 1;
if (!decimal.TryParse(quantityString, out quantity))
{
return(new ParseOrderLineResult(ParseOrderLineResultState.ParseError));
}
string productName = olElements[1].Trim();
bool productHasOptions = false;
string[] productOptionElements = null;
if (productName.Contains('?'))
{
var productNameElements = productName.Split('?').ToList();
productName = productNameElements[0].Trim();
productHasOptions = true;
productOptionElements = productNameElements[1].Split('&');
}
Product product = _Ctx.Product.FirstOrDefault(p => p.Name == productName && catalogIds.Contains(p.CatalogId));
if (product == null)
{
string msg = string.Format("Product '{0}' not found for line: {1}", productName, orderLinesAsString);
return(new ParseOrderLineResult(ParseOrderLineResultState.ProductNotFound, msg));
}
_Ctx.Entry(product).State = System.Data.Entity.EntityState.Detached;
OrderLine orderLine = new OrderLine()
{
Quantity = quantity,
ProductId = product.Id,
Product = product,
PlanningOrder = product.PlanningOrder
};
if (productHasOptions)
{
orderLine.OrderLineOptions = new List <OrderLineOption>();
for (int i = 0; i < productOptionElements.Length; i++)
{
string optionString = productOptionElements[i].Trim();
var optionElements = optionString.Split('=');
string optionCode = optionElements[0].Trim();
string optionValue = optionElements[1].Trim();
if (optionCode.ToLower() == "persons")
{
orderLine.Persons = optionValue;
continue;
}
ProductOption option = _Ctx.ProductOption.FirstOrDefault(po => po.Code == optionCode && po.OrganisationId == org.Id);
if (option == null)
{
string msg = string.Format("Product option '{0}' not found for line: {1}", optionCode, orderLinesAsString);
return(new ParseOrderLineResult(ParseOrderLineResultState.ProductOptionNotFound, msg));
}
/*
* OrderLineOption olOption = new OrderLineOption()
* {
* ProductOptionId = option.Id
* };*/
OrderLineOption olOption = OrderLineOption.CreateNew();
olOption.ProductOptionId = option.Id;
if (option.HasValueObjects)
{
ProductOptionValue value = _Ctx.ProductOptionValue.FirstOrDefault(v => v.ProductOptionId == option.Id && v.Code == optionValue);
if (value != null)
{
olOption.ProductOptionValueId = value.Id;
}
else
{
throw new ApplicationException(string.Format("Product option value not found: {0}!", optionValue));
}
}
else
{
decimal optionNumValue = 0;
if (!decimal.TryParse(optionValue, out optionNumValue))
{
string msg = string.Format("Could not parse value '{0}' for option '{1}' for line: {2}", optionValue, optionCode, orderLinesAsString);
return(new ParseOrderLineResult(ParseOrderLineResultState.InvalidProductOptionValue));
}
olOption.ProductOptionValue = optionNumValue;
}
orderLine.OrderLineOptions.Add(olOption);
}
}
return(new ParseOrderLineResult(orderLine));
}
/// <summary>
/// Create a Organisation
/// </summary>
/// <param name="currentUser"></param>
/// <param name="user"></param>
/// <param name="appID"></param>
/// <param name="overrideID"></param>
/// <param name="dc"></param>
/// <param name="dataRepository"></param>
/// <param name="uow"></param>
public OrganisationVMDC CreateOrganisation(string currentUser, string user, string appID, string overrideID, OrganisationDC dc, IRepository <Organisation> dataRepository, IUnitOfWork uow, IExceptionManager exceptionManager, IMappingService mappingService)
{
try
{
#region Parameter validation
// Validate parameters
if (string.IsNullOrEmpty(currentUser))
{
throw new ArgumentOutOfRangeException("currentUser");
}
if (string.IsNullOrEmpty(user))
{
throw new ArgumentOutOfRangeException("user");
}
if (string.IsNullOrEmpty(appID))
{
throw new ArgumentOutOfRangeException("appID");
}
if (null == dc)
{
throw new ArgumentOutOfRangeException("dc");
}
if (null == dataRepository)
{
throw new ArgumentOutOfRangeException("dataRepository");
}
if (null == uow)
{
throw new ArgumentOutOfRangeException("uow");
}
if (null == exceptionManager)
{
throw new ArgumentOutOfRangeException("exceptionManager");
}
if (null == mappingService)
{
throw new ArgumentOutOfRangeException("mappingService");
}
#endregion
using (uow)
{
// Create a new ID for the Organisation item
dc.Code = Guid.NewGuid();
// Map data contract to model
Organisation destination = mappingService.Map <OrganisationDC, Organisation>(dc);
// Add the new item
dataRepository.Add(destination);
// Commit unit of work
uow.Commit();
// Map model back to data contract to return new row id.
dc = mappingService.Map <Organisation, OrganisationDC>(destination);
}
// Create aggregate data contract
OrganisationVMDC returnObject = new OrganisationVMDC();
// Add new item to aggregate
returnObject.OrganisationItem = dc;
return(returnObject);
}
catch (Exception e)
{
//Prevent exception from propogating across the service interface
exceptionManager.ShieldException(e);
return(null);
}
}
private void DisplayOrganisationDetails(Organisation organisation)
{
_pnlContactDetails.Style.Add("width", "800px");
_pnlContactDetails.Style.Add("height", "500px");
_pnlOrganisation.Visible = true;
_pnlIndividual.Visible = false;
//Get the data for the dropdown lists only if we havent fetched it earlier
if (!(bool)ViewState["OrganisationsDropdownsPopulated"])
{
BindOrganisationsDropdownLists();
ViewState["OrganisationsDropdownsPopulated"] = true;
}
_txtOrganisationName.Text = organisation.Name;
_txtRegisteredName.Text = organisation.RegisteredName;
_txtRegisteredNo.Text = organisation.RegisteredNo;
_txtVATNo.Text = organisation.VATNo;
_ddlIndustry.SelectedValue = organisation.IndustryId.ToString();
_ddlSubType.SelectedValue = organisation.SubTypeId.ToString();
}
public static QuoteItemBuilder WithSerializedDefaults(this QuoteItemBuilder @this, Organisation internalOrganisation)
{
var faker = @this.Session.Faker();
var serializedProduct = new UnifiedGoodBuilder(@this.Session).WithSerialisedDefaults(internalOrganisation).Build();
@this.WithDetails(faker.Lorem.Sentence());
@this.WithComment(faker.Lorem.Sentence());
@this.WithInternalComment(faker.Lorem.Sentence());
@this.WithEstimatedDeliveryDate(@this.Session.Now().AddDays(5));
@this.WithInvoiceItemType(new InvoiceItemTypes(@this.Session).ProductItem);
@this.WithProduct(serializedProduct);
@this.WithSerialisedItem(serializedProduct.SerialisedItems.First);
@this.WithUnitOfMeasure(new UnitsOfMeasure(@this.Session).Piece);
@this.WithAssignedUnitPrice(faker.Random.UInt());
@this.WithQuantity(1);
return(@this);
}
private static void TestFindingItemsUsingLinqSyntax(Repository repository, Organisation organisation)
{
// Try the linq syntax to select items with sales details..
var itemQuery = from item in repository.Items
where item.SalesDetails != null
select item;
var itemList = itemQuery.ToList();
Console.WriteLine("There are {0} inventory items", itemList.Count);
foreach (var item in itemList)
{
Console.WriteLine(string.Format(" Item {0} is sold at price: {1} {2}", item.Description, item.SalesDetails.UnitPrice, organisation.BaseCurrency));
}
}
public static Organisation[] GetFlattenedTree(DataTable dt = null, bool showDeleted = false, int organisationID = 0, bool onlyLowerBranches = false, string org_type_ids = "")
{
if (dt == null)
{
dt = OrganisationDB.GetDataTable(0, showDeleted, true, false, false, true, true, "", false, org_type_ids);
}
dt.Columns.Add("tree_level", typeof(Int32));
Organisation[] tree = GetChildren(ref dt, "parent_organisation_id is NULL", 0);
if (organisationID != 0)
{
for (int i = 0; i < tree.Length; i++)
{
if (tree[i].OrganisationID == organisationID || Contains(tree[i].TreeChildren, organisationID))
{
if (!onlyLowerBranches)
{
tree = new Organisation[] { tree[i] }
}
;
else
{
tree = new Organisation[] { GetNode(new Organisation[] { tree[i] }, organisationID) }
};
}
}
}
DataTable newTable = dt.Clone();
Flatten(tree, ref newTable);
if (onlyLowerBranches && newTable.Rows.Count > 0) // if taking only sub-tree, then reset the level to zero for the base node(s)
{
int levelAdjustment = Convert.ToInt32(newTable.Rows[0]["tree_level"]);
for (int i = 0; i < newTable.Rows.Count; i++)
{
newTable.Rows[i]["tree_level"] = Convert.ToInt32(newTable.Rows[i]["tree_level"]) - levelAdjustment;
}
}
ArrayList newList = new ArrayList();
Hashtable orgHash = new Hashtable();
for (int i = 0; i < newTable.Rows.Count; i++)
{
Organisation org = OrganisationDB.LoadAll(newTable.Rows[i]);
org.TreeLevel = Convert.ToInt32(newTable.Rows[i]["tree_level"]);
orgHash[org.OrganisationID] = org;
newList.Add(org);
}
Organisation[] list = (Organisation[])newList.ToArray(typeof(Organisation));
for (int i = 0; i < list.Length; i++)
{
if (list[i].ParentOrganisation != null)
{
list[i].ParentOrganisation = (Organisation)orgHash[list[i].ParentOrganisation.OrganisationID];
}
}
return(list);
}
