Exemple #1
0
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            NinjectModule clientModule        = new ClientModule();
            NinjectModule usertModule         = new UserModule();
            NinjectModule categoryModule      = new CategoryModule();
            NinjectModule priceCategoryModule = new PriceCategoryModule();
            NinjectModule roomModule          = new RoomModule();
            NinjectModule reservationModule   = new ReservationModule();
            NinjectModule dependencyModule    = new DependencyModule("HotelModel");

            var kernel = new StandardKernel(dependencyModule, usertModule, clientModule,
                                            categoryModule, priceCategoryModule, roomModule, reservationModule);

            DependencyResolver.SetResolver(new NinjectDependencyResolver(kernel));
            ControllerBuilder.Current.SetControllerFactory(new NinjectControllerFactory(kernel));

            //var kernel = new StandardKernel(clientModule, usertModule, categoryModule,
            //    priceCategoryModule, roomModule, reservationModule, dependencyModule);
            //kernel.Bind<DefaultFilterProviders>().ToSelf().WithConstructorArgument(GlobalConfiguration.Configuration.Services.GetFilterProviders());
            //kernel.Bind<DefaultModelValidatorProviders>().ToConstant(new DefaultModelValidatorProviders(GlobalConfiguration.Configuration.Services.GetModelValidatorProviders()));
            //GlobalConfiguration.Configuration.DependencyResolver = new Ninject.Web.WebApi.NinjectDependencyResolver(kernel);
        }
 public IHttpActionResult GetProductPrice(int id)
 {
     try
     {
         return(Ok(CategoryModule.GetAllSubCategory(id)));
     }
     catch (Exception)
     {
         return(InternalServerError());
     }
 }
Exemple #3
0
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            NinjectModule categoryModule = new CategoryModule();
            NinjectModule serviceModule  = new ServiceModule("1");
            var           kernel         = new StandardKernel(categoryModule, serviceModule);

            DependencyResolver.SetResolver(new NinjectDependencyResolver(kernel));
        }
Exemple #4
0
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            GlobalConfiguration.Configure(WebApiConfig.Register);
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            NinjectModule categoryModule = new CategoryModule();
            NinjectModule lotModule      = new LotModule();
            NinjectModule serviceModule  = new ServiceModule("DefaultConnection");
            var           kernel         = new StandardKernel(categoryModule, lotModule, serviceModule);

            GlobalConfiguration.Configuration.DependencyResolver = new NinjectResolver(kernel);
        }
Exemple #5
0
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            // dependency injection
            NinjectModule bookModule     = new BookModule();
            NinjectModule categoryModule = new CategoryModule();
            NinjectModule serviceModule  = new ServiceModule();

            var kernel = new Ninject.StandardKernel(bookModule, categoryModule, serviceModule);

            //you just unbind ninject validator and there should be no collision with default validator.
            kernel.Unbind <ModelValidatorProvider>();
            DependencyResolver.SetResolver(new Ninject.Web.Mvc.NinjectDependencyResolver(kernel));
        }
Exemple #6
0
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();
            GlobalConfiguration.Configure(WebApiConfig.Register);
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            NinjectModule guestModule      = new GuestModule();
            NinjectModule roomModule       = new RoomModule();
            NinjectModule categoryModule   = new CategoryModule();
            NinjectModule bookingModule    = new BookingModule();
            NinjectModule dependencyModule = new DependencyModule("HotelModel");
            var           kernel           = new StandardKernel(guestModule, roomModule, categoryModule, bookingModule, dependencyModule);

            kernel.Bind <DefaultFilterProviders>().ToSelf().WithConstructorArgument(GlobalConfiguration.Configuration.Services.GetFilterProviders());
            kernel.Bind <DefaultModelValidatorProviders>().ToConstant(new DefaultModelValidatorProviders(GlobalConfiguration.Configuration.Services.GetModelValidatorProviders()));
            GlobalConfiguration.Configuration.DependencyResolver = new Ninject.Web.WebApi.NinjectDependencyResolver(kernel);
        }
Exemple #7
0
 public CategoryRepository()
 {
     _dateCategoryModule = new CategoryModule();
     _allCateData        = new Dictionary <string, List <FrontCategoryInfo> >();
 }
