public void OnRunningSalesAndBuyInvoicesReport(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters)
{
var reportDataTable = new DataTable("ReportTable");
var invoiceType = parameters["InvoiceType"] as string;
EntityList salesAndBuysList = new EntityList();
//var accountReviewType = parameters["AccountReviewType"];
reportDataTable.Columns.Add("IssueDate");
reportDataTable.Columns.Add("DocType_PersianText");
reportDataTable.Columns.Add("InvoiceNumber");
reportDataTable.Columns.Add("TotalStuffAndServicesPrice", typeof(decimal));
reportDataTable.Columns.Add("GeneralDiscount", typeof(decimal));
reportDataTable.Columns.Add("StuffAndServicesTotalAmountAfterDiscount", typeof(decimal));
reportDataTable.Columns.Add("TotalTaxAndToll", typeof(decimal));
reportDataTable.Columns.Add("FinalAmount", typeof(decimal));
for (int i = 0; i < ps.SalesAndBuyInvoices.Entities.Count; i++)
{
Entity saleAndBuyEntity = ps.SalesAndBuyInvoices.Entities[i];
var docType = saleAndBuyEntity.GetFieldValue <string>("DocType");
if (docType == invoiceType)
{
salesAndBuysList.Entities.Add(saleAndBuyEntity);
}
}
foreach (var entity in salesAndBuysList.Entities)
{
var row = reportDataTable.NewRow();
row["IssueDate"] = entity.GetFieldValue <string>("IssueDate");
row["DocType_PersianText"] = entity.GetFieldValue <string>("DocType_PersianText");
row["InvoiceNumber"] = entity.GetFieldValue <string>("InvoiceNumber");
row["TotalStuffAndServicesPrice"] = entity.GetFieldValue <decimal>("TotalStuffAndServicesPrice");
row["GeneralDiscount"] = entity.GetFieldValue <decimal>("GeneralDiscount");
row["StuffAndServicesTotalAmountAfterDiscount"] = entity.GetFieldValue <decimal>("StuffAndServicesTotalAmountAfterDiscount");
row["TotalTaxAndToll"] = entity.GetFieldValue <decimal>("TotalTaxAndToll");
row["FinalAmount"] = entity.GetFieldValue <decimal>("FinalAmount");
reportDataTable.Rows.Add(row);
}
report.Dictionary.DataSources.Clear();
report.RegData("DataSource1", reportDataTable);
report.Dictionary.Synchronize();
StiDataBand dataBand1 = (StiDataBand)report.GetComponentByName("DataBand1");
dataBand1.DataSourceName = "ReportTable";
//report.DataSources.Clear();
//var list = (StiDataBand)report.GetComponentByName("DataBand1");
}
public void OnRunningSalesInvoice1Report(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters)
{
var dbHelper = CoreComponent.Instance.MainDbHelper;
var logoImage = report.GetComponentByName("LogoImage") as Stimulsoft.Report.Components.StiImage;
var invoiceID = Guid.Parse(parameters["InvoiceID"] as string);
var invoice = dbHelper.FetchSingleByID("ps.BuyInvoice", invoiceID, null);
}
public void OnRunningConnectedAccountsrReport(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters)
{
DataTable connectedAccountstDataTable = new DataTable("ReportTable");
var core = CoreComponent.Instance;
var connectedAccounts = core.TryGetUserSessionKeyValue("acc", "ConnectedAccounts");
EntityList connectedAccountsEntityList = (EntityList)connectedAccounts;
//var accountReviewType = parameters["AccountReviewType"];
connectedAccountstDataTable.Columns.Add("CodeAndName");
connectedAccountstDataTable.Columns.Add("AccountName");
connectedAccountstDataTable.Columns.Add("DebtorAmount", typeof(decimal));
connectedAccountstDataTable.Columns.Add("CreditorAmount", typeof(decimal));
//connectedAccountstDataTable.Columns.Add("RemainingDebtorAmount", typeof(decimal));
//connectedAccountstDataTable.Columns.Add("RemainingCreditorAmount", typeof(decimal));
foreach (var entity in connectedAccountsEntityList.Entities)
{
var row = connectedAccountstDataTable.NewRow();
row["CodeAndName"] = entity.GetFieldValue <string>("CodeAndName");
row["AccountName"] = entity.GetFieldValue <string>("AccountName");
//row["DebtorAmount"] = entity.GetFieldValue<string>("AccountCode");
//row["CreditorAmount"] = entity.GetFieldValue<string>("FarsiAccountReviewType");
row["DebtorAmount"] = entity.GetFieldValue <decimal>("DebtorAmount");
row["CreditorAmount"] = entity.GetFieldValue <decimal>("CreditorAmount");
//row["RemainingDebtorAmount"] = entity.GetFieldValue<decimal>("RemainingDebtorAmount");
//row["RemainingCreditorAmount"] = entity.GetFieldValue<decimal>("RemainingCreditorAmount");
connectedAccountstDataTable.Rows.Add(row);
}
report.Dictionary.DataSources.Clear();
report.RegData("ReportTable", connectedAccountstDataTable);
report.Dictionary.Synchronize();
StiDataBand dataBand1 = (StiDataBand)report.GetComponentByName("DataBand1");
dataBand1.DataSourceName = "ReportTable";
}
public void OnRunningAccountReviewShenavarReport(Entity reportEntity, Stimulsoft.Report.StiReport report, Dictionary <string, object> parameters)
{
var dbHelper = CoreComponent.Instance.MainDbHelper;
EntityList accountReview = new EntityList();
var test = report.DataSources;
var query = string.Format("");
DataTable shenavarReportDataTable = new DataTable("ReportTable");
var reportParameterAccountReview = new Guid?();
if (parameters["AccountReview"] != null)
{
reportParameterAccountReview = Guid.Parse(parameters["AccountReview"].ToString());
}
var shenavarType = parameters["ShenavarType"];
shenavarReportDataTable.Columns.Add("ShenavarName");
shenavarReportDataTable.Columns.Add("DebtorAmount_Shenavar");
shenavarReportDataTable.Columns.Add("CreditorAmount_Shenavar");
shenavarReportDataTable.Columns.Add("AccountCode");
shenavarReportDataTable.Columns.Add("FarsiAccountReviewType_Shenavar");
shenavarReportDataTable.Columns.Add("RemainingDebtorAmount_Shenavar", typeof(decimal));
shenavarReportDataTable.Columns.Add("RemainingCreditorAmount_Shenavar", typeof(decimal));
shenavarReportDataTable.Columns.Add("FarsiShenavarType");
shenavarReportDataTable.Columns.Add("AccountReviewName_Shenavar");
for (int i = 0; i < acc.AccountReview1.Entities.Count; i++)
{
Entity accountReviewEntity = acc.AccountReview1.Entities[i];
var accountReview_Shenavar = accountReviewEntity.GetFieldValue <Guid?>("AccountReview_Shenavar");
if (reportParameterAccountReview != null)
{
if (shenavarType as string == "Person")
{
if (accountReview_Shenavar == reportParameterAccountReview)
{
if (accountReviewEntity.GetFieldValue <string>("ShenavarType") == "Person")
{
accountReview.Entities.Add(accountReviewEntity);
}
}
}
else if (shenavarType as string == "CostCenter")
{
if (accountReview_Shenavar == reportParameterAccountReview)
{
if (accountReviewEntity.GetFieldValue <string>("ShenavarType") == "CostCenter")
{
accountReview.Entities.Add(accountReviewEntity);
}
}
}
else if (shenavarType as string == "Project")
{
if (accountReview_Shenavar == reportParameterAccountReview)
{
if (accountReviewEntity.GetFieldValue <string>("ShenavarType") == "Project")
{
accountReview.Entities.Add(accountReviewEntity);
}
}
}
}
}
foreach (var entity in accountReview.Entities)
{
var row = shenavarReportDataTable.NewRow();
row["ShenavarName"] = entity.GetFieldValue <string>("ShenavarName");
row["RemainingDebtorAmount_Shenavar"] = entity.GetFieldValue <decimal>("RemainingDebtorAmount_Shenavar");
row["RemainingCreditorAmount_Shenavar"] = entity.GetFieldValue <decimal>("RemainingCreditorAmount_Shenavar");
row["FarsiAccountReviewType_Shenavar"] = entity.GetFieldValue <string>("FarsiAccountReviewType_Shenavar");
row["FarsiShenavarType"] = entity.GetFieldValue <string>("FarsiShenavarType");
row["AccountReviewName_Shenavar"] = entity.GetFieldValue <string>("AccountReviewName_Shenavar");
shenavarReportDataTable.Rows.Add(row);
}
report.Dictionary.DataSources.Clear();
report.RegData("DataSource", shenavarReportDataTable);
report.Dictionary.Synchronize();
StiDataBand dataBand1 = (StiDataBand)report.GetComponentByName("DataBand1");
dataBand1.DataSourceName = "ReportTable";
}
