public static Portal ClearLog(Data.Site site, int portalId)
{
var response = DnnPromptController.ProcessCommand(site, portalId, 5, "get-portal");
var result = Newtonsoft.Json.JsonConvert.DeserializeObject<ConsoleResultModel<Portal>>(response.Contents);
result.AssertValidConsoleResponse();
return result.Data[0];
}
protected override void Init()
{
using (var api = new Api(GetDb(), new ContentServiceFactory(services), storage)) {
// Initialize
Piranha.App.Init();
var pageTypeBuilder = new PageTypeBuilder(api)
.AddType(typeof(BlogPage));
pageTypeBuilder.Build();
// Add site
var site = new Data.Site()
{
Id = SITE_ID,
Title = "Hook Site",
IsDefault = true
};
api.Sites.Save(site);
// Add blog page
var page = BlogPage.Create(api);
page.Id = BLOG_ID;
page.SiteId = SITE_ID;
page.Title = "Hook Blog";
api.Pages.Save(page);
// Add category
api.Categories.Save(new Data.Category()
{
Id = ID,
BlogId = BLOG_ID,
Title = "Hook Category"
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
int site_id = Convert.ToInt32(Request.QueryString["site_id"]);
Data.Site site = db.Sites.Where(p => p.site_id == site_id).FirstOrDefault();
rlbFieldTripsStart.DataSource = db.Trips
.Where(p => p.Office.wsc_id == site.Office.wsc_id)
.Select(p => new { TripName = p.trip_nm + " (" + p.user_id + ")", trip_id = p.trip_id })
.OrderBy(p => p.TripName)
.ToList();
rlbFieldTripsStart.DataBind();
List <TripItem> trips = new List <TripItem>();
foreach (var trip in site.TripSites)
{
//Remove the trips that are already assigned to the site from the start list box
RadListBoxItem itemToRemove = rlbFieldTripsStart.FindItemByValue(trip.trip_id.ToString());
rlbFieldTripsStart.Items.Remove(itemToRemove);
//Add the trips that are already assigned to the site to the trips list
trips.Add(new TripItem {
trip_id = trip.trip_id, TripName = trip.Trip.trip_nm + " ( " + trip.Trip.user_id + ")"
});
}
rlbFieldTripsEnd.DataSource = trips;
rlbFieldTripsEnd.DataBind();
}
public static PortalBase[] ListPortals(Data.Site site)
{
var response = DnnPromptController.ProcessCommand(site, 5, "list-portals");
var result = Newtonsoft.Json.JsonConvert.DeserializeObject<ConsoleResultModel<PortalBase>>(response.Contents);
result.AssertValidConsoleResponse();
return result.Data;
}
protected void rbEditStatus_Command(object sender, CommandEventArgs e)
{
if (hfStatusEdited.Value == "no")
{
period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(Request.QueryString["period_id"]));
List <Data.PeriodDialog> dialogs = new List <Data.PeriodDialog>();
switch (period.status_va)
{
case "Analyzed":
dialogs = period.PeriodDialogs.Where(p => p.status_set_to_va == "Analyzed").ToList();
period.status_va = "Analyzing";
period.status_set_by_role_va = "Analyst";
break;
case "Approved":
dialogs = period.PeriodDialogs.Where(p => p.origin_va == "Approver").ToList();
period.status_va = "Analyzed";
period.status_set_by_role_va = "Analyst";
break;
}
db.PeriodDialogs.DeleteAllOnSubmit(dialogs);
pnlSetBackStatus.Visible = false;
pnlDialogs.Visible = false;
pnlConfirm.Visible = true;
db.SubmitChanges();
site = period.Record.Site;
PopulateRecordPeriods("confirm");
hfStatusEdited.Value = "yes";
}
}
protected void Page_Load(object sender, EventArgs e)
{
//If no site_id was passed, then redirect back to the homepage
string site_id = Request.QueryString["site_id"];
if (!string.IsNullOrEmpty(site_id))
{
SiteID = Convert.ToInt32(site_id);
}
else
{
Response.Redirect(Config.SIMSURL + "SIMSWSCHome.aspx");
}
//Using the passed site_id, setup the site data element, and reset the office and wsc to match that of the current site
currSite = db.Sites.Where(p => p.site_id == SiteID).FirstOrDefault();
OfficeID = (int)currSite.office_id;
WSCID = (int)db.Offices.Where(p => p.office_id == OfficeID).FirstOrDefault().wsc_id;
ph1.Title = "Edit Station Documents";
ph1.SubTitle = currSite.site_no + " " + db.vSITEFILEs.FirstOrDefault(s => s.site_id == currSite.nwisweb_site_id).station_nm;
ph1.ShowOfficeInfoPanel = true;
if (!Page.IsPostBack)
{
//If the user belongs to this site's WSC (or has an exception to work in the WSC), or is a SuperUser, then allow them to edit the page
if (user.WSCID.Contains(WSCID) || user.IsSuperUser)
{
HasEditAccess = true;
}
InitialPageSetup();
}
}
/// <summary>
/// Adds or updates the given model in the database
/// depending on its state.
/// </summary>
/// <param name="model">The model</param>
public async Task Save(Models.Site model)
{
var site = await _db.Sites
.FirstOrDefaultAsync(s => s.Id == model.Id)
.ConfigureAwait(false);
if (site == null)
{
site = new Data.Site
{
Id = model.Id != Guid.Empty ? model.Id : Guid.NewGuid(),
Created = DateTime.Now
};
await _db.Sites.AddAsync(site).ConfigureAwait(false);
}
site.SiteTypeId = model.SiteTypeId;
site.Title = model.Title;
site.InternalId = model.InternalId;
site.Description = model.Description;
site.LogoId = model.Logo?.Id;
site.Hostnames = model.Hostnames;
site.Culture = model.Culture;
site.IsDefault = model.IsDefault;
site.ContentLastModified = model.ContentLastModified;
site.LastModified = DateTime.Now;
await _db.SaveChangesAsync().ConfigureAwait(false);
}
protected void btnSubmitSite_Command(object source, CommandEventArgs e)
{
string agency_cd = "USGS", site_no = null;
int site_id;
if (e.CommandArgument.ToString() == "choosesite")
{
if (!string.IsNullOrEmpty(rcbSites.SelectedValue.ToString()))
{
site_id = Convert.ToInt32(rcbSites.SelectedValue);
site = db.Sites.FirstOrDefault(p => p.site_id == site_id);
RefreshPageData(site_id);
tbSiteNo.Text = "";
}
}
else
{
if (!string.IsNullOrEmpty(tbSiteNo.Text))
{
agency_cd = tbAgencyCd.Text;
site_no = tbSiteNo.Text;
site = db.Sites.FirstOrDefault(p => p.site_no == site_no && p.agency_cd == agency_cd);
RefreshPageData(site.site_id);
if (rcbSites.Items.Contains(new ListItem {
Value = site.site_id.ToString(), Text = site.site_no + " " + site.station_full_nm
}))
{
rcbSites.SelectedValue = site.site_id.ToString();
}
}
}
}
/// <summary>
/// Invokes the router.
/// </summary>
/// <param name="api">The current api</param>
/// <param name="url">The requested url</param>
/// <param name="hostname">The optional hostname</param>
/// <returns>The piranha response, null if no matching page was found</returns>
public static IRouteResponse Invoke(IApi api, string url, string hostname)
{
if (string.IsNullOrWhiteSpace(url) || url == "/")
{
Data.Site site = null;
if (!string.IsNullOrWhiteSpace(hostname))
{
site = api.Sites.GetByHostname(hostname);
}
if (site == null)
{
site = api.Sites.GetDefault();
}
var page = api.Pages.GetStartpage(site.Id);
if (page != null)
{
return(new RouteResponse()
{
Route = page.Route ?? "/page",
QueryString = "id=" + page.Id + "&startpage=true&piranha_handled=true",
IsPublished = page.Published.HasValue && page.Published.Value <= DateTime.Now,
CacheInfo = new HttpCacheInfo()
{
EntityTag = Utils.GenerateETag(page.Id.ToString(), page.LastModified),
LastModified = page.LastModified
}
});
}
}
return(null);
}
/// <summary>
/// Invokes the router.
/// </summary>
/// <param name="api">The current api</param>
/// <param name="url">The requested url</param>
/// <param name="hostname">The optional hostname</param>
/// <returns>The piranha response, null if no matching page was found</returns>
public static IRouteResponse Invoke(IApi api, string url, string hostname)
{
Data.Site site = null;
if (!string.IsNullOrWhiteSpace(hostname))
{
site = api.Sites.GetByHostname(hostname);
}
if (site == null)
{
site = api.Sites.GetDefault();
}
if (!String.IsNullOrWhiteSpace(url) && url.Length > 1)
{
// Check if we can find an alias with the requested url
var alias = api.Aliases.GetByAliasUrl(url, site.Id);
if (alias != null)
{
return(new RouteResponse()
{
IsPublished = true,
RedirectUrl = alias.RedirectUrl,
RedirectType = alias.Type
});
}
}
return(null);
}
public static string DeleteRole(Data.Site site, int portalId, int roleId)
{
var response = DnnPromptController.ProcessCommand(site, portalId, 5, string.Format("delete-role --id {0}", roleId));
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <object> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Output);
}
public static RoleModelBase[] ListRoles(Data.Site site, int portalId)
{
var response = DnnPromptController.ProcessCommand(site, portalId, 5, "list-roles");
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <RoleModelBase> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data);
}
public static Portal GetPortal(Data.Site site, int portalId)
{
var cmd = portalId == -1 ? "get-portal" : string.Format("get-portal --id {0}", portalId);
var response = DnnPromptController.ProcessCommand(site, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject<ConsoleResultModel<Portal>>(response.Contents);
result.AssertValidConsoleResponse();
return result.Data[0];
}
protected void btnSubmitSite_Command(object sender, CommandEventArgs e)
{
if (pnlEditStatus.Visible == false)
{
site = db.Sites.FirstOrDefault(p => p.site_no == rtbSiteNo.Text && p.agency_cd == rtbAgencyCd.Text);
PopulateRecordPeriods("view");
}
}
public static Command[] ListCommands(Data.Site site)
{
var response = DnnPromptController.ProcessCommand(site, 5, "list-commands");
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <Command> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data);
}
public static HostModel GetHost(Data.Site site)
{
var response = DnnPromptController.ProcessCommand(site, 5, "get-host");
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <HostModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data[0]);
}
protected override void Init()
{
using (var api = new Api(GetDb(), storage)) {
Piranha.App.Init(api);
var builder = new PageTypeBuilder(api)
.AddType(typeof(MyPage));
builder.Build();
// Add site
var site1 = new Data.Site()
{
Id = SITE1_ID,
Title = "Page Site",
InternalId = "PageSite",
IsDefault = true
};
api.Sites.Save(site1);
var site2 = new Data.Site()
{
Id = SITE2_ID,
Title = "Page Site 2",
InternalId = "PageSite2",
Hostnames = "www.myothersite.com",
IsDefault = false
};
api.Sites.Save(site2);
// Add pages
var page1 = MyPage.Create(api);
page1.Id = PAGE1_ID;
page1.SiteId = SITE1_ID;
page1.Title = "My first page";
page1.Body = "My first body";
page1.Published = DateTime.Now;
api.Pages.Save(page1);
var page2 = MyPage.Create(api);
page2.Id = PAGE2_ID;
page2.SiteId = SITE2_ID;
page2.Title = "My second page";
page2.Body = "My second body";
page2.Published = DateTime.Now;
api.Pages.Save(page2);
var page3 = MyPage.Create(api);
page3.Id = PAGE3_ID;
page3.SiteId = SITE1_ID;
page3.SortOrder = 1;
page3.Title = "My third page";
page3.Published = DateTime.Now;
page3.RedirectUrl = "http://www.redirect.com";
page3.RedirectType = Models.RedirectType.Temporary;
api.Pages.Save(page3);
}
}
public static ModuleInfoModel GetModule(Data.Site site, int portalId, int moduleId, int pageId)
{
var cmd = string.Format("get-module --id {0} --pageid {1}", moduleId, pageId);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <ModuleInfoModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data[0]);
}
public static TaskModel GetTask(Data.Site site, int portalId, int taskId)
{
var cmd = string.Format("get-task --id {0}", taskId);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <TaskModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data[0]);
}
public static string RestoreUser(Data.Site site, int portalId, int userId)
{
var cmd = string.Format("restore-user --id {0}", userId);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <object> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Output);
}
public static ModuleInfoModel MoveModule(Data.Site site, int portalId, int moduleId, int pageId, int toPageId, string paneName)
{
var cmd = string.Format("move-module --id {0} --pageid {1} --topageid {2}", moduleId, pageId, toPageId);
cmd += string.IsNullOrEmpty(paneName) ? "" : string.Format(" --pane {0}", paneName);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <ModuleInfoModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data[0]);
}
public static string ResetPassword(Data.Site site, int portalId, int userId, bool?notify)
{
var cmd = string.Format("reset-password --id {0}", userId);
cmd += notify == null ? "" : string.Format(" --notify {0}", notify);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <object> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Output);
}
public static UserModel DeleteUser(Data.Site site, int portalId, int userId, bool?notify)
{
var cmd = string.Format("delete-user --id {0}", userId);
cmd += notify == null ? "" : string.Format(" --notify {0}", notify);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <UserModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data[0]);
}
public static string PurgePage(Data.Site site, int portalId, int pageId, bool?deleteChildren)
{
var cmd = string.Format("purge-page --id {0}", pageId);
cmd += deleteChildren == null ? "" : string.Format(" --deletechildren {0}", deleteChildren);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <object> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Output);
}
public static TaskModelBase[] ListTasks(Data.Site site, int portalId, bool?enabled, string taskName)
{
var cmd = string.Format("list-tasks");
cmd += enabled == null ? "" : string.Format(" --enabled {0}", enabled);
cmd += string.IsNullOrEmpty(taskName) ? "" : string.Format(" --name {0}", taskName);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <TaskModelBase> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data);
}
public static ModuleInstanceModel[] AddModule(Data.Site site, int portalId, string moduleName, int pageId, string paneName, string moduleTitle)
{
var cmd = string.Format("add-module --name {0} --pageid {1}", moduleName, pageId);
cmd += string.IsNullOrEmpty(paneName) ? "" : string.Format(" --pane {0}", paneName);
cmd += string.IsNullOrEmpty(moduleTitle) ? "" : string.Format(" --title {0}", moduleTitle);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <ModuleInstanceModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data);
}
public static UserRoleModel[] AddRoles(Data.Site site, int portalId, int userId, string roles, System.DateTime?start, System.DateTime?end)
{
var cmd = string.Format("add-roles --id {0} --roles {1}", userId, roles);
cmd += start == null ? "" : string.Format(" --start {0:yyyy-MM-dd}", start);
cmd += end == null ? "" : string.Format(" --start {0:yyyy-MM-dd}", end);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <UserRoleModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data);
}
protected void Page_Load(object sender, EventArgs e)
{
string office_id = Request.QueryString["office_id"];
string period_id = Request.QueryString["period_id"];
date_type = Request.QueryString["dt"];
if (!string.IsNullOrEmpty(office_id))
{
OfficeID = Convert.ToInt32(office_id);
}
else
{
OfficeID = user.OfficeID;
}
WSCID = Convert.ToInt32(db.Offices.FirstOrDefault(p => p.office_id == OfficeID).wsc_id);
if (!Page.IsPostBack)
{
//If the user belongs to this site's WSC (or has an exception to work in the WSC), or is a SuperUser, then allow them to edit the page
if (user.WSCID.Contains(WSCID) && user.IsAdmin || user.IsSuperUser)
{
HasEditAccess = true;
}
if (HasEditAccess)
{
pnlHasAccess.Visible = true;
pnlNotice.Visible = false;
pnlNoAccess.Visible = false;
if (!string.IsNullOrEmpty(period_id))
{
period = db.RecordAnalysisPeriods.FirstOrDefault(p => p.period_id == Convert.ToInt32(period_id));
site = period.Record.Site;
PopulateRecordPeriods("edit", "");
}
else
{
pnlEnterSite.Visible = true;
pnlEditDates.Visible = false;
rbCancel.PostBackUrl = String.Format("{0}Admin/Tasks.asp?office_id={1}", Config.SIMSURL, OfficeID);
}
}
else
{
pnlHasAccess.Visible = false;
pnlNoAccess.Visible = true;
}
UserControlSetup();
}
}
/// <summary>
/// Set up our environment based on current session or query string info.
/// </summary>
/// <param name="context"></param>
private void Setup(HttpContext context)
{
if (context.Request.QueryString[site_no_qs] != null)
{
site_no = context.Request.QueryString[site_no_qs];
}
if (context.Request.QueryString[agency_cd_qs] != null)
{
agency_cd = context.Request.QueryString[agency_cd_qs];
}
site = db.Sites.FirstOrDefault(p => p.site_no == site_no && p.agency_cd == agency_cd);
//site = db.Sites.FirstOrDefault(p => p.site_no == "434307112382601" && p.agency_cd == "USGS");
}
public static UserModel NewUser(Data.Site site, int portalId, string email, string username, string firstname, string lastname, string password, bool?approved, bool?notify)
{
var cmd = string.Format("new-user --email {0} --username {1} --firstname {2} --lastname {3}", email, username, firstname, lastname);
cmd += string.IsNullOrEmpty(password) ? "" : string.Format(" --password {0}", password);
cmd += approved == null ? "" : string.Format(" --approved {0}", approved);
cmd += notify == null ? "" : string.Format(" --notify {0}", notify);
var response = DnnPromptController.ProcessCommand(site, portalId, 5, cmd);
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <ConsoleResultModel <UserModel> >(response.Contents);
result.AssertValidConsoleResponse();
return(result.Data[0]);
}
