private void populateLinkedCurriculumCourses() { using (var Dbconnection = new MCDEntities()) { List <CurriculumCourse> AllItems = (from a1 in Dbconnection.GetCurriculumCourseInOrder(CurrentEnrollemnt.CurriculumID) select a1).Intersect(from a2 in Dbconnection.CurriculumCourseEnrollments where a2.EnrollmentID == CurrentEnrollemnt.EnrollmentID select a2.CurriculumCourse) .ToList <CurriculumCourse>(); curriculumCourseLinkedBindingSource.DataSource = (from a in AllItems orderby a.Course.CourseName select a).ToList(); foreach (CurriculumCourse CurriculumCourseObj in curriculumCourseLinkedBindingSource.List) { if (!Dbconnection.Entry(CurriculumCourseObj).Reference(a => a.Course).IsLoaded) { Dbconnection.Entry(CurriculumCourseObj).Reference(a => a.Course).Load(); } if (!Dbconnection.Entry(CurriculumCourseObj).Collection(a => a.CurriculumCourseEnrollments).IsLoaded) { Dbconnection.Entry(CurriculumCourseObj).Collection(a => a.CurriculumCourseEnrollments).Load(); } } }; }
private void btnPropcessException_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { try { Dbconnection.Enrollments.Attach(SelectedEnrollment); SelectedEnrollment.LookupEnrollmentProgressStateID = (int)EnumEnrollmentProgressStates.Excempt; Dbconnection.Entry(SelectedEnrollment).State = System.Data.Entity.EntityState.Modified; Dbconnection.SaveChanges(); EquiryHistory hist = new EquiryHistory { EnquiryID = EnquiryID, EmployeeID = this.CurrentEmployeeLoggedIn.EmployeeID, LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Enrollment_Course_PreRequisite_Was_Except, DateEnquiryUpdated = DateTime.Now, EnquiryNotes = "For Enrollment : " + EnquiryID.ToString() + "\n\nThe following Curriculum: " + SelectedEnrollment.Curriculum.CurriculumName.ToString() + " Has Been Excempt.\n\nEnrollment Ref:\n" + SelectedEnrollment.EnrollmentID + "\n\nNotes:" + txtExceptionNotes.Text.ToString() }; Dbconnection.EquiryHistories.Add(hist); int IsSaved = Dbconnection.SaveChanges(); //SelectedEnrollment.LookupEnrollmentProgressState = null; Dbconnection.Entry(SelectedEnrollment).Reference("LookupEnrollmentProgressState").Load(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { this.Close(); } }; }
private void btnUpdateContactDetials_Click(object sender, EventArgs e) { using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0)) { ContactDetail CurrentDetail = (ContactDetail)contactDetailBindingSource.Current; frm.CurrentDetail = CurrentDetail; frm.ContactDetailID = CurrentDetail.ContactDetailID; Individual CurrentContact = (Individual)individualBindingSource.Current; frm.ShowDialog(); if (frm.CurrentDetail != null) { using (var Dbconnection = new MCDEntities()) { Dbconnection.ContactDetails.Attach(CurrentDetail); Dbconnection.Entry(CurrentDetail).State = EntityState.Modified; Dbconnection.SaveChanges(); Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load(); }; this.refreshContactDetails(); } } }
private void btnAddStudentAddress_Click(object sender, EventArgs e) { frmAddUpdateAddresses frm = new frmAddUpdateAddresses(0); frm.ShowDialog(); if (frm.CurrentAddress != null) { if (frm.CurrentAddress.AddressID != 0) { using (var Dbconnection = new MCDEntities()) { Data.Models.Company CurrentCompany = ((Data.Models.Company)companyBindingSource.Current); Dbconnection.Companies.Attach(CurrentCompany); Dbconnection.Addresses.Attach(frm.CurrentAddress); CurrentCompany.Addresses.Add(frm.CurrentAddress); Dbconnection.SaveChanges(); Dbconnection.Entry(frm.CurrentAddress).Reference("LookupAddressType").Load(); Dbconnection.Entry(frm.CurrentAddress).Reference("LookupProvince").Load(); Dbconnection.Entry(frm.CurrentAddress).Reference("LookupCountry").Load(); }; refreshCompanyAddresses(); } } }
private void btnStudentAddressAddUpdate_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { if (CurrentAddress != null) { Dbconnection.Addresses.Attach(CurrentAddress); CurrentAddress.AddressTypeID = Convert.ToInt32(cboStudentAddressAddressType.SelectedValue); CurrentAddress.AddressIsDefault = chkStudnetAddressIsDefault.Checked; CurrentAddress.CountryID = Convert.ToInt32(cboStudentAddressCountry.SelectedValue); CurrentAddress.ProvinceID = Convert.ToInt32(cboStudentAddressProvince.SelectedValue); CurrentAddress.AddressLineTwo = txtStudentAddressLineTwo.Text.ToString(); CurrentAddress.AddressLineOne = txtStudentAddressLineOne.Text.ToString(); CurrentAddress.AddressTown = txtStudentAddressTown.Text.ToString(); CurrentAddress.AddressSuburb = txtStudentAddressSuburb.Text.ToString(); CurrentAddress.AddressAreaCode = txtStudentAddressAreaCode.Text.ToString(); Dbconnection.SaveChanges(); Dbconnection.Entry(CurrentAddress).Reference(a => a.LookupAddressType).Load(); Dbconnection.Entry(CurrentAddress).Reference(a => a.LookupProvince).Load(); Dbconnection.Entry(CurrentAddress).Reference(a => a.LookupCountry).Load(); } ; }; this.Close(); }
private void btnStudentAddressAddUpdate_Click(object sender, EventArgs e) { //using (var Dbconnection = new MCDEntities()) //{ // Address AddressToUpdate = (from a in Dbconnection.Addresses // where a.AddressID == this.AddressID // select a).FirstOrDefault<Address>(); // AddressToUpdate.AddressTypeID = Convert.ToInt32(cboStudentAddressAddressType.SelectedValue); // AddressToUpdate.AddressIsDefault = chkStudnetAddressIsDefault.Checked; // AddressToUpdate.CountryID = Convert.ToInt32(cboStudentAddressCountry.SelectedValue); // AddressToUpdate.ProvinceID = Convert.ToInt32(cboStudentAddressProvince.SelectedValue); // AddressToUpdate.AddressLineTwo = txtStudentAddressLineTwo.Text.ToString(); // AddressToUpdate.AddressLineOne = txtStudentAddressLineOne.Text.ToString(); // AddressToUpdate.AddressTown = txtStudentAddressTown.Text.ToString(); // AddressToUpdate.AddressSuburb = txtStudentAddressSuburb.Text.ToString(); // AddressToUpdate.AddressAreaCode = txtStudentAddressAreaCode.Text.ToString(); // AddressToUpdate.AddressModifiedDate = DateTime.Now; // Dbconnection.SaveChanges(); // Dbconnection.Entry(AddressToUpdate).Reference(a => a.LookupAddressType).Load(); // Dbconnection.Entry(AddressToUpdate).Reference(a => a.LookupProvince).Load(); // Dbconnection.Entry(AddressToUpdate).Reference(a => a.LookupCountry).Load(); //}; using (var Dbconnection = new MCDEntities()) { if (CurrentAddress != null) { Dbconnection.Addresses.Attach(CurrentAddress); CurrentAddress.AddressTypeID = Convert.ToInt32(cboStudentAddressAddressType.SelectedValue); CurrentAddress.AddressIsDefault = chkStudnetAddressIsDefault.Checked; CurrentAddress.CountryID = Convert.ToInt32(cboStudentAddressCountry.SelectedValue); CurrentAddress.ProvinceID = Convert.ToInt32(cboStudentAddressProvince.SelectedValue); CurrentAddress.AddressLineTwo = txtStudentAddressLineTwo.Text.ToString(); CurrentAddress.AddressLineOne = txtStudentAddressLineOne.Text.ToString(); CurrentAddress.AddressTown = txtStudentAddressTown.Text.ToString(); CurrentAddress.AddressSuburb = txtStudentAddressSuburb.Text.ToString(); CurrentAddress.AddressAreaCode = txtStudentAddressAreaCode.Text.ToString(); Dbconnection.SaveChanges(); Dbconnection.Entry(CurrentAddress).Reference(a => a.LookupAddressType).Load(); Dbconnection.Entry(CurrentAddress).Reference(a => a.LookupProvince).Load(); Dbconnection.Entry(CurrentAddress).Reference(a => a.LookupCountry).Load(); } ; }; this.Close(); }
private void picSearchStudents_Click(object sender, EventArgs e) { List <Student> StudentExcemptionList = new List <Student>(); using (var Dbconnection = new MCDEntities()) { //Loadds the associated Collections in this case the Enrollment with their associated Students that are enrolled. Dbconnection.CurriculumEnquiries.Attach(CurrentCurriculumEnquiry); //Load all enrollments that linked to the Enquiry Item. Dbconnection.Entry(CurrentCurriculumEnquiry).Collection(a => a.Enrollments).Load(); foreach (Enrollment EnrollmentObj in CurrentCurriculumEnquiry.Enrollments) { //Load the student linked to the enrollment Dbconnection.Entry(EnrollmentObj).Reference(a => a.Student).Load(); StudentExcemptionList.Add(EnrollmentObj.Student); } }; using (frmStudentSearchForStudent frm = new frmStudentSearchForStudent()) { //Set the list of student that are already Enrolled for this Enquiry Item. frm.StudentExpceptionList = StudentExcemptionList; frm.ShowDialog(); if (frm.CurrentSelectedStudent != null) { txtStudentFullName.Text = frm.CurrentSelectedStudent.Individual.FullName; txtStudentIdNumber.Text = frm.CurrentSelectedStudent.StudentIDNumber; txtStudentNember.Text = frm.CurrentSelectedStudent.StudentID.ToString(); CurrentSelectedStudent = frm.CurrentSelectedStudent; //Summary Fields txtSummaryFullName.Text = txtStudentFullName.Text; txtSummaryIDNumber.Text = txtStudentIdNumber.Text; txtSummaryStudentNumber.Text = txtStudentNember.Text; picbtnEditCurrentStudent.Visible = true; } else { picbtnEditCurrentStudent.Visible = false; txtStudentFullName.Clear(); txtStudentIdNumber.Clear(); txtStudentNember.Clear(); //Summary Fields txtSummaryFullName.Clear(); txtSummaryIDNumber.Clear(); txtSummaryStudentNumber.Clear(); CurrentSelectedStudent = null; } }; }
private void btnSearchForCompany_Click(object sender, EventArgs e) { using (frmCompanySearch frm = new frmCompanySearch()) { frm.ShowDialog(); if (frm.CurrentCompany != null) { //this.CurrentScheduleConfiguration.Clear(); CurrentlySelectedCompany = frm.CurrentCompany; using (var Dbconnection = new MCDEntities()) { Dbconnection.Companies.Attach(CurrentlySelectedCompany); Dbconnection.Entry(CurrentlySelectedCompany).Collection(a => a.Addresses).Load(); }; companyBindingSource.DataSource = CurrentlySelectedCompany; addressBindingSource.DataSource = (from a in CurrentlySelectedCompany.Addresses select a).ToList <Data.Models.Address>(); } else { companyBindingSource.DataSource = null; addressBindingSource.DataSource = null; //this.CurrentScheduleConfiguration.Companies.Clear(); } }; this.refreshCompanyInfo(); }
private void btnUpdateEmployee_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { Dbconnection.Employees.Attach(CurrentEmployee); CurrentEmployee.EmployeeNumber = txtEmployeeNumber.Text.ToString(); CurrentEmployee.Individual.TitleID = Convert.ToInt32(this.cboEmployeeTitle.SelectedValue); CurrentEmployee.Individual.IndividualFirstName = txtEmployeeFirstName.Text.ToString(); CurrentEmployee.Individual.IndividualSecondName = txtEmployeeSecondName.Text.ToString(); CurrentEmployee.Individual.IndividualLastname = txtEmployeeLastName.Text.ToString(); Dbconnection.Entry <Employee>(CurrentEmployee).State = System.Data.Entity.EntityState.Modified; Dbconnection.SaveChanges(); //Dbconnection.Entry(CurrentEmployee).Reference(a => a.Individual.LookupTitle).Load(); //Dbconnection.Entry(CurrentEmployee).Reference(a => a.LookupProvince).Load(); //Dbconnection.Entry(CurrentEmployee).Reference(a => a.LookupCountry).Load(); }; this.Close(); }
private void btnRemoveStudentIDDocuments_Click(object sender, EventArgs e) { DialogResult Rtn = MessageBox.Show("Are You Sure You Wish To Remove This File?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (Rtn == DialogResult.Yes) { Data.Models.File FileToRemove = (Data.Models.File)fileStudentIDDocumentBindingSource.Current; using (var Dbconnection = new MCDEntities()) { //Data.Models.File x = (from a in Dbconnection.Files // where a.) List <StudentIDDocument> x = (from a in Dbconnection.StudentIDDocuments where a.FileID == FileToRemove.FileID select a).ToList <StudentIDDocument>(); foreach (StudentIDDocument doc in x) { Dbconnection.Entry(doc).State = EntityState.Deleted; } Dbconnection.SaveChanges(); }; this.refreshStudentIDDocumnets(); } }
private void btnSave_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { string InitialConsultationText = "None or No Notes where documented."; if (txtNotes.Text.Length > 0) { InitialConsultationText = txtNotes.Text; } EquiryHistory hist = new EquiryHistory { EnquiryID = CurrentEnquiry.EnquiryID, EmployeeID = this.EmployeeID, LookupEquiyHistoryTypeID = (int)EnumEquiryHistoryTypes.Enquiry_Initial_Consultation_Completed, DateEnquiryUpdated = DateTime.Now, EnquiryNotes = InitialConsultationText }; Dbconnection.EquiryHistories.Add(hist); int IsSaved = Dbconnection.SaveChanges(); if (IsSaved > 0) { Dbconnection.Enquiries.Attach(CurrentEnquiry); CurrentEnquiry.InitialConsultationComplete = true; Dbconnection.Entry <Data.Models.Enquiry>(CurrentEnquiry).State = System.Data.Entity.EntityState.Modified; Dbconnection.SaveChanges(); } }; this.Close(); }
private void btnUpdateContact_Click(object sender, EventArgs e) { Individual IndividualToUpdate = null; using (var Dbconnection = new MCDEntities()) { IndividualToUpdate = (from a in Dbconnection.Individuals where a.IndividualID == IndividualID select a).FirstOrDefault <Individual>(); IndividualToUpdate.TitleID = Convert.ToInt32(cboIndividualTitle.SelectedValue); IndividualToUpdate.IndividualFirstName = txtFirstName.Text.ToString(); IndividualToUpdate.IndividualSecondName = txtSecondName.Text.ToString(); IndividualToUpdate.IndividualLastname = txtLastName.Text.ToString(); Dbconnection.SaveChanges(); Dbconnection.Entry(IndividualToUpdate).Reference(a => a.LookupTitle).Load(); }; if (CurrentContact != null) { CurrentContact.TitleID = Convert.ToInt32(cboIndividualTitle.SelectedValue); CurrentContact.IndividualFirstName = txtFirstName.Text.ToString(); CurrentContact.IndividualSecondName = txtSecondName.Text.ToString(); CurrentContact.IndividualLastname = txtLastName.Text.ToString(); CurrentContact.LookupTitle = IndividualToUpdate.LookupTitle; } this.Close(); }
private void btnAddNewContactDetails_Click(object sender, EventArgs e) { if (CurrentEnquiry.Individuals.Count > 0) { frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0); Individual CurrentContact = CurrentEnquiry.Individuals.FirstOrDefault <Individual>(); frm.ShowDialog(); if (frm.CurrentDetail != null) { using (var Dbconnection = new MCDEntities()) { Dbconnection.Individuals.Attach(CurrentContact); Dbconnection.ContactDetails.Attach(frm.CurrentDetail); CurrentContact.ContactDetails.Add(frm.CurrentDetail); Dbconnection.SaveChanges(); Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load(); }; this.refreshContactDetails(); } } }
private Boolean DetermineIfAllPreRequisiteCourseHaveBeenScheduled(int _CurriculumCourseID, int _EnrollmentID) { Boolean Rtn = true; IEnumerable <CurriculumCourse> PreRequisiteCoursesNotScheduled; using (var Dbconnection = new MCDEntities()) { PreRequisiteCoursesNotScheduled = (from a in Dbconnection.GetCurriculumCoursePreRequisiteCourseNotYetScheduled(_CurriculumCourseID, _EnrollmentID) select a) .ToList <CurriculumCourse>(); if (PreRequisiteCoursesNotScheduled.Count <CurriculumCourse>() > 0) { int iCounter = 1; Rtn = false; String ErrorMessage = "Before proceeding to schedule this course please schedule the following course first, as these are Pre-Requisite Courses for the currently selected course:\n\n"; foreach (CurriculumCourse CC in PreRequisiteCoursesNotScheduled) { Dbconnection.Entry(CC).Reference(a => a.Course).Load(); ErrorMessage += iCounter + " - " + CC.Course.CourseName + "\n"; iCounter++; } MessageBox.Show(ErrorMessage, "Pre-Requisite Course To Schedule", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }; return(Rtn); }
private void dgvClientFullName_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { var gridView = (DataGridView)sender; foreach (DataGridViewRow row in gridView.Rows) { if (!row.IsNewRow) { Individual IndividualObj = (Individual)(row.DataBoundItem); if (IndividualObj.Companies == null) { using (var Dbconnection = new MCDEntities()) { Dbconnection.Configuration.LazyLoadingEnabled = false; Dbconnection.Individuals.Attach(IndividualObj); Dbconnection.Entry(IndividualObj).Collection(a => a.Companies).Load(); }; } if (IndividualObj.Companies != null) { if (IndividualObj.Companies.Count > 0) { row.Cells[colContactCompany.Index].Value = IndividualObj.Companies.FirstOrDefault().CompanyName.ToString(); } else { row.Cells[colContactCompany.Index].Value = "NA - Private Client"; } } } } }
private void btnAddContactInfo_Click(object sender, EventArgs e) { using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0)) { Individual CurrentContact = (Individual)individualBindingSource.Current; frm.ShowDialog(); if (frm.CurrentDetail != null) { using (var Dbconnection = new MCDEntities()) { Dbconnection.Individuals.Attach(CurrentContact); Dbconnection.ContactDetails.Attach(frm.CurrentDetail); CurrentContact.ContactDetails.Add(frm.CurrentDetail); Dbconnection.SaveChanges(); Dbconnection.Entry(frm.CurrentDetail).Reference("LookupContactType").Load(); }; this.refreshContactDetails(); } } }
private void btnUpdateCurriculumEnquiryItemEnrollmentQty_Click(object sender, EventArgs e) { using (frmUpdateSelectedCurriculumEnrollQty frm = new frmUpdateSelectedCurriculumEnrollQty()) { CurriculumEnquiry CE = (CurriculumEnquiry)curriculumEnquiryInprogressBindingSource.Current; using (var Dbconnection = new MCDEntities()) { Data.Models.Enquiry EnquiryObj = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current; Dbconnection.Enquiries.Attach(EnquiryObj); Dbconnection.Entry(CE).Collection(a => a.Enrollments).Load(); }; frm.nudQtyToEnroll.Minimum = CE.Enrollments.Count + 1; frm.nudQtyToEnroll.Value = CE.Enrollments.Count + 1; frm.CurrentCurriculumEnquiry = CE; frm.ShowDialog(); //any change to the Qty will be saved. using (var Dbconnection = new MCDEntities()) { Dbconnection.CurriculumEnquiries.Attach(CE); Dbconnection.Entry(CE).State = EntityState.Modified; Dbconnection.SaveChanges(); }; this.curriculumEnquiryInprogressBindingSource.ResetCurrentItem(); //this.refreshInProgressEnquiry(CurrentSelectedEnquiryID); } }
private void btnAddContactDetail_Click(object sender, EventArgs e) { using (frmAddUpdateContactDetails frm = new frmAddUpdateContactDetails(0)) { Individual CurrentContact = (Individual)((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Individuals.FirstOrDefault <Individual>(); frm.ShowDialog(); if (frm.CurrentDetail != null) { using (var Dbconnection = new MCDEntities()) { Dbconnection.Individuals.Attach(CurrentContact); ContactDetail Con = new ContactDetail { ContactTypeID = frm.CurrentDetail.ContactTypeID, ContactDetailValue = frm.CurrentDetail.ContactDetailValue }; Dbconnection.ContactDetails.Attach(frm.CurrentDetail); Dbconnection.Entry(frm.CurrentDetail).Reference(a => a.LookupContactType).Load(); CurrentContact.ContactDetails.Add(frm.CurrentDetail); Dbconnection.SaveChanges(); }; // refreshInProgressEnquiry(CurrentSelectedEnquiryID); } } }
private void tbnRemoveCourse_Click(object sender, EventArgs e) { dgvLinkedCourses.EndEdit(); using (var Dbconnection = new MCDEntities()) { List <FacilitatorAssociatedCourse> CoursesToBeRemoved = new List <FacilitatorAssociatedCourse>(); foreach (DataGridViewRow currentRow in dgvLinkedCourses.Rows) { DataGridViewCheckBoxCell chk = currentRow.Cells[chkItemToReomve.Index] as DataGridViewCheckBoxCell; if (chk.Value != null) { Course CurrentCourse = (Course)currentRow.DataBoundItem; FacilitatorAssociatedCourse LinkedFacilitatorCourse = (from a in CurrentCourse.FacilitatorAssociatedCourses where a.CourseID == CurrentCourse.CourseID && a.IndividualID == currentFacilitator.FacilitatorID select a).FirstOrDefault <FacilitatorAssociatedCourse>(); Dbconnection.Entry(LinkedFacilitatorCourse).State = System.Data.Entity.EntityState.Deleted; Dbconnection.SaveChanges(); //Dbconnection.FacilitatorAssociatedCourses.Attach(LinkedFacilitatorCourse); //CoursesToBeRemoved.Add(LinkedFacilitatorCourse); } } //Dbconnection.FacilitatorAssociatedCourses.RemoveRange(CoursesToBeRemoved); Dbconnection.SaveChanges(); } refreshAvailableCourses(); refreshLinkedCourses(); }
private void btnUpdateCompanyDetails_Click(object sender, EventArgs e) { Data.Models.Company CompanyToUpdate = (Data.Models.Company)companyBindingSource.Current; CompanyToUpdate.CompanySARSLevyRegistrationNumber = this.txtSARSLevyRegistration.Text.ToString(); CompanyToUpdate.CompanySETANumber = this.txtCompanySETANumber.Text.ToString(); CompanyToUpdate.CompanySicCode = this.txtSicCode.Text.ToString(); this.UpdateCompanyContactDetails(CompanyToUpdate); using (var Dbconnection = new MCDEntities()) { Dbconnection.Companies.Attach(CompanyToUpdate); Dbconnection.Entry(CompanyToUpdate).State = System.Data.Entity.EntityState.Modified; foreach (ContactDetail contactDetailToUpdate in CompanyToUpdate.ContactDetails) { Dbconnection.Entry(contactDetailToUpdate).State = System.Data.Entity.EntityState.Modified; } Dbconnection.SaveChanges(); }; }
private void btnUpdateCompanyInfo_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction()) { try { //CRUD Operations Data.Models.Company UpdateCompany = (from a in Dbconnection.Companies where a.CompanyID == CurrentlySelectedCompany.CompanyID select a) .FirstOrDefault <Data.Models.Company>(); UpdateCompany.CompanyName = txtCompanyName.Text; UpdateCompany.CompanySETANumber = txtSETANumber.Text; UpdateCompany.CompanySicCode = txtSiCode.Text; UpdateCompany.CompanySARSLevyRegistrationNumber = txtSARSLevyReg.Text; Dbconnection.Entry(UpdateCompany).State = EntityState.Modified; ////saves all above operations within one transaction Dbconnection.SaveChanges(); //commit transaction dbTran.Commit(); } catch (Exception ex) { if (ex is DbEntityValidationException) { foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Rollback transaction if exception occurs dbTran.Rollback(); } } }; }
private void btnUpdateMessage_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { Dbconnection.MessageTemplates.Attach(CurrentMessageTemplate); CurrentMessageTemplate.Message = txtMessage.Text.ToString(); Dbconnection.Entry(CurrentMessageTemplate).State = System.Data.Entity.EntityState.Modified; Dbconnection.SaveChanges(); MessageBox.Show("Template Updated!", "Update Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); }; }
private void populateLinkedCurriculumCourses() { using (var Dbconnection = new MCDEntities()) { curriculumCourseLinkedBindingSource.DataSource = (from a1 in Dbconnection.GetCurriculumCourseInOrder(CurrentEnrollemnt.CurriculumID) select a1).Intersect(from a2 in Dbconnection.CurriculumCourseEnrollments where a2.EnrollmentID == CurrentEnrollemnt.EnrollmentID select a2.CurriculumCourse) .ToList <CurriculumCourse>(); foreach (CurriculumCourse CurriculumCourseObj in curriculumCourseLinkedBindingSource.List) { Dbconnection.Entry(CurriculumCourseObj).Reference("Course").Load(); Dbconnection.Entry(CurriculumCourseObj).Collection("CurriculumCourseEnrollments").Load(); } //curriculumCourseLinkedBindingSource.DataSource = (from a in Dbconnection.CurriculumCourseEnrollments // where a.EnrollmentID == CurrentEnrollemnt.EnrollmentID // select a.CurriculumCourse) // .Include("Course") // .Include("CurriculumCourseEnrollments") // .ToList<CurriculumCourse>(); }; }
private void AddCurriculumCoursePreRequesiteCourse(int _CurrCourseParentID, int _CurrCourseChildID) { using (var Dbconnection = new MCDEntities()) { CurriculumCourse currCourseObj = (from a in Dbconnection.CurriculumCourses where a.CurriculumCourseID == _CurrCourseChildID select a).FirstOrDefault <CurriculumCourse>(); currCourseObj.CurriculumCourseParentID = _CurrCourseParentID; Dbconnection.Entry(currCourseObj).State = System.Data.Entity.EntityState.Modified; Dbconnection.SaveChanges(); }; }
private void btnUpdateVenueFromForm_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction()) { try { //CRUD Operations Venue CurrentVenue = (Venue)venueBindingSource.Current; Venue VenueToUpdate = Dbconnection.Venues.Where(a => a.VenueID == CurrentVenue.VenueID).FirstOrDefault(); VenueToUpdate.VenueName = this.txtVenueName.Text; VenueToUpdate.VenueMaxCapacity = (int)this.nudAddUpdateVenueCapacity.Value; Dbconnection.Entry(VenueToUpdate).State = EntityState.Modified; //CurrentVenue.VenueName = this.txtVenueName.Text; //CurrentVenue.VenueMaxCapacity = (int)this.nudAddUpdateVenueCapacity.Value; //Dbconnection.Entry(CurrentVenue).State = System.Data.Entity.EntityState.Modified; ////saves all above operations within one transaction Dbconnection.SaveChanges(); //commit transaction dbTran.Commit(); this.hideAddEditVenues(); } catch (Exception ex) { if (ex is DbEntityValidationException) { foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Rollback transaction if exception occurs dbTran.Rollback(); } } }; refreshVenues(); }
private void prePopulateCurrentlySelectedCourse() { using (var Dbconnection = new MCDEntities()) { CurrentlySelectedCurriculumCourseToSchedule = CurrentSelectedCurriculumCourseEnrollment.CurriculumCourse; Dbconnection.CurriculumCourses.Attach(CurrentlySelectedCurriculumCourseToSchedule); //loads the days that can be scheduled. if (!Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.CurriculumCourseDayCanBeScheduleds).IsLoaded) { Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.CurriculumCourseDayCanBeScheduleds).Load(); } //load the course that associated with the Curriculum Course if (!Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Reference <Course>(a => a.Course).IsLoaded) { Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Reference <Course>(a => a.Course).Load(); } //if (!Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.Course.VenueAssociatedCourses).IsLoaded) //{ // Dbconnection.Entry(CurrentlySelectedCurriculumCourseToSchedule).Collection(a => a.Course.VenueAssociatedCourses).Load(); //} }; }
private void btnAddDisability_Click(object sender, EventArgs e) { using (var Dbconnection = new MCDEntities()) { using (System.Data.Entity.DbContextTransaction dbTran = Dbconnection.Database.BeginTransaction()) { try { //CRUD Operations CurrentStudentDisablity = new StudentDisability() { DisabilityID = this.DisablityID, StudentID = this.StudentID, StudentDisabilityNotes = this.txtStudentDisablityNotes.Text }; Dbconnection.StudentDisabilities.Add(CurrentStudentDisablity); ////saves all above operations within one transaction Dbconnection.SaveChanges(); //commit transaction dbTran.Commit(); Dbconnection.Entry(CurrentStudentDisablity).Reference(a => a.LookupDisability).Load(); } catch (Exception ex) { if (ex is DbEntityValidationException) { foreach (DbEntityValidationResult entityErr in ((DbEntityValidationException)ex).EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { MessageBox.Show(error.ErrorMessage, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show(ex.Message, "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Rollback transaction if exception occurs dbTran.Rollback(); } finally{ this.Close(); } } }; }
private void btnREmoveVenueCourse_Click(object sender, EventArgs e) { if (venueAssociatedCourseBindingSource.Count > 0) { using (var Dbconnection = new MCDEntities()) { VenueAssociatedCourse VenueAssociatedCourseToRemove = ((VenueAssociatedCourse)venueAssociatedCourseBindingSource.Current); Dbconnection.Entry(VenueAssociatedCourseToRemove).State = EntityState.Deleted; Dbconnection.SaveChanges(); }; this.refreshDepartmentCourses(); this.refreshVenueCourses(); } }
private void btnInProgressChangeContact_Click(object sender, EventArgs e) { if (((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.Count > 0) { using (frmSelectCompanyContact frm = new frmSelectCompanyContact()) { Data.Models.Enquiry _CurentSelectedEnquiry = (Data.Models.Enquiry)enquiryInprogressBindingSource.Current; using (var Dbconnection = new MCDEntities()) { Dbconnection.Enquiries.Attach(_CurentSelectedEnquiry); Dbconnection.Entry(_CurentSelectedEnquiry).Collection(a => a.Companies).Load(); frm.CurrentCompany = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Companies.FirstOrDefault<Data.Models.Company>(); frm.ShowDialog(); if (frm.SelectedIndividual != null) { Individual CurrentEnquiryContact = ((Data.Models.Enquiry)enquiryInprogressBindingSource.Current).Individuals.FirstOrDefault<Individual>(); //REmove C=urrent Contact Dbconnection.Enquiries.Attach(_CurentSelectedEnquiry); _CurentSelectedEnquiry.Individuals.Remove(CurrentEnquiryContact); Dbconnection.SaveChanges(); //Link Selected Contact Dbconnection.Individuals.Attach(frm.SelectedIndividual); _CurentSelectedEnquiry.Individuals.Add(frm.SelectedIndividual); Dbconnection.SaveChanges(); }; //REfresh Enquiry this.refreshInProgressEnquiry(CurrentSelectedEnquiryID); } } } else { MetroMessageBox.Show(this, "Can Only Change Company Contacts, Not Private Contacts", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnRemoveLinkedDaysToSchedule_Click(object sender, EventArgs e) { CurriculumCourseDayCanBeScheduled CurriculumCourseDayCanBeScheduledObj = (CurriculumCourseDayCanBeScheduled)(linkedCcurriculumCourseDayCanBeScheduledBindingSource.Current); CurriculumCourseDayCanBeScheduledObj.ObjectState = EntityObjectState.Deleted; using (var Dbconnection = new MCDEntities()) { Dbconnection.Entry(CurriculumCourseDayCanBeScheduledObj).State = EntityState.Deleted; Dbconnection.SaveChanges(); this.loadupStepThree(); this.btnLinkDayAvailableToSchedule.Enabled = true; }; }