예제 #1
0
        public List <UserModel> GetAllUsers()
        {
            var db    = new TableBasedSp(RunSpName);
            var dt    = db.GetFirstTableOfData("uspGetUsers", ConnectionString);
            var users = new DataTableToList().Convert <UserModel>(dt);

            return(users);
        }
예제 #2
0
        public DataTable GetMenu(int userId)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() },
                { "UserId", userId.ToString() }
            };

            return(db.GetFirstTableOfData("uspGetUserMenu", ConnectionString, parameters));
        }
예제 #3
0
        public List <UserModel> GetProgramUsers(UserStatusEnum userStatusEnum = UserStatusEnum.All)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() },
                { "Enable", ((int)userStatusEnum).ToString() }
            };
            var dt    = db.GetFirstTableOfData("uspGetProgramUsers", ConnectionString, parameters);
            var users = new DataTableToList().Convert <UserModel>(dt);

            return(users);
        }
예제 #4
0
 public List<ProgramsModel> GetPrograms()
 {
     var db = new TableBasedSp(RunSpName);
     
     try
     {
         var dt = db.GetFirstTableOfData("uspGetPrograms", ConnectionString);
         var programs = new DataTableToList().Convert<ProgramsModel>(dt);
         return programs;
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
예제 #5
0
        public List <ProgramRoleModel> GetProgramRoles(int programId)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() }
            };

            try
            {
                var dt    = db.GetFirstTableOfData("uspGetProgramRoles", ConnectionString, parameters);
                var roles = new DataTableToList().Convert <ProgramRoleModel>(dt);
                return(roles);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #6
0
        public DataTable GetFullElementWithSetting(ElementTypeEnum elementType, int userId)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() },
                { "ElementTypeId", ((int)elementType).ToStringVar() },
                { "UserId", userId.ToString() }
            };

            try
            {
                return(db.GetFirstTableOfData("uspVisibleElementDataForUser", ConnectionString, parameters));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #7
0
        public UserModel Login(string userId, string password)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() },
                { "UserId", userId },
                { "Password", password }
            };
            var dt = db.GetFirstTableOfData("uspLoginInProgram", ConnectionString, parameters);

            if (dt == null || dt.Rows.Count < 1)
            {
                return(null);
            }
            var user = new DataTableToList().Convert <UserModel>(dt);

            return(user[0]);
        }
예제 #8
0
        public List <ElementAccessModel> GetElementAccess(ElementTypeEnum elementType, int userId)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() },
                { "ElementTypeId", ((int)elementType).ToStringVar() },
                { "UserId", userId.ToString() }
            };

            try
            {
                var dt       = db.GetFirstTableOfData("uspVisibleElementDataForUser", ConnectionString, parameters);
                var elements = new DataTableToList().Convert <ElementAccessModel>(dt);
                return(elements);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #9
0
        public ElementAccessModel GetElementAccess(int elementId, int userId)
        {
            var db         = new TableBasedSp(RunSpName);
            var parameters = new Dictionary <string, string>
            {
                { "ProgramId", ProgramId.ToString() },
                { "ElementId", elementId.ToString() },
                { "UserId", userId.ToString() }
            };

            try
            {
                var dt       = db.GetFirstTableOfData("[uspGetUserAccessForElement]", ConnectionString, parameters);
                var elements = new DataTableToList().Convert <ElementAccessModel>(dt);
                return(elements[0]);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
예제 #10
0
        private static void Main(string[] args)
        {
            //var conn =
            //    new SqlConnection(
            //        "Data Source=HRMS;Initial Catalog=laboratory;Persist Security Info=True;User ID=sa;Password=S@334sai334@Sxxx");
            //var command = new SqlCommand("sp_GetStuffRegistration2ORMTest", conn);
            //command.CommandType = CommandType.StoredProcedure;
            //command.Parameters.Add("@mainTestRegistrationId", 640);
            //conn.Open();
            //reader = command.ExecuteReader();
            //var dt = new DataTable();
            //dt.Load(reader);
            //var list = new DataTableToList().Convert<StuffTestRegisterVM>(dt);


            //var tableBased = new TableBasedSp("RunSp").GetFirstTableOfData("uspGetElementData",
            //    "Data Source=FROSH;Initial Catalog=UM;User ID=saleadmin;Password=H2389*x;",
            //    new Dictionary<string, string>
            //    {
            //        {"ProgramId", "2"},
            //        {"ElementId", "36"}
            //    }
            //    );

            //var t2 = new TableBasedSp("RunSp").GetAllTablesOfData("uspGetElementData",
            //    "Data Source=FROSH;Initial Catalog=UM;User ID=saleadmin;Password=H2389*x;",
            //    new Dictionary<string, string>
            //    {
            //        {"ProgramId", "2"},
            //        {"ElementId", "36"}
            //    }
            //    );

            //var t3 = new TableBasedSp("RunSp").RunSp("uspGetElementData",
            //    "Data Source=FROSH;Initial Catalog=UM;User ID=saleadmin;Password=H2389*x;",
            //    new Dictionary<string, string>
            //    {
            //        {"ProgramId", "2"},
            //        {"ElementId", "36"}
            //    }
            //    );

            //var list = new DataTableToList().Convert<MenuVm>(tableBased);
            //var list2 = new DataTableToList().Convert<MenuVm>(t2.Tables[0]);

            try
            {
                var     db = new TableBasedSp("Business.uspRunSp");
                DataSet ds = db.GetAllTablesOfData("[Business].[uspGetWorkorders]",
                                                   @"Data Source=cmms;Initial Catalog=WorkorderManagement;Integrated Security=True",
                                                   new Dictionary <string, string>
                {
                    { "_CD", "2016-02-13 09:36:05.677" },
                    { "_Username", "890012" },
                    { "_Password", "123" },
                    { "_ExecutingVersion", "1.3.1.0" },
                    { "_RequestId", Guid.NewGuid().ToString() },
                    { "ReportSectionId", "1" },
                    { "PropertyNames", "SelectedRequesterUnits;" },
                    { "PropertyValues", "1,2;" },
                    { "WorkorderIds", "342" },
                    { "CheckId", "2" },
                    { "CheckResult", "p0" },
                    { "WorkorderDetailIds", "234,239,240,241" },
                    { "ScheduleStart", "2015-06-27 10:00:00.000" },
                    { "ScheduleFinish", "2015-07-01 09:00:00.000" },
                    { "WorkorderId", "330" },
                    { "Modes", "0" },
                    { "FromDate", "2010-06-23 14:25:44.267" },
                    { "ToDate", "2020-06-23 14:25:44.267" },
                    { "PreferredRole", "-1" },
                    { "Requester", "930682" },
                    { "RequestDate", "2015-09-05 08:53:37.315" },
                    { "NeedDate", "2015-09-06 08:53:37.315" },
                    { "WorkUnitId", "147" },
                    { "RequesterUnitId", "126" },
                    { "Description", "" },
                    { "DeviceCode", "" },
                    {
                        "WorkorderDetails",
                        "<DocumentElement>  <WorkorderDetails>    <OrderToPerform>0</OrderToPerform>    <JobToDo>تست درخواست</JobToDo>  </WorkorderDetails></DocumentElement>"
                    }
                });

                var a = 1;
            }
            catch (Shoniz.Common.Data.SqlServer.DataException ex)
            {
            }
        }