protected void Page_Load(object sender, EventArgs e) { RunSecurity(CRM.Code.Models.Admin.AllowedSections.NotSet); Entity = db.CRM_Schools.SingleOrDefault(o => o.ID.ToString() == Request.QueryString["id"]); // buttons // btnDelete.EventHandler = btnDelete_Click; btnSubmit.EventHandler = btnSubmit_Click; btnSubmitChanges.EventHandler = btnSubmitChanges_Click; ucCustomFields._DataTableID = db._DataTables.Single(c => c.TableReference == "CRM_School").ID; btnReinstate.EventHandler = btnReinstate_Click; ucLogHistory.IHistory = Entity; ucLogNotes.INotes = Entity; // confirmations // confirmationDelete.StandardDeleteHidden("organisation", btnRealDelete_Click); CRMContext = Entity; // process // if (!IsPostBack) { ddlSchoolType.DataSource = CRM_SchoolType.SetDropDown(db.CRM_SchoolTypes.Select(s => (IArchivable)s), Entity == null ? null : Entity.CRM_SchoolType); ddlSchoolType.DataBind(); ddlLEA.DataSource = CRM_LEA.BaseSet(db); ddlLEA.DataBind(); chkKeyStages.DataSource = CRM_KeyStage.SetCheckboxList(db.CRM_KeyStages.Select(s => (IArchivable)s), Entity == null ? null : Entity.CRM_SchoolKeystages.Select(s => (ICRMRecord)s.CRM_KeyStage)); chkKeyStages.DataBind(); if (Entity != null) { PopulateFields(); } else { ucCustomFields.Populate(String.Empty); } } ucNavSchool.Entity = Entity; }
protected void lnkAutoSearch(object sender, EventArgs e) { CRM.Code.Models.CRM_School Item = db.CRM_Schools.SingleOrDefault(c => c.ID.ToString() == acSchool.SelectedID); if (Item != null) { if (!Entity.CRM_OrganisationSchools.Any((a => a.CRM_SchoolID == Item.ID))) { CRM_OrganisationSchool CRM_OrganisationSchool = new CRM_OrganisationSchool() { CRM_SchoolID = Item.ID, CRM_OrganisationID = Entity.ID }; db.CRM_OrganisationSchools.InsertOnSubmit(CRM_OrganisationSchool); db.SubmitChanges(); } } NoticeManager.SetMessage(Item.DisplayName + " tagged to " + Entity.DisplayName); }
protected void SaveRecord(bool newRecord) { // new record / exiting record // object oldEntity = null; object oldAddress = null; if (newRecord) { Entity = new CRM_School(); Entity.IsArchived = false; Entity.CRM_Address = new CRM_Address(); Entity.PrimaryContactReference = ""; db.CRM_Schools.InsertOnSubmit(Entity); } else { oldEntity = Entity.ShallowCopy(); oldAddress = Entity.CRM_Address.ShallowCopy(); } if (ddlLEA.SelectedValue != "") { Entity.CRM_LEAID = Convert.ToInt32(ddlLEA.SelectedValue); } else { Entity.CRM_LEAID = null; } Entity.Name = txtOrganisationName.Text; Entity.CRM_SchoolTypeID = Convert.ToInt32(ddlSchoolType.SelectedValue); Entity.ApproxPupils = Convert.ToInt32(txtPupils.Text); Entity.SageAccountNumber = txtSage.Text; Entity.SENSupportFreq = txtSENFrequency.Text; Entity.IsSEN = chkIsSEN.Checked; Entity.Email = txtEmail.Text; Entity.Phone = txtPhone.Text; ucAddress.Save(Entity.CRM_Address); db.CRM_SchoolKeystages.DeleteAllOnSubmit(Entity.CRM_SchoolKeystages); db.SubmitChanges(); foreach (ListItem item in chkKeyStages.Items) { if (item.Selected) { CRM_SchoolKeystage sKs = new CRM_SchoolKeystage() { CRM_KeyStageID = Convert.ToInt32(item.Value), CRM_SchoolID = Entity.ID }; db.CRM_SchoolKeystages.InsertOnSubmit(sKs); db.SubmitChanges(); } } if (oldEntity != null) { CRM.Code.History.History.RecordLinqUpdate(AdminUser, oldEntity, Entity); CRM.Code.History.History.RecordLinqUpdate(AdminUser, oldAddress, Entity.CRM_Address); db.SubmitChanges(); } else { CRM.Code.History.History.RecordLinqInsert(AdminUser, Entity); CRM.Code.History.History.RecordLinqInsert(AdminUser, Entity.CRM_Address); } ucCustomFields.Save(Entity.Reference); }