Exemplo n.º 1
0
        public List <ReportSalesEmployee> GetReportSalesEmployee(ParamDate date)
        {
            var table = new DataTable();
            var param = CommonFunction.getParameters(date);

            using (var sqlAdapter = new SqlDataAdapter())
            {
                using (var sqlCommand = CreateSqlCommand("Proc_GetReportSalesEmployee"))
                {
                    sqlCommand.Parameters.AddRange(param);
                    sqlAdapter.SelectCommand = sqlCommand;

                    sqlAdapter.Fill(table);
                    sqlCommand.Connection.Close();
                }
                if (CommonFunction.ConvertDataTable <ReportSalesEmployee>(table).Count > 0)
                {
                    return(CommonFunction.ConvertDataTable <ReportSalesEmployee>(table));
                }
                else
                {
                    return(null);
                }
            }
        }
        public void ORA_ReservedNameDate_Test()
        {
            using (var db = OpenDbConnection())
            {
                DropAndCreateTables(db);

                var row = new ParamDate {
                    Id = 2, Date = 12
                };
                db.Insert(row);

                row.Date = 826;
                db.Update(row);
            }
        }
        public object GetReportSales([FromBody] ParamDate date)
        {
            ServiceResult result = new ServiceResult();

            try
            {
                List <SAInvoiceViewer> items;
                var objBL = new BLReport();
                items       = objBL.GetReportSales(date);
                result.Data = items;
            }
            catch (Exception ex)
            {
                CommonFunction.WriteLog(ex, "", Request.RequestUri.ToString());
                result.Success   = false;
                result.ErrorCode = ex.Message;
            }
            return(result);
        }
        public void ORA_ReservedNameDate_Test()
        {
            using (var db = OpenDbConnection())
            {
                DropAndCreateTables(db);

                var row = new ParamDate { Id = 2, Date = 12 };
                db.Insert(row);

                row.Date = 826;
                db.Update(row);
            }
        }
Exemplo n.º 5
0
 public List <ReportSalesEmployee> GetReportSalesEmployee(ParamDate date)
 {
     return(new DLReport().GetReportSalesEmployee(date));
 }
Exemplo n.º 6
0
 public List <SAInvoiceViewer> GetReportSales(ParamDate date)
 {
     return(new DLReport().GetReportSales(date));
 }
Exemplo n.º 7
0
 public List <ReportSalesArea> GetReportSalesArea(ParamDate date)
 {
     return(new DLReport().GetReportSalesArea(date));
 }
Exemplo n.º 8
0
 public List <ReportSalesCustomer> GetReportSalesCustomer(ParamDate date)
 {
     return(new DLReport().GetReportSalesCustomer(date));
 }