public static int SaveQuickAttributes(string listId, string listattribute_id, string displayname, string defaultcssclassname)
{
string sql = @"UPDATE listsettings.listattribute
SET displayname = @displayname,
defaultcssclassname = @defaultcssclassname
WHERE listattribute_id = @listattribute_id AND list_id = @list_id
";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("listattribute_id", listattribute_id),
new KeyValuePair <string, string>("list_id", listId),
new KeyValuePair <string, string>("displayname", displayname),
new KeyValuePair <string, string>("defaultcssclassname", defaultcssclassname),
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
return(0);
}
return(1);
}
protected void btnDropEntity_Click(object sender, EventArgs e)
{
string sql = @"SELECT entitysettings.dropentityfrommodelbyid(
@p_entityid
)";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
Response.Redirect("EntityManagerList.aspx");
}
private void AddNewClientClaim()
{
try
{
string sql = "INSERT INTO \"ClientClaims\" (\"Type\", \"Value\", \"ClientId\") VALUES(@Type, @Value, CAST(@ClientId AS INT));";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Type", this.txtType.Text),
new KeyValuePair <string, string>("Value", this.txtValue.Text),
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value)
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
ClearAttributesForm();
this.lblSuccess.Text = "Client claim added";
this.lblSuccess.Visible = true;
BindEntityGrid();
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
protected void dgClientClaim_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Remove")
{
try
{
string sql = "DELETE FROM \"ClientClaims\" WHERE \"Id\" = CAST(@Id AS INT);";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Id", e.Item.Cells[0].Text.ToString())
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
ClearAttributesForm();
this.lblSuccess.Text = "Client claim removed";
this.lblSuccess.Visible = true;
BindEntityGrid();
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string sql = @"DELETE FROM eboards.bedboard WHERE bedboard_id = @bedboard_id;";
string newID = this.hdnBedBoardID.Value;
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("bedboard_id", newID)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
StringBuilder sbe = new StringBuilder();
sbe.AppendLine("<div class='contentAlertDanger'><h3 style='color: #712f2f'>Sorry, there was an error:</h3>");
sbe.AppendLine(ex.ToString());
sbe.AppendLine("</div>");
this.ltrlError.Visible = true;
this.ltrlError.Text = sbe.ToString();
return;
}
Response.Redirect("BoardManagerList.aspx");
}
protected void btnDropBaseView_Click(object sender, EventArgs e)
{
this.lblError.Visible = false;
this.lblSuccess.Visible = false;
string sql = @"SELECT listsettings.dropbaseview(
@p_baseview_id,
@p_baseviewname
)";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_baseview_id", this.hdnBaseViewID.Value),
new KeyValuePair <string, string>("p_baseviewname", this.lblSummaryType.Text)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Visible = true;
this.lblError.Text = ex.ToString();
return;
}
Response.Redirect("BaseViewManagerList.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
string haserr = "form-group has-error";
string noerr = "form-group";
this.lblError.Text = string.Empty;
this.lblError.Visible = false;
this.lblSuccess.Visible = false;
this.fgDeviceName.CssClass = noerr;
if (string.IsNullOrEmpty(this.txtDeviceName.Text.ToString()))
{
this.lblError.Text = "Please enter the device name";
this.txtDeviceName.Focus();
this.lblError.Visible = true;
this.fgDeviceName.CssClass = haserr;
return;
}
this.fgIPAddress.CssClass = noerr;
if (string.IsNullOrEmpty(this.txtIPAddress.Text.ToString()))
{
this.lblError.Text = "Please enter the IP Address";
this.txtIPAddress.Focus();
this.lblError.Visible = true;
this.fgIPAddress.CssClass = haserr;
return;
}
string sql = @"UPDATE eboards.bedboarddevice SET
bedboarddevicename = @bedboarddevicename, bedboard_id = @bedboard_id, deviceipaddress = @deviceipaddress, locationward = @locationward, locationbayroom = @locationbayroom, locationbed = @locationbed
WHERE bedboarddevice_id = @bedboarddevice_id;" ;
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("bedboarddevice_id", this.hdnDeviceID.Value),
new KeyValuePair <string, string>("bedboarddevicename", this.txtDeviceName.Text),
new KeyValuePair <string, string>("bedboard_id", this.ddlBedBoard.SelectedValue),
new KeyValuePair <string, string>("deviceipaddress", this.txtIPAddress.Text),
new KeyValuePair <string, string>("locationward", this.ddllWard.SelectedValue),
new KeyValuePair <string, string>("locationbayroom", this.ddlBayRoom.SelectedValue),
new KeyValuePair <string, string>("locationbed", this.ddlBed.SelectedValue)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
Response.Redirect("BedBoardDeviceList.aspx");
}
private void CreateNewList()
{
string sql = "INSERT INTO listsettings.listmanager(list_id, listname, listdescription, listcontextkey, baseview_id, listnamespaceid, " +
"listnamespace, defaultcontext, defaultcontextfield, matchedcontextfield, tablecssstyle, tableheadercssstyle, defaultrowcssstyle, " +
"patientbannerfield, rowcssfield, wardpersonacontextfield, clinicalunitpersonacontextfield, specialtypersonacontextfield, teampersonacontextfield, snapshottemplateline1, " +
"snapshottemplateline2, snapshottemplatebadge, defaultsortcolumn, defaultsortorder) " +
"VALUES (@list_id, @listname, @listdescription, @listcontextkey, @baseview_id, @listnamespaceid, " +
"@listnamespace, @defaultcontext, @defaultcontextfield, @matchedcontextfield, @tablecssstyle, @tableheadercssstyle, @defaultrowcssstyle, @patientbannerfield, @rowcssfield, " +
"@wardpersonacontextfield, @clinicalunitpersonacontextfield, @specialtypersonacontextfield, @teampersonacontextfield, @snapshottemplateline1, @snapshottemplateline2, @snapshottemplatebadge, " +
"@defaultsortcolumn, @defaultsortorder)";
string newId = System.Guid.NewGuid().ToString();
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("list_id", newId),
new KeyValuePair <string, string>("listname", this.txtListName.Text),
new KeyValuePair <string, string>("listdescription", this.txtListComments.Text),
new KeyValuePair <string, string>("listcontextkey", ""),
new KeyValuePair <string, string>("baseview_id", this.ddlBaseView.SelectedValue),
new KeyValuePair <string, string>("listnamespaceid", this.hdnNamespaceID.Value),
new KeyValuePair <string, string>("listnamespace", SynapseHelpers.GetListNamespaceNameFromID(this.hdnNamespaceID.Value)),
new KeyValuePair <string, string>("defaultcontext", this.ddlDefaultContext.SelectedValue),
new KeyValuePair <string, string>("defaultcontextfield", this.lblDefaultContextField.Text),
new KeyValuePair <string, string>("matchedcontextfield", this.ddlMatchedContextField.SelectedValue),
new KeyValuePair <string, string>("patientbannerfield", this.ddlPatientBannerField.SelectedValue),
new KeyValuePair <string, string>("rowcssfield", this.ddlRowCSSField.SelectedValue),
new KeyValuePair <string, string>("tablecssstyle", this.txtTableClass.Text),
new KeyValuePair <string, string>("tableheadercssstyle", this.txtTableHeaderClass.Text),
new KeyValuePair <string, string>("defaultrowcssstyle", this.txtDefaultTableRowCSS.Text),
new KeyValuePair <string, string>("wardpersonacontextfield", this.ddlWardPersonaContextField.SelectedValue == "0" ? null : this.ddlWardPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("clinicalunitpersonacontextfield", this.ddlCUPersonaContextField.SelectedValue == "0" ? null : this.ddlCUPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("specialtypersonacontextfield", this.ddlSpecialtyPersonaContextField.SelectedValue == "0" ? null : this.ddlSpecialtyPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("teampersonacontextfield", this.ddlTeamPersonaContextField.SelectedValue == "0" ? null : this.ddlTeamPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("snapshottemplateline1", this.ddlSnapshotLine1.SelectedValue == "0" ? null : this.ddlSnapshotLine1.SelectedValue),
new KeyValuePair <string, string>("snapshottemplateline2", this.ddlSnapshotLine2.SelectedValue == "0" ? null : this.ddlSnapshotLine2.SelectedValue),
new KeyValuePair <string, string>("snapshottemplatebadge", this.ddlSnapshotBadge.SelectedValue == "0" ? null : this.ddlSnapshotBadge.SelectedValue),
new KeyValuePair <string, string>("defaultsortcolumn", this.ddlDefaultSortColumn.SelectedValue == "0" ? null : this.ddlDefaultSortColumn.SelectedValue),
// Don't save defaultsortorder if defaultsortcolumn is not selected
new KeyValuePair <string, string>("defaultsortorder", this.ddlDefaultSortColumn.SelectedValue == "0" ? null : this.ddlDefaultSortOrder.SelectedValue)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
updateTeminusFilter(newId);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
Response.Redirect("ListManagerAttributes.aspx?id=" + newId);
}
private void AddNewClientRedirectUri()
{
try
{
string sql = string.Empty;
var paramList = new List <KeyValuePair <string, string> >();
if (this.ddlURIType.SelectedValue == "Redirect URI")
{
sql = "INSERT INTO \"ClientRedirectUris\" (\"RedirectUri\", \"ClientId\") VALUES(@RedirectUri, CAST(@ClientId AS INT));";
paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("RedirectUri", this.txtRedirectUri.Text),
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value)
};
}
else if (this.ddlURIType.SelectedValue == "CORS origin URI")
{
sql = "INSERT INTO \"ClientCorsOrigins\" (\"Origin\", \"ClientId\") VALUES(@Origin, CAST(@ClientId AS INT));";
paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Origin", this.txtRedirectUri.Text),
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value)
};
}
else if (this.ddlURIType.SelectedValue == "Post logout redirect URI")
{
sql = "INSERT INTO \"ClientPostLogoutRedirectUris\" (\"PostLogoutRedirectUri\", \"ClientId\") VALUES(@PostLogoutRedirectUri, CAST(@ClientId AS INT));";
paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("PostLogoutRedirectUri", this.txtRedirectUri.Text),
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value)
};
}
DataServices.ExcecuteNonQueryFromSQL(sql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
string selectedValue = this.ddlURIType.SelectedValue;
ClearAttributesForm();
this.lblSuccess.Text = "Client " + selectedValue + " URI added";
this.lblSuccess.Visible = true;
BindEntityGrid();
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
protected void dgClientRedirectURI_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Remove")
{
try
{
string sql = string.Empty;
var paramList = new List <KeyValuePair <string, string> >();
if (e.Item.Cells[2].Text.ToString() == "Redirect URI")
{
sql = "DELETE FROM \"ClientRedirectUris\" WHERE \"Id\" = CAST(@Id AS INT);";
paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Id", e.Item.Cells[0].Text.ToString())
};
}
else if (e.Item.Cells[2].Text.ToString() == "CORS origin URI")
{
sql = "DELETE FROM \"ClientCorsOrigins\" WHERE \"Id\" = CAST(@Id AS INT);";
paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Id", e.Item.Cells[0].Text.ToString())
};
}
else if (e.Item.Cells[2].Text.ToString() == "Post logout redirect URI")
{
sql = "DELETE FROM \"ClientPostLogoutRedirectUris\" WHERE \"Id\" = CAST(@Id AS INT);";
paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Id", e.Item.Cells[0].Text.ToString())
};
}
DataServices.ExcecuteNonQueryFromSQL(sql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
ClearAttributesForm();
this.lblSuccess.Text = "Client " + e.Item.Cells[2].Text.ToString() + " removed";
this.lblSuccess.Visible = true;
BindEntityGrid();
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
}
protected void btnDropAttribute_Click(object sender, EventArgs e)
{
DataTable dtBVs = SynapseHelpers.GetEntityBaseviewsDT(this.hdnEntityID.Value);
string sql = @"SELECT entitysettings.dropattributefromentity(
@p_attributeid,
@p_entityid
)";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_attributeid", this.hdnAttributeID.Value),
new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
foreach (DataRow row in dtBVs.Rows)
{
string baseview_id = row["baseview_id"].ToString();
string sqlRecreate = "SELECT listsettings.recreatebaseview(@baseview_id);";
var paramListRecreate = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("baseview_id", baseview_id)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sqlRecreate, paramListRecreate);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
Response.Redirect("EntityManagerAttributes.aspx?action=view&id=" + this.hdnEntityID.Value);
}
private void AddNewClientGrantType()
{
try
{
string sql = "SELECT * FROM \"ClientGrantTypes\" WHERE \"ClientId\" = CAST(@ClientId AS INT) AND \"GrantType\" = @GrantType";
var param = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value),
new KeyValuePair <string, string>("GrantType", this.ddlClientGrantType.SelectedValue)
};
DataSet ds = DataServices.DataSetFromSQL(sql, param, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
this.lblError.Text = "Grant type already exists";
this.lblError.Visible = true;
this.pnlClientGrantType.CssClass = "form - group has - error";
return;
}
else
{
string insertSql = "INSERT INTO \"ClientGrantTypes\" (\"GrantType\", \"ClientId\") VALUES(@GrantType, CAST(@ClientId AS INT));";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("GrantType", this.ddlClientGrantType.SelectedValue),
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value)
};
DataServices.ExcecuteNonQueryFromSQL(insertSql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
ClearAttributesForm();
this.lblSuccess.Text = "Client grant type added";
this.lblSuccess.Visible = true;
BindEntityGrid();
}
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
protected void btnDropEntity_Click(object sender, EventArgs e)
{
string sql = @"SELECT entitysettings.dropentityfrommodelbyid(
@p_entityid
)";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value)
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
Response.Redirect("EntityManagerList.aspx");
}
protected void btnDropAttribute_Click(object sender, EventArgs e)
{
string sql = @"SELECT entitysettings.droprelationfromentity(
@p_attributeid,
@p_entityid
)";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_attributeid", this.hdnAttributeID.Value),
new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value)
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
Response.Redirect("EntityManagerRelations.aspx?action=view&id=" + this.hdnEntityID.Value);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string sql = "DELETE FROM eboards.bedboarddevice WHERE bedboarddevice_id = @bedboarddevice_id;";
DataSet ds = new DataSet();
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("bedboarddevice_id", this.hdnDeviceID.Value)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
Response.Redirect("BedBoardDeviceList.aspx");
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
public void updateTeminusFilter()
{
string sql = "delete FROM entitystorematerialised.meta_listcontexts WHERE list_id = @list_id;";
string listid = this.hdnListID.Value;
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("list_id", listid)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
DataTable dt = (DataTable)Session["personfilterTable"];
for (int i = 0; i < dt.Rows.Count; i++)
{
string sqlAddfilter = "INSERT INTO entitystorematerialised.meta_listcontexts(listcontexts_id,persona_id, field, list_id) " +
"VALUES (@listcontexts_id, @persona_id, @field, @list_id) ";
string newId = System.Guid.NewGuid().ToString();
var paramListAddlist = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("listcontexts_id", newId),
new KeyValuePair <string, string>("persona_id", dt.Rows[i]["persona_id"].ToString()),
new KeyValuePair <string, string>("field", dt.Rows[i]["field"].ToString()),
new KeyValuePair <string, string>("list_id", dt.Rows[i]["list_id"].ToString())
};
DataServices.ExcecuteNonQueryFromSQL(sqlAddfilter, paramListAddlist);
}
}
public void updateTeminusFilter(string listid)
{
DataTable dt = (DataTable)Session["personfilterTable"];
for (int i = 0; i < dt.Rows.Count; i++)
{
string sqlAddfilter = "INSERT INTO entitystorematerialised.meta_listcontexts(listcontexts_id,persona_id, field, list_id) " +
"VALUES (@listcontexts_id, @persona_id, @field, @list_id) ";
string newId = System.Guid.NewGuid().ToString();
var paramListAddlist = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("listcontexts_id", newId),
new KeyValuePair <string, string>("persona_id", dt.Rows[i]["persona_id"].ToString()),
new KeyValuePair <string, string>("field", dt.Rows[i]["field"].ToString()),
new KeyValuePair <string, string>("list_id", dt.Rows[i]["list_id"].ToString())
};
DataServices.ExcecuteNonQueryFromSQL(sqlAddfilter, paramListAddlist);
}
}
private void AddNewClientSecret()
{
try
{
string sql = "INSERT INTO \"ClientSecrets\" (\"Value\", \"Type\", \"ClientId\") VALUES(@Value, @Type, CAST(@ClientId AS INT));";
string hashedPassword = string.Empty;
using (SHA256 shA256 = SHA256.Create())
{
byte[] bytes = Encoding.UTF8.GetBytes(this.txtValue.Text);
hashedPassword = Convert.ToBase64String(((HashAlgorithm)shA256).ComputeHash(bytes));
}
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Value", hashedPassword),
new KeyValuePair <string, string>("Type", this.txtType.Text),
new KeyValuePair <string, string>("ClientId", this.hdnClientID.Value)
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
ClearAttributesForm();
this.lblSuccess.Text = "Client secret added";
this.lblSuccess.Visible = true;
BindEntityGrid();
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string haserr = "form-group has-error";
string noerr = "form-group";
this.lblError.Text = string.Empty;
this.lblError.Visible = false;
this.lblSuccess.Visible = false;
this.fgDeviceName.CssClass = noerr;
if (string.IsNullOrEmpty(this.txtDeviceName.Text.ToString()))
{
this.lblError.Text = "Please enter the device name";
this.txtDeviceName.Focus();
this.lblError.Visible = true;
this.fgDeviceName.CssClass = haserr;
return;
}
this.fgIPAddress.CssClass = noerr;
if (string.IsNullOrEmpty(this.txtIPAddress.Text.ToString()))
{
this.lblError.Text = "Please enter the IP Address";
this.txtIPAddress.Focus();
this.lblError.Visible = true;
this.fgIPAddress.CssClass = haserr;
return;
}
this.fgLocationCode.CssClass = noerr;
if (string.IsNullOrEmpty(this.txtLocationCode.Text.ToString()))
{
this.lblError.Text = "Please enter the Location Code";
this.txtLocationCode.Focus();
this.lblError.Visible = true;
this.fgLocationCode.CssClass = haserr;
return;
}
string sql = @"INSERT INTO eboards.Locatorboarddevice(
Locatorboarddevice_id, Locatorboarddevicename, Locatorboard_id, deviceipaddress, locationid)
VALUES(@Locatorboarddevice_id, @Locatorboarddevicename, @Locatorboard_id, @deviceipaddress, @locationid);" ;
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Locatorboarddevice_id", this.hdnDeviceID.Value),
new KeyValuePair <string, string>("Locatorboarddevicename", this.txtDeviceName.Text),
new KeyValuePair <string, string>("Locatorboard_id", this.ddlLocatorBoard.SelectedValue),
new KeyValuePair <string, string>("deviceipaddress", this.txtIPAddress.Text),
new KeyValuePair <string, string>("locationid", this.txtLocationCode.Text)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
Response.Redirect("LocatorBoardDeviceView.aspx?id=" + this.hdnDeviceID.Value);
}
private void CreateNewAttribute()
{
DataTable dtBVs = SynapseHelpers.GetEntityBaseviewsDT(this.hdnEntityID.Value);
this.hdnDataType.Value = SynapseHelpers.GetDataTypeFromID(this.ddlDataType.SelectedValue);
string sql = @"SELECT entitysettings.addattributetoentity(
@p_entityid,
@p_entityname,
@p_synapsenamespaceid,
@p_synapsenamespacename,
@p_username,
@p_attributename,
@p_attributedescription,
@p_datatype,
@p_datatypeid,
CAST(@p_ordinal_position AS integer),
@p_attributedefault,
@p_maximumlength,
@p_commondisplayname,
@p_isnullsetting,
@p_entityversionid
)";
DataTable dt = SynapseHelpers.GetEntityDSFromID(this.hdnEntityID.Value);
string maxLength = "";
if (this.ddlDataType.SelectedItem.Text == "Short String")
{
maxLength = "255";
}
if (this.ddlDataType.SelectedItem.Text == "Long String")
{
maxLength = "1000";
}
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value),
new KeyValuePair <string, string>("p_entityname", SynapseHelpers.GetEntityNameFromID(this.hdnEntityID.Value)),
new KeyValuePair <string, string>("p_synapsenamespaceid", dt.Rows[0]["synapsenamespaceid"].ToString()),
new KeyValuePair <string, string>("p_synapsenamespacename", dt.Rows[0]["synapsenamespacename"].ToString()),
new KeyValuePair <string, string>("p_username", this.hdnUserName.Value),
new KeyValuePair <string, string>("p_attributename", this.txtAttributeName.Text),
new KeyValuePair <string, string>("p_attributedescription", "Description"),
new KeyValuePair <string, string>("p_datatype", this.hdnDataType.Value),
new KeyValuePair <string, string>("p_datatypeid", this.ddlDataType.SelectedValue),
new KeyValuePair <string, string>("p_ordinal_position", this.hdnNextOrdinalPosition.Value),
new KeyValuePair <string, string>("p_attributedefault", ""),
new KeyValuePair <string, string>("p_maximumlength", maxLength),
new KeyValuePair <string, string>("p_commondisplayname", ""),
new KeyValuePair <string, string>("p_isnullsetting", ""),
new KeyValuePair <string, string>("p_entityversionid", SynapseHelpers.GetCurrentEntityVersionFromID(this.hdnEntityID.Value))
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
ClearAttributesForm();
this.lblSuccess.Text = "Attribute created";
this.lblSuccess.Visible = true;
this.hdnNextOrdinalPosition.Value = SynapseHelpers.GetNextOrdinalPositionFromID(this.hdnEntityID.Value);
foreach (DataRow row in dtBVs.Rows)
{
string baseview_id = row["baseview_id"].ToString();
string sqlRecreate = "SELECT listsettings.recreatebaseview(@baseview_id);";
var paramListRecreate = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("baseview_id", baseview_id)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sqlRecreate, paramListRecreate);
}
catch (Exception ex) {
var a = ex.ToString();
}
}
BindEntityGrid();
}
private void AddUser()
{
try
{
string userId = Guid.NewGuid().ToString();
string hashedPassword = string.Empty;
PasswordHasher <IdentityUser> passwordHasher = new PasswordHasher <IdentityUser>();
IdentityUser user = new IdentityUser(this.txtUsername.Text);
hashedPassword = passwordHasher.HashPassword(user, this.txtPassword.Text);
//using (SHA256 shA256 = SHA256.Create())
//{
// byte[] bytes = Encoding.UTF8.GetBytes(this.txtPassword.Text);
// hashedPassword = Convert.ToBase64String(((HashAlgorithm)shA256).ComputeHash(bytes));
//}
string sql = "INSERT INTO \"AspNetUsers\"(\"Id\", \"UserName\", \"NormalizedUserName\", \"Email\", \"NormalizedEmail\", \"EmailConfirmed\", \"PasswordHash\", \"SecurityStamp\", \"ConcurrencyStamp\", \"PhoneNumberConfirmed\", \"TwoFactorEnabled\", \"LockoutEnabled\", \"AccessFailedCount\") "
+ " VALUES(@Id, @UserName, @NormalizedUserName, @Email, @NormalizedEmail, false, @PasswordHash, @SecurityStamp, @ConcurrencyStamp, false, false, false, 0)";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Id", userId),
new KeyValuePair <string, string>("Username", this.txtUsername.Text),
new KeyValuePair <string, string>("NormalizedUserName", this.txtUsername.Text.ToUpper()),
new KeyValuePair <string, string>("Email", this.txtEmail.Text),
new KeyValuePair <string, string>("NormalizedEmail", this.txtEmail.Text.ToUpper()),
new KeyValuePair <string, string>("PasswordHash", hashedPassword),
new KeyValuePair <string, string>("SecurityStamp", Guid.NewGuid().ToString()),
new KeyValuePair <string, string>("ConcurrencyStamp", Guid.NewGuid().ToString())
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
string query = "INSERT INTO \"AspNetUserClaims\" (\"UserId\", \"ClaimType\", \"ClaimValue\") " +
"VALUES(@UserId, @ClaimType, @ClaimValue), " +
"(@UserId, @ClaimType1, @ClaimValue1), " +
"(@UserId, @ClaimType2, @ClaimValue2), " +
"(@UserId, @ClaimType3, @ClaimValue3), " +
"(@UserId, @ClaimType4, @ClaimValue4);";
var parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("UserId", userId),
new KeyValuePair <string, string>("ClaimType", "name"),
new KeyValuePair <string, string>("ClaimValue", this.txtFirstName.Text + ' ' + this.txtLastName.Text),
new KeyValuePair <string, string>("ClaimType1", "given_name"),
new KeyValuePair <string, string>("ClaimValue1", this.txtFirstName.Text),
new KeyValuePair <string, string>("ClaimType2", "family_name"),
new KeyValuePair <string, string>("ClaimValue2", this.txtLastName.Text),
new KeyValuePair <string, string>("ClaimType3", "email"),
new KeyValuePair <string, string>("ClaimValue3", this.txtEmail.Text),
new KeyValuePair <string, string>("ClaimType4", "email_verified"),
new KeyValuePair <string, string>("ClaimValue4", "true")
};
DataServices.ExcecuteNonQueryFromSQL(query, parameters, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
ClearAttributesForm();
this.lblSuccess.Text = "New user added";
this.lblSuccess.Visible = true;
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
private void updateClient()
{
try
{
string sql = "SELECT * FROM \"Clients\" WHERE \"ClientId\" = @ClientId";
var param = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("ClientId", txtClientId.Text)
};
DataSet ds = DataServices.DataSetFromSQL(sql, param, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 1)
{
lblError.Text = "Client Id Not exists";
txtClientId.Focus();
lblError.Visible = true;
pnlClientId.CssClass = "form - group has - error";
return;
}
else
{
string insertSQL = " UPDATE \"Clients\" SET "
+ " \"Enabled\" =CAST(@Enabled AS BOOLEAN), "
+ " \"RequireClientSecret\" = CAST(@RequireClientSecret AS BOOLEAN), "
+ " \"ClientName\" = @ClientName,"
+ " \"Description\" = @Description, "
+ " \"RequireConsent\" = CAST(@RequireConsent AS BOOLEAN), "
+ " \"AllowAccessTokensViaBrowser\" = CAST(@AllowAccessTokensViaBrowser AS BOOLEAN), "
+ " \"AllowOfflineAccess\" = CAST(@AllowOfflineAccess AS BOOLEAN), "
+ " \"IdentityTokenLifetime\" = CAST(@IdentityTokenLifetime AS INT), "
+ " \"AccessTokenLifetime\" = CAST(@AccessTokenLifetime AS INT), "
+ " \"AuthorizationCodeLifetime\" = CAST(@AuthorizationCodeLifetime AS INT), "
+ " \"ConsentLifetime\" = CAST(@ConsentLifetime AS INT), "
+ " \"AbsoluteRefreshTokenLifetime\" = CAST(@AbsoluteRefreshTokenLifetime AS INT), "
+ " \"SlidingRefreshTokenLifetime\" = CAST(@SlidingRefreshTokenLifetime AS INT), "
+ " \"RefreshTokenUsage\" = CAST(@RefreshTokenUsage AS INT), "
+ " \"UpdateAccessTokenClaimsOnRefresh\" = CAST(@UpdateAccessTokenClaimsOnRefresh AS BOOLEAN), "
+ " \"RefreshTokenExpiration\" =CAST(@RefreshTokenExpiration AS INT), "
+ " \"EnableLocalLogin\" = CAST(@EnableLocalLogin AS BOOLEAN), "
+ " \"AlwaysSendClientClaims\" =CAST(@AlwaysSendClientClaims AS BOOLEAN), "
+ " \"ClientClaimsPrefix\" = @ClientClaimsPrefix "
+ " WHERE \"ClientId\" = @ClientId ";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Enabled", chkEnabled.Checked ? "1" : "0"),
new KeyValuePair <string, string>("ClientId", txtClientId.Text),
new KeyValuePair <string, string>("RequireClientSecret", chkReqClntSecret.Checked ? "1" : "0"),
new KeyValuePair <string, string>("ClientName", txtClientName.Text),
new KeyValuePair <string, string>("Description", txtDesc.Text),
new KeyValuePair <string, string>("RequireConsent", chkReqCon.Checked ? "1" : "0"),
new KeyValuePair <string, string>("AllowAccessTokensViaBrowser", chkAllAccTkn.Checked ? "1" : "0"),
new KeyValuePair <string, string>("AllowOfflineAccess", chkAllOffAcc.Checked ? "1" : "0"),
new KeyValuePair <string, string>("IdentityTokenLifetime", txtIdTknLt.Text),
new KeyValuePair <string, string>("AccessTokenLifetime", txtAccTknLt.Text),
new KeyValuePair <string, string>("AuthorizationCodeLifetime", txtAuthCodeLt.Text),
new KeyValuePair <string, string>("ConsentLifetime", txtConLt.Text),
new KeyValuePair <string, string>("AbsoluteRefreshTokenLifetime", txtAbReTknLt.Text),
new KeyValuePair <string, string>("SlidingRefreshTokenLifetime", txtSlReTknLt.Text),
new KeyValuePair <string, string>("RefreshTokenUsage", chkReTknUs.Checked ? "1" : "0"),
new KeyValuePair <string, string>("UpdateAccessTokenClaimsOnRefresh", chkUpdAccTknClRe.Checked ? "1" : "0"),
new KeyValuePair <string, string>("RefreshTokenExpiration", chkReTknExp.Checked ? "1" : "0"),
new KeyValuePair <string, string>("EnableLocalLogin", chkEnLocLog.Checked ? "1" : "0"),
new KeyValuePair <string, string>("AlwaysSendClientClaims", chkAlSenClntCl.Checked ? "1" : "0"),
new KeyValuePair <string, string>("ClientClaimsPrefix", txtClntClPre.Text)
};
DataServices.ExcecuteNonQueryFromSQL(insertSQL, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
if (!string.IsNullOrEmpty(GetClientId(this.txtClientId.Text)) || GetClientId(this.txtClientId.Text) != "An error occurred")
{
string clientId = GetClientId(this.txtClientId.Text);
Response.Redirect("ClientScopes.aspx?id=" + clientId);
}
}
}
catch (Exception ex)
{
lblError.Text = ex.ToString();
lblError.Visible = true;
return;
}
}
private void AddNewClient()
{
try
{
string sql = "SELECT * FROM \"Clients\" WHERE \"ClientId\" = @ClientId";
var param = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("ClientId", this.txtClientId.Text)
};
DataSet ds = DataServices.DataSetFromSQL(sql, param, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
this.lblError.Text = "Client Id already exists";
this.txtClientId.Focus();
this.lblError.Visible = true;
this.pnlClientId.CssClass = "form - group has - error";
return;
}
else
{
string insertSQL = "INSERT INTO \"Clients\" (\"Enabled\", \"ClientId\", \"ProtocolType\", \"RequireClientSecret\", \"ClientName\", "
+ " \"Description\", \"RequireConsent\", \"AllowRememberConsent\", \"AlwaysIncludeUserClaimsInIdToken\", "
+ " \"RequirePkce\", \"AllowPlainTextPkce\", \"AllowAccessTokensViaBrowser\", \"FrontChannelLogoutSessionRequired\", "
+ " \"BackChannelLogoutSessionRequired\", \"AllowOfflineAccess\", \"IdentityTokenLifetime\", \"AccessTokenLifetime\", "
+ " \"AuthorizationCodeLifetime\", \"ConsentLifetime\", \"AbsoluteRefreshTokenLifetime\", \"SlidingRefreshTokenLifetime\", "
+ " \"RefreshTokenUsage\", \"UpdateAccessTokenClaimsOnRefresh\", \"RefreshTokenExpiration\", \"AccessTokenType\", "
+ " \"EnableLocalLogin\", \"IncludeJwtId\", \"AlwaysSendClientClaims\", \"ClientClaimsPrefix\") "
+ " VALUES(CAST(@Enabled AS BOOLEAN), @ClientId, 'oidc', CAST(@RequireClientSecret AS BOOLEAN), @ClientName, "
+ " @Description, CAST(@RequireConsent AS BOOLEAN), true, true, "
+ " false, true, CAST(@AllowAccessTokensViaBrowser AS BOOLEAN), false, "
+ " false, CAST(@AllowOfflineAccess AS BOOLEAN), CAST(@IdentityTokenLifetime AS INT), CAST(@AccessTokenLifetime AS INT), "
+ " CAST(@AuthorizationCodeLifetime AS INT), CAST(@ConsentLifetime AS INT), CAST(@AbsoluteRefreshTokenLifetime AS INT), CAST(@SlidingRefreshTokenLifetime AS INT), "
+ " CAST(@RefreshTokenUsage AS INT), CAST(@UpdateAccessTokenClaimsOnRefresh AS BOOLEAN), CAST(@RefreshTokenExpiration AS INT), 0, "
+ " CAST(@EnableLocalLogin AS BOOLEAN), false, CAST(@AlwaysSendClientClaims AS BOOLEAN), @ClientClaimsPrefix);";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("Enabled", this.chkEnabled.Checked ? "1" : "0"),
new KeyValuePair <string, string>("ClientId", this.txtClientId.Text),
new KeyValuePair <string, string>("RequireClientSecret", this.chkReqClntSecret.Checked ? "1" : "0"),
new KeyValuePair <string, string>("ClientName", this.txtClientName.Text),
new KeyValuePair <string, string>("Description", this.txtDesc.Text),
new KeyValuePair <string, string>("RequireConsent", this.chkReqCon.Checked ? "1" : "0"),
new KeyValuePair <string, string>("AllowAccessTokensViaBrowser", this.chkAllAccTkn.Checked ? "1" : "0"),
new KeyValuePair <string, string>("AllowOfflineAccess", this.chkAllOffAcc.Checked ? "1" : "0"),
new KeyValuePair <string, string>("IdentityTokenLifetime", this.txtIdTknLt.Text),
new KeyValuePair <string, string>("AccessTokenLifetime", this.txtAccTknLt.Text),
new KeyValuePair <string, string>("AuthorizationCodeLifetime", this.txtAuthCodeLt.Text),
new KeyValuePair <string, string>("ConsentLifetime", this.txtConLt.Text),
new KeyValuePair <string, string>("AbsoluteRefreshTokenLifetime", this.txtAbReTknLt.Text),
new KeyValuePair <string, string>("SlidingRefreshTokenLifetime", this.txtSlReTknLt.Text),
new KeyValuePair <string, string>("RefreshTokenUsage", this.chkReTknUs.Checked ? "1" : "0"),
new KeyValuePair <string, string>("UpdateAccessTokenClaimsOnRefresh", this.chkUpdAccTknClRe.Checked ? "1" : "0"),
new KeyValuePair <string, string>("RefreshTokenExpiration", this.chkReTknExp.Checked ? "1" : "0"),
new KeyValuePair <string, string>("EnableLocalLogin", this.chkEnLocLog.Checked ? "1" : "0"),
new KeyValuePair <string, string>("AlwaysSendClientClaims", this.chkAlSenClntCl.Checked ? "1" : "0"),
new KeyValuePair <string, string>("ClientClaimsPrefix", this.txtClntClPre.Text)
};
DataServices.ExcecuteNonQueryFromSQL(insertSQL, paramList, dbConnection: SynapseHelpers.DBConnections.PGSQLConnectionSIS);
if (!string.IsNullOrEmpty(GetClientId(this.txtClientId.Text)) || GetClientId(this.txtClientId.Text) != "An error occurred")
{
string clientId = GetClientId(this.txtClientId.Text);
Response.Redirect("ClientScopes.aspx?id=" + clientId);
}
}
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
}
protected void btnCreateNewEntity_Click(object sender, EventArgs e)
{
//Drop the baseeview
string sqlDrop = @"SELECT listsettings.dropbaseview(
@p_baseview_id,
@p_baseviewname
)";
var paramListDrop = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_baseview_id", this.hdnBaseViewID.Value),
new KeyValuePair <string, string>("p_baseviewname", this.lblSummaryType.Text)
};
DataServices.ExcecuteNonQueryFromSQL(sqlDrop, paramListDrop);
//Recreate the baseview
//string tmpViewName = Guid.NewGuid().ToString("N");
//Check if we can create a temporary view using the supplied SQL Statement
string sqlCreate = "CREATE VIEW baseviewcore." + this.lblNamespaceName.Text + "_" + this.lblBaseViewName.Text + " AS " + this.txtSQL.Text + ";";
var paramListCreate = new List <KeyValuePair <string, string> >()
{
};
try
{
DataServices.executeSQLStatement(sqlCreate, paramListCreate);
}
catch (Exception ex)
{
this.lblError.Text = "Error creating view: " + ex.ToString();
this.lblError.Visible = true;
return;
}
string baseviewid = this.hdnBaseViewID.Value;
string sql = "SELECT listsettings.recreatebaseview(@p_baseviewnamespaceid, @p_baseviewnamespace, @p_baseviewname, @p_baseviewdescription, @p_baseviewsqlstatement, @p_username, @baseviewid);";
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_baseviewnamespaceid", this.hdnNamespaceID.Value),
new KeyValuePair <string, string>("p_baseviewnamespace", this.lblNamespaceName.Text),
new KeyValuePair <string, string>("p_baseviewname", this.lblBaseViewName.Text),
new KeyValuePair <string, string>("p_baseviewdescription", this.lblBaseViewComments.Text),
new KeyValuePair <string, string>("p_baseviewsqlstatement", this.txtSQL.Text),
new KeyValuePair <string, string>("p_username", this.hdnUserName.Value),
new KeyValuePair <string, string>("baseviewid", this.hdnBaseViewID.Value),
};
DataSet ds = new DataSet();
try
{
ds = DataServices.DataSetFromSQL(sql, paramList);
}
catch (Exception ex)
{
this.lblError.Text = "Error creating view: " + ex.ToString();
this.lblError.Visible = true;
return;
}
DataTable dt = ds.Tables[0];
string newGuid = "";
try
{
newGuid = dt.Rows[0][0].ToString();
}
catch { }
Response.Redirect("BaseViewManageSQL.aspx?id=" + newGuid);
}
protected void btnClone_Click(object sender, EventArgs e)
{
string haserr = "form-group has-error";
string noerr = "form-group";
this.ltrlError.Text = string.Empty;
this.ltrlError.Visible = false;
this.lblSuccess.Visible = false;
int errcount = 0;
StringBuilder sb = new StringBuilder();
sb.AppendLine("<div class='contentAlertDanger'><h3 style='color: #712f2f'>Please resolve the following errors:</h3><ul>");
this.fgBedBoardName.CssClass = noerr;
if (string.IsNullOrWhiteSpace(this.txtBedBoardName.Text))
{
sb.AppendLine("<li>" + "Please enter a new name for the Bed Board" + "</li>");
this.fgBedBoardName.CssClass = haserr;
errcount++;
}
this.fgBaseView.CssClass = noerr;
if (this.ddlBaseView.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select a baseview" + "</li>");
this.fgBaseView.CssClass = haserr;
errcount++;
}
this.fgPersonIDField.CssClass = noerr;
if (this.ddlPersonIDField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the PersonID field from the baseview" + "</li>");
this.fgPersonIDField.CssClass = haserr;
errcount++;
}
this.fgEncounterIDField.CssClass = noerr;
if (this.ddlEncounterIDField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the EncounterID field from the baseview" + "</li>");
this.fgEncounterIDField.CssClass = haserr;
errcount++;
}
this.fgWardField.CssClass = noerr;
if (this.ddlWardField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the Ward Code field from the baseview" + "</li>");
this.fgWardField.CssClass = haserr;
errcount++;
}
this.fgBedField.CssClass = noerr;
if (this.ddlBedField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the Bed Code field from the baseview" + "</li>");
this.fgBedField.CssClass = haserr;
errcount++;
}
this.fgTopSetting.CssClass = noerr;
if (this.ddlTopSetting.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the top section setting" + "</li>");
this.fgTopSetting.CssClass = haserr;
errcount++;
}
this.fgTopField.CssClass = noerr;
if (this.ddlTopSetting.SelectedValue == "1" && this.ddlTopField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Top Section" + "</li>");
this.fgTopField.CssClass = haserr;
errcount++;
}
this.fgTopLeftField.CssClass = noerr;
if (this.ddlTopSetting.SelectedValue == "2" && this.ddlTopLeftField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Top Left Section" + "</li>");
this.fgTopField.CssClass = haserr;
errcount++;
}
this.fgTopRightField.CssClass = noerr;
if (this.ddlTopSetting.SelectedValue == "2" && this.ddlTopRightField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Top Right Section" + "</li>");
this.fgTopField.CssClass = haserr;
errcount++;
}
this.fgMiddleSetting.CssClass = noerr;
if (this.ddlMiddleSetting.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the Middle section setting" + "</li>");
this.fgMiddleSetting.CssClass = haserr;
errcount++;
}
this.fgMiddleField.CssClass = noerr;
if (this.ddlMiddleSetting.SelectedValue == "1" && this.ddlMiddleField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Middle Section" + "</li>");
this.fgMiddleField.CssClass = haserr;
errcount++;
}
this.fgMiddleLeftField.CssClass = noerr;
if (this.ddlMiddleSetting.SelectedValue == "2" && this.ddlMiddleLeftField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Middle Left Section" + "</li>");
this.fgMiddleField.CssClass = haserr;
errcount++;
}
this.fgMiddleRightField.CssClass = noerr;
if (this.ddlMiddleSetting.SelectedValue == "2" && this.ddlMiddleRightField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Middle Right Section" + "</li>");
this.fgMiddleField.CssClass = haserr;
errcount++;
}
this.fgBottomSetting.CssClass = noerr;
if (this.ddlBottomSetting.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the Bottom section setting" + "</li>");
this.fgBottomSetting.CssClass = haserr;
errcount++;
}
this.fgBottomField.CssClass = noerr;
if (this.ddlBottomSetting.SelectedValue == "1" && this.ddlBottomField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Bottom Section" + "</li>");
this.fgBottomField.CssClass = haserr;
errcount++;
}
this.fgBottomLeftField.CssClass = noerr;
if (this.ddlBottomSetting.SelectedValue == "2" && this.ddlBottomLeftField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Bottom Left Section" + "</li>");
this.fgBottomField.CssClass = haserr;
errcount++;
}
this.fgBottomRightField.CssClass = noerr;
if (this.ddlBottomSetting.SelectedValue == "2" && this.ddlBottomRightField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Bottom Right Section" + "</li>");
this.fgBottomField.CssClass = haserr;
errcount++;
}
if (errcount > 0)
{
sb.AppendLine("</ul></div>");
this.ltrlError.Visible = true;
this.ltrlError.Text = sb.ToString();
return;
}
string sql = @"INSERT INTO eboards.bedboard(
_createdby,
bedboard_id,
bedboardname,
bedboarddescription,
baseviewnamespace_id,
baseview_id,
baseviewpersonidfield,
baseviewencounteridfield,
baseviewwardfield,
baseviewbedfield,
topsetting,
middlesetting,
bottomsetting,
topfield,
topleftfield,
toprightfield,
middlefield,
middleleftfield,
middlerightfield,
bottomfield,
bottomleftfield,
bottomrightfield
)
VALUES(
@_createdby,
@bedboard_id,
@bedboardname,
@bedboarddescription,
@baseviewnamespace_id,
@baseview_id,
@baseviewpersonidfield,
@baseviewencounteridfield,
@baseviewwardfield,
@baseviewbedfield,
@topsetting,
@middlesetting,
@bottomsetting,
@topfield,
@topleftfield,
@toprightfield,
@middlefield,
@middleleftfield,
@middlerightfield,
@bottomfield,
@bottomleftfield,
@bottomrightfield
)";
string newID = System.Guid.NewGuid().ToString();
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("_createdby", this.hdnUserName.Value),
new KeyValuePair <string, string>("bedboard_id", newID),
new KeyValuePair <string, string>("bedboardname", this.txtBedBoardName.Text + "_Clone"),
new KeyValuePair <string, string>("bedboarddescription", this.txtBedBoardDescription.Text),
new KeyValuePair <string, string>("baseviewnamespace_id", this.ddlBaseViewNamespace.SelectedValue),
new KeyValuePair <string, string>("baseview_id", this.ddlBaseView.SelectedValue),
new KeyValuePair <string, string>("baseviewpersonidfield", this.ddlPersonIDField.SelectedValue),
new KeyValuePair <string, string>("baseviewencounteridfield", this.ddlEncounterIDField.SelectedValue),
new KeyValuePair <string, string>("baseviewwardfield", this.ddlWardField.SelectedValue),
new KeyValuePair <string, string>("baseviewbedfield", this.ddlBedField.SelectedValue),
new KeyValuePair <string, string>("topsetting", this.ddlTopSetting.SelectedValue),
new KeyValuePair <string, string>("middlesetting", this.ddlMiddleSetting.SelectedValue),
new KeyValuePair <string, string>("bottomsetting", this.ddlBottomSetting.SelectedValue),
new KeyValuePair <string, string>("topfield", this.ddlTopField.SelectedValue),
new KeyValuePair <string, string>("topleftfield", this.ddlTopLeftField.SelectedValue),
new KeyValuePair <string, string>("toprightfield", this.ddlTopRightField.SelectedValue),
new KeyValuePair <string, string>("middlefield", this.ddlMiddleField.SelectedValue),
new KeyValuePair <string, string>("middleleftfield", this.ddlMiddleLeftField.SelectedValue),
new KeyValuePair <string, string>("middlerightfield", this.ddlMiddleRightField.SelectedValue),
new KeyValuePair <string, string>("bottomfield", this.ddlBottomField.SelectedValue),
new KeyValuePair <string, string>("bottomleftfield", this.ddlBottomLeftField.SelectedValue),
new KeyValuePair <string, string>("bottomrightfield", this.ddlBottomRightField.SelectedValue)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
StringBuilder sbe = new StringBuilder();
sbe.AppendLine("<div class='contentAlertDanger'><h3 style='color: #712f2f'>Sorry, there was an error:</h3>");
sbe.AppendLine(ex.ToString());
sbe.AppendLine("</div>");
this.ltrlError.Visible = true;
this.ltrlError.Text = sbe.ToString();
return;
}
Response.Redirect("BedBoardManagerView.aspx?id=" + newID);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string haserr = "form-group has-error";
string noerr = "form-group";
this.ltrlError.Text = string.Empty;
this.ltrlError.Visible = false;
this.lblSuccess.Visible = false;
int errcount = 0;
StringBuilder sb = new StringBuilder();
sb.AppendLine("<div class='contentAlertDanger'><h3 style='color: #712f2f'>Please resolve the following errors:</h3><ul>");
this.fgLocatorBoardName.CssClass = noerr;
if (string.IsNullOrWhiteSpace(this.txtLocatorBoardName.Text))
{
sb.AppendLine("<li>" + "Please enter a new name for the Bed Board" + "</li>");
this.fgLocatorBoardName.CssClass = haserr;
errcount++;
}
//Lists
this.fgList.CssClass = noerr;
if (this.ddlList.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the underlying list for the board" + "</li>");
this.fgList.CssClass = haserr;
errcount++;
}
this.fgListLocationField.CssClass = noerr;
if (this.ddlListLocationField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the location id field for the list" + "</li>");
this.fgListLocationField.CssClass = haserr;
errcount++;
}
this.fgBaseViewNamespace.CssClass = noerr;
if (this.ddlBaseViewNamespace.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the location specific information baseview" + "</li>");
this.fgBaseViewNamespace.CssClass = haserr;
errcount++;
}
this.fgBaseView.CssClass = noerr;
if (this.ddlBaseView.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select a location specific baseview" + "</li>");
this.fgBaseView.CssClass = haserr;
errcount++;
}
this.fgLocationIDField.CssClass = noerr;
if (this.ddlLocationIDField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the Bed Code field from the baseview" + "</li>");
this.fgLocationIDField.CssClass = haserr;
errcount++;
}
this.fgHeading.CssClass = noerr;
if (this.ddlHeading.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the Heading column from the baseview" + "</li>");
this.fgHeading.CssClass = haserr;
errcount++;
}
this.fgTopLeftField.CssClass = noerr;
if (this.ddlTopLeftField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Top Left Section" + "</li>");
this.fgTopLeftField.CssClass = haserr;
errcount++;
}
this.fgTopRightField.CssClass = noerr;
if (ddlTopRightField.SelectedIndex == 0)
{
sb.AppendLine("<li>" + "Please select the field column from the baseview for the Top Right Section" + "</li>");
this.fgTopRightField.CssClass = haserr;
errcount++;
}
if (errcount > 0)
{
sb.AppendLine("</ul></div>");
this.ltrlError.Visible = true;
this.ltrlError.Text = sb.ToString();
return;
}
string sql = @"INSERT INTO eboards.LocatorBoard(
_createdby,
LocatorBoard_id,
LocatorBoardname,
LocatorBoarddescription,
list_id,
listlocationfield,
locationbaseviewnamespace_id,
locationbaseview_id,
locationidfield,
locationdisplayfield,
topleftfield,
toprightfield
)
VALUES(
@_createdby,
@LocatorBoard_id,
@LocatorBoardname,
@LocatorBoarddescription,
@list_id,
@listlocationfield,
@locationbaseviewnamespace_id,
@locationbaseview_id,
@locationidfield,
@locationdisplayfield,
@topleftfield,
@toprightfield
)";
string newID = System.Guid.NewGuid().ToString();
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("_createdby", this.hdnUserName.Value),
new KeyValuePair <string, string>("LocatorBoard_id", newID),
new KeyValuePair <string, string>("LocatorBoardname", this.txtLocatorBoardName.Text),
new KeyValuePair <string, string>("LocatorBoarddescription", this.txtLocatorBoardDescription.Text),
new KeyValuePair <string, string>("list_id", this.ddlList.SelectedValue),
new KeyValuePair <string, string>("listlocationfield", this.ddlListLocationField.SelectedValue),
new KeyValuePair <string, string>("locationbaseviewnamespace_id", this.ddlBaseViewNamespace.SelectedValue),
new KeyValuePair <string, string>("locationbaseview_id", this.ddlBaseView.SelectedValue),
new KeyValuePair <string, string>("locationidfield", this.ddlLocationIDField.SelectedValue),
new KeyValuePair <string, string>("locationdisplayfield", this.ddlHeading.SelectedValue),
new KeyValuePair <string, string>("topleftfield", this.ddlTopLeftField.SelectedValue),
new KeyValuePair <string, string>("toprightfield", this.ddlTopRightField.SelectedValue)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
}
catch (Exception ex)
{
StringBuilder sbe = new StringBuilder();
sbe.AppendLine("<div class='contentAlertDanger'><h3 style='color: #712f2f'>Sorry, there was an error:</h3>");
sbe.AppendLine(ex.ToString());
sbe.AppendLine("</div>");
this.ltrlError.Visible = true;
this.ltrlError.Text = sbe.ToString();
return;
}
Response.Redirect("LocatorBoardManagerView.aspx?id=" + newID);
}
private void SaveNewList()
{
string haserr = "form-group has-error";
string noerr = "form-group";
this.lblError.Text = string.Empty;
this.lblError.Visible = false;
this.lblSuccess.Visible = false;
this.fgListName.CssClass = noerr;
if (string.IsNullOrEmpty(this.txtListName.Text.ToString()))
{
this.lblError.Text = "Please enter a new name for the List";
this.txtListName.Focus();
this.lblError.Visible = true;
this.fgListName.CssClass = haserr;
return;
}
this.fgDefaultContext.CssClass = noerr;
if (this.ddlDefaultContext.SelectedIndex == 0)
{
this.lblError.Text = "Please select the entity that defines the default context";
this.ddlDefaultContext.Focus();
this.lblError.Visible = true;
this.fgDefaultContext.CssClass = haserr;
return;
}
this.fgMatchedContextField.CssClass = noerr;
if (this.ddlMatchedContextField.SelectedIndex == 0)
{
this.lblError.Text = "Please select the field from the baseview that matches the default context key defined";
this.ddlMatchedContextField.Focus();
this.lblError.Visible = true;
this.fgMatchedContextField.CssClass = haserr;
return;
}
string sql = "UPDATE listsettings.listmanager SET " +
"listname = @listname, " +
"listdescription = @listdescription, " +
"defaultcontext = @defaultcontext, " +
"defaultcontextfield = @defaultcontextfield, " +
"matchedcontextfield = @matchedcontextfield, " +
"tablecssstyle = @tablecssstyle, " +
"tableheadercssstyle = @tableheadercssstyle, " +
"defaultrowcssstyle = @defaultrowcssstyle, " +
"patientbannerfield = @patientbannerfield, " +
"rowcssfield = @rowcssfield, " +
"wardpersonacontextfield = @wardpersonacontextfield, " +
"clinicalunitpersonacontextfield = @clinicalunitpersonacontextfield, " +
"specialtypersonacontextfield = @specialtypersonacontextfield, " +
"teampersonacontextfield = @teampersonacontextfield, " +
"snapshottemplateline1 = @snapshottemplateline1, " +
"snapshottemplateline2 = @snapshottemplateline2, " +
"snapshottemplatebadge = @snapshottemplatebadge, " +
"defaultsortcolumn = @defaultsortcolumn, " +
"defaultsortorder = @defaultsortorder " +
"WHERE list_id = @list_id;";
string newId = this.hdnListID.Value;
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("list_id", newId),
new KeyValuePair <string, string>("listname", this.txtListName.Text),
new KeyValuePair <string, string>("listdescription", this.txtListComments.Text),
new KeyValuePair <string, string>("defaultcontext", this.ddlDefaultContext.SelectedValue),
new KeyValuePair <string, string>("defaultcontextfield", this.lblDefaultContextField.Text),
new KeyValuePair <string, string>("matchedcontextfield", this.ddlMatchedContextField.SelectedValue),
new KeyValuePair <string, string>("patientbannerfield", this.ddlPatientBannerField.SelectedValue),
new KeyValuePair <string, string>("rowcssfield", this.ddlRowCSSField.SelectedValue),
new KeyValuePair <string, string>("tablecssstyle", this.txtTableClass.Text),
new KeyValuePair <string, string>("tableheadercssstyle", this.txtTableHeaderClass.Text),
new KeyValuePair <string, string>("defaultrowcssstyle", this.txtDefaultTableRowCSS.Text),
new KeyValuePair <string, string>("wardpersonacontextfield", this.ddlWardPersonaContextField.SelectedValue == "0" ? null : this.ddlWardPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("clinicalunitpersonacontextfield", this.ddlCUPersonaContextField.SelectedValue == "0" ? null : this.ddlCUPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("specialtypersonacontextfield", this.ddlSpecialtyPersonaContextField.SelectedValue == "0" ? null : this.ddlSpecialtyPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("teampersonacontextfield", this.ddlTeamPersonaContextField.SelectedValue == "0" ? null : this.ddlTeamPersonaContextField.SelectedValue),
new KeyValuePair <string, string>("snapshottemplateline1", this.ddlSnapshotLine1.SelectedValue == "0" ? null : this.ddlSnapshotLine1.SelectedValue),
new KeyValuePair <string, string>("snapshottemplateline2", this.ddlSnapshotLine2.SelectedValue == "0" ? null : this.ddlSnapshotLine2.SelectedValue),
new KeyValuePair <string, string>("snapshottemplatebadge", this.ddlSnapshotBadge.SelectedValue == "0" ? null : this.ddlSnapshotBadge.SelectedValue),
new KeyValuePair <string, string>("defaultsortcolumn", this.ddlDefaultSortColumn.SelectedValue == "0" ? null : this.ddlDefaultSortColumn.SelectedValue),
// Don't save defaultsortorder if defaultsortcolumn is not selected
new KeyValuePair <string, string>("defaultsortorder", this.ddlDefaultSortColumn.SelectedValue == "0" ? null : this.ddlDefaultSortOrder.SelectedValue)
};
try
{
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
updateTeminusFilter();
}
catch (Exception ex)
{
this.lblError.Text = ex.ToString();
this.lblError.Visible = true;
return;
}
Response.Redirect("ListManagerList.aspx");
}
private void CreateRelation()
{
string sql = @"SELECT entitysettings.addrelationtoentity(
@p_entityid,
@p_entityname,
@p_synapsenamespaceid,
@p_synapsenamespacename,
@p_parententityid,
@p_parententityname,
@p_parentsynapsenamespaceid,
@p_parentsynapsenamespacename,
@p_attributeid,
@p_attributename,
CAST(@p_ordinal_position AS integer),
@p_entityversionid,
@p_username,
@p_localentityattributeid,
@p_localentityattributename
)";
DataTable dt = SynapseHelpers.GetEntityDSFromID(this.hdnEntityID.Value);
DataTable dtParent = SynapseHelpers.GetEntityDSFromID(this.ddlEntity.SelectedValue);
DataTable dtKey = SynapseHelpers.GetEntityKeyAttributeFromID(this.ddlEntity.SelectedValue);
string attributename = dtKey.Rows[0]["attributename"].ToString();
if (this.ddlLocalAttribute.SelectedIndex > 0)
{
attributename += "_" + this.ddlLocalAttribute.SelectedItem.Text;
}
var paramList = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("p_entityid", this.hdnEntityID.Value),
new KeyValuePair <string, string>("p_entityname", SynapseHelpers.GetEntityNameFromID(this.hdnEntityID.Value)),
new KeyValuePair <string, string>("p_synapsenamespaceid", dt.Rows[0]["synapsenamespaceid"].ToString()),
new KeyValuePair <string, string>("p_synapsenamespacename", dt.Rows[0]["synapsenamespacename"].ToString()),
new KeyValuePair <string, string>("p_parententityid", this.ddlEntity.SelectedValue),
new KeyValuePair <string, string>("p_parententityname", this.ddlEntity.SelectedItem.Text),
new KeyValuePair <string, string>("p_parentsynapsenamespaceid", dtParent.Rows[0]["synapsenamespaceid"].ToString()),
new KeyValuePair <string, string>("p_parentsynapsenamespacename", dtParent.Rows[0]["synapsenamespacename"].ToString()),
new KeyValuePair <string, string>("p_attributeid", dtKey.Rows[0]["attributeid"].ToString()),
new KeyValuePair <string, string>("p_attributename", attributename),
new KeyValuePair <string, string>("p_ordinal_position", this.hdnNextOrdinalPosition.Value),
new KeyValuePair <string, string>("p_entityversionid", SynapseHelpers.GetCurrentEntityVersionFromID(this.hdnEntityID.Value)),
new KeyValuePair <string, string>("p_username", this.hdnUserName.Value),
new KeyValuePair <string, string>("p_localentityattributeid", this.ddlLocalAttribute.SelectedValue),
new KeyValuePair <string, string>("p_localentityattributename", this.ddlLocalAttribute.SelectedItem.Text)
};
DataServices.ExcecuteNonQueryFromSQL(sql, paramList);
ClearAttributesForm();
this.hdnNextOrdinalPosition.Value = SynapseHelpers.GetNextOrdinalPositionFromID(this.hdnEntityID.Value);
BindEntityGrid();
this.lblSuccess.Text = "Relation created";
this.lblSuccess.Visible = true;
}
