private void LoadData() { PersonnelBindingSource.DataSource = PersonnelManagement.GetA(PersonnelNo); EducationObjBindingSource.DataSource = StaticClass.ListEducation(PersonnelNo); EligibilityBindingSource.DataSource = EligibilityManagement.GetAll(PersonnelNo); ExperiencyBindingSource.DataSource = ExperienceManagement.GetAll(PersonnelNo); VoluntaryBindingSource.DataSource = VoluntaryManagement.GetAll(PersonnelNo); TrainingBindingSource.DataSource = TrainingManagement.GetAll(PersonnelNo); SpousBindingSource.DataSource = SpouseManagement.GetA(PersonnelNo); SkillBindingSource.DataSource = SkillManagement.GetAll(PersonnelNo); OrganizationBindingSource.DataSource = OrganizationManagement.GetAll(PersonnelNo); DistinctionBindingSource.DataSource = DistinctionManagement.GetAll(PersonnelNo); QuestionBindingSource.DataSource = QuestionManagement.GetAll(PersonnelNo); ReferenceBindingSource.DataSource = ReferencesManagement.GetAll(PersonnelNo); DetailBindingSource.DataSource = Details.GetAll(PersonnelNo); if (SpousBindingSource?.Current == null) { return; } ChildrenObjBindingSource.DataSource = StaticClass.ListChildren(((Spous)SpousBindingSource.Current).SpouseNo); reportViewer1.SetDisplayMode(DisplayMode.PrintLayout); reportViewer1.ZoomMode = ZoomMode.Percent; reportViewer1.ZoomPercent = 100; this.reportViewer1.RefreshReport(); }
private void organizationDataGridView_RowLeave(object sender, DataGridViewCellEventArgs e) { if (organizationBindingSource == null) { return; } if (organizationDataGridView.Rows.Count <= 1) { return; } if (!organizationDataGridView.IsCurrentRowDirty) { return; } Validate(); ((Organization)organizationBindingSource.Current).PersonnelNo = Personnel.PersonnelNo; organizationBindingSource.EndEdit(); var iResult = OrganizationManagement.Save((Organization)organizationBindingSource.Current); }
private void DeleteOrganization() { var dResult = MessageBox.Show(@"Delete Organization current record?", @"Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); if (dResult == DialogResult.Yes) { if (OrganizationManagement.Delete(((Organization)organizationBindingSource.Current).OrganizationNo)) { MessageBox.Show(@"Record was deleted successfully.", @"Delete", MessageBoxButtons.OK, MessageBoxIcon.Information); organizationBindingSource.RemoveCurrent(); } else { MessageBox.Show(@"Error on delete operation.", @"Delete", MessageBoxButtons.OK, MessageBoxIcon.Error); organizationDataGridView.Focus(); } } }
private void LoadInitPersonnelRelatedRecord() { Cursor.Current = Cursors.WaitCursor; var pNo = ((Personnel)personnelBindingSource.Current).PersonnelNo; if (pNo > 0) { eligibilityBindingSource.DataSource = EligibilityManagement.GetAll(pNo); experiencyBindingSource.DataSource = ExperienceManagement.GetAll(pNo); voluntaryBindingSource.DataSource = VoluntaryManagement.GetAll(pNo); trainingBindingSource.DataSource = TrainingManagement.GetAll(pNo); educationObjBindingSource.DataSource = StaticClass.ListEducation(pNo); spousBindingSource.DataSource = SpouseManagement.GetAll(pNo); skillBindingSource.DataSource = SkillManagement.GetAll(pNo); organizationBindingSource.DataSource = OrganizationManagement.GetAll(pNo); distinctionBindingSource.DataSource = DistinctionManagement.GetAll(pNo); questionBindingSource.DataSource = QuestionManagement.GetAll(pNo); referenceBindingSource.DataSource = ReferencesManagement.GetAll(pNo); detailBindingSource.DataSource = Details.GetAll(pNo); } Cursor.Current = Cursors.Default; }
public FunctionDataProvider(OrganizationManagement orgManager) { this._orgManager = orgManager; }
protected void btnAddInstitution_Click(object sender, EventArgs e) { string Name = txtName.Text; string Email = txtEmail.Text; string Password = txtPassword.Text; if (Name != "" && Email != "" && Password != "") { if ((from org in dc.Organizations where org.Name == Name select org).Count() == 0) { if ((from usr in dc.aspnet_Users where usr.UserName == Email select usr).Count() == 0) { try { // add organization Organization org = new Organization(); org.Name = Name; org.Description = txtDesc.Text; dc.Organizations.InsertOnSubmit(org); dc.SubmitChanges(); // add user MembershipUser newUser = Membership.CreateUser(Email, Password, Email); Roles.AddUserToRole(newUser.UserName, "institute administrator"); // get organization ID and user ID long orgID = (from org1 in dc.Organizations where org1.Name == Name select org1).Single().OrganizationID; Guid userID = (from usr in dc.aspnet_Users where usr.UserName == Email select usr).Single().UserId; // create relationship OrganizationManagement relationship = new OrganizationManagement(); relationship.OrganizationID = orgID; relationship.UserID = userID; dc.OrganizationManagements.InsertOnSubmit(relationship); dc.SubmitChanges(); lbStatus.Text = "Institution successfully added"; txtName.Text = txtDesc.Text = txtEmail.Text = ""; List<Organization> list = (from org0 in dc.Organizations select org0).ToList<Organization>(); rptInstitution.DataSource = list; rptInstitution.DataBind(); } catch (Exception ex) { Organization org = (from org2 in dc.Organizations where org2.Name == Name select org2).SingleOrDefault(); aspnet_User user = (from usr1 in dc.aspnet_Users where usr1.UserName == Email select usr1).SingleOrDefault(); OrganizationManagement relationship = null; if (org != null && user != null) { relationship = (from rel in dc.OrganizationManagements where rel.UserID == user.UserId && rel.OrganizationID == org.OrganizationID select rel).SingleOrDefault(); } if (org != null) { dc.Organizations.DeleteOnSubmit(org); } if (user != null) { Membership.DeleteUser(Email, true); } if (relationship != null) { dc.OrganizationManagements.DeleteOnSubmit(relationship); } dc.SubmitChanges(); lbStatus.Text = "Institution not added, an error has occurred"; } } else { lbStatus.Text = "A user with the same Email exists already"; } } else { lbStatus.Text = "An institution with the same name exists already"; } } else { lbStatus.Text = "Please complete the form"; } }
public DepartmentDataProvider(OrganizationManagement orgManager) { this._orgManager = orgManager; }
partial void DeleteOrganizationManagement(OrganizationManagement instance);
partial void UpdateOrganizationManagement(OrganizationManagement instance);
partial void InsertOrganizationManagement(OrganizationManagement instance);
private void detach_OrganizationManagements(OrganizationManagement entity) { this.SendPropertyChanging(); entity.Organization = null; }
public GroupDataProvider(OrganizationManagement orgManager) { this._orgManager = orgManager; }