protected void Page_Load(object sender, EventArgs e)
    {
        OB = new OrderBusiness();
        EB = new EmployeeBusiness();
        CB = new CompanyBLL();

        loadData();
        String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
        ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        OB = new OrderBusiness();
        CB = new CompanyBLL();

        DataTable dtCompany = CB.Company_ShowAllDisplay("");
        dtCompany.Columns.Add("Payment", typeof(double));
        foreach (DataRow item in dtCompany.Rows)
        {
            Guid comId = new Guid(item["Company_Id"].ToString());
            double companyPayment = 0;
            List<Order> listOrder = OB.GetOrdersByCompanyId(comId, false);
            foreach (Order order in listOrder)
            {
                companyPayment += Double.Parse(order.Total_Charge);
            }
            listOrder = OB.GetOrdersByCompanyId(comId, true);
            foreach (Order order in listOrder)
            {
                companyPayment += Double.Parse(order.Total_Charge);
            }
            item["Payment"] = companyPayment;
        }

        DataView dv = dtCompany.DefaultView;
        dv.Sort = "Payment DESC";

        dtCompany = dv.Table;
        //for (int i = 0; i < newDataTable.Rows.Count; i++)// change 'newDataTable.Rows.Count' by a prametter.
        //{
        //}
        DataRow dr = dtCompany.Rows[0];
        imgCompany1.ImageUrl = WebHelper.Instance.GetImageURL(dr["Company_Logo"].ToString(), 50, 50, false);
        lnkCompanyName1.Text = dr["Company_Name"].ToString();
        lblAddress1.Text = dr["Company_Address"].ToString();

        dr = dtCompany.Rows[1];
        imgCompany2.ImageUrl = WebHelper.Instance.GetImageURL(dr["Company_Logo"].ToString(), 50, 50, false);
        lnkCompanyName2.Text = dr["Company_Name"].ToString();
        lblAddress2.Text = dr["Company_Address"].ToString();

        dr = dtCompany.Rows[2];
        imgCompany3.ImageUrl = WebHelper.Instance.GetImageURL(dr["Company_Logo"].ToString(), 50, 50, false);
        lnkCompanyName3.Text = dr["Company_Name"].ToString();
        lblAddress3.Text = dr["Company_Address"].ToString();
    }
        private void FillDataToOrder(Order order, OrderOfService orderService)
        {
            order.OrderOfService_Id            = orderService.OrderOfService_Id;
            order.Company_Id                   = orderService.Company_Id;
            order.Employee_Id                  = orderService.Employee_Id;
            order.OrderOfService_BillDate      = orderService.OrderOfService_BillDate.ToShortDateString();
            order.OrderOfService_Description   = orderService.OrderOfService_Description;
            order.OrderOfService_IsDelete      = orderService.OrderOfService_IsDelete;
            order.OrderOfService_PaymentDate   = orderService.OrderOfService_PaymentDate.ToShortDateString();
            order.OrderOfService_PaymentMethod = orderService.OrderOfService_PaymentMethod;
            switch (orderService.OrderOfService_Status)
            {
            case 0:
                order.OrderOfService_Status = "Pending";
                break;

            case 99:
                order.OrderOfService_Status = "In Progress";
                break;

            case 1:
                order.OrderOfService_Status = "Resolved";
                break;

            default: break;
            }

            CompanyBLL CB      = new CompanyBLL();
            DataRow    company = CB.Company_ShowOnewDisplay(orderService.Company_Id.ToString());

            order.Company_Name = company["Company_Name"].ToString();

            AccountBusiness AB      = new AccountBusiness();
            Account         account = AB.GetAccountOfEmployee(orderService.Employee_Id);

            order.Account_UserName = account.Account_UserName;

            CalculateServicesAndCharges(order, order.OrderOfService_IsDelete);
        }
        private void FillDataToOrder(Order order, OrderOfService orderService)
        {
            order.OrderOfService_Id = orderService.OrderOfService_Id;
            order.Company_Id = orderService.Company_Id;
            order.Employee_Id = orderService.Employee_Id;
            order.OrderOfService_BillDate = orderService.OrderOfService_BillDate.ToShortDateString();
            order.OrderOfService_Description = orderService.OrderOfService_Description;
            order.OrderOfService_IsDelete = orderService.OrderOfService_IsDelete;
            order.OrderOfService_PaymentDate = orderService.OrderOfService_PaymentDate.ToShortDateString();
            order.OrderOfService_PaymentMethod = orderService.OrderOfService_PaymentMethod;
            switch (orderService.OrderOfService_Status)
            {
                case 0:
                    order.OrderOfService_Status = "Pending";
                    break;
                case 99:
                    order.OrderOfService_Status = "In Progress";
                    break;
                case 1:
                    order.OrderOfService_Status = "Resolved";
                    break;
                default: break;
            }

            CompanyBLL CB = new CompanyBLL();
            DataRow company = CB.Company_ShowOnewDisplay(orderService.Company_Id.ToString());
            order.Company_Name = company["Company_Name"].ToString();

            AccountBusiness AB = new AccountBusiness();
            Account account = AB.GetAccountOfEmployee(orderService.Employee_Id);
            order.Account_UserName = account.Account_UserName;

            CalculateServicesAndCharges(order, order.OrderOfService_IsDelete);
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        pnlRed.Visible = false;
        pnlGreen.Visible = false;
        pnlYellow.Visible = false;
        pnlBlue.Visible = false;

        SB = new ServiceBusiness();
        AB = new AccountBusiness();
        EB = new EmployeeBusiness();
        DB = new DepartmentBusiness();
        CB = new CompanyBLL();
        OB = new OrderBusiness();

        GetRouteData();
        cvBillDate.ValueToCompare = DateTime.Now.Date.ToShortDateString();
        if (!IsPostBack)
            loadData();
        else
        {
            String script = WebHelper.Instance.GetJqueryScript("App_Themes/js/jquery/custom_jquery.js");
            ScriptManager.RegisterStartupScript(Page, Page.GetType(), "MessageWarning", script, true);
        }
    }