public DateTime ToUtc(TrimDateTime dateTime) { if (dateTime.IsTimeClear) { return(DateTime.SpecifyKind(dateTime.ToDateTime(), DateTimeKind.Utc)); } TimeZoneInfo userTimeZone = getTimeZoneInfo(); return(TimeZoneInfo.ConvertTimeToUtc(dateTime.ToDateTime(), userTimeZone)); }
//public void Dispose() //{ // if (m_loader != null) // { // m_loader.Dispose(); // m_loader = null; // } // if (m_origin != null) // { // m_origin.Dispose(); // m_origin = null; // } //} bool getNextRecord(PropertyOrFieldValue[] fields) { // this function would normally be processing some input data source, // reading the next item, setting yp the fields array from this input. // For the example, we "hard code" some simple property values and // provide 5 records. m_recordCount++; if (m_recordCount > 5) { return false; } // a simple title String title = "Test Bulk Loaded Record Import #" + System.Convert.ToString(m_recordCount); title += ", imported from run number " + System.Convert.ToString(m_loader.RunHistoryUri); // some notes String notes = "Some notes for the bulk imported record #" + System.Convert.ToString(m_recordCount) + " data imported at: " + TrimDateTime.Now.ToLongDateTimeString(); // a random date TrimDateTime dateCreated = new TrimDateTime(2007, 12, 14, 12, 0, 0); // create a location "on the fly" for the Author property //PropertyOrFieldValue[] authorFields = new PropertyOrFieldValue[2]; //authorFields[0] = new PropertyOrFieldValue(PropertyIds.LocationTypeOfLocation); //authorFields[1] = new PropertyOrFieldValue(PropertyIds.LocationSortName); //authorFields[0].SetValue(LocationType.Position); //authorFields[1].SetValue("Position #" + System.Convert.ToString(m_recordCount)); ////12 12 HP TRIM Bulk Data Importing Programming Guide //// if we are rerunning, check to see if it already exists //PropertyValue positionName = new PropertyValue(PropertyIds.LocationSortName); //positionName.SetValue("Position #" + System.Convert.ToString(m_recordCount)); //Int64 authorUri = m_loader.FindLocation(positionName); //if (authorUri == 0) //{ // // use the loader to setup the new location's properties // Location authorLoc = m_loader.NewLocation(); // m_loader.SetProperties(authorLoc, authorFields); // // now submit the location to the bulk loader queue // authorUri = m_loader.SubmitLocation(authorLoc); //} // now set up the fields array based on these values fields[0].SetValue(title); fields[1].SetValue(dateCreated); fields[2].SetValue(notes); fields[3].SetValue(lCont); //fields[3].SetValue(authorUri); return true; }
/// <summary> /// Save Button - used to save a record. If the assignee is invalid it displays an error. /// The record the verified before getting saved. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Save_Click(object sender, EventArgs e) { try { using (Database objDB = getDatabase()) //create a database object { recNumber = RecNumVal.Text; //record number title = RecTitleVal.Text; //record title date = new TrimDateTime(DateCreatedVal.Text); //record date of creation locName = AssigneeVal.Text; //record assignee Record rec = new Record(objDB, recNumber); //record object rec.Title = title; rec.DateCreated = date; location = new Location(objDB, rec.Assignee.Name); //location object if (location.Name != locName) //checking if the assignee name has changed { try { Location loc = new Location(objDB, locName); rec.SetAssignee(loc); } //An exception is thrown if the location name is invalid catch (Exception k) { System.Diagnostics.Trace.WriteLine(k.Message); MessageBox.Show("The assingee is invalid or does not exist"); return; } } //Saving the record object if (rec.Verify(true)) { rec.Save(); MessageBox.Show("Record Saved"); } else //Error is displayed if record verification fails { MessageBox.Show(rec.ErrorMessage); } } } // Display any exception thrown in a msgbox catch (Exception k) { MessageBox.Show(k.Message); } }