public void GenerateRows(string HiddenStaffPermissionId)
{
objUserPreferences = new Streamline.UserBusinessServices.UserPrefernces();
DataSet DataSetPermissions = null;
DataSet dsTemp = null;
DataSet dsStaff = null;
dsUserPreferences = new Streamline.UserBusinessServices.DataSets.DataSetUserPrefrences();
try
{
DataSet dtst = new DataSet();
Session["Permissions"] = "";
DataSetPermissions = new DataSet();
if (Session["StaffIdForPreferences"] != null && HiddenStaffPermissionId == string.Empty)
{
dsTemp = objUserPreferences.CheckStaffPermissions(Convert.ToInt32(Session["StaffIdForPreferences"]));
dsUserPreferences.Staff.Merge(dsTemp.Tables[0]);
dsUserPreferences.StaffPermissions.Merge(dsTemp.Tables[1]);
}
//Changes for merge.
else if (Session["StaffIdForPreferences"] != null && HiddenStaffPermissionId != string.Empty)
{
if (Session["DataSetPermissionsList"] != null)
{
if (((DataSet)(Session["DataSetPermissionsList"])).Tables.Count > 0)
{
dsUserPreferences = (Streamline.UserBusinessServices.DataSets.DataSetUserPrefrences)(Session["DataSetPermissionsList"]);
}
}
DataRow[] _DataRowPermissions = Streamline.UserBusinessServices.SharedTables.DataSetSystemActions.Tables[0].Select("ActionId in(" + HiddenStaffPermissionId + ")");
for (int i = 0; i < _DataRowPermissions.Length; i++)
{
DataRow DataRowNewPermissiosn = dsUserPreferences.StaffPermissions.NewRow();
DataRowNewPermissiosn["StaffId"] = Convert.ToInt32(dsUserPreferences.Staff.Rows[0]["StaffId"]);
DataRowNewPermissiosn["ActionId"] = _DataRowPermissions[i]["ActionId"];
DataRowNewPermissiosn["RowIdentifier"] = System.Guid.NewGuid();
DataRowNewPermissiosn["CreatedBy"] = Context.User.Identity.Name; // ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
DataRowNewPermissiosn["CreatedDate"] = DateTime.Now;
DataRowNewPermissiosn["ModifiedBy"] = Context.User.Identity.Name; //((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
DataRowNewPermissiosn["ModifiedDate"] = DateTime.Now;
DataRowNewPermissiosn["NewlyAddedColumn"] = "Y";
dsUserPreferences.StaffPermissions.Rows.Add(DataRowNewPermissiosn);
}
}
else if (Session["StaffIdForPreferences"] == null && HiddenStaffPermissionId != string.Empty)
{
DataRow[] _dataRow = Streamline.UserBusinessServices.SharedTables.DataSetSystemActions.Tables[0].Select("ActionId in (" + HiddenStaffPermissionId + ")");
String[] ActionId = HiddenStaffPermissionId.Split(',');
if (ActionId.Length > 0)
{
if (Session["DataSetPermissionsList"] == null)
{
DataSetPermissions = new DataSet();
DataSetPermissions.Tables.Add("StaffPermissions");
DataSetPermissions.Tables[0].Columns.Add("ActionId", System.Type.GetType("System.Int32"));
DataSetPermissions.Tables[0].Columns.Add("StaffPermissionId", System.Type.GetType("System.Int32"));
DataSetPermissions.Tables[0].Columns.Add("NewlyAddedColumn");
DataSetPermissions.Tables[0].Columns.Add("StaffId", System.Type.GetType("System.Int32"));
DataSetPermissions.Tables[0].Columns.Add("CreatedBy");
DataSetPermissions.Tables[0].Columns.Add("CreatedDate", System.Type.GetType("System.DateTime"));
DataSetPermissions.Tables[0].Columns.Add("ModifiedBy");
DataSetPermissions.Tables[0].Columns.Add("ModifiedDate", System.Type.GetType("System.DateTime"));
DataSetPermissions.Tables[0].Columns.Add("RecordDeleted");
DataSetPermissions.Tables[0].Columns.Add("DeletedBy");
DataSetPermissions.Tables[0].Columns.Add("DeletedDate", System.Type.GetType("System.DateTime"));
DataSetPermissions.Tables[0].Columns.Add("RowIdentifier", System.Type.GetType("System.Guid"));
}
else
{
dsTemp = (DataSet)Session["DataSetPermissionsList"];
dsUserPreferences.Merge(dsTemp);
}
Random ran = new Random();
for (int i = 0; i < ActionId.Length; i++)
{
//Random ran = new Random();
DataRow DataRowNewPermissiosn = dsUserPreferences.StaffPermissions.NewRow();
DataRowNewPermissiosn["StaffPermissionId"] = Convert.ToInt32(ran.Next().ToString());
DataRowNewPermissiosn["StaffId"] = Convert.ToInt32(dsUserPreferences.Staff.Rows[0]["StaffId"]);
DataRowNewPermissiosn["ActionId"] = Convert.ToInt32(_dataRow[i]["ActionId"]);
DataRowNewPermissiosn["RowIdentifier"] = System.Guid.NewGuid();
DataRowNewPermissiosn["CreatedBy"] = Context.User.Identity.Name; //((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
DataRowNewPermissiosn["CreatedDate"] = DateTime.Now;
DataRowNewPermissiosn["ModifiedBy"] = Context.User.Identity.Name; //((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserCode;
DataRowNewPermissiosn["ModifiedDate"] = DateTime.Now;
DataRowNewPermissiosn["NewlyAddedColumn"] = "Y";
dsUserPreferences.StaffPermissions.Rows.Add(DataRowNewPermissiosn);
}
}
}
DataSetPermissions.Merge(dsUserPreferences.StaffPermissions);
PanelPermissionsList.Controls.Clear();
PanelPermissionsList.ScrollBars = ScrollBars.Vertical;
Table tbPermissionsList = new Table();
tbPermissionsList.ID = System.Guid.NewGuid().ToString();
//tbPermissionsList.BorderWidth = 2;
tbPermissionsList.Width = new Unit(100, UnitType.Percentage);
TableHeaderRow thTitle = new TableHeaderRow();
TableHeaderCell thBlank1 = new TableHeaderCell();
//Screen Name
TableHeaderCell thScreenName = new TableHeaderCell();
thScreenName.Text = "Screen Name";
thScreenName.Attributes.Add("onclick", "onHeaderClick(this)");
thScreenName.Attributes.Add("ColumnName", "ScreenName");
//thScreenName.CssClass = "handStyle";
thScreenName.Attributes.Add("align", "left");
//Action
TableHeaderCell thAction = new TableHeaderCell();
thAction.Text = "Action";
thAction.Attributes.Add("onclick", "onHeaderClick(this)");
thAction.Attributes.Add("ColumnName", "Action");
//thAction.CssClass = "handStyle";
thAction.Attributes.Add("align", "left");
thTitle.Cells.Add(thBlank1);
thTitle.Cells.Add(thScreenName);
thTitle.Cells.Add(thAction);
thTitle.CssClass = "GridViewHeaderText";
tbPermissionsList.Rows.Add(thTitle);
string rowStyle = "GridViewRowStyle";
string staffPermissionId;
string myscript = "<script id='Permissionslist' type='text/javascript'>";
myscript += "function $deleteRecord(sender,e){";
if (!string.IsNullOrEmpty(_deleteRowMessage))
{
myscript += " if (confirm ('" + _deleteRowMessage + "') == true ){" + this._onDeleteEventHandler + "(sender,e)}}";
}
else
{
myscript += "}";
}
if (DataSetPermissions != null && DataSetPermissions.Tables["StaffPermissions"].Rows.Count > 0)
{
myscript += "function RegisterPermissionsListControlEvents(){try{";
if (DataSetPermissions.Tables[0].Rows.Count > 0)
{
Random ran = new Random();
DataRow[] dtr = DataSetPermissions.Tables[0].Select("ISNULL(RecordDeleted,'N')<>'Y'");
DataView dtv = DataSetPermissions.Tables[0].DefaultView;
dtv.RowFilter = "ISNULL(RecordDeleted,'N')<>'Y'";
dtst.Merge(dtr);
foreach (DataRow dr in dtst.Tables[0].Rows)
{
if (dtst.Tables[0].Columns.Contains("StaffPermissionId"))
{
if (dr["StaffPermissionId"].ToString() != "")
{
staffPermissionId = dr["StaffPermissionId"].ToString();
}
else
{
staffPermissionId = ran.Next().ToString();
dr["StaffPermissionId"] = staffPermissionId;
}
}
else
{
staffPermissionId = ran.Next().ToString();
}
string screeName = "Medication Management";
DataRow[] _DataRowAction = Streamline.UserBusinessServices.SharedTables.DataSetSystemActions.Tables[0].Select("ActionId in(" + Convert.ToInt32(dr["ActionId"]) + ")");
string action = _DataRowAction[0]["Action"].ToString();
if (Session["Permissions"].ToString() == "")
{
Session["Permissions"] = _DataRowAction[0]["ActionId"].ToString();
}
else
{
Session["Permissions"] = Session["Permissions"] + "," + _DataRowAction[0]["ActionId"].ToString();
}
tbPermissionsList.Rows.Add(GenerateSubRows(dr, staffPermissionId, screeName, action, tbPermissionsList.ClientID, ref myscript, rowStyle));
rowStyle = rowStyle == "GridViewRowStyle" ? "GridViewAlternatingRowStyle" : "GridViewRowStyle";
}
}
Session["DataSetPermissionsList"] = dsUserPreferences;
PanelPermissionsList.Controls.Add(tbPermissionsList);
myscript += "}catch(e){ Streamline.SmartClient.ExceptionManager.getInstance().publishException(ERROR_CODE_REGULAR, e);}}</script>";
Page.RegisterClientScriptBlock(this.ClientID, myscript);
}
}
catch (Exception ex)
{
if (ex.Data["CustomExceptionInformation"] == null)
{
ex.Data["CustomExceptionInformation"] = "";
}
else
{
ex.Data["CustomExceptionInformation"] = "";
}
if (ex.Data["DatasetInfo"] == null)
{
ex.Data["DatasetInfo"] = null;
}
throw (ex);
}
}
public override void Activate()
{
DataSet dsTemp = null;
try
{
if (System.Configuration.ConfigurationSettings.AppSettings["OpenFromSmartCare"].ToString().ToUpper() == "FALSE")
{
LinkButtonLogout.Style["display"] = "block";
LinkButtonStartPage.Style["display"] = "block";
}
LabelPrescriberName.Text = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).LastName + ", " + ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).FirstName + " " + (((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity)).StaffDegree;
#region --Made changes by Pradeep as per task#2711
string LastPrescriptionReviewTime = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).LastPrescriptionReviewTime;
if (LastPrescriptionReviewTime.ToString() != string.Empty)
{
LabelReviewDateTime.Text = Convert.ToDateTime(LastPrescriptionReviewTime).ToString("MM/dd/yyyy hh:mm tt");;
}
#endregion --
//LabelReviewDateTime.Text = ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).LastPrescriptionReviewTime;
HiddenFieldRDLCurrentDateTime.Value = DateTime.Now.ToString();
if (Session["DataSetSecurityQustion"] != null)
{
dsTemp = (DataSet)Session["DataSetSecurityQustion"];
Random random = new Random();
int num = random.Next(0, dsTemp.Tables[0].Rows.Count);
if (dsTemp.Tables[0].Rows.Count > 0)
{
LabelSecurityQuestion.Text = dsTemp.Tables["StaffSecurityQuestion"].Rows[num]["CodeName"].ToString();
HiddenFieldSecurityAnswer.Value = dsTemp.Tables["StaffSecurityQuestion"].Rows[num]["SecurityAnswer"].ToString();
}
}
else
{
objUserPreferences = new UserPrefernces();
dsTemp = objUserPreferences.GetSecurityQuestions(Convert.ToInt32((((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserId)));
Session["DataSetSecurityQustion"] = dsTemp;
Random random = new Random();
int num = random.Next(0, dsTemp.Tables[0].Rows.Count);
if (dsTemp.Tables[0].Rows.Count > 0)
{
LabelSecurityQuestion.Text = dsTemp.Tables["StaffSecurityQuestion"].Rows[num]["CodeName"].ToString();
HiddenFieldSecurityAnswer.Value = dsTemp.Tables["StaffSecurityQuestion"].Rows[num]["SecurityAnswer"].ToString();
}
}
GetRDLCContents();
//if (Session["DataSetSecurityQustion"] != null)
//{
// dsSecurityQuestion = new DataSet();
// dsSecurityQuestion = (DataSet)Session["DataSetSecurityQustion"];
// Random ran = new Random();
// int randomNumber = ran.Next(0,dsSecurityQuestion.Tables["StaffSecurityQuestion"].Rows.Count);
// LabelSecurityQuestion.Text = dsSecurityQuestion.Tables["StaffSecurityQuestion].Rows[randomNumber]["CodeName"];
// HiddenFieldSecurityAnswer.Value = dsSecurityQuestion.Tables[StaffSecurityQuestion].Rows[randomNumber]["Answer"];
//}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objUserPreferences = null;
}
}
protected void ButtonApprove_Click(object sender, EventArgs e)
{
int count = 0;
new Streamline.UserBusinessServices.MedicationLogin();
DataSet dsTemp = null;
try
{
if (LabelErrorMessage.Text == "Your account is disabled.Please contact system administrator.")
{
Response.Redirect("MedicationLogin.aspx");
}
if (HiddenFieldFirstChance.Value == "")
{
HiddenFieldFirstChance.Value = "0";
}
if (HiddenFieldSecurityAnswer.Value.Trim().ToLower() == TextBoxAnswer.Text.Trim().ToLower())
{
ImageError.Style.Add("display", "none");
ImageError.Style.Add("display", "none");
LabelErrorMessage.Style.Add("display", "none");
TextBoxAnswer.Focus();
LabelErrorMessage.Text = "";
objUserPreferences = new Streamline.UserBusinessServices.UserPrefernces();
count = objUserPreferences.ApprovePrescription(((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).UserId, ((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).LastPrescriptionReviewTime, HiddenFieldRDLCurrentDateTime.Value);
((Streamline.BaseLayer.StreamlineIdentity)Context.User.Identity).LastPrescriptionReviewTime = HiddenFieldRDLCurrentDateTime.Value;
ScriptManager.RegisterStartupScript(LabelErrorMessage, LabelErrorMessage.GetType(), ClientID.ToString(), "redirectToStartPage();", true);
//return count;
}
else
{
HiddenFieldFirstChance.Value = Convert.ToString(Convert.ToInt32(HiddenFieldFirstChance.Value) + 1);
if (Convert.ToInt32(HiddenFieldFirstChance.Value) >= 2)
{
if (HiddenFieldSecondChance.Value == "")
{
HiddenFieldSecondChance.Value = "0";
}
HiddenFieldSecondChance.Value = Convert.ToString(Convert.ToInt32(HiddenFieldSecondChance.Value) + 1);
if (HiddenFieldSecondChance.Value == "1")
{
dsTemp = (DataSet)Session["DataSetSecurityQustion"];
Random random = new Random();
if (dsTemp != null)
{
int num = random.Next(0, dsTemp.Tables[0].Rows.Count);
if (dsTemp.Tables[0].Rows.Count > 0)
{
LabelSecurityQuestion.Text = dsTemp.Tables["StaffSecurityQuestion"].Rows[num]["CodeName"].ToString();
HiddenFieldSecurityAnswer.Value = dsTemp.Tables["StaffSecurityQuestion"].Rows[num]["SecurityAnswer"].ToString();
}
}
}
if (Convert.ToInt32(HiddenFieldSecondChance.Value) > 2)
{
objMedicationLogin = new Streamline.UserBusinessServices.MedicationLogin();
objMedicationLogin.chkCountLogin(((StreamlineIdentity)(Context.User.Identity)).UserCode);
ImageError.Style.Add("display", "block");
ImageError.Style.Add("display", "block");
LabelErrorMessage.Style.Add("display", "block");
TextBoxAnswer.Focus();
LabelErrorMessage.Text = "Your account is disabled.Please contact system administrator.";
return;
}
}
ImageError.Style.Add("display", "block");
ImageError.Style.Add("display", "block");
LabelErrorMessage.Style.Add("display", "block");
TextBoxAnswer.Focus();
LabelErrorMessage.Text = "The answers provided do not match the answers on record.";
}
}
catch (Exception ex)
{
throw;
}
}
private void FillGridView(string sortField, string activeUsersOnly, string searchFilter, string prescribersOnly, string epcsprescribers)
{
DataTable dtTemp;
DataSet dsTemp;
objUserPreferences = new UserPrefernces();
string filterString = "";
string[] filters = searchFilter.Split(' ');
if (filters.Length > 0 && searchFilter != "")
{
if (filters.Length == 1)
{
filterString = "(lastname like '%" + filters[0] + "%' or firstname like '%" + filters[0] + "%') AND ";
}
else
{
filterString = "(lastname like '%" + filters[1] + "%' and firstname like '%" + filters[0] + "%') AND ";
}
}
try
{
_dsUserPreferences = new Streamline.UserBusinessServices.DataSets.DataSetUserPrefrences();
dsTemp = objUserPreferences.DownloadStaffMedicationDetail();
_dsUserPreferences.Staff.Merge(dsTemp.Tables[0]);
dtTemp = _dsUserPreferences.Staff.Clone();
if (activeUsersOnly == "Y")
{
filterString = filterString + "ISNULL(Active,'Y')<>'N' and ISNULL(RecordDeleted,'N')<>'Y'";
DataRow[] dataRowUsers = _dsUserPreferences.Tables["Staff"].Select(filterString, sortField);
for (int i = 0; i < dataRowUsers.Length; i++)
{
dtTemp.ImportRow(dataRowUsers[i]);
}
//DataGridUsers.DataSource = dtTemp;
//DataGridUsers.DataBind();
lvUserList.DataSource = dtTemp;
lvUserList.DataBind();
Session["DataViewUserManagement"] = _dsUserPreferences.Tables["Staff"].DefaultView;
}
else if (prescribersOnly == "Y")
{
filterString = filterString + "ISNULL(Prescriber,'Y')<>'N' and ISNULL(RecordDeleted,'N')<>'Y'";
DataRow[] dataRowUsers = _dsUserPreferences.Tables["Staff"].Select(filterString, sortField);
for (int i = 0; i < dataRowUsers.Length; i++)
{
dtTemp.ImportRow(dataRowUsers[i]);
}
lvUserList.DataSource = dtTemp;
lvUserList.DataBind();
Session["DataViewUserManagement"] = _dsUserPreferences.Tables["Staff"].DefaultView;
}
else if (epcsprescribers == "Y")
{
filterString = filterString + "EPCS = 'Y' and ISNULL(RecordDeleted,'N')<>'Y'";
DataRow[] dataRowUsers = _dsUserPreferences.Tables["Staff"].Select(filterString, sortField);
for (int i = 0; i < dataRowUsers.Length; i++)
{
dtTemp.ImportRow(dataRowUsers[i]);
}
lvUserList.DataSource = dtTemp;
lvUserList.DataBind();
Session["DataViewUserManagement"] = _dsUserPreferences.Tables["Staff"].DefaultView;
}
else
{
filterString = filterString + "ISNULL(RecordDeleted,'N')<>'Y'";
DataRow[] dataRowUsers = _dsUserPreferences.Tables["Staff"].Select(filterString, sortField);
for (int i = 0; i < dataRowUsers.Length; i++)
{
dtTemp.ImportRow(dataRowUsers[i]);
}
//DataGridUsers.DataSource = dtTemp;
//DataGridUsers.DataBind();
lvUserList.DataSource = dtTemp;
lvUserList.DataBind();
Session["DataViewUserManagement"] = dtTemp.DefaultView;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dtTemp = null;
}
}
