/// <summary>
		/// Obtains a set of interpretation steps that are candidates for linked reporting to the specified interpretation step.
		/// </summary>
		/// <param name="step"></param>
		/// <param name="author"></param>
		/// <returns></returns>
		public IList<ProtocolAssignmentStep> GetLinkedProtocolCandidates(ProtocolAssignmentStep step, Staff author)
		{
			var q = this.GetNamedHqlQuery("linkedProtocolCandidates");
			q.SetParameter(0, step);
			q.SetParameter(1, author);
			return q.List<ProtocolAssignmentStep>();
		}

        public ActionResult AddStaff(Staff t)
        {
            User search = db.Users.Where(x => x.EMail == t.EMail).FirstOrDefault();

            if (ModelState.IsValid && search == null)
            {
                t.HireDate = DateTime.Now;
                db.Staffs.Add(t);
                db.SaveChanges();

                User u = new User();
                u.EMail = t.EMail;
                u.FirstName = t.FirstName;
                u.LastName = t.LastName;
                u.Password = t.Password;
                u.Role = "Staff";

                db.Users.Add(u);
                db.SaveChanges();
                TempData["Success"] = u.FirstName + " " + u.LastName + " added successfully.";
                return RedirectToAction("ManageStaff", "Manager");

            }
            if (search != null)
                TempData["Error"] = search.EMail + " is already registered to the system.";
            return View();
        }

 public void AddStaff(Staff staff)
 {
     try
     {
         if (staff != null)
         {
             if (!this.staffNode.ContainsKey(staff.Uid))
             {
                 SelfDepartmentStaffNode node = new SelfDepartmentStaffNode(staff);
                 node.SessionService = this.sessionService;
                 node.DataService = this.dataService;
                 if (!this.staffNode.ContainsKey(staff.Uid))
                 {
                     this.staffNode.Add(staff.Uid, node);
                     base.Items.Add(node);
                     node.ContextMenu = this.GetContextMenu(node);
                     node.ContextMenuOpening += delegate(object s, ContextMenuEventArgs e)
                     {
                         if (DataModel.Instance.CustomeGroupName.Count > 0)
                         {
                             this.AddContextMenu(node, s);
                         }
                     };
                 }
             }
         }
     }
     catch (System.Exception ex)
     {
         this.logger.Error(ex.ToString());
     }
 }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string ID = e.CommandArgument.ToString().Trim();
        if (e.CommandName == "CustomDelete")
        {
            string userName;

            Staff objStaff = DataRepository.StaffProvider.GetById(int.Parse("0"+ID));
            userName = objStaff.UserName;

            TList<Appointment> listAppointmentDoctor = DataRepository.AppointmentProvider.GetByDoctorUsername(userName);
            TList<Appointment> listAppointmentNurse = DataRepository.AppointmentProvider.GetByNurseUsername(userName);
            TList<DoctorRoom> listDoctorRoom = DataRepository.DoctorRoomProvider.GetByDoctorUserName(userName);
            TList<DoctorFunc> listDoctorFunc = DataRepository.DoctorFuncProvider.GetByDoctorUserName(userName);
            TList<DoctorRoster> listDoctorRoster = DataRepository.DoctorRosterProvider.GetByDoctorUserName(userName);
            if (listAppointmentDoctor.Count > 0 || listAppointmentNurse.Count > 0 || listDoctorRoom.Count > 0 || listDoctorFunc.Count > 0 || listDoctorRoster.Count > 0)
            {
                Response.Write(@"<script language='javascript'>alert('Vui lòng xóa tất cả chi tiết.')</script>");

            }
            else
            {
                objStaff = new Staff();
                objStaff.Id = int.Parse(ID);
                DataRepository.StaffProvider.Delete(objStaff);
            }
            GridView1.DataBind();
        }
    }

 public JsonResult Get(int page, int pageSize)
 {
     JsonResult result = new JsonResult();
     Staff bll = new Staff();
     var t = bll.FindByPage(pageSize, page);
     return Json(t, JsonRequestBehavior.AllowGet);
 }

    protected void SearchData()
    {
        String dat = txt_contractStartDate.Text;
        //String tim = txt_happen_Time.Text;

        Staff _operator = new Staff("Company");
        string condition = " WHERE 1=1";
        if (txt_Query_Reason.Text != "") 
        {
            condition += " AND MaterialName  like '%" + txt_Query_Reason.Text.Trim() + "%' ";
        }
        if (dat != "" ) 
        {
            condition += " AND (RelnventoryDate BETWEEN '" + dat + " 00:00:00' AND '" + dat + " 23:59:59')";
        }
        //condition += query_company;
        DataSet ds = _operator.SelectSQL("SELECT *  FROM [MROS].[dbo].[ICS_ReInventory] " + condition + " ORDER BY  [RelnventoryDate] DESC ");
        Session["DS_INT"] = ds;
        if (ds.Tables[0].Rows.Count == 0)
        {
            ShowMsg2(UpdatePanel1, "查詢無資料");
        }
       
            gv.DataSource = ds;
            gv.DataBind();
        
    }

    protected void SearchData()
    {
        gv_stockOutitem.DataSource = null;
        gv_stockOutitem.DataBind();

        lbl_stockitem.Visible = false;
        //string query_company = GetCompanyScope();
        Staff _operator = new Staff("View_ICS_StockOut_Record");
        string conditionName = ddlst_SearchType.SelectedValue;
        StringBuilder  condition = new StringBuilder(txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' AND " : "");
        //condition += query_company;
        if (txt_startDateTime.Text.Length > 0 )
        {
            condition.Append("  StockOutDate >= '" + txt_startDateTime.Text + "'  ");
        }
        if (txt_endDateTime.Text.Length > 0)
        {
            condition.Append("and StockOutDate <= '" + txt_endDateTime.Text + "' ");
        }
        DataSet ds = _operator.Select(condition.ToString(), "StockOutDate desc");
        //Session["DS_MIS"] = ds;
        gv.DataSource = ds;
        gv.DataBind();

        if (ds.Tables[0].Rows.Count == 0)
        {
            lbl_stockitem.Visible = true;
            lbl_stockitem.Text = "查詢無資料";
        }
    }

 public void SaveInfo(Staff staff)
 {
     try
     {
         staff.Email = this.tbxEmail.Text;
         staff.Mobile = this.tbxMobile.Text;
         staff.MyDescription = this.tbxMyDescription.Text;
         staff.MyHome = this.tbxMyHome.Text;
         staff.Telephone = this.tbxPhone.Text;
         staff.School = this.tbxSchool.Text;
         staff.Job = this.cbxProfessional.Text;
         staff.Extension = this.tbxExtension.Text;
         string temp = this.cbxShowScope.Text;
         if (temp == "公开")
         {
             staff.ShowScope = 1;
         }
         else
         {
             if (temp == "保密")
             {
                 staff.ShowScope = 2;
             }
         }
     }
     catch (System.Exception e)
     {
         ServiceUtil.Instance.Logger.Error(e.ToString());
     }
 }

    private void AddSubNodes(Microsoft.Web.UI.WebControls.TreeNode currentNode, RoleType currentRoleType, Staff s)
    {
        //增加子角色分类
        foreach (RoleType rt in currentRoleType.SubRoleTypes)
        {
            Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
            currentNode.Nodes.Add(node);
            node.Type = "roletype";
            node.Text = rt.Name;
            node.PKId = rt.Id;

            AddSubNodes(node, rt, s);

            node.Expanded = true;
        }

        //增加角色
        foreach (Role r in currentRoleType.Roles)
        {
            Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
            currentNode.Nodes.Add(node);
            node.Type = "role";
            node.Text = r.Name;
            node.PKId = r.Id;
            node.CheckBox = true;
            node.Checked = s.Roles.Contains(r);
        }
    }

			public void Execute(InterpretationStep step, Staff executingStaff, List<InterpretationStep> linkInterpretations, IWorkflow workflow)
			{
				// if not assigned, assign
				if (step.AssignedStaff == null)
				{
					step.Assign(executingStaff);
				}

				// put in-progress
				step.Start(executingStaff);

				// if a report has not yet been created for this step, create now
				if (step.ReportPart == null)
				{
					var report = new Report(step.Procedure);
					var reportPart = report.ActivePart;

					workflow.AddEntity(report);

					step.ReportPart = reportPart;
					step.ReportPart.Interpreter = executingStaff;
				}

				// attach linked interpretations to this report
				foreach (var interpretation in linkInterpretations)
				{
					interpretation.LinkTo(step);
				}
			}

 public void UpdateMember(Staff staff)
 {
     for (int i = 0; i < this.lstBoxFrom.Items.Count; i++)
     {
         Staff staffNew = (this.lstBoxFrom.Items[i] as CustomMemberItem).DataContext as Staff;
         if (staffNew != null && staff.Uid == staffNew.Uid)
         {
             this.lstBoxFrom.Items.RemoveAt(i);
             CustomMemberItem item = new CustomMemberItem(CustomMemberType.Add);
             item.DataContext = staff;
             item.imgHead.Source = staff.HeaderImage;
             item.tbkAccount.Text = staff.Name;
             item.ItemAdd += new System.EventHandler(this.item_ItemAdd);
             this.lstBoxFrom.Items.Insert(i, item);
             break;
         }
     }
     for (int i = 0; i < this.lstBoxTo.Items.Count; i++)
     {
         Staff staffNew = (this.lstBoxTo.Items[i] as CustomMemberItem).DataContext as Staff;
         if (staffNew != null && staff.Uid == staffNew.Uid)
         {
             this.lstBoxTo.Items.RemoveAt(i);
             CustomMemberItem item = new CustomMemberItem(CustomMemberType.Add);
             item.DataContext = staff;
             item.imgHead.Source = staff.HeaderImage;
             item.tbkAccount.Text = staff.Name;
             item.ItemAdd += new System.EventHandler(this.item_ItemAdd);
             this.lstBoxTo.Items.Insert(i, item);
             break;
         }
     }
 }

 public static Waypoint[] FindPracticeWaypoints(Staff staff)
 {
     Waypoint desk = null;
     List<Waypoint> availableWaypoints = new List<Waypoint>();
     foreach(Waypoint point in FindObjectsOfType(typeof(Waypoint)))
     {
         if(point.action == Waypoint.Action.practice && point.owner == staff)
         {
             desk = point;
         }
         if(point.action == Waypoint.Action.practiceAction)
         {
             availableWaypoints.Add (point);
         }
     }
     if(desk)
     {
         availableWaypoints.Add (desk);
     }
     availableWaypoints.Shuffle();
     Waypoint[] waypoints;
     waypoints = availableWaypoints.ToArray ();
     if(waypoints.Length >= 1)
     {
         waypoints[0] = desk;  // always puts the desk to the front of the array so the ReturnToDesk() function in the Staff class can actually work.
     }
     return waypoints;
 }

 public Patient(int patient_id, int person_id, DateTime patient_date_added, bool is_clinic_patient, bool is_gp_patient,
     bool is_deleted, bool is_deceased,
     string flashing_text, int flashing_text_added_by, DateTime flashing_text_last_modified_date,
     string private_health_fund, string concession_card_number, DateTime concession_card_expiry_date,
     bool is_diabetic, bool is_member_diabetes_australia, DateTime diabetic_assessment_review_date, int ac_inv_offering_id, int ac_pat_offering_id,
     string login, string pwd,
     bool is_company, string abn,
     string next_of_kin_name, string next_of_kin_relation, string next_of_kin_contact_info)
 {
     this.patient_id                       = patient_id;
     this.person                           = new Person(person_id);
     this.patient_date_added               = patient_date_added;
     this.is_clinic_patient                = is_clinic_patient;
     this.is_gp_patient                    = is_gp_patient;
     this.is_deleted                       = is_deleted;
     this.is_deceased                      = is_deceased;
     this.flashing_text                    = flashing_text;
     this.flashing_text_added_by           = flashing_text_added_by == -1 ? null : new Staff(flashing_text_added_by);
     this.flashing_text_last_modified_date = flashing_text_last_modified_date;
     this.private_health_fund              = private_health_fund;
     this.concession_card_number           = concession_card_number;
     this.concession_card_expiry_date      = concession_card_expiry_date;
     this.is_diabetic                      = is_diabetic;
     this.is_member_diabetes_australia     = is_member_diabetes_australia;
     this.diabetic_assessment_review_date  = diabetic_assessment_review_date;
     this.ac_inv_offering                  = ac_inv_offering_id == -1 ? null : new Offering(ac_inv_offering_id);
     this.ac_pat_offering                  = ac_pat_offering_id == -1 ? null : new Offering(ac_pat_offering_id);
     this.login                            = login;
     this.pwd                              = pwd;
     this.is_company                       = is_company;
     this.abn                              = abn;
     this.next_of_kin_name                 = next_of_kin_name;
     this.next_of_kin_relation             = next_of_kin_relation;
     this.next_of_kin_contact_info         = next_of_kin_contact_info;
 }

 public Invoice(int invoice_id, int entity_id, int invoice_type_id, int booking_id, int payer_organisation_id, int payer_patient_id, int non_booking_invoice_organisation_id, string healthcare_claim_number, int reject_letter_id, string message,
                int staff_id, int site_id, DateTime invoice_date_added, decimal total, decimal gst, decimal receipts_total, decimal vouchers_total, decimal credit_notes_total, decimal refunds_total,
                bool is_paid, bool is_refund, bool is_batched, int reversed_by, DateTime reversed_date, DateTime last_date_emailed)
 {
     this.invoice_id              = invoice_id;
     this.entity_id               = entity_id;
     this.invoice_type            = new IDandDescr(invoice_type_id);
     this.booking                 = booking_id            == -1 ? null : new Booking(booking_id);
     this.payer_organisation      = payer_organisation_id ==  0 ? null : new Organisation(payer_organisation_id);
     this.payer_patient           = payer_patient_id      == -1 ? null : new Patient(payer_patient_id);
     this.non_booking_invoice_organisation = non_booking_invoice_organisation_id == -1 ? null : new Organisation(non_booking_invoice_organisation_id);
     this.healthcare_claim_number = healthcare_claim_number;
     this.reject_letter           = reject_letter_id      == -1 ? null : new Letter(reject_letter_id);
     this.message                 = message;
     this.staff                   = new Staff(staff_id);
     this.site                    = site_id               == -1 ? null : new Site(site_id);
     this.invoice_date_added      = invoice_date_added;
     this.total                   = total;
     this.gst                     = gst;
     this.receipts_total          = receipts_total;
     this.vouchers_total          = vouchers_total;
     this.credit_notes_total      = credit_notes_total;
     this.refunds_total           = refunds_total;
     this.is_paid                 = is_paid;
     this.is_refund               = is_refund;
     this.is_batched              = is_batched;
     this.reversed_by             = reversed_by == -1 ? null : new Staff(reversed_by);
     this.reversed_date           = reversed_date;
     this.last_date_emailed       = last_date_emailed;
 }

    private void AddSubNodes(Microsoft.Web.UI.WebControls.TreeNode currentNode, ModuleType currentModuleType, Staff staff)
    {
        //增加子模块分类
        foreach (ModuleType mt in currentModuleType.SubModuleTypes)
        {
            Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
            currentNode.Nodes.Add(node);
            node.Type = "moduletype";
            node.Text = mt.Name;
            AddSubNodes(node, mt, staff);
            node.Expanded = true;
        }

        //增加模块
        foreach (Module m in currentModuleType.Modules)
        {
            if (staff.IsInnerUser == 1 ||
                ((m.Disabled == 0) && staff.HasGrantPermission(ModuleRightSrv.GetModuleRight(m, "rights_browse"))))
            {
                Microsoft.Web.UI.WebControls.TreeNode node = new Microsoft.Web.UI.WebControls.TreeNode();
                currentNode.Nodes.Add(node);
                node.Type = "module";
                node.Text = m.Name;
                node.Target = "modulePanel";
                if(m.ModuleUrl != null && m.ModuleUrl.Length > 0)
                {
                    node.NavigateUrl = m.ModuleUrl;
                }
                else
                {
                    node.NavigateUrl = "Welcome.aspx";
                }
            }
        }
    }

		/// <summary>
		/// Obtains a set of interpretation steps that are candidates for linked reporting to the specified interpretation step.
		/// </summary>
		/// <param name="step"></param>
		/// <param name="interpreter"></param>
		/// <returns></returns>
		public IList<InterpretationStep> GetLinkedInterpretationCandidates(InterpretationStep step, Staff interpreter)
		{
			var q = this.GetNamedHqlQuery("linkedInterpretationCandidates");
			q.SetParameter(0, step);
			q.SetParameter(1, interpreter);
			return q.List<InterpretationStep>();
		}

    protected void SearchData()
    {
        //string query_company = GetCompanyScope();
        Staff _operator = new Staff("View_DeviceConfig");
        string conditionName = ddlst_SearchType.SelectedValue;
        string condition = "";
        //若查詢日期則把模糊查詢like改為=
        if (conditionName == "ContractStartDate" || conditionName == "ContractEndDate")
        {
            condition = (txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " = '" + txt_Query_Reason.Text.Trim() + "' " : "");
        }
        else
        {
            condition = (txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' " : "");
        }
        DataSet ds = _operator.Select(condition, "", "View_DeviceConfig");
        Session["DS_MIS"] = ds;
        gv.DataSource = ds;
        gv.DataBind();
        if (ds.Tables[0].Rows.Count == 0)
        {
            ShowMsg2(UpdatePanel1, "查詢無資料");
        }
        //for (int i = 0; i < gv.Rows.Count; i++)
        //{
        //    if (gv.Rows[i].Cells[10].Text.Trim().Equals("True"))
        //        gv.Rows[i].Cells[10].Text = "男";
        //    else
        //        gv.Rows[i].Cells[10].Text = "女";

        //}
    }

 public ActionResult Detail()
 {
     var id = Request.QueryString["id"].ToString();
     int sid = 0;
     var num = int.TryParse(id, out sid);
     ViewData["staffDetail"] = new Staff().Find(sid);
     return View();
 }

 public Overpayment(int overpayment_id, int receipt_id, decimal total, DateTime overpayment_date_added, int staff_id)
 {
     this.overpayment_id = overpayment_id;
     this.receipt = new Receipt(receipt_id);
     this.total = total;
     this.overpayment_date_added = overpayment_date_added;
     this.staff = new Staff(staff_id);
 }

 /// <summary>
 /// Save data as XML
 public static void SaveAsXml(Staff data)
 {
     FileStream file = new FileStream(fileName2, FileMode.Create);
     XmlSerializer formatter = new XmlSerializer(typeof(Staff));
     //BinaryFormatter formatter = new BinaryFormatter();
     formatter.Serialize(file, data);
     file.Close();
 }