private string AttachmentPathx(int id) { string path = Connection.AttachmentPath(id); path = Path.Combine(Path.Combine(path, "Organizations"), OrganizationID.ToString()); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } return(path); }
private void ShowOrganization() { EasyDataProvide UnitName = new EasyDataProvide("UnitName"); DataTable dtUnitName = UnitName.GetAllData("order by listNum"); OrganizationID.DataTextField = "title"; OrganizationID.DataValueField = "id"; OrganizationID.DataSource = dtUnitName; OrganizationID.DataBind(); ListItem item = new ListItem("未指定", "0"); OrganizationID.Items.Add(item); if (OrganizationID.Items.Count == 1) { trUnit.Visible = false; } }
protected override string GetQuery(CodeActivityContext context) { long organization = OrganizationID.Get(context); fileInfo = FileInfo.Get(context); if (fileInfo == null || string.IsNullOrWhiteSpace(fileInfo.Name)) { var filePath = FilePath.Get(context); fileInfo = new FileInfo(Path.GetFullPath(filePath)); } if (!fileInfo.Exists) { throw new ArgumentException("The file doesn't exist."); } contentType = MimeMapping.GetMimeMapping(fileInfo.Name); return(string.Format(CreatePresignedUrlQuery, organization, fileInfo.Name, contentType)); }
public void UpdateModel(Models.Program program, Person currentPerson, bool isNew) { program.ProgramName = IsDefaultForBulkImportOnly ? null : ProgramName; program.ProgramShortName = IsDefaultForBulkImportOnly ? null : ProgramShortName; program.OrganizationID = OrganizationID.GetValueOrDefault(); program.ProgramIsActive = IsActive; program.IsDefaultProgramForImportOnly = IsDefaultForBulkImportOnly; if (isNew) { program.ProgramCreateDate = DateTime.Now; program.ProgramCreatePersonID = currentPerson.PersonID; } else { program.ProgramLastUpdatedDate = DateTime.Now; program.ProgramLastUpdatedByPersonID = currentPerson.PersonID; } program.ProgramPrimaryContactPersonID = PrimaryContactPersonID; }
public OrganizationRank SaveOrganizationRank() { SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "InsertUpdate_OrganizationRank"; command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationRankID", SqlDbType.Int, OrganizationRankID.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationID", SqlDbType.Int, OrganizationID.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationRankLevel", SqlDbType.Int, OrganizationRankLevel.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@ScoreMin", SqlDbType.Int, ScoreMin.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@ScoreMax", SqlDbType.Int, ScoreMax.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@Title", SqlDbType.VarChar, Title, 400)); command.Parameters.Add(dbconn.GenerateParameterObj("@Benefits", SqlDbType.VarChar, Benefits, 4000)); command.Parameters.Add(dbconn.GenerateParameterObj("@Duties", SqlDbType.Int, Duties, 4000)); result = command.ExecuteReader(); result.Read(); SetReaderToObject(ref result); } catch { Exception e = new Exception(); this._insertUpdateOK = false; this._insertUpdateMessage.Append(e.Message.ToString()); throw e; } finally { command.Dispose(); connection.Close(); } return(this); }
public Organization SaveOrganization() { SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "InsertUpdate_Organization"; command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationID", SqlDbType.Int, OrganizationID.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationName", SqlDbType.VarChar, OrganizationName, 100)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationDescription", SqlDbType.VarChar, OrganizationDescription, 4000)); command.Parameters.Add(dbconn.GenerateParameterObj("@ScaleID", SqlDbType.Int, ScaleID.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationTypeID", SqlDbType.Int, OrganizationTypeID.ToString(), 0)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationAllies", SqlDbType.VarChar, OrganizationAllies, 4000)); command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationEnemies", SqlDbType.VarChar, OrganizationEnemies, 4000)); command.Parameters.Add(dbconn.GenerateParameterObj("@ForceTraditionID", SqlDbType.Int, ForceTraditionID.ToString(), 0)); result = command.ExecuteReader(); result.Read(); SetReaderToObject(ref result); } catch { Exception e = new Exception(); this._insertUpdateOK = false; this._insertUpdateMessage.Append(e.Message.ToString()); throw e; } finally { command.Dispose(); connection.Close(); } return(this); }
/// <summary> /// Deletes the Organization. /// </summary> /// <returns>boolean</returns> public bool DeleteOrganization() { SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "Delete_Organization"; command.Parameters.Add(dbconn.GenerateParameterObj("@OrganizationID", SqlDbType.Int, OrganizationID.ToString(), 0)); result = command.ExecuteReader(); } catch { Exception e = new Exception(); this._deleteOK = false; this._deletionMessage.Append(e.Message + " Inner Exception= " + e.InnerException); throw e; } finally { command.Dispose(); connection.Close(); } return(this.DeleteOK); }
protected void Page_Load(object sender, EventArgs e) { string ProjectName = string.Empty; string OrgConnectionString = GetClientDBConnectionString(); if (OrgConnectionString.Length == 0) { MessageLabel.Visible = true; MainPanel.Visible = false; return; } if (!IsPostBack) { ProjectView oProjectView = new ProjectView(); oProjectView.ConnectionString = OrgConnectionString; oProjectView.Where.ProjectID.Value = ProjectID; oProjectView.Where.ProjectID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; oProjectView.Query.Load(); if (oProjectView.RowCount == 0) { MessageLabel.Visible = true; MainPanel.Visible = false; return; } else { this.ViewState["ProjectName"] = oProjectView.Name; } hlSubscribe.NavigateUrl = string.Format("{0}?ProjectID={1}&OrganizationID={2}", Global.SubscribePageURL, ProjectID.ToString(), OrganizationID.ToString()); DL_WEB.DAL.Client.ImpactLevel oImpactLevel = new DL_WEB.DAL.Client.ImpactLevel(OrgConnectionString); foreach (DataRow row in oImpactLevel.LoadAllImpactLevel().Table.Rows) { ddlImpactLevel.Items.Add(new ListItem(row["Name"].ToString(), row["ImpactLevelID"].ToString())); } } if (this.ViewState["ProjectName"] != null) { ProjectName = this.ViewState["ProjectName"].ToString(); } this.Title = string.Format("Deployment Log for '{0}' Project", ProjectName); if (0 != ImpactLevel) { divImpactLevel.Visible = false; } ProductionUpdates oProductionUpdates = new ProductionUpdates(OrgConnectionString); oProductionUpdates.Where.ProjectID.Value = ProjectID; oProductionUpdates.Where.ProjectID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; oProductionUpdates.Query.Load(); oProductionUpdates.Sort = ProductionUpdates.ColumnNames.BuildDate + " DESC"; if (oProductionUpdates.RowCount > 0) { do { TableRow tr = new TableRow(); TableCell tc = new TableCell(); tc.Text = string.Format("<br/><div class=\"project_name\">{0}</div> {1}", ProjectName, oProductionUpdates.IsColumnNull(ProductionUpdates.ColumnNames.BuildNumber) ? "v " + oProductionUpdates.BuildNumber : "") + " - " + oProductionUpdates.BuildDate.Month + "/" + oProductionUpdates.BuildDate.Day + "/" + oProductionUpdates.BuildDate.Year + "<br/><br/>"; tc.ColumnSpan = 4; tr.Cells.Add(tc); tblHistory.Rows.Add(tr); ProductionLogEntries oProductionLogEntries = new ProductionLogEntries(OrgConnectionString); oProductionLogEntries.Where.UpdateID.Value = oProductionUpdates.UpdateID; oProductionLogEntries.Where.UpdateID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.Equal; if (ddlImpactLevel.SelectedValue != "0") { oProductionLogEntries.Where.ImpactLevelID.Value = ddlImpactLevel.SelectedValue; oProductionLogEntries.Where.ImpactLevelID.Operator = MyGeneration.dOOdads.WhereParameter.Operand.LessThanOrEqual; } oProductionLogEntries.Query.Load(); if (oProductionLogEntries.RowCount > 0) { do { tr = new TableRow(); tc = new TableCell(); tc.CssClass = "log_entry_image"; Image img = new Image(); img.ImageUrl = oProductionLogEntries.IconPath; img.AlternateText = oProductionLogEntries.TypeName; tc.Controls.Add(img); tc.Width = 30; tr.Cells.Add(tc); tc = new TableCell(); tc.CssClass = "log_entry_section"; tc.Text = string.Format("{0} :", oProductionLogEntries.ProjectSectionName); tr.Cells.Add(tc); tc = new TableCell(); tc.CssClass = "log_entry_name"; tc.Text = oProductionLogEntries.PublicHeader; tr.Cells.Add(tc); tc = new TableCell(); tc.CssClass = "log_entry_description"; tc.Text = oProductionLogEntries.PublicDescription; tr.Cells.Add(tc); tblHistory.Rows.Add(tr); } while (oProductionLogEntries.MoveNext()); } else { tr = new TableRow(); tc = new TableCell(); tc.Text = "<i>There were no changes</i>"; tc.ColumnSpan = 3; tr.Cells.Add(tc); tblHistory.Rows.Add(tr); } } while (oProductionUpdates.MoveNext()); } }
protected override string GetQuery(CodeActivityContext context) { var orgId = OrganizationID.Get(context); return(string.Format(GetOrganizationQuery, orgId)); }