public ActionResult SearchExport()
        {
            try
            {
                var table = new StringBuilder();
                var datefrom = DateTime.ParseExact(Request["DateFrom"], "dd/MM/yyyy", null);
                var dateto = DateTime.ParseExact(Request["DateTo"], "dd/MM/yyyy", null);
                var eService = new ExportService();
                var oService = new OrderService();
                var tService = new StockService();
                var cService = new CustomerService();
                var exports = eService.GetExportByDate(datefrom, dateto);

                table.Append("<table id='table1' class='table1'>");
                table.Append("<thead>");
                table.Append("<tr>");
                table.Append("<th>Mã đơn hàng</th>");
                table.Append("<th>Khách hàng</th>");
                table.Append("<th>Tên kho</th>");
                table.Append("<th>Ngày xuất kho</th>");
                table.Append("</tr>");
                table.Append("</thead>");

                table.Append("<tbody>");
                foreach (var export in exports)
                {
                    var order = oService.GetOrderById(export.OrderId);
                    var customer = cService.GetCustomerById(order.CustomerId);
                    var stock = tService.GetStockById(export.StockId);
                    table.Append("<tr>");
                    table.AppendFormat("<td>{0}</td>", order.Code);
                    table.AppendFormat("<td>{0}</td>", customer.Name);
                    table.AppendFormat("<td>{0}</td>", stock.Name);
                    table.AppendFormat("<td>{0}</td>", export.CreatedDate.ToShortDateString());
                    table.Append("</tr>");
                }

                table.Append("</tbody>");
                table.Append("</table>");

                return Json(new
                {
                    finish = true,
                    data = table.ToString()
                });
            }
            catch (Exception e)
            {

                return Json(new { finish = false, data = e.ToString() });

            }
        }
        public ActionResult SearchPayment()
        {
            try
            {
                var table = new StringBuilder();
                var datefrom = DateTime.ParseExact(Request["DateFrom"], "dd/MM/yyyy", null);
                var dateto = DateTime.ParseExact(Request["DateTo"], "dd/MM/yyyy", null);
                var pService = new PaymentService();
                var oService = new OrderService();
                var cService = new CustomerService();
                var payments = pService.GetPaymentByDate(datefrom, dateto);
                double totalCash = 0, totalTransfer = 0;

                table.Append("<table id='table1' class='table1'>");
                table.Append("<thead>");
                table.Append("<tr>");
                table.Append("<th>Mã đơn hàng</th>");
                table.Append("<th>Khách hàng</th>");
                table.Append("<th>Hình thức thanh toán</th>");
                table.Append("<th>Tổng giá trị</th>");
                table.Append("</tr>");
                table.Append("</thead>");

                table.Append("<tbody>");
                foreach (var payment in payments)
                {
                    var total = oService.GetOrderDetailByOrderid(payment.OrderId).Sum(c => c.TotalQuantity);
                    var order = oService.GetOrderById(payment.OrderId);
                    var customer = cService.GetCustomerById(order.CustomerId);
                    if (order.IsSeen == false)
                        table.Append("<tr style='background:grey'>");
                    else
                        table.Append("<tr>");
                    table.AppendFormat("<td>{0}</td>", order.Code);
                    table.AppendFormat("<td>{0}</td>", customer.Name);
                    table.AppendFormat("<td>{0}</td>", payment.PaymentType.Name);
                    table.AppendFormat("<td>{0}</td>", Constant.ConvertCurrency(total));
                    table.Append("</tr>");

                    if (payment.PaymentType.Id == (int)PaymentType.CASH)
                        totalCash += total;
                    else
                        totalTransfer += total;
                }

                table.Append("</tbody>");
                table.Append("</table>");

                return Json(new
                {
                    finish = true,
                    data = table.ToString(),
                    totalCash = Constant.ConvertCurrency(totalCash),
                    totalTransfer = Constant.ConvertCurrency(totalTransfer)
                });
            }
            catch (Exception e)
            {

                return Json(new { finish = false, data = e.ToString() });

            }
        }