Example #1
0
        public void generateHTML(HTMLFile htmlfile, XLFile xlfile, String dirPath)
        {
            CellRange[] cells       = xlfile.CellsFirstCol;
            CellRange[] cellsValues = xlfile.CellsValCol;
            HtmlNode    node        = htmlfile.Htmldoc.GetElementbyId(cells[1].Value.ToString());
            string      value       = null;

            for (int i = 0, j = 1; j < cellsValues.Length; i++, j++)
            {
                if (cellsValues[j].Value.ToString() != "")
                {
                    System.Console.Write("\nprocessing row" + j + "...\n");

                    /*if (j == 3 || j == 4 || j == 23)
                     * {*/
                    htmlfile.updateNode(i, cells[j].Value.ToString(), cellsValues[j].Value.ToString(), "%");

                    /*}
                     * else
                     * {
                     *  value = null;
                     *  value = cellsValues[j].Value.ToString();
                     *  htmlfile.NodeList.ElementAt(i).InnerHtml = value;
                     * }*/
                }
            }
            String[] splitPath = xlfile.Path.Split('\\');
            htmlfile.Htmldoc.Save(@dirPath + splitPath[splitPath.Length - 1].Split('.')[0] + ".html");
            //System.Console.Write("\nC:/Users/trakotom/Desktop/local/RTM/Generated-file/" + splitPath[splitPath.Length - 1].Split('.')[0] + ".html\n");
        }
Example #2
0
        static void Main(string[] args)
        {
            Tool tool = new Tool();

            System.Console.Write("Enter excel files directory path (C:\\xxx\\xxx\\):\n");
            String dirPath = System.Console.ReadLine();
            XLFile file    = new XLFile(@dirPath);

            file.loadFile();
            System.Console.Write("\nEnter HTML base template path (C:\\xxx\\xxx\\file.html):\n");
            String   htmlPath = System.Console.ReadLine();
            HTMLFile htmlFile = new HTMLFile(@htmlPath);

            if (tool.validate(htmlFile, file))
            {
                System.Console.WriteLine("\nFiles validated\n");
            }
            else
            {
                System.Console.Write("\n ID error do you want to continue?(y/n)\n");
                System.Console.ReadLine();
            }
            System.Console.Write("\n Enter destination path (C:\\xxx\\xxx\\): \n");
            String destPath = System.Console.ReadLine();

            tool.generateHTML(htmlFile, file, destPath);
            System.Console.WriteLine("File Generated\n");

            //htmlFile.findPlaceHolder();

            System.Console.ReadLine();
        }
