/// <summary> /// Authes the logon. /// </summary> /// <returns></returns> private bool AuthLogon() { string sql = "StaffNumber = '" + txtUserName.Text.Trim().Replace("'", "") + "' AND Password = '******'", "") + "'"; RT2020.DAL.Staff oStaff = RT2020.DAL.Staff.LoadWhere(sql); if (oStaff != null) { if (oStaff.Status > Convert.ToInt32(RT2020.DAL.Common.Enums.Status.Inactive.ToString("d"))) { if (!oStaff.Retired) { this.Context.Session.IsLoggedOn = AuthShopLogon(); Common.Utility.CurrentUserId = oStaff.StaffId; } else { this.lblErrorMessage.Text = "Staff was retired!"; } } else { this.lblErrorMessage.Text = "Staff is inactivate! Please contact system administrator!"; } } else { // When user inputs incorrect staff number or password, prompt user the error message. // To Do: We can try to limited the times of attempt to 5 or less. this.lblErrorMessage.Text = "Incorrect Staff Number or Password! Please try again!"; this.Context.Session.IsLoggedOn = false; } return(this.Context.Session.IsLoggedOn); }
private string GetStaffName(Guid staffId) { RT2020.DAL.Staff oStaff = RT2020.DAL.Staff.Load(staffId); if (oStaff != null) { return(oStaff.StaffNumber); } else { return(string.Empty); } }
public Guid IsAuth(string staffNumber, string password) { string query = "StaffNumber = '" + staffNumber.Trim().Replace("'", "") + "' AND Password = '******'", "") + "'"; RT2020.DAL.Staff objStaff = RT2020.DAL.Staff.LoadWhere(query); if (objStaff != null) { return(objStaff.StaffId); } else { return(Guid.Empty); } }
/// <summary> /// Only support the ComboBox control from WinForm/Visual WebGUI /// </summary> /// <param name="ddList">the ComboBox control from WinForm/Visual WebGUI</param> /// <param name="TextField">e.g. new string[]{"FieldName1", "FieldName2", ...}</param> /// <param name="TextFormatString">e.g. "{0} - {1}"</param> /// <param name="SwitchLocale">Can be localized, if the FieldName has locale suffix, e.g. '_chs'</param> /// <param name="BlankLine">add blank label text to ComboBox or not</param> /// <param name="BlankLineText">the blank label text</param> /// <param name="ParentFilter">e.g. "ForeignFieldName = 'value'"</param> /// <param name="WhereClause">Where Clause for SQL Statement. e.g. "FieldName = 'SomeCondition'"</param> /// <param name="OrderBy">Sorting order, string array, e.g. {"FieldName1", "FiledName2"}</param> public static void LoadCombo(ref ComboBox ddList, string [] TextField, string TextFormatString, bool SwitchLocale, bool BlankLine, string BlankLineText, string ParentFilter, string WhereClause, string[] OrderBy) { if (SwitchLocale) { TextField = GetSwitchLocale(TextField); } ddList.Items.Clear(); StaffCollection source; if (OrderBy == null || OrderBy.Length == 0) { OrderBy = TextField; } // Filter the retired records if (WhereClause.Length > 0) { WhereClause += " AND Retired = 0"; } else { WhereClause = "Retired = 0"; } if (WhereClause.Length > 0) { source = Staff.LoadCollection(WhereClause, OrderBy, true); } else { source = Staff.LoadCollection(OrderBy, true); } Common.ComboList sourceList = new Common.ComboList(); if (BlankLine) { sourceList.Add(new Common.ComboItem(BlankLineText, Guid.Empty)); } foreach (Staff item in source) { bool filter = false; if (ParentFilter.Trim() != String.Empty) { filter = true; if (item.DeptId != Guid.Empty) { filter = IgnorThis(item, ParentFilter); } } if (!(filter)) { string code = GetFormatedText(item, TextField, TextFormatString); sourceList.Add(new Common.ComboItem(code, item.StaffId)); } } ddList.DataSource = sourceList; ddList.DisplayMember = "Code"; ddList.ValueMember = "Id"; if (ddList.Items.Count > 0) { ddList.SelectedIndex = 0; } }