/// <summary> /// DeleteDirect /// </summary> /// <param name="serviceId">serviceId</param> /// <param name="serviceType">serviceType</param> /// <param name="companyId">companyId</param> public void DeleteDirect(int serviceId, string unitType, int companyId) { ServicesGateway servicesGeteway = new ServicesGateway(); servicesGeteway.LoadByServiceId(serviceId, companyId); if (servicesGeteway.Table.Rows.Count > 0) { // Delete vehicle info if (unitType == "Vehicle") { ServicesVehicle servicesVehicle = new ServicesVehicle(null); servicesVehicle.DeleteDirect(serviceId, companyId); } // Delete notes ServicesNote servicesNote = new ServicesNote(null); servicesNote.DeleteAllDirect(serviceId, companyId); // Delete costs ServicesCost servicesCost = new ServicesCost(null); servicesCost.DeleteAllDirect(serviceId, companyId); // Delete service servicesGeteway.Delete(serviceId, companyId); } }
/// <summary> /// Save all notes to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { ServiceInformationTDS serviceInformationChanges = (ServiceInformationTDS)Data.GetChanges(); if (serviceInformationChanges != null) { if (serviceInformationChanges.NoteInformation.Rows.Count > 0) { ServiceInformationServiceNoteGateway serviceInformationServiceNoteGateway = new ServiceInformationServiceNoteGateway(serviceInformationChanges); foreach (ServiceInformationTDS.NoteInformationRow row in (ServiceInformationTDS.NoteInformationDataTable)serviceInformationChanges.NoteInformation) { // Insert new notes if ((!row.Deleted) && (!row.InServiceNoteDatabase)) { int? libraryFilesId = null; if (!row.IsLIBRARY_FILES_IDNull()) libraryFilesId = row.LIBRARY_FILES_ID; ServicesNote servicesNote = new ServicesNote(null); servicesNote.InsertDirect(row.ServiceID, row.RefID, row.Subject, row.UserID, row.DateTime_, row.Note, libraryFilesId, row.Deleted, row.COMPANY_ID); } // Update notes if ((!row.Deleted) && (row.InServiceNoteDatabase)) { int serviceId = row.ServiceID; int refId = row.RefID; bool originalDeleted = false; int originalCompanyId = companyId; // original values string originalSubject = serviceInformationServiceNoteGateway.GetSubjectOriginal(serviceId, refId); int originalUserId = serviceInformationServiceNoteGateway.GetUserIdOriginal(serviceId, refId); DateTime originalDateTime_ = serviceInformationServiceNoteGateway.GetDateTime_Original(serviceId, refId); string originalNote = serviceInformationServiceNoteGateway.GetNoteOriginal(serviceId, refId); int? originalLibraryFilesId = null; if (serviceInformationServiceNoteGateway.GetLibraryFilesIdOriginal(serviceId, refId).HasValue) originalLibraryFilesId = serviceInformationServiceNoteGateway.GetLibraryFilesIdOriginal(serviceId, refId); // new values string newSubject = serviceInformationServiceNoteGateway.GetSubject(serviceId, refId); string newNote = serviceInformationServiceNoteGateway.GetNote(serviceId, refId); int? newLibraryFilesId = null; if (serviceInformationServiceNoteGateway.GetLibraryFilesId(serviceId, refId).HasValue) newLibraryFilesId = serviceInformationServiceNoteGateway.GetLibraryFilesId(serviceId, refId); ServicesNote servicesNote = new ServicesNote(null); servicesNote.UpdateDirect(serviceId, refId, originalSubject, originalUserId, originalDateTime_, originalNote, originalLibraryFilesId, originalDeleted, originalCompanyId, serviceId, refId, newSubject, originalUserId, originalDateTime_, newNote, newLibraryFilesId, originalDeleted, originalCompanyId); } // Deleted notes if ((row.Deleted) && (row.InServiceNoteDatabase)) { ServicesNote servicesNote = new ServicesNote(null); servicesNote.DeleteDirect(row.ServiceID, row.RefID, row.COMPANY_ID); } } } } }