Exemple #8
0
        public CustomController()
        {
            //  List<CustomersModule> customerlist = new List<CustomersModule>();

            IList <CustomersModule> customerlist = new List <CustomersModule>();
            IList <Staff>           stafflist    = new List <Staff>();
            IList <ProjectModule>   projectlist  = new List <ProjectModule>();
            IList <ProjectModule>   projectlist2 = new List <ProjectModule>();
            IList <TaskManModule>   taskmode     = new List <TaskManModule>();
            IList <CategoryModule>  categorylist = new List <CategoryModule>();
            IList <TaskManModule>   tasklist     = new List <TaskManModule>();

            IList <TaskManModule> timesheet = new List <TaskManModule>();

            IList <TaskManModule> taskplanner = new List <TaskManModule>();


            string conString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

            using (SqlConnection con = new SqlConnection(conString))
            {
                con.Open();
                //-------------------------------
                string        query      = "Select * from [dbo].[customers]";
                SqlCommand    cmd        = new SqlCommand(query, con);
                SqlDataReader dataReader = cmd.ExecuteReader();


                while (dataReader.Read())
                {
                    CustomersModule sitems = new CustomersModule();
                    sitems.id   = Convert.ToString(dataReader["id"]);
                    sitems.name = Convert.ToString(dataReader["name"]);
                    sitems.code = Convert.ToString(dataReader["code"]);
                    customerlist.Add(sitems);
                }
                //   sitems.File_file = termsList.ToArray();
                //-------------------------------
                query = "Select * from [dbo].[staff]";
                SqlCommand    cmd2        = new SqlCommand(query, con);
                SqlDataReader dataReader2 = cmd2.ExecuteReader();


                while (dataReader2.Read())
                {
                    Staff sitems = new Staff();
                    sitems.id       = Convert.ToString(dataReader2["id"]);
                    sitems.fullname = Convert.ToString(dataReader2["fullname"]) + " " + Convert.ToString(dataReader2["lastname"]);
                    sitems.alias    = Convert.ToString(dataReader2["alias"]);
                    stafflist.Add(sitems);
                }

                //-------------------------------
                query = "Select * from [dbo].[project]";
                SqlCommand    cmd3        = new SqlCommand(query, con);
                SqlDataReader dataReader3 = cmd3.ExecuteReader();
                while (dataReader3.Read())
                {
                    ProjectModule sitems = new ProjectModule();
                    sitems.id     = Convert.ToString(dataReader3["id"]);
                    sitems.name   = Convert.ToString(dataReader3["name"]);
                    sitems.code   = Convert.ToString(dataReader3["code"]);
                    sitems.custid = Convert.ToString(dataReader3["custid"]);
                    projectlist.Add(sitems);
                }


                //------------------------------------------------


                //string query2 = "Select * from [dbo].[project] WHERE custid=" + Request.QueryString["customerid"].ToString();
                //SqlCommand cmd9 = new SqlCommand(query2, con);
                //SqlDataReader dataReader9 = cmd9.ExecuteReader();


                //while (dataReader9.Read())
                //{

                //    ProjectModule sitems = new ProjectModule();
                //    sitems.id = Convert.ToString(dataReader9["id"]);
                //    sitems.name = Convert.ToString(dataReader9["name"]);
                //    sitems.code = Convert.ToString(dataReader9["code"]);
                //    sitems.custid = Convert.ToString(dataReader9["custid"]);
                //    projectlist2.Add(sitems);
                //}


                //-------------------------------

                query = "Select id, description from [dbo].[taskman]";
                SqlCommand    cmd5        = new SqlCommand(query, con);
                SqlDataReader dataReader5 = cmd5.ExecuteReader();

                while (dataReader5.Read())
                {
                    TaskManModule sitems = new TaskManModule();
                    sitems.id          = Convert.ToInt16(dataReader5["id"]);
                    sitems.description = Convert.ToString(dataReader5["description"]);
                    tasklist.Add(sitems);
                }


                query = "Select id, projectid, status, code, name, description, datecreated from [dbo].[categories]";
                SqlCommand    cmd6        = new SqlCommand(query, con);
                SqlDataReader dataReader6 = cmd6.ExecuteReader();

                while (dataReader6.Read())
                {
                    CategoryModule cat = new CategoryModule();

                    cat.id          = Convert.ToInt16(dataReader6["id"].ToString());
                    cat.projectid   = Convert.ToInt16(dataReader6["projectid"].ToString());
                    cat.code        = Convert.ToString(dataReader6["code"]);
                    cat.name        = Convert.ToString(dataReader6["name"]);
                    cat.description = Convert.ToString(dataReader6["description"]);
                    cat.status      = Convert.ToString(dataReader6["status"]);
                    cat.datecreated = Convert.ToDateTime(dataReader6["datecreated"]);
                    categorylist.Add(cat);
                }

                //--------------------------------------------------------------------------------
                query = " SELECT T.id as id, C.code as cust,P.code as proj, T.description as descr, T.dev as dev, T.note as note, (Select fullname from[timesheet].[dbo].[staff] where id = T.resource) as resc, T.pr as pr,T.start as start,T.finish as finish, T.stat as stat, T.esthours as est,T.ddate as ddate from[timesheet].[dbo].[taskman] as T,[timesheet].[dbo].[customers] as C,[timesheet].[dbo].[project] as P,[timesheet].[dbo].[staff] as S WHERE C.id=T.customerid AND P.id=T.projectid AND T.resource=S.id ORDER BY T.id DESC";


                SqlCommand    cmd4        = new SqlCommand(query, con);
                SqlDataReader dataReader4 = cmd4.ExecuteReader();

                if (dataReader4.HasRows)
                {
                    while (dataReader4.Read())
                    {
                        TaskManModule sitems = new TaskManModule();
                        sitems.id          = Convert.ToInt16(dataReader4["id"]);
                        sitems.cust        = Convert.ToString(dataReader4["cust"]);
                        sitems.proj        = Convert.ToString(dataReader4["proj"]);
                        sitems.description = Convert.ToString(dataReader4["descr"]);
                        taskmode.Add(sitems);
                    }
                }
                else
                {
                    TaskManModule sitems = new TaskManModule();
                    sitems.id          = Convert.ToInt16("0");
                    sitems.cust        = Convert.ToString("no");
                    sitems.proj        = Convert.ToString("no");
                    sitems.description = Convert.ToString("no");
                    taskmode.Add(sitems);
                }


                string        queryday    = "Select * from [dbo].[tasklist]";
                SqlCommand    cmdd        = new SqlCommand(queryday, con);
                SqlDataReader dataReaderd = cmdd.ExecuteReader();


                while (dataReaderd.Read())
                {
                    TaskManModule sitems = new TaskManModule();
                    string        edate  = Convert.ToString(dataReaderd["edate"]);
                    sitems.ddate = String.Format("{0:MM/dd/yyyy}", edate);
                    timesheet.Add(sitems);
                }



                con.Close();
            }

            // Now store it in your model
            ViewData["CustomerList"]  = customerlist;
            ViewData["CustomerList2"] = customerlist;
            ViewData["StaffList"]     = stafflist;
            ViewData["ProjectList"]   = projectlist;
            //   ViewData["ProjectList2"] = projectlist2;
            ViewData["Taskman"]      = taskmode;
            ViewData["CategoryList"] = categorylist;



            ViewData["TaskList"] = tasklist;

            ViewData["SystemDate"] = DateTime.Now.ToString("MM/dd/yyyy");

            ViewData["dataDates"] = timesheet;


            // date range -------------- here

            DayOfWeek firstWeekDay = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.FirstDayOfWeek;

            DateTime startDateOfWeek = DateTime.Now;

            while (startDateOfWeek.DayOfWeek != firstWeekDay)
            {
                startDateOfWeek = startDateOfWeek.AddDays(-1d);
            }

            DateTime endDateOfWeek = startDateOfWeek.AddDays(6d);

            //return checkDate >= startDateOfWeek && checkDate <= endDateOfWeek;

            ViewData["begin"] = startDateOfWeek.ToString("MM/dd/yyyy");
            ViewData["end"]   = endDateOfWeek.ToString("MM/dd/yyyy");



            // end of date range
        }
 public CategoryDetails GetCategoryById(int id)
 {
     return(CategoryModule.GetCategoryDetailsById(id));
 }
 public List <CATEGORIES_DTO> GetAllCategories()
 {
     return(CategoryModule.GetAllCategories());
 }