protected void DoNotContactPerMDClick(object sender, EventArgs e)
{
DataView dv = new DataView(GetSelectedPatients());
dv.RowFilter = "DoNotContactPerMD = 1";
int count = 0;
foreach (DataRowView drv in dv)
{
// set patient status to 'DoNotContactPerPT'
Patient ptObj = new Patient();
ptObj.Get(Int32.Parse(drv[BOL.Patient.PatientId].ToString()));
if (!ptObj.IsEmpty)
{
ptObj[Patient.PtContactStatus] = "DoNotContactPerMD";
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj[Patient.UpdatedTime] = DateTime.Today;
ptObj.Save();
count++;
}
}
if (count > 0)
{
Option3RB.Checked = false;
Option3RB.Enabled = false;
Option3Title.Text = "No patients specified for no contact.";
Option3Title.ForeColor = System.Drawing.Color.Gray;
Option3Details.Text = String.Empty;
PopulateDoNotContactResults();
RemovePatientFromNeedLetterList(dv, "DoNotContactPerMD");
//PopulateResults();
}
}
public ActionResult ChangePassword()
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null)
{
return(RedirectToAction("Login", "Login"));
}
UserModel model = new UserModel();
UserDa dataAccess = new UserDa();
if (currentUser.ID > 0)
{
UserModel infor = new UserModel();
infor = dataAccess.getInfoUser(currentUser.ID);
model = infor != null ? infor : model;
}
return(View(model));
}
public long UpdatePassword(UserModel model)
{
long res = 0;
// Declare new DataAccess object
UserDa dataAccess = new UserDa();
using (var transaction = new TransactionScope())
{
TblUser entity = new TblUser();
entity.ID = model.ID;
entity.Password = SafePassword.GetSaltedPassword(model.NEW_PASSWORD);
res = dataAccess.UpdatePassword(entity);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
return(res);
}
protected void SaveActionClick(object sender, EventArgs e)
{
if (PatientId != 0)
{
// create ActionItem = 'MD_Contacted' for patients to check
ActionDa actionDa = new ActionDa();
BOL.Action actionObj = new Caisis.BOL.Action();
actionObj[BOL.Action.PatientId] = PatientId;
actionObj[BOL.Action.ActionDateText] = DateTime.Today.ToShortDateString();
actionObj[BOL.Action.ActionDate] = DateTime.Today;
actionObj[BOL.Action.ActionItem] = "MD_Contacted";
actionObj[BOL.Action.ActionNotes] = !String.IsNullOrEmpty(PersonSpokeTo.Text) ? "Spoke to " + PersonSpokeTo.Text : String.Empty;
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
actionObj[BOL.Action.EnteredBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
actionObj[BOL.Action.EnteredTime] = DateTime.Now;
actionObj.Save();
// set patient status to 'MD_Contacted'
Patient ptObj = new Patient();
ptObj.Get(PatientId);
if (!ptObj.IsEmpty)
{
ptObj[Patient.PtContactStatus] = "MD_Contacted";
ptObj[Patient.UpdatedTime] = DateTime.Now;
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj.Save();
}
}
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "_reloadMainPage", "reloadMainPage(); ", true);
}
public long InsertUser(UserModel model)
{
long res = 0;
// Declare new DataAccess object
UserDa dataAccess = new UserDa();
TblUser User = new TblUser();
User.Email = model.Email;
User.UserName = model.UserName;
User.Password = SafePassword.GetSaltedPassword(model.Password);
User.Phone = model.Phone;
User.IsAdmin = false;
// Chưa xác nhận email
User.Email_Confirm = Constant.ConfirmEmail.CONFIRMED;
User.Status = Constant.Status.ACTIVE;
User.del_flg = Constant.DeleteFlag.NON_DELETE;
User.CreatedDate = DateTime.Now;
res = dataAccess.InsertUser(User);
return(res);
}
public ActionResult UserList()
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null || currentUser.IsAdmin == false)
{
return(RedirectToAction("Login", "Login"));
}
UserModel model = new UserModel();
CommonService comService = new CommonService();
var tmpCondition = GetRestoreData() as UserModel;
if (tmpCondition != null)
{
model = tmpCondition;
}
UserDa dataAccess = new UserDa();
int HaNoiCity = 1;
ManageDistrictDa daDistrict = new ManageDistrictDa();
model.DISTRICT_LIST = daDistrict.getDistrictList(HaNoiCity).ToList().Select(
f => new SelectListItem
{
Value = f.ID.ToString(),
Text = f.Name
}).ToList();
model.DISTRICT_LIST.Insert(0, new SelectListItem {
Value = Constant.DEFAULT_VALUE, Text = "Chọn Quận/huyện"
});
return(View(model));
}
/// <summary>
/// 更新用户信息，可以更改用户密码
/// </summary>
/// <param name="user"></param>
public void EditUserInfo(string itcode, string password, string firstname, string lastname, string phone)
{
User existUser = UserDa.GetUserByItCode(itcode);
if (existUser == null)
{
throw new BusinessObjectLogicException("Invalid User!");
}
if (existUser.Disabled)
{
throw new BusinessObjectLogicException("User is disabled!");
}
if (!String.IsNullOrEmpty(password))
{
existUser.Password = password;
}
existUser.FirstName = firstname;
existUser.LastName = lastname;
existUser.Phone = phone;
UserDa.UpdateUser(existUser);
}
/// <summary>
/// Gets the table of search results
/// </summary>
/// <returns></returns>
public HtmlGenericControl GetCallbackResult()
{
ProjectManagementDa da = new ProjectManagementDa();
// Determine if need to filter by user id
DataView projectsList = new DataView();
if (FilterByUser)
{
string uName = new Caisis.Security.SecurityController().GetUserName();
UserDa uda = new UserDa();
int uId = uda.GetUserId(uName);
projectsList = da.ProjectMgmtSearch(callbackSearchValue, uId).DefaultView;
}
else
{
projectsList = da.ProjectMgmtSearch(callbackSearchValue).DefaultView;
}
BindProjectList(projectsList);
return(ContentTableHolder);
}
protected void Repeater1_ItemCommand(object o, RepeaterCommandEventArgs e)
{
try
{
string currentPatientId = Convert.ToString(e.CommandArgument);
string actionItemCommand = Convert.ToString(e.CommandName);
HtmlImage DataReceivedImg = (HtmlImage)e.Item.FindControl("DataReceivedImg");
ImageButton DataReceivedBtn = (ImageButton)e.Item.FindControl("DataReceivedBtn");
Label DataReceivedLBL = (Label)e.Item.FindControl("DataReceivedLBL");
HtmlImage NeedMD_ContactImg = (HtmlImage)e.Item.FindControl("NeedMD_ContactImg");
ImageButton NeedMD_ContactBtn = (ImageButton)e.Item.FindControl("NeedMD_ContactBtn");
Label NeedMD_ContactLBL = (Label)e.Item.FindControl("NeedMD_ContactLBL");
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
if (actionItemCommand == "DataReceived")
{
if (DataReceivedBtn != null && DataReceivedImg != null)
{
DataReceivedBtn.Style["display"] = "none";
}
if (!String.IsNullOrEmpty(currentPatientId))
{
bool actionAlreadyExists = false;
ActionDa actionDa = new ActionDa();
DataSet actionDs = actionDa.ValidateActionItem(Int32.Parse(currentPatientId), actionItemCommand);
if (actionDs.Tables.Count > 0)
{
DataView actionDv = new DataView(actionDs.Tables[0]);
actionDv.RowFilter = BOL.Action.ActionDateText + " = '" + DateTime.Today.ToShortDateString() + "' AND " + BOL.Action.ActionItem + " = '" + actionItemCommand + "' ";
if (actionDv.Count > 0)
{
actionAlreadyExists = true;
}
}
// if action item does not already exist for today
if (!actionAlreadyExists)
{
// create ActionItem = 'DataReceived' for patients to check
BOL.Action actionObj = new Caisis.BOL.Action();
actionObj[BOL.Action.PatientId] = int.Parse(currentPatientId);
actionObj[BOL.Action.ActionDateText] = DateTime.Today.ToShortDateString();
actionObj[BOL.Action.ActionDate] = DateTime.Today;
actionObj[BOL.Action.ActionItem] = actionItemCommand;
actionObj[BOL.Action.EnteredBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
actionObj[BOL.Action.EnteredTime] = DateTime.Today;
actionObj.Save();
}
// set patient status to 'NeedDataEntry'
Patient ptObj = new Patient();
ptObj.Get(Int32.Parse(currentPatientId));
if (!ptObj.IsEmpty)
{
ptObj[Patient.PtContactStatus] = "NeedDataEntry";
ptObj[Patient.UpdatedTime] = DateTime.Today;
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj.Save();
}
if (DataReceivedLBL != null && DataReceivedImg != null)
{
DataReceivedImg.Style["display"] = "";
DataReceivedLBL.Text = actionItemCommand;
}
// show "NeedMD_Contact" btn
if (NeedMD_ContactBtn != null)
{
NeedMD_ContactBtn.Style["display"] = "";
}
if (NeedMD_ContactLBL != null && NeedMD_ContactImg != null)
{
NeedMD_ContactImg.Style["display"] = "none";
NeedMD_ContactLBL.Text = String.Empty;
}
}
}
else if (actionItemCommand == "NeedMD_Contact")
{
if (NeedMD_ContactBtn != null && NeedMD_ContactImg != null)
{
NeedMD_ContactBtn.Style["display"] = "none";
}
if (!String.IsNullOrEmpty(currentPatientId))
{
// if any action item was created for "DataReceived", delete
ActionDa actionDa = new ActionDa();
DataSet actionDs = actionDa.ValidateActionItem(Int32.Parse(currentPatientId), "DataReceived");
if (actionDs.Tables.Count > 0)
{
DataView actionDv = new DataView(actionDs.Tables[0]);
actionDv.RowFilter = BOL.Action.ActionDateText + " = '" + DateTime.Today.ToShortDateString() + "' AND " + BOL.Action.ActionItem + " = 'DataReceived' ";
if (actionDv.Count > 0)
{
BOL.Action actionObj = new Caisis.BOL.Action();
actionObj.Get(Int32.Parse(actionDv[0][BOL.Action.ActionId].ToString()));
actionObj.Delete();
}
}
// set patient status to 'NeedMD_Contact'
Patient ptObj = new Patient();
ptObj.Get(Int32.Parse(currentPatientId));
if (!ptObj.IsEmpty)
{
ptObj[Patient.PtContactStatus] = "NeedMD_Contact";
ptObj[Patient.UpdatedTime] = DateTime.Today;
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj.Save();
}
if (NeedMD_ContactLBL != null && NeedMD_ContactImg != null)
{
NeedMD_ContactImg.Style["display"] = "";
NeedMD_ContactLBL.Text = actionItemCommand;
}
// show "Data Received" btn
if (DataReceivedBtn != null)
{
DataReceivedBtn.Style["display"] = "";
}
if (DataReceivedLBL != null && DataReceivedImg != null)
{
DataReceivedImg.Style["display"] = "none";
DataReceivedLBL.Text = String.Empty;
}
}
}
}
catch (Exception ex)
{
// publish raw error
ExceptionHandler.Publish(ex);
}
}
protected override void Page_Load(object sender, System.EventArgs e)
{
base.Page_Load(sender, e);
if (!string.IsNullOrEmpty(Request.QueryString["userId"]))
{
//admin is coming from update password or just added new user.. populate send email fieds with new password info
userId = int.Parse(Request.QueryString["userId"]);
string pswd = Request.QueryString["pswd"];
if (!string.IsNullOrEmpty(EncPassword))
{
pswd = Security.CustomCryptoHelper.Decrypt(EncPassword);
}
UserDa user = new UserDa();
DataSet ds = user.GetByUserId(userId);
//populate to address
if (ds.Tables[0].Rows.Count > 0)
{
emailAddress = ds.Tables[0].Rows[0]["UserEmail"].ToString();
userName = ds.Tables[0].Rows[0]["UserName"].ToString();
userLast = ds.Tables[0].Rows[0]["UserLastName"].ToString();
userFirst = ds.Tables[0].Rows[0]["UserFirstName"].ToString();
if (!string.IsNullOrEmpty(emailAddress))
{
txtTo.Text = emailAddress;
}
}
// Default Admin Mail Address
MailManager m = new MailManager();
txtFrom.Text = m.AdminEmailAddress;
if (Request.QueryString["newUser"] != null && Request.QueryString["newUser"].Equals("yes"))
{
newUserBool.Value = bool.TrueString;
//new user default message
txtSubject.Text = "Caisis Account Information";
txtContent.Value = userFirst + " " + userLast + ",\n\nYour new Caisis account has been created by a system administrator. You may now use the information below to login to the system.\n\n";
txtContent.Value += "UserName: "******"\n";
// if using LDAP
if (UseLDAP)
{
txtContent.Value += "Password: Log in using your network (Windows) password.";
}
// otherwise, normal auth
else
{
txtContent.Value += "Password: "******"\n\n";
txtContent.Value += "Please update this password on your first use of the system. You may do this by clicking the \"Change Your Password\" button on the login page.";
}
}
else
{
// only notify about valid password updates
if (!string.IsNullOrEmpty(pswd))
{
txtSubject.Text = "Password Update";
txtContent.Value = userFirst + " " + userLast + ",\n\nYour Caisis password has been updated by a system administrator.\n\nYour new password is: " + pswd + "\n\n";
txtContent.Value += "Please update this password on your next use of the system. You may do this by clicking the \"Change Your Password\" button on the login page.";
}
}
// append sent date to existing content
if (!string.IsNullOrEmpty(txtSubject.Text))
{
txtContent.Value += "\n\n\nThe Caisis Team";
txtContent.Value += "\n\nMessage Sent: " + System.DateTime.Now.ToShortDateString() + " " + System.DateTime.Now.ToShortTimeString();
}
}
}
protected override void Page_Load(object sender, EventArgs e)
{
// set dataset message
if (!hasInstitutionDataset)
{
NewPatientInstitution.Visible = true;
}
if (!Page.IsPostBack)
{
int protocolId = int.Parse(BaseProtocolId);
// Get an auto-generate screening id
ScreeningID.Value = PatientProtocolController.GenerateScreeningId().ToString();
// study id
string autoStudyId = PatientProtocolController.GenerateStudyId(protocolId);
StudyID.Value = autoStudyId;
bool calculateStudyIdBySite = ProtocolMgmtUtil.GenerateStudyIdByOrganization();
// custom auto-generation
if (calculateStudyIdBySite)
{
OrganizationStudyIds.Visible = true;
StudyIdTooltip.Attributes["title"] = "An Id created to identify a patient on a study in the form: Site Id (2 digits) + Protocol Id (3 digits) + Incremental Patient Id (3 digits)";
// get associated Project (to select organizations)
Protocol protocol = new Protocol();
protocol.Get(protocolId);
string protocolNum = protocol[Protocol.ProtocolNum].ToString();
// get a list of associated organizations
if (!protocol.IsNull(Protocol.ProjectId) && !string.IsNullOrEmpty(protocolNum))
{
ProjectManagementDa da = new ProjectManagementDa();
int projectId = (int)protocol[Protocol.ProjectId];
// get a list of organizations associated with project
var projectOrganizations = BusinessObject.GetByFields <Project_ProjectOrganization>(new Dictionary <string, object> {
{ Project_ProjectOrganization.ProjectId, projectId }
});
// get a list of user's organizations
int userId = new UserController().GetUserId();
DataTable userOrganizations = new UserDa().GetUserOrganizations(userId);
var userOrganizationIds = userOrganizations.AsEnumerable().Select(r => (int)r["OrganizationId"]);
// get the intersect of user's sites and lead sites
var userLeadSites = from po in projectOrganizations
let organizationType = po["OrganizationType"].ToString()
let organizationId = (int)po[Project_ProjectOrganization.OrganizationId]
where organizationType.Contains("Lead Site")
join userOrgId in userOrganizationIds on organizationId equals userOrgId
select userOrgId;
// if user is part of a lead site, allow to select organization
if (userLeadSites.Count() > 0)
{
// TODO: centralize call to get project organizations
var organizations = da.GetAllOrganizationsByProjectId(projectId);
// get a list of organizations and calculate study id per organization
var organizationToStudyId = from row in organizations.AsEnumerable()
let orgName = row["Name"].ToString()
let orgId = (int)row["OrganizationId"]
let isAssociated = userOrganizationIds.Contains(orgId) ? 0 : 1
orderby
//isAssociated ascending,
orgName ascending
select new
{
OrganizationName = orgName,
OrganizationId = orgId,
OrganizationStudyId = GenerateStudyIdByOrganization(protocolId, protocolNum, orgId)
};
OrganizationStudyIds.DataSource = organizationToStudyId;
OrganizationStudyIds.DataBind();
// a list of insitutions where institution = organization in project
var allInstitutions = from inst in BOL.BusinessObject.GetAll <Institution>()
let institutionId = (int)inst[BOL.Institution.InstitutionId]
let institutionName = inst[BOL.Institution.Institution_Field].ToString()
select new
{
InstitutionId = institutionId,
Institution = institutionName
};
var orgs = from org in userOrganizations.AsEnumerable()
select new
{
Name = org["Name"].ToString(),
ShortName = org["ShortName"].ToString()
};
// get institution where name matches an organization's name or short name
var institutions = from inst in allInstitutions
let institutionName = inst.Institution
let organization = orgs.Where(org => org.Name == institutionName || org.ShortName == institutionName).FirstOrDefault()
where organization != null
select new
{
Text = organization.Name,
Value = inst.InstitutionId
};
// build institutions
NewPatientInstitutionSelect.DataSource = institutions;
NewPatientInstitutionSelect.DataBind();
// set default study id: user's organization
// get user's site
int userLeadSiteId = userLeadSites.First();
// get study id for user's site
var userSites = organizationToStudyId.Where(o => o.OrganizationId == userLeadSiteId);
autoStudyId = userSites.Count() == 1 ? userSites.First().OrganizationStudyId : "";
// update field and select
OrganizationStudyIds.Value = autoStudyId;
StudyID.Value = autoStudyId;
}
// show a list of all user's organizations
else
{
if (userOrganizations.Rows.Count > 0)
{
string organizationName = userOrganizations.Rows[0]["Name"].ToString();
int organizationId = (int)userOrganizations.Rows[0]["OrganizationId"];
// a list of orgaizations associated with the project
var organizations = from o in userOrganizations.AsEnumerable()
let orgId = (int)o["OrganizationId"]
select
new
{
OrganizationName = o["Name"].ToString(),
OrganizationId = orgId,
OrganizationStudyId = GenerateStudyIdByOrganization(protocolId, protocolNum, orgId)
};
// a list of insitutions where institution = organization in project
var allInstitutions = from inst in BOL.BusinessObject.GetAll <Institution>()
let institutionId = (int)inst[BOL.Institution.InstitutionId]
let institutionName = inst[BOL.Institution.Institution_Field].ToString()
select new
{
InstitutionId = institutionId,
Institution = institutionName
};
var orgs = from org in userOrganizations.AsEnumerable()
select new
{
Name = org["Name"].ToString(),
ShortName = org["ShortName"].ToString()
};
// get institution where name matches an organization's name or short name
var institutions = from inst in allInstitutions
let institutionName = inst.Institution
let organization = orgs.Where(org => org.Name == institutionName || org.ShortName == institutionName).FirstOrDefault()
where organization != null
select new
{
Text = organization.Name,
Value = inst.InstitutionId
};
// build organizations
OrganizationStudyIds.DataSource = organizations;
OrganizationStudyIds.DataBind();
// build institutions
NewPatientInstitutionSelect.DataSource = institutions;
NewPatientInstitutionSelect.DataBind();
autoStudyId = organizations.Count() == 1? organizations.First().OrganizationStudyId : "";
OrganizationStudyIds.Value = autoStudyId;
//OrganizationStudyIds.Enabled = false;
StudyID.Value = autoStudyId;
}
}
}
if (string.IsNullOrEmpty(autoStudyId))
{
StudyIdError.Visible = true;
}
}
// default screeing date
//ScreeningDate.Value = DateTime.Today.ToShortDateString();
PopulatePhysicians();
// set search by particpant id type
SeachTypeParticipantID.Text = PROTOCOL_PARTICIPANT_ID_CODE;
// default participant id field
ParticipantIdField.Text = GetNextParticipantId();
// default radios and panel which can be seen by user
DetermineUserSearchAccess();
}
}
public List <User> GetUserAll()
{
return(UserDa.GetUserAll());
}
public static bool ResetPassword(string email, string token, string password)
{
var result = new UserDa().ResetPassword(email, token, password);
return(result);
}
public bool create(User user)
{
UserDa userDa = new UserDa();
return(userDa.create(user));
}
public List <UserRole> GetUserRole(string user, string bu)
{
return(UserDa.GetUserRole(user, null, bu));
}
protected void PrintingCompleteClick(object sender, EventArgs e)
{
DataView dv = new DataView(GetSelectedPatients());
dv.RowFilter = "Mail = 1";
int count = 0;
foreach (DataRowView drv in dv)
{
// set patient status and create action items for either Letter1_Sent, Letter2_Sent, or Letter3_Sent
ActionDa actionDa = new ActionDa();
BOL.Action actionObj = new Caisis.BOL.Action();
Patient ptObj = new Patient();
ptObj.Get(Int32.Parse(drv[BOL.Patient.PatientId].ToString()));
if (!ptObj.IsEmpty)
{
if (ptObj[Patient.PtContactStatus].ToString() == "NeedLetter1")
{
ptObj[Patient.PtContactStatus] = "Letter1_Sent";
actionObj[BOL.Action.ActionItem] = "Letter1_Sent";
}
else if (ptObj[Patient.PtContactStatus].ToString() == "NeedLetter2")
{
ptObj[Patient.PtContactStatus] = "Letter2_Sent";
actionObj[BOL.Action.ActionItem] = "Letter2_Sent";
}
else if (ptObj[Patient.PtContactStatus].ToString() == "NeedLetter3")
{
ptObj[Patient.PtContactStatus] = "Letter3_Sent";
actionObj[BOL.Action.ActionItem] = "Letter3_Sent";
}
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj[Patient.UpdatedTime] = DateTime.Today;
ptObj.Save();
actionObj[BOL.Action.PatientId] = Int32.Parse(drv[BOL.Patient.PatientId].ToString());
actionObj[BOL.Action.ActionDateText] = DateTime.Today.ToShortDateString();
actionObj[BOL.Action.ActionDate] = DateTime.Today;
actionObj[BOL.Action.EnteredBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
actionObj[BOL.Action.EnteredTime] = DateTime.Now;
actionObj.Save();
count++;
}
}
if (count > 0)
{
Option2RB.Checked = false;
Option2RB.Enabled = false;
Option2Title.Text = "No packages to print.";
Option2Title.ForeColor = System.Drawing.Color.Gray;
Option2ResultDiv.Style["display"] = "none";
Option2Details.Text = String.Empty;
RemovePatientFromNeedLetterList(dv, "Mail");
}
}
public List <User> GetUserByItCodes(params string[] itcodes)
{
return(UserDa.GetUserByItCode(itcodes));
}
public void UpdateDefaultBu(string itcode, string bu)
{
UserDa.UpdateDefaultBu(itcode, bu);
}
public List <User> GetUser(Guid organ)
{
return(UserDa.GetUser(null, organ, null, null));
}
public static bool InsertUser(string userName, string password, string fullName, string phone, string email)
{
var result = new UserDa().Insert(userName, password, fullName, phone, email);
return(result);
}
public static bool CreateResetPasswordToken(string usermail)
{
var result = new UserDa().CreateResetPasswordToken(usermail);
return(result);
}
protected void Repeater1_ItemCommand(object o, RepeaterCommandEventArgs e)
{
if (Convert.ToString(e.CommandName) == "DataEntered")
{
string currentPatientId = Convert.ToString(e.CommandArgument);
string actionItemCommand = Convert.ToString(e.CommandName);
try
{
HtmlImage DataEnteredImg = (HtmlImage)e.Item.FindControl("DataEnteredImg");
ImageButton DataEnteredBtn = (ImageButton)e.Item.FindControl("DataEnteredBtn");
Label DataEnteredLBL = (Label)e.Item.FindControl("DataEnteredLBL");
DropDownList HipaaDDL = (DropDownList)e.Item.FindControl("HipaaDDL");
Label StatusLBL = (Label)e.Item.FindControl("StatusLBL");
Label StatusPatientId = (Label)e.Item.FindControl("StatusPatientId");
// if hipaa status has been selected
if (!String.IsNullOrEmpty(HipaaDDL.SelectedValue))
{
StatusLBL.Text = String.Empty;
if (DataEnteredBtn != null && DataEnteredImg != null)
{
DataEnteredBtn.Style["display"] = "none";
}
if (!String.IsNullOrEmpty(currentPatientId))
{
// create ActionItem = 'DataEntered' for patients to check
ActionDa actionDa = new ActionDa();
BOL.Action actionObj = new Caisis.BOL.Action();
actionObj[BOL.Action.PatientId] = int.Parse(currentPatientId);
actionObj[BOL.Action.ActionDateText] = DateTime.Today.ToShortDateString();
actionObj[BOL.Action.ActionDate] = DateTime.Today;
actionObj[BOL.Action.ActionItem] = actionItemCommand;
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
actionObj[BOL.Action.EnteredBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
actionObj[BOL.Action.EnteredTime] = DateTime.Today;
actionObj.Save();
// set patient status to 'NeedMD_Contact' if HIPAA = 'Yes"
// set patient status to 'NeedPtAuthorization' if HIPAA = 'No'
Patient ptObj = new Patient();
ptObj.Get(Int32.Parse(currentPatientId));
if (!ptObj.IsEmpty && !String.IsNullOrEmpty(HipaaDDL.SelectedValue))
{
if (HipaaDDL.SelectedValue.ToLower() == "yes")
{
ptObj[Patient.PtContactStatus] = "NeedMD_Contact";
}
else if (HipaaDDL.SelectedValue.ToLower() == "no")
{
ptObj[Patient.PtContactStatus] = "NeedPtAuthorization";
}
ptObj[Patient.UpdatedTime] = DateTime.Today;
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj.Save();
}
if (DataEnteredLBL != null && DataEnteredImg != null)
{
DataEnteredImg.Style["display"] = "";
DataEnteredLBL.Text = actionItemCommand;
}
}
}
else
{
StatusLBL.Text = "<br/>* specify HIPPA authorization";
StatusLBL.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
// publish raw error
ExceptionHandler.Publish(ex);
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
//rGen = new Random();
FormTable.Visible = true;
SentTable.Visible = false;
if (Page.IsPostBack)
{
if (Request.Form["userName"] != null && Request.Form["userName"].ToString().Length > 0)
{
FormTable.Visible = false;
SentTable.Visible = true;
//take username and get password
UserDa da = new UserDa();
DataSet ds = da.GetByUserName(userName.Value);
if (ds.Tables[0].Rows.Count > 0)
{
string userStatus = da.GetUserStatus(userName.Value);
if (userStatus.Equals("Valid"))
{
string userEmail = ds.Tables[0].Rows[0]["UserEmail"].ToString();
string userFirstName = ds.Tables[0].Rows[0]["UserFirstName"].ToString();
string userLastName = ds.Tables[0].Rows[0]["UserLastName"].ToString();
//set new password in database
string newPassword = this.SetRandomPassword(userEmail);
if (!newPassword.Equals("false"))
{
//email new random password
this.EmailNewPassword(userEmail, userFirstName, userLastName, newPassword);
emailMessage.Text = "An email with a new password has been sent to " + userEmail + ".\n\n<br>Please update this password on first login. Thank you.";
}
else
{
//update of password failed
emailMessage.Text = "There was a problem updating your password. Please contact " + CaisisConfiguration.GetWebConfigValue("adminEmail") + " to request a new password.";
}
}
else if (userStatus.Equals("InvalidDeactivated"))
{
//Deactivated user
emailMessage.Text = "User has been deactivated. Please contact " + CaisisConfiguration.GetWebConfigValue("adminEmail") + ".";
}
else
{
//InvalidUnknown. InvalidUsername should never get here because of 'if(ds.Tables[0].Rows.Count > 0)' above.
emailMessage.Text = "There was an unknown problem updating your password. Please contact " + CaisisConfiguration.GetWebConfigValue("adminEmail") + " to request a new password.";
}
}
else
{
emailMessage.Text = "The username you entered does not have an email address on file. Please contact the Administrator to obtain a new password.";
}
ValidationMsg.Visible = false;
}
else
{
ValidationMsg.InnerText = "You must enter your username to request a new password.";
}
}
}
public List <User> GetUserWithBuRole(string bu, int role, string department)
{
return(UserDa.GetUserWithBuRole(bu, role, department));
}
public ActionResult processRegister()
{
VerifyDbContext context = new VerifyDbContext();
//check đã chụp ảnh chưa
string path1 = Server.MapPath(IMAGE_DIR + "RegisterImage1.jpg");
string path2 = Server.MapPath(IMAGE_DIR + "RegisterImage2.jpg");
string path3 = Server.MapPath(IMAGE_DIR + "RegisterImage3.jpg");
string dir1 = Directory.GetParent(path1).FullName;
string dir2 = Directory.GetParent(path2).FullName;
string dir3 = Directory.GetParent(path3).FullName;
if (!System.IO.File.Exists(path1) && !System.IO.File.Exists(path2) && !System.IO.File.Exists(path3))
{
TempData["error"] = "Bạn chưa chụp ảnh";
return(RedirectToAction("Register", "Login"));
}
else
{
NameValueCollection form = Request.Form;
string fullName = "", email = "", personId = "";
string sex;
fullName = form["fullName"];
email = form["email"];
sex = form["optradio"];
Debug.WriteLine(fullName + email + sex);
//Goi hàm kiểm tra email đã tồn tại checkEmail(email); trả về true nếu đã tồn tại trong database
var userDa = new UserDa();
var verificationDa = new VerificationDa();
if (userDa.HasMailExisted(email))
{
TempData["error"] = "Email " + email + " đã được sử dụng để đăng ký trước đây";
return(RedirectToAction("Register", "Login"));
}
else
{
try
{
Debug.WriteLine(1);
//Tao mới person
var request =
(HttpWebRequest)
WebRequest.Create(
"https://api.projectoxford.ai/face/v1.0/persongroups/open_source_net1/persons");
var postData = "{\"name\":\"" + email + "\",\"userData\":\"user-provided data attached to the person group\"}";
//var imgBinary = File.ReadAllBytes(_imgPath1);
byte[] byteData = Encoding.UTF8.GetBytes(postData);
//var data = Encoding.ASCII.GetBytes(postData);
request.Method = "POST";
request.ContentType = "application/json";
request.ContentLength = byteData.Length;
request.Host = "api.projectoxford.ai";
request.Headers.Add("Ocp-Apim-Subscription-Key", "1c056c36ece84f14a0619803ee4f0ceb");
using (var stream = request.GetRequestStream())
{
stream.Write(byteData, 0, byteData.Length);
}
var response = (HttpWebResponse)request.GetResponse();
var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();
string json = responseString.ToString();
dynamic stuff = JObject.Parse(json);
personId = stuff.personId;
//Vi - TODO: goi ham luu person moi vao database addPerson(fullName, email, personId);
var addedUser = userDa.Add(new User {
Email = email, Gender = sex, Name = fullName, PersonId = personId
});
int userID = addedUser.Id;
//add ảnh vào person
if (Directory.Exists(dir1))
{
Debug.WriteLine(2);
var request1 =
(HttpWebRequest)
WebRequest.Create(
"https://api.projectoxford.ai/face/v1.0/persongroups/open_source_net1/persons/" + personId + "/persistedFaces");
Debug.WriteLine(path1);
var imgBinary = System.IO.File.ReadAllBytes(path1);
request1.Method = "POST";
request1.ContentType = "application/octet-stream";
request1.ContentLength = imgBinary.Length;
request1.Host = "api.projectoxford.ai";
request1.Headers.Add("Ocp-Apim-Subscription-Key", "1c056c36ece84f14a0619803ee4f0ceb");
using (var stream = request1.GetRequestStream())
{
stream.Write(imgBinary, 0, imgBinary.Length);
}
var response1 = (HttpWebResponse)request1.GetResponse();
responseString = new StreamReader(response1.GetResponseStream()).ReadToEnd();
json = responseString.ToString();
Debug.WriteLine(json);
stuff = JObject.Parse(json);
string persistedFaceId = stuff.persistedFaceId;
Debug.WriteLine(persistedFaceId);
//addIdentification(userId, persistedFaceId)
verificationDa.Add(new Verification {
PersistedFaceId = persistedFaceId, UserId = userID
});
}
if (System.IO.File.Exists(path2))
{
Debug.WriteLine(Directory.Exists(dir2));
var request1 =
(HttpWebRequest)
WebRequest.Create(
"https://api.projectoxford.ai/face/v1.0/persongroups/open_source_net1/persons/" + personId + "/persistedFaces");
var imgBinary = System.IO.File.ReadAllBytes(path2);
request1.Method = "POST";
request1.ContentType = "application/octet-stream";
request1.ContentLength = imgBinary.Length;
request1.Host = "api.projectoxford.ai";
request1.Headers.Add("Ocp-Apim-Subscription-Key", "1c056c36ece84f14a0619803ee4f0ceb");
using (var stream = request1.GetRequestStream())
{
stream.Write(imgBinary, 0, imgBinary.Length);
}
var response1 = (HttpWebResponse)request1.GetResponse();
responseString = new StreamReader(response1.GetResponseStream()).ReadToEnd();
json = responseString.ToString();
stuff = JObject.Parse(json);
string persistedFaceId = stuff.persistedFaceId;
Debug.WriteLine(persistedFaceId);
//addIdentification(userId, persistedFaceId)
verificationDa.Add(new Verification {
PersistedFaceId = persistedFaceId, UserId = userID
});
}
if (System.IO.File.Exists(path3))
{
Debug.WriteLine(4);
var request1 =
(HttpWebRequest)
WebRequest.Create(
"https://api.projectoxford.ai/face/v1.0/persongroups/open_source_net1/persons/" + personId + "/persistedFaces");
var imgBinary = System.IO.File.ReadAllBytes(path3);
request1.Method = "POST";
request1.ContentType = "application/octet-stream";
request1.ContentLength = imgBinary.Length;
request1.Host = "api.projectoxford.ai";
request1.Headers.Add("Ocp-Apim-Subscription-Key", "1c056c36ece84f14a0619803ee4f0ceb");
using (var stream = request1.GetRequestStream())
{
stream.Write(imgBinary, 0, imgBinary.Length);
}
var response1 = (HttpWebResponse)request1.GetResponse();
responseString = new StreamReader(response1.GetResponseStream()).ReadToEnd();
json = responseString.ToString();
stuff = JObject.Parse(json);
string persistedFaceId = stuff.persistedFaceId;
Debug.WriteLine(persistedFaceId);
//addIdentification(userId, persistedFaceId)
verificationDa.Add(new Verification {
PersistedFaceId = persistedFaceId, UserId = userID
});
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
Debug.WriteLine(ex.Message);
TempData["error"] = "Xảy ra lỗi trong quá trình giao tiếp với API, bạn vui long tiến hành đăng ký lại";
return(RedirectToAction("Register", "Login"));
}
}
}
return(RedirectToAction("Index", "Login"));
}
protected void NeedMDContactClick(object sender, EventArgs e)
{
if (PatientId != 0)
{
// create ActionItem = 'DataReceived'
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
bool actionAlreadyExists = false;
ActionDa actionDa = new ActionDa();
DataSet actionDs = actionDa.ValidateActionItem(PatientId, "DataReceived");
if (actionDs.Tables.Count > 0)
{
DataView actionDv = new DataView(actionDs.Tables[0]);
actionDv.RowFilter = BOL.Action.ActionDateText + " = '" + DateTime.Today.ToShortDateString() + "' AND " + BOL.Action.ActionItem + " = 'DataReceived' ";
if (actionDv.Count > 0)
{
actionAlreadyExists = true;
}
}
// if action item does not already exist for today
if (!actionAlreadyExists)
{
BOL.Action actionObj = new Caisis.BOL.Action();
actionObj[BOL.Action.PatientId] = PatientId;
actionObj[BOL.Action.ActionDateText] = DateTime.Today.ToShortDateString();
actionObj[BOL.Action.ActionDate] = DateTime.Today;
actionObj[BOL.Action.ActionItem] = "DataReceived";
actionObj[BOL.Action.EnteredBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
actionObj[BOL.Action.EnteredTime] = DateTime.Today;
actionObj.Save();
}
// set patient status to 'NeedMD_ToCallPt'
Patient ptObj = new Patient();
ptObj.Get(PatientId);
if (!ptObj.IsEmpty)
{
ptObj[Patient.PtContactStatus] = "NeedMD_ToCallPt";
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj[Patient.UpdatedTime] = DateTime.Now;
ptObj.Save();
if (AddressUpdatedLBL != null && AddressUpdatedImg != null)
{
AddressUpdatedImg.Style["display"] = "none";
AddressUpdatedLBL.Text = String.Empty;
}
if (NeedMDContactLBL != null && NeedMDContactImg != null)
{
NeedMDContactImg.Style["display"] = "";
NeedMDContactLBL.Text = "Pt Status: " + ptObj[Patient.PtContactStatus].ToString();
}
}
}
//Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "_reloadMainPage", "reloadMainPage(); ", true);
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (Request.QueryString["toUser"] != null && Request.QueryString["toUser"].ToString() != "")
{
toUserName = Request.QueryString["toUser"].ToString();
// emails regarding datafeed records are sent to the admin
if (toUserName.ToUpper().StartsWith("DATAFEED"))
{
toUserEmail = CaisisConfiguration.GetWebConfigValue("adminEmail");
txtTo.Text = "Caisis Administrators";
txtTo.ReadOnly = true;
noToEmail = false;
toDataFeed = true;
}
else
{
UserDa toUser = new UserDa();
DataSet toUserDs = toUser.GetByUserName(toUserName);
//populate to address
if (toUserDs.Tables[0].Rows.Count > 0)
{
bool activeUser = false;
if ((toUserDs.Tables[0].Rows[0][BOL.User.DeactivatedTime] == null) || (toUserDs.Tables[0].Rows[0][BOL.User.DeactivatedTime].ToString().Length < 1))
{
activeUser = true;
}
else
{
deactivatedToUser = true;
}
string emailAddress = toUserDs.Tables[0].Rows[0]["UserEmail"].ToString();
toFirstName = toUserDs.Tables[0].Rows[0]["UserFirstName"].ToString();
toLastName = toUserDs.Tables[0].Rows[0]["UserLastName"].ToString();
if (emailAddress == null || emailAddress.Equals(""))
{
noToEmail = true;
}
if (activeUser == true && noToEmail == false)
{
toUserEmail = emailAddress;
txtTo.Text = toFirstName + " " + toLastName + " (email not shown)";
txtTo.ReadOnly = true;
}
else if (deactivatedToUser)
{
toUserEmail = CaisisConfiguration.GetWebConfigValue("adminEmail");
txtTo.Text = "Caisis Administrator";
txtTo.ReadOnly = true;
}
else if (noToEmail)// active but no email address
{
toUserEmail = CaisisConfiguration.GetWebConfigValue("adminEmail");
txtTo.Text = "Caisis Administrator";
txtTo.ReadOnly = true;
}
}
// no user identified
else
{
toUserEmail = CaisisConfiguration.GetWebConfigValue("adminEmail");
noToEmail = true;
}
}
}
txtSubject.Text = "Locked Record in Caisis";
MailForm.Visible = true;
sentMessageTable.Visible = false;
if (Page.IsPostBack)
{
this.btnSend_Click(sender, e);
MailForm.Visible = false;
sentMessageTable.Visible = true;
}
else
{
UserDa user = new UserDa();
DataSet ds = user.GetByUserName(User.Identity.Name);
//populate from address
if (ds.Tables[0].Rows.Count > 0)
{
string emailAddress = ds.Tables[0].Rows[0]["UserEmail"].ToString();
fromFName.Value = ds.Tables[0].Rows[0]["UserFirstName"].ToString();
fromLName.Value = ds.Tables[0].Rows[0]["UserLastName"].ToString();
if (emailAddress != null && !emailAddress.Equals(""))
{
txtFrom.Text = emailAddress;
txtFrom.ReadOnly = true;
}
}
}
}
protected void Repeater1_ItemCommand(object o, RepeaterCommandEventArgs e)
{
if (Convert.ToString(e.CommandName) == "TumorRegistryChecked")
{
string currentPatientId = Convert.ToString(e.CommandArgument);
string actionItemCommand = Convert.ToString(e.CommandName);
try
{
HtmlImage TumorRegCheckedImg = (HtmlImage)e.Item.FindControl("TumorRegCheckedImg");
ImageButton TumorRegCheckedBtn = (ImageButton)e.Item.FindControl("TumorRegCheckedBtn");
Label TumorRegCheckedLBL = (Label)e.Item.FindControl("TumorRegCheckedLBL");
DropDownList StatusDDL = (DropDownList)e.Item.FindControl("StatusDDL");
Label StatusLBL = (Label)e.Item.FindControl("StatusLBL");
Label StatusPatientId = (Label)e.Item.FindControl("StatusPatientId");
if (TumorRegCheckedBtn != null && TumorRegCheckedImg != null)
{
TumorRegCheckedBtn.Style["display"] = "none";
}
if (!String.IsNullOrEmpty(currentPatientId))
{
// create ActionItem = 'TumorRegistryChecked' for patients to check
ActionDa actionDa = new ActionDa();
BOL.Action actionObj = new Caisis.BOL.Action();
actionObj[BOL.Action.PatientId] = int.Parse(currentPatientId);
actionObj[BOL.Action.ActionDateText] = DateTime.Today.ToShortDateString();
actionObj[BOL.Action.ActionDate] = DateTime.Today;
actionObj[BOL.Action.ActionItem] = actionItemCommand;
UserController userCt = new UserController();
int currentUserId = userCt.GetUserId();
UserDa currentUserDa = new UserDa();
DataSet currentUserDs = currentUserDa.GetByUserId(userCt.GetUserId());
actionObj[BOL.Action.EnteredBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
actionObj[BOL.Action.EnteredTime] = DateTime.Today;
actionObj.Save();
// set patient status to 'Current'
Patient ptObj = new Patient();
ptObj.Get(Int32.Parse(currentPatientId));
if (!ptObj.IsEmpty)
{
ptObj[Patient.PtContactStatus] = "Current";
ptObj[Patient.UpdatedTime] = DateTime.Today;
ptObj[Patient.UpdatedBy] = (currentUserDs.Tables.Count > 0 && currentUserDs.Tables[0].Rows.Count > 0) ? currentUserDs.Tables[0].Rows[0][BOL.User.UserName].ToString() : "not specified";
ptObj.Save();
}
if (TumorRegCheckedLBL != null && TumorRegCheckedImg != null)
{
TumorRegCheckedImg.Style["display"] = "";
TumorRegCheckedLBL.Text = actionItemCommand;
}
// show status options
if (StatusDDL != null && StatusLBL != null)
{
StatusDDL.Style["display"] = "";
StatusDDL.Width = Unit.Pixel(150);
StatusLBL.Style["display"] = "none";
ptObj.Get(Int32.Parse(StatusPatientId.Text));
if (!ptObj.IsEmpty)
{
ListItem statusLi = new ListItem(ptObj[Patient.PtContactStatus].ToString(), ptObj[Patient.PtContactStatus].ToString());
if (StatusDDL.Items.Contains(statusLi))
{
StatusDDL.SelectedValue = statusLi.Value;
}
else
{
StatusDDL.SelectedValue = "Current";
}
}
}
}
}
catch (Exception ex)
{
// publish raw error
ExceptionHandler.Publish(ex);
}
}
}
protected void SetReferralMDList()
{
XmlNode configNode = CaisisConfiguration.GetEFormNode(this.EFormName);
if (configNode != null)
{
XmlAttribute att = configNode.Attributes["enableReferrals"];
if (att != null)
{
bool doEnable = bool.Parse(att.Value);
if (doEnable)
{
referToPanelContainer.Visible = true;
//UserDa uDa = new UserDa();
//DataTable uDt = uDa.GetUsersByAttributeValue("EForm Referee", "true");
//DataView uDv = uDt.DefaultView;
//uDv.Sort = BOL.User.UserLastName + " ASC";
//AppointmentDa da = new AppointmentDa();
//DataTable dt = da.GetUsersWithAppointments();
//DataView uDv = dt.DefaultView;
AppointmentDa da = new AppointmentDa();
DataTable dt = da.GetUsersWithAppointments();
List <string> UsersWithAppointments = (from row in dt.AsEnumerable()
select row.Field <string>(BOL.User.UserName)).ToList <string>();
// add referral recipients
DataTable uDt = ReferralRecipientsToGetLimitedData();
List <string> RECIPIENTS_TO_GET_LIMITED_DATA = (from row in uDt.AsEnumerable()
select row.Field <string>(BOL.User.UserName)).ToList <string>();
UserDa userDa = new UserDa();
foreach (string refUserName in RECIPIENTS_TO_GET_LIMITED_DATA)
{
// check if user is already in list
if (!UsersWithAppointments.Contains(refUserName))
{
// include the "additional" users in list even if they don't have appointments
DataTable userDt = userDa.GetByUserName(refUserName).Tables[0];
if (userDt.Rows.Count > 0)
{
dt.Rows.Add(userDt.Rows[0].ItemArray);
}
}
}
DataView uDv = dt.DefaultView;
uDv.Sort = "UserLastName ASC";
if (uDv.Count > 0)
{
NoEFormReferees.Visible = false;
ReferToRptr.DataSource = uDv;
ReferToRptr.DataBind();
}
}
}
}
}
public User GetUserByItCode(string itcode)
{
return(UserDa.GetUserByItCode(itcode));
}
