private void InsertProjectNote(int originalProjectId) { // ... Data for current project ProjectTDS projectTDSTemp = new ProjectTDS(); ProjectNotesGateway projectNotesGatewayTemp = new ProjectNotesGateway(projectTDSTemp); projectNotesGatewayTemp.LoadAllByProjectId(originalProjectId); ProjectNotesGateway projectNotesGateway = new ProjectNotesGateway(projectTDS); projectNotesGateway.LoadAllByProjectId(originalProjectId); ProjectNotes projectNotes = new ProjectNotes(projectTDS); // ... Definition of general variables int refId; string subject; DateTime dateTime; int loginId; string note; bool deleted; int? libraryFilesId; foreach (ProjectTDS.LFS_PROJECT_NOTERow row in projectTDSTemp.Tables["LFS_PROJECT_NOTE"].Rows) { // ... Definition of general variables refId = row.RefID; subject = row.Subject; dateTime = row.DateTime; loginId = row.LoginID; try { note = row.Note; } catch { note = ""; } deleted = row.Deleted; try { libraryFilesId = row.LIBRARY_FILES_ID; } catch { libraryFilesId = null; } // ... Insert Notes projectNotes.Insert(0, subject, dateTime, loginId, note, deleted, libraryFilesId, Int32.Parse(hdfCompanyId.Value.Trim())); } }
private void LoadNotes() { int companyId = Int32.Parse(hdfCompanyId.Value); int projectId = Int32.Parse(hdfProjectId.Value); // Data for Notes ProjectNotes projectNotes = new ProjectNotes(projectTDS); projectNotes.LoadAllByProjectId(projectId); tbxNotes.Text = projectNotes.GetAllProjectNotes(projectId, companyId, projectNotes.Table.Rows.Count, "\n"); // ProjectGateway projectGateway = new ProjectGateway(projectTDS); // int? libraryCategoriesId = null; if (projectGateway.GetLibraryCategoriesId(int.Parse(hdfProjectId.Value)).HasValue) libraryCategoriesId = (int)projectGateway.GetLibraryCategoriesId(int.Parse(hdfProjectId.Value)); // if (libraryCategoriesId.HasValue) // { // ViewState["libraryCategoriesId"] = (int)libraryCategoriesId; // tbxCategoryAssocited.Text = GetFullCategoryName((int)libraryCategoriesId); // btnAssociate.Visible = false; // btnUnassociate.Visible = true; // } // else // { // tbxCategoryAssocited.Text = ""; // btnAssociate.Visible = true; // btnUnassociate.Visible = false; // } }
/// <summary> /// Save all notes to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { ProjectNavigatorTDS notesChanges = (ProjectNavigatorTDS)Data.GetChanges(); if (notesChanges != null) { if (notesChanges.ProjectNotes.Rows.Count > 0) { ProjectNavigatorProjectNotesGateway projectNavigatorProjectNotesGateway = new ProjectNavigatorProjectNotesGateway(notesChanges); foreach (ProjectNavigatorTDS.ProjectNotesRow row in (ProjectNavigatorTDS.ProjectNotesDataTable)notesChanges.ProjectNotes) { // Insert new Notes if ((!row.Deleted) && (!row.InNoteDatabase)) { int? libraryFilesId = null; if (!row.IsLIBRARY_FILES_IDNull()) libraryFilesId = row.LIBRARY_FILES_ID; ProjectNotes projectNotes = new ProjectNotes(null); projectNotes.InsertDirect(row.ProjectID, row.RefID, row.Subject, row.LoginID, row.DateTime, row.Note, row.Deleted, row.COMPANY_ID, libraryFilesId); } // Update Notes if ((!row.Deleted) && (row.InNoteDatabase)) { int projectId = row.ProjectID; int refId = row.RefID; bool originalDeleted = false; int originalCompanyId = companyId; // original values string originalSubject = projectNavigatorProjectNotesGateway.GetSubjectOriginal(projectId, refId); int originalLoginId = projectNavigatorProjectNotesGateway.GetLoginIdOriginal(projectId, refId); DateTime originalDateTime = projectNavigatorProjectNotesGateway.GetDateTimeOriginal(projectId, refId); string originalNote = projectNavigatorProjectNotesGateway.GetNoteOriginal(projectId, refId); int? originalLibraryFilesId = projectNavigatorProjectNotesGateway.GetLibraryFilesIdOriginal(projectId, refId); // new values string newSubject = projectNavigatorProjectNotesGateway.GetSubject(projectId, refId); string newNote = projectNavigatorProjectNotesGateway.GetNote(projectId, refId); int? newLibraryFilesId = projectNavigatorProjectNotesGateway.GetLibraryFilesId(projectId, refId); ProjectNotes projectNotes = new ProjectNotes(null); projectNotes.UpdateDirect(projectId, refId, originalSubject, originalLoginId, originalDateTime, originalNote, originalDeleted, originalCompanyId, originalLibraryFilesId, projectId, refId, newSubject, originalLoginId, originalDateTime, newNote, originalDeleted, originalCompanyId, newLibraryFilesId); } // Deleted notes if ((row.Deleted) && (row.InNoteDatabase)) { ProjectNotes projectNotes = new ProjectNotes(null); projectNotes.DeleteDirect(row.ProjectID, row.RefID, row.COMPANY_ID); } } } } }