Example #3
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile  = FileManager.LoadFile("base.html");
            HTMLFile panelFile = FileManager.LoadFile("blocks/panel.html");

            panelFile.AddData(new Dictionary <string, object>()
            {
                { "form", DataSet.ToHTMLForm(Dataset) },
                { "header", "Register" }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                //{"car_1", new string[] {"hoi", DataSet.ToHTMLForm(Dataset)}}
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", panelFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #4
0
        void ReleaseDesignerOutlets()
        {
            if (CSharpFile != null)
            {
                CSharpFile.Dispose();
                CSharpFile = null;
            }

            if (HTMLFile != null)
            {
                HTMLFile.Dispose();
                HTMLFile = null;
            }

            if (MarkDownFile != null)
            {
                MarkDownFile.Dispose();
                MarkDownFile = null;
            }

            if (XMLFile != null)
            {
                XMLFile.Dispose();
                XMLFile = null;
            }

            if (ChooseButton != null)
            {
                ChooseButton.Dispose();
                ChooseButton = null;
            }
        }
Example #5
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile = FileManager.LoadFile("base.html");
            HTMLFile carFile  = FileManager.LoadFile("blocks/detail.html");

            sales_catalog_car car = DB.GetModel("sales_catalog_car").Select("*").AddFieldToFilter("car_license_plate", new Tuple <string, Expression>("eq", new Expression(Url.Split('/')[1]))).Load().ToDataSet <sales_catalog_car>().First();

            sales_order_item[] items = DB.GetModel("sales_order_item").Select("*").AddFieldToFilter("car_id", new Tuple <string, Expression>("eq", new Expression(car.car_id.ToString()))).Load().ToDataSet <sales_order_item>();

            List <string> dates = new List <string>();

            foreach (sales_order_item item in items)
            {
                for (DateTime dt = Convert.ToDateTime(item.hired_from); dt <= Convert.ToDateTime(item.hired_to); dt = dt.AddDays(1))
                {
                    dates.Add(string.Format("{0:yyyy/MM/dd}", dt.Date));
                }
            }

            carFile.AddData(new Dictionary <string, object>()
            {
                { "image", GetImagePath(car.car_image) },
                { "name", car.car_type + " - " + car.car_brand },
                { "description", car.car_description },
                { "price", car.car_day_price.ToString() },
                { "license", car.car_license_plate },
                { "dates", dates.ToArray() }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", carFile.GetData() }
            });

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }

            LoadBootStrap();
            this.AddCss("styles.css");
            this.AddCss("datepicker.min.css");
            this.AddJs("datepicker.min.js");
            this.AddJs("custom.js");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #6
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile  = FileManager.LoadFile("base.html");
            HTMLFile adminFile = FileManager.LoadFile("blocks/beheer.html");

            sales_catalog_car car = DB.GetModel("sales_catalog_car").Select("*").AddFieldToFilter("car_license_plate", new Tuple <string, Expression>("eq", new Expression(Url.Split('/')[3]))).Load().ToDataSet <sales_catalog_car>().First();

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).AddFieldToFilter("is_admin", new Tuple <string, Expression>("eq", new Expression("1"))).Load().ToDataSet <core_customer>().First();

            if (customer == null)
            {
                Location = "/index";
                return;
            }

            adminFile.AddData(new Dictionary <string, object>()
            {
                { "username", customer.customer_name }
            });

            adminFile.AddData(new Dictionary <string, object>()
            {
                { "content", DataSet.ToHTMLForm(typeof(sales_catalog_car), car, car.car_id, "PATCH", "http://localhost/admin/cars") }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", adminFile.GetData() }
            });

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }

            LoadBootStrap();
            this.AddCss("styles.css");
            this.AddCss("datepicker.min.css");
            this.AddJs("datepicker.min.js");
            this.AddJs("custom.js");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #7
0
        public void ShouldExportToHTMLFile()
        {
            List <Event> eventsRepo = new List <Event>
            {
                new Event("2015-01-01", "event", "description"), new Event("2015-01-02", "event2"), new Event("2015-03-01", "event3", "description3")
            };

            HTMLFile newObj = new HTMLFile(eventsRepo);

            newObj.ExportToHTMLFile(@"HTMLFile.html");
            Assert.IsTrue(File.Exists(@"HTMLFile.html"));
        }
