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);
}
}
public List <ReportSalesEmployee> GetReportSalesEmployee(ParamDate date)
{
return(new DLReport().GetReportSalesEmployee(date));
}
public List <SAInvoiceViewer> GetReportSales(ParamDate date)
{
return(new DLReport().GetReportSales(date));
}
public List <ReportSalesArea> GetReportSalesArea(ParamDate date)
{
return(new DLReport().GetReportSalesArea(date));
}
public List <ReportSalesCustomer> GetReportSalesCustomer(ParamDate date)
{
return(new DLReport().GetReportSalesCustomer(date));
}