// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS - DATASET
//
/// <summary>
/// LoadAllByProjectId
/// </summary>
/// <param name="projectId">ProjectId filter</param>
public void LoadAllByProjectId(int projectId)
{
ProjectNotesGateway projectNotesGateway = new ProjectNotesGateway(Data);
projectNotesGateway.LoadAllByProjectId(projectId);
}
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()));
}
}