Example #8
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile    = FileManager.LoadFile("base.html");
            HTMLFile confirmFile = FileManager.LoadFile("blocks/confirm.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }
            else
            {
                this.Location = "/register";
                return;
            }

            sales_catalog_car car = DB.GetModel("sales_catalog_car").Select("*").AddFieldToFilter("car_license_plate", new Tuple <string, Expression>("eq", new Expression(Url.Split('/')[1]))).Load().ToDataSet <sales_catalog_car>().First();

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).Load().ToDataSet <core_customer>().First();

            confirmFile.AddData(new Dictionary <string, object>()
            {
                { "car_name", car.car_type + " - " + car.car_brand },
                { "hired_from", _POST["date_1"] },
                { "hired_to", _POST["date_2"] },
                { "address", "<address><strong>" + customer.customer_name + "</strong>, " + customer.address_street + " " + customer.address_number + " <br>" + customer.address_postal + "</address>" },
                { "price", Convert.ToInt16((DateTime.ParseExact(_POST["date_2"], "yyyy/MM/dd", CultureInfo.InvariantCulture) - DateTime.ParseExact(_POST["date_1"], "yyyy/MM/dd", CultureInfo.InvariantCulture)).TotalDays) * car.car_day_price },
                { "license", car.car_license_plate }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", confirmFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");

            this.Location = "";

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #9
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile  = FileManager.LoadFile("base.html");
            HTMLFile panelFile = FileManager.LoadFile("blocks/panel.html");
            HTMLFile loginFile = FileManager.LoadFile("blocks/login.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });

                int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

                core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).AddFieldToFilter("is_admin", new Tuple <string, Expression>("eq", new Expression("1"))).Load().ToDataSet <core_customer>().First();

                if (customer != null)
                {
                    Location = "/admin/manage";
                    return;
                }
            }

            loginFile.AddData(new Dictionary <string, object>()
            {
                { "url", "/adminauth" },
                { "redirect", "/admin/manage" }
            });

            panelFile.AddData(new Dictionary <string, object>()
            {
                { "form", loginFile.GetData() },
                { "header", "Beheerders login" }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", panelFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #10
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile    = FileManager.LoadFile("base.html");
            HTMLFile accountFile = FileManager.LoadFile("blocks/myaccount.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }
            else
            {
                Location = "/index";
                return;
            }

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).Load().ToDataSet <core_customer>().First();

            accountFile.AddData(new Dictionary <string, object>()
            {
                { "username", customer.customer_name },
                { "content", DataSet.ToHTMLForm(typeof(core_customer), customer, customerID, "PATCH", "http://localhost/editaccount") }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", accountFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");

            this.Location = "";

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #11
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile     = FileManager.LoadFile("base.html");
            HTMLFile homepageFile = FileManager.LoadFile("homepage.html");
            HTMLFile panelFile    = FileManager.LoadFile("blocks/panel.html");

            homepageFile.AddData(new Dictionary <string, object>()
            {
                { "car_1", GetImagePath("a6-limousine.png") },
                { "car_2", GetImagePath("bmw.jpg") }
            });

            panelFile.AddData(new Dictionary <string, object>()
            {
                { "form", "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus consequat quam quis tellus mattis, ac malesuada felis laoreet. Curabitur velit lorem, ullamcorper non commodo ac, tristique id ipsum. Vestibulum posuere est vitae arcu auctor, eu dapibus felis aliquet. Nullam pellentesque turpis in dui scelerisque condimentum. Donec rhoncus eu eros vel eleifend. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed tincidunt elit a sagittis pharetra.<br> Vestibulum et tempor arcu, nec hendrerit tortor. In hac habitasse platea dictumst. Pellentesque et mi id diam finibus volutpat at in sapien. Quisque gravida neque sed lacus congue volutpat.<br> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam tempus magna sed nisl dictum, vel semper lectus euismod. Integer in enim a quam feugiat imperdiet sed nec urna. Sed accumsan vulputate lectus, a tincidunt nisl dapibus sed.<br> <br> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus consequat quam quis tellus mattis, ac malesuada felis laoreet. Curabitur velit lorem, ullamcorper non commodo ac, tristique id ipsum. Vestibulum posuere est vitae arcu auctor, eu dapibus felis aliquet. Nullam pellentesque turpis in dui scelerisque condimentum. Donec rhoncus eu eros vel eleifend. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Sed tincidunt elit a sagittis pharetra.<br> Vestibulum et tempor arcu, nec hendrerit tortor. In hac habitasse platea dictumst. Pellentesque et mi id diam finibus volutpat at in sapien. Quisque gravida neque sed lacus congue volutpat.<br> Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam tempus magna sed nisl dictum, vel semper lectus euismod. Integer in enim a quam feugiat imperdiet sed nec urna. Sed accumsan vulputate lectus, a tincidunt nisl dapibus sed." }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                //{"car_1", new string[] {"hoi", DataSet.ToHTMLForm(Dataset)}}
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", homepageFile.GetData() + panelFile.GetData() }
            });

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }

            LoadBootStrap();
            this.AddCss("styles.css");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #12
0
 public Boolean validate(HTMLFile htmlFile, XLFile xlfile)
 {
     try
     {
         CellRange[] cells = xlfile.CellsFirstCol;
         Boolean     check = true;
         for (int i = 1; i < cells.Length; i++)
         {
             if (!htmlFile.checkID(cells[i].Value.ToString()))
             {
                 System.Console.Write("ID '" + cells[i].Value.ToString() + "' is missing\n");
                 check = false;
             }
             htmlFile.NodeList.Add(htmlFile.Htmldoc.GetElementbyId(cells[i].Value.ToString()));
         }
         return(check);
     }
     catch (Exception exc)
     {
         System.Console.Write(exc.StackTrace);
     }
     return(false);
 }
Example #13
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile    = FileManager.LoadFile("base.html");
            HTMLFile catalogFile = FileManager.LoadFile("blocks/catalog.html");

            sales_catalog_car[] cars = DB.GetModel("sales_catalog_car").Select("*").Load().ToDataSet <sales_catalog_car>();

            List <string> carsData = new List <string>();

            for (int i = 0; i < cars.Length; i += 2)
            {
                HTMLFile carFile = FileManager.LoadFile("blocks/carsmall.html");
                carFile.AddData(new Dictionary <string, object>()
                {
                    { "car_1_image", GetImagePath(cars[i].car_image) },
                    { "car_1_name", cars[i].car_type + " - " + cars[i].car_brand },
                    { "car_1_link", GetUrl(cars[i].car_license_plate) },
                    { "car_1_desc", cars[i].car_description },
                    { "car_1_price", cars[i].car_day_price },
                });


                if (cars.Length > i + 1)
                {
                    carFile.AddData(new Dictionary <string, object>()
                    {
                        { "car_2_image", GetImagePath(cars[i + 1].car_image) },
                        { "car_2_name", cars[i + 1].car_type + " - " + cars[i + 1].car_brand },
                        { "car_2_link", GetUrl(cars[i + 1].car_license_plate) },
                        { "car_2_desc", cars[i + 1].car_description },
                        { "car_2_price", cars[i + 1].car_day_price }
                    });
                }

                carsData.Add(carFile.GetData());
            }

            catalogFile.AddData(new Dictionary <string, object>()
            {
                { "products", carsData.ToArray() },
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", catalogFile.GetData() }
            });

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }

            LoadBootStrap();
            this.AddCss("styles.css");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #14
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile  = FileManager.LoadFile("base.html");
            HTMLFile adminFile = FileManager.LoadFile("blocks/beheer.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }
            else
            {
                Location = "/index";
                return;
            }

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).AddFieldToFilter("is_admin", new Tuple <string, Expression>("eq", new Expression("1"))).Load().ToDataSet <core_customer>().First();

            if (customer == null)
            {
                Location = "/index";
                return;
            }

            adminFile.AddData(new Dictionary <string, object>()
            {
                { "username", customer.customer_name }
            });

            if (HTTPMethod == Constants.METHOD_POST)
            {
                adminFile.AddData(new Dictionary <string, object>()
                {
                    { "content", "<h3 class=\"green\">Bestand uploaden gelukt!</h3>" }
                });
            }
            else
            {
                adminFile.AddData(new Dictionary <string, object>()
                {
                    { "content", "<form method=\"post\" action=\"\\image\" enctype=\"multipart/form-data\"><div class=\"form-group\"><input type=\"file\" name=\"file\" /></div><div class=\"form-group\"> <input type=\"submit\" name=\"submit\" /></div></form>" }
                });
            }

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", adminFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #15
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile   = FileManager.LoadFile("base.html");
            HTMLFile beheerFile = FileManager.LoadFile("blocks/beheer.html");
            HTMLFile carsFile   = FileManager.LoadFile("blocks/day_cars.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }
            else
            {
                Location = "/index";
                return;
            }

            string date = null;

            if (!_POST.ContainsKey("date"))
            {
                date = string.Format("{0:yyyy-MM-dd}", DateTime.Now);
            }
            else
            {
                date = _POST["date"];
            }

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).AddFieldToFilter("is_admin", new Tuple <string, Expression>("eq", new Expression("1"))).Load().ToDataSet <core_customer>().First();

            if (customer == null)
            {
                Location = "/index";
                return;
            }

            sales_order_item[] items = DB.GetModel("sales_order_item").Select("*").AddFieldToFilter("hired_from", new Tuple <string, Expression>("eq", new Expression(date))).Load().ToDataSet <sales_order_item>();

            List <string> cars = new List <string>();

            foreach (sales_order_item item in items)
            {
                HTMLFile carLine = FileManager.LoadFile("blocks/day_cars_line.html");

                sales_catalog_car car          = DB.GetModel("sales_catalog_car").Select("*").AddFieldToFilter("car_id", new Tuple <string, Expression>("eq", new Expression(item.car_id.ToString()))).Load().ToDataSet <sales_catalog_car>().First();
                core_customer     itemCustomer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(DB.GetModel("sales_flat_order").Select("*").AddFieldToFilter("order_id", new Tuple <string, Expression>("eq", new Expression(item.order_id.ToString()))).Load().ToDataSet <sales_flat_order>().First().customer_id.ToString()))).Load().ToDataSet <core_customer>().First();

                carLine.AddData(new Dictionary <string, object>()
                {
                    { "license_plate", car.car_license_plate },
                    { "brand", car.car_brand + " - " + car.car_type },
                    { "customer", itemCustomer.customer_name }
                });

                cars.Add(carLine.GetData());
            }

            carsFile.AddData(new Dictionary <string, object>()
            {
                { "cars", cars.ToArray() },
                { "date", date }
            });

            beheerFile.AddData(new Dictionary <string, object>()
            {
                { "username", customer.customer_name },
                { "content", carsFile.GetData() }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", beheerFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");
            this.AddCss("datepicker.min.css");
            this.AddJs("datepicker.min.js");

            this.Location = "";

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #16
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile      = FileManager.LoadFile("base.html");
            HTMLFile myaccountFile = FileManager.LoadFile("blocks/myaccount.html");
            HTMLFile invoicesFile  = FileManager.LoadFile("blocks/invoices.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }
            else
            {
                Location = "/index";
                return;
            }

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).Load().ToDataSet <core_customer>().First();

            sales_flat_order[] orders = DB.GetModel("sales_flat_order")
                                        .Select("*")
                                        .AddFieldToFilter("customer_id",
                                                          new Tuple <string, Expression>("eq", new Expression(customerID.ToString())))
                                        .Load()
                                        .ToDataSet <sales_flat_order>();

            List <string> invoices = new List <string>();

            foreach (sales_flat_order order in orders)
            {
                HTMLFile invoiceLine = FileManager.LoadFile("blocks/invoice_line.html");

                invoiceLine.AddData(new Dictionary <string, object>()
                {
                    { "invoice_no", "1000" + order.order_id },
                    { "invoice_link", order.invoice_link }
                });

                invoices.Add(invoiceLine.GetData());
            }

            invoicesFile.AddData(new Dictionary <string, object>()
            {
                { "invoices", invoices.ToArray() }
            });

            myaccountFile.AddData(new Dictionary <string, object>()
            {
                { "username", customer.customer_name },
                { "content", invoicesFile.GetData() }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", myaccountFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");

            this.Location = "";

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }
Example #17
0
        public override void Init(HttpListenerContext ctx = null)
        {
            HTMLFile baseFile    = FileManager.LoadFile("base.html");
            HTMLFile beheerFile  = FileManager.LoadFile("blocks/beheer.html");
            HTMLFile contactFile = FileManager.LoadFile("blocks/contacts.html");

            if (ctx.Request.Cookies["guid"] != null &&
                Sessions.sessions.ContainsKey(
                    (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key)
                    .First()))
            {
                baseFile.AddData(new Dictionary <string, object>()
                {
                    { "account", GetUrl("myaccount") }
                });
            }
            else
            {
                Location = "/index";
                return;
            }

            int customerID = (from s in Sessions.sessions where s.Value.Item2 == ctx.Request.Cookies["guid"].Value select s.Key).First();

            core_customer customer = DB.GetModel("core_customer").Select("*").AddFieldToFilter("customer_id", new Tuple <string, Expression>("eq", new Expression(customerID.ToString()))).AddFieldToFilter("is_admin", new Tuple <string, Expression>("eq", new Expression("1"))).Load().ToDataSet <core_customer>().First();

            if (customer == null)
            {
                Location = "/index";
                return;
            }

            core_contact[] contacts = DB.GetModel("core_contact").Select("*").Load().ToDataSet <core_contact>();

            List <string> contactText = new List <string>();

            foreach (core_contact contact in contacts)
            {
                HTMLFile contactLine = FileManager.LoadFile("blocks/contact_line.html");

                contactLine.AddData(new Dictionary <string, object>()
                {
                    { "contact_name", contact.contact_name },
                    { "contact_email", contact.contact_email },
                    { "contact_message", contact.contact_message },
                    { "id", contact.contact_id }
                });

                contactText.Add(contactLine.GetData());
            }

            contactFile.AddData(new Dictionary <string, object>()
            {
                { "contacts", contactText.ToArray() }
            });

            beheerFile.AddData(new Dictionary <string, object>()
            {
                { "username", customer.customer_name },
                { "content", contactFile.GetData() }
            });

            baseFile.AddData(new Dictionary <string, object>()
            {
                { "register", GetUrl("register") },
                { "login", GetUrl("login") },
                { "content", beheerFile.GetData() }
            });

            LoadBootStrap();
            this.AddCss("styles.css");
            this.AddCss("datepicker.min.css");
            this.AddJs("datepicker.min.js");

            this.Location = "";

            this.response    = baseFile.GetData();
            this.ContentType = Constants.CONTENT_HTML;
        }