Beispiel #1
0
        public string ValidateOperatorLogin(string operatorCode, string password, out string error)
        {
            string employeeName = "";

            error = "";

            var tranDt   = new ObjectParameter("TranDT", typeof(DateTime?));
            var res      = new ObjectParameter("Result", typeof(int?));
            var debugMsg = new ObjectParameter("DebugMsg", typeof(string));
            int debug    = 0;

            using (var context = new MONITOREntities2())
            {
                try
                {
                    usp_Web_Login_Result result = context.usp_Web_Login(operatorCode, password, tranDt, res, debug, debugMsg).FirstOrDefault();
                    employeeName = result.name;
                }
                catch (Exception ex)
                {
                    error = (ex.InnerException == null) ? ex.Message : ex.InnerException.Message;
                }
            }
            return(employeeName);
        }
Beispiel #2
0
        public string GetUserWebPages(string operatorCode)
        {
            string result = "";
            var    tranDt = new ObjectParameter("TranDT", typeof(DateTime?));
            var    res    = new ObjectParameter("Result", typeof(int?));

            UserWebPagesList.Clear();
            using (var context = new MONITOREntities2())
            {
                try
                {
                    var query = context.usp_Web_GetPages(operatorCode, tranDt, res);
                    foreach (var item in query)
                    {
                        var page = new UserWebPagesDataModel();
                        page.WebPage     = item.PageName;
                        page.FilePath    = item.FilePath;
                        page.DefaultPage = item.DefaultPage;

                        UserWebPagesList.Add(page);
                    }
                }
                catch (Exception ex)
                {
                    result = (ex.InnerException == null) ? ex.Message : ex.InnerException.Message;
                }
            }
            return(result);
        }
 public ReportsNavigationController()
 {
     _context = new MONITOREntities2();
 }