public void AddPostSaleToDatabase() { SqlConnection connection = Connection(); SqlCommand command; string query; query = "INSERT INTO PostSale(StepName, Notes, CompleteDate, DueDate, StepNumber, OfferRef, StepCost, Complete) VALUES(@StepName, @Notes, @CompleteDate, @DueDate, @StepNumber, @OfferRef, @StepCost, @Complete)"; connection.Open(); command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@StepName", StepName); command.Parameters.AddWithValue("@Notes", Note); command.Parameters.AddWithValue("@CompleteDate", CompleteDate); command.Parameters.AddWithValue("@DueDate", DueDate); command.Parameters.AddWithValue("@StepNumber", StepNumber); command.Parameters.AddWithValue("@OfferRef", OfferRef); command.Parameters.AddWithValue("@StepCost", StepCost); command.Parameters.AddWithValue("@Complete", Complete.ToString()); foreach (SqlParameter parameter in command.Parameters) { if (parameter.Value == null) { parameter.Value = DBNull.Value; } } command.ExecuteNonQuery(); connection.Close(); }
public void WriteXml(XmlWriter xr) { xr.WriteStartElement("name"); xr.WriteString(name); xr.WriteEndElement(); xr.WriteStartElement("type"); xr.WriteString(type); xr.WriteEndElement(); xr.WriteStartElement("model"); xr.WriteString(model); xr.WriteEndElement(); xr.WriteStartElement("flags"); xr.WriteAttributeString("known", Known.ToString()); xr.WriteAttributeString("complete", Complete.ToString()); xr.WriteEndElement(); xr.WriteStartElement("category"); xr.WriteAttributeString("id", Category.ToString()); xr.WriteEndElement(); xr.WriteStartElement("notes"); xr.WriteString(notes); xr.WriteEndElement(); xr.WriteStartElement("files"); xr.WriteString(files); xr.WriteEndElement(); foreach (ObjectDbField f in Fields) { f.WriteXml(xr); } }
public void Save() { if (String.IsNullOrEmpty(Id)) { throw new InvalidOperationException(); } var document = new XDocument(new XElement("deployment", new XElement("id", Id), new XElement("author", XmlUtility.Sanitize(Author)), new XElement("deployer", Deployer), new XElement("authorEmail", AuthorEmail), new XElement("message", XmlUtility.Sanitize(Message)), new XElement("progress", Progress), new XElement("status", Status), new XElement("statusText", StatusText), new XElement("lastSuccessEndTime", LastSuccessEndTime), new XElement("receivedTime", ReceivedTime), new XElement("startTime", StartTime), new XElement("endTime", EndTime), new XElement("complete", Complete.ToString()), new XElement("is_temp", IsTemporary.ToString()), new XElement("is_readonly", IsReadOnly.ToString()) )); _statusLock.LockOperation(() => { using (Stream stream = FileSystemHelpers.CreateFile(_statusFile)) { document.Save(stream); } OperationManager.Attempt(() => { // Used for ETAG if (FileSystemHelpers.FileExists(_activeFile)) { FileSystemHelpers.SetLastWriteTimeUtc(_activeFile, DateTime.UtcNow); } else { FileSystemHelpers.WriteAllText(_activeFile, String.Empty); } }); OperationManager.Attempt(() => { // enable the feature thru configuration if (ScmHostingConfigurations.DeploymentStatusCompleteFileEnabled && Complete) { FileSystemHelpers.CopyFile(_statusFile, _statusCompleteFile); } else if (FileSystemHelpers.FileExists(_statusCompleteFile)) { FileSystemHelpers.DeleteFile(_statusCompleteFile); } }); }, "Updating deployment status", DeploymentStatusManager.LockTimeout); }
private void ClearData() { TotalRecord = 0; Complete = 0; Failed = 0; progressBarInsReport.Value = 0; progressBarInsReport.Visible = false; lbl_totalrecord.Text = TotalRecord.ToString(); lbl_complete.Text = Complete.ToString(); lbl_failed.Text = Failed.ToString(); }
public Dictionary <string, string> GetUrlParameters() { return(new Dictionary <string, string> { { "database", Database }, { "type", Type.ToString().ToLower() }, { "waitForSync", WaitForSync.ToString() }, { "complete", Complete.ToString() }, { "details", Details.ToString() }, { "collection", Collection }, { "createCollection", CreateCollection.ToString() }, }); }
public void Save() { if (String.IsNullOrEmpty(Id)) { throw new InvalidOperationException(); } var document = new XDocument(new XElement("deployment", new XElement("id", Id), new XElement("author", Author), new XElement("deployer", Deployer), new XElement("authorEmail", AuthorEmail), new XElement("message", Message), new XElement("progress", Progress), new XElement("status", Status), new XElement("statusText", StatusText), new XElement("lastSuccessEndTime", LastSuccessEndTime), new XElement("receivedTime", ReceivedTime), new XElement("startTime", StartTime), new XElement("endTime", EndTime), new XElement("complete", Complete.ToString()), new XElement("is_temp", IsTemporary.ToString()), new XElement("is_readonly", IsReadOnly.ToString()) )); _statusLock.LockOperation(() => { using (Stream stream = FileSystemHelpers.CreateFile(_statusFile)) { document.Save(stream); } // Used for ETAG if (FileSystemHelpers.FileExists(_activeFile)) { FileSystemHelpers.SetLastWriteTimeUtc(_activeFile, DateTime.UtcNow); } else { FileSystemHelpers.WriteAllText(_activeFile, String.Empty); } }, DeploymentStatusManager.LockTimeout); }
private void ReportStatus() { lbl_complete.Text = Complete.ToString(); lbl_failed.Text = Failed.ToString(); }