public async Task <IActionResult> GetAccountLedgersList()
{
try
{
var accountLedgerList = await Task.FromResult(ReportsHelperClass.GetAccountLedgers());
if (accountLedgerList != null && accountLedgerList.Count > 0)
{
dynamic expdoObj = new ExpandoObject();
expdoObj.accountLedgerList = accountLedgerList;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = "No Data Found."
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <ActionResult> SalesGSTCSVReport(string companyId, string branchID, string userName)
{
try
{
var SalesGST = await Task.FromResult(ReportsHelperClass.GetSalesGSTReportDataTable(companyId, branchID, userName));
System.Text.StringBuilder fileContent = new System.Text.StringBuilder();
IEnumerable <string> columnNames = SalesGST.Columns.Cast <DataColumn>().
Select(column => column.ColumnName);
fileContent.AppendLine(string.Join(",", columnNames));
foreach (DataRow row in SalesGST.Rows)
{
IEnumerable <string> fields = row.ItemArray.Select(field => field.ToString());
fileContent.AppendLine(string.Join(",", fields));
}
byte[] bytes = System.Text.Encoding.ASCII.GetBytes(fileContent.ToString());
return(File(fileContents: bytes, contentType: "text/csv", fileDownloadName: "SalesGSTReport.csv"));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetAccountLedgerReportData(string UserID, string ledgerCode, DateTime fromDate, DateTime toDate)
{
try
{
var serviceResult = await Task.FromResult(ReportsHelperClass.GetAccountLedgerReportDataList(UserID, ledgerCode, fromDate, toDate));
if (serviceResult.Item1 != null && serviceResult.Item1.Count > 0)
{
dynamic expdoObj = new ExpandoObject();
expdoObj.accountLedgerList = serviceResult.Item1;
expdoObj.headerList = serviceResult.Item2;
expdoObj.footerList = serviceResult.Item3;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = "No Data Found."
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetEmployeeRegisterReportData(string UserID)
{
try
{
var employeeRegisterList = await Task.FromResult(ReportsHelperClass.GetEmployeeRegisterReportList(UserID));
if (employeeRegisterList != null && employeeRegisterList.Count > 0)
{
dynamic expdoObj = new ExpandoObject();
expdoObj.employeeRegisterList = employeeRegisterList;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = "No Data Found."
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetSalesGSTReportData(string companyId, string branchID, string userName)
{
try
{
var SalesGSTList = await Task.FromResult(ReportsHelperClass.GetSalesGSTReportDataList(companyId, branchID, userName));
if (SalesGSTList != null && SalesGSTList.Count > 0)
{
dynamic expdoObj = new ExpandoObject();
expdoObj.SalesGSTList = SalesGSTList;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = "No Data Found."
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetMemberMasterReportData(string isMobileNumberRequired, string UserID)
{
try
{
var memberMasterList = await Task.FromResult(ReportsHelperClass.GetMemberMasterReportDataList(isMobileNumberRequired, UserID));
if (memberMasterList.Count > 0)
{
dynamic expdoObj = new ExpandoObject();
expdoObj.memberMasterList = memberMasterList;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = "No Data Found."
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetDefaultShiftReportDataTableList()
{
try
{
var serviceResult = await Task.FromResult(ReportsHelperClass.GetDefaultShiftReportDataTableList());
if (serviceResult.Item1 != null && serviceResult.Item1.Count > 0)
{
dynamic expdoObj = new ExpandoObject();
expdoObj.shiftViewList = serviceResult.Item1;
expdoObj.headerList = serviceResult.Item2;
expdoObj.footerList = serviceResult.Item3;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = "No Data Found."
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetStockVerificationReportData(string branchCode, string UserID, DateTime fromDate, DateTime toDate)
{
try
{
var serviceResult = await Task.FromResult(ReportsHelperClass.GetStockVerificationReportDataList(branchCode, UserID, fromDate, toDate));
dynamic expdoObj = new ExpandoObject();
expdoObj.StockVerificationList = serviceResult.Item1;
expdoObj.headerList = serviceResult.Item2;
expdoObj.footerList = serviceResult.Item3;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetProductWiseMonthlyPurchaseReportData(string userID, DateTime fromDate, DateTime toDate)
{
try
{
var serviceResult = await Task.FromResult(ReportsHelperClass.GetProductWiseMonthlyPurchaseReportDataList(userID, fromDate, toDate));
dynamic expdoObj = new ExpandoObject();
expdoObj.ProductWiseMonthlyPurchaseList = serviceResult.Item1;
expdoObj.headerList = serviceResult.Item2;
expdoObj.footerList = serviceResult.Item3;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
public async Task <IActionResult> GetShiftViewReportList(string userName, string userID, string branchCode, string shiftId, DateTime fromDate, DateTime toDate, int reportID)
{
try
{
var serviceResult = await Task.FromResult(ReportsHelperClass.GetShiftViewReportDataList(userName, userID, branchCode, shiftId, fromDate, toDate, reportID));
dynamic expdoObj = new ExpandoObject();
expdoObj.shiftViewList = serviceResult.Item1;
expdoObj.headerList = serviceResult.Item2;
expdoObj.footerList = serviceResult.Item3;
return(Ok(new APIResponse {
status = APIStatus.PASS.ToString(), response = expdoObj
}));
}
catch (Exception ex)
{
return(Ok(new APIResponse {
status = APIStatus.FAIL.ToString(), response = ex.Message
}));
}
}
