private void ShowCreditNoteReport(int id)
{
var creditNoteDataSet = new CreditNoteDataSet();
var firmTable = creditNoteDataSet.Tables["FirmMaster"];
var otherInfo = creditNoteDataSet.Tables["OtherInfo"];
_dataSetProvider.GetFirmDataTable(firmTable);
var crn = _transactionService.GetCreditNotes().Single(x => x.Id == id);
var customer = (Customer)cboCustomer.SelectedItem;
var otherRow = otherInfo.NewRow();
otherRow["InvoiceNo"] = crn.InvoiceNo;
otherRow["TransactionDate"] = crn.TransactionDate;
otherRow["ContactName"] = customer.ContactName;
otherRow["ContactNo"] = customer.Address.Phone;
otherRow["Address"] = customer.Address.ToString();
otherRow["Particulars"] = crn.Description;
otherRow["TotalAmount"] = crn.Amount;
otherRow["VATNumber"] = customer.VATNumber;
otherRow["CSTNumber"] = customer.CSTNumber;
otherRow["AmountInWords"] = SpellNumber.SpellInWord(crn.Amount);
otherInfo.Rows.Add(otherRow);
var orderReport = new frmReport
{
ReportPath = ReportUtility.ResolveReportPath(ReportConstants.CreditNoteReport),
ReportDataSet = creditNoteDataSet
};
orderReport.Show();
}
public void ShowTaxInvoice(Guid identifier)
{
var taxInvoiceDataSet = new TaxInvoiceDetailDataSet();
var firmDataTable = taxInvoiceDataSet.Tables["FirmMaster"];
_dataSetService.GetFirmDataTable(firmDataTable);
}
private DataSet GetJewelTransactionReport()
{
var jewelTransactionsDataSet = new JewelTransactionsDataSet();
var jewelTransactionDataTable = jewelTransactionsDataSet.Tables["JewelTransactions"];
var firmDataTable = jewelTransactionsDataSet.Tables["FirmMaster"];
_firmDataSetService.GetFirmDataTable(firmDataTable);
var temp = _transactionsServices.GetJewelTransactionsLookUp().ToList();
var jewelLookupList = temp
.Where(tr => tr.TransactionType == ((LocalStore.TransactionTypeItems)(cboTransactionType.SelectedItem)).JewelTransactionType &&
tr.TransactionDate.Date >= fromDateTimePicker.Value.Date && tr.TransactionDate.Date <= toDateTimePicker.Value.Date).ToList();
if (jewelLookupList.Count == 0)
{
MessageBox.Show(Resources.frmJewelTransactionsReport_GetJewelTransactionReport_No_Data_found_);
return(null);
}
int counter = 1;
foreach (var jewelLookup in jewelLookupList)
{
jewelLookup.JewelTransactions.ToList().ForEach(tran =>
{
var jewelTransactionRow = jewelTransactionDataTable.NewRow();
jewelTransactionRow["SrNo"] = counter;
jewelTransactionRow["TransactionDate"] = jewelLookup.TransactionDate;
jewelTransactionRow["ContactName"] = jewelLookup.ContactName;
jewelTransactionRow["DocNumber"] = jewelLookup.DocNumber;
jewelTransactionRow["Remarks"] = jewelLookup.Remarks;
jewelTransactionRow["CertificateNumber"] = tran.CertificateNumber;
jewelTransactionRow["JewelType"] = tran.JewelType;
jewelTransactionRow["JewelNumber"] = tran.JewelNumber;
jewelTransactionRow["DesingCode"] = tran.DesignCode;
jewelTransactionRow["TotalWeight"] = tran.TotalWeight;
jewelTransactionRow["MetalWeight"] = tran.MetalWeight;
jewelTransactionRow["StoneWeight"] = tran.StoneWeight;
jewelTransactionRow["StonePcs"] = tran.StonePcs;
jewelTransactionRow["TotalAmount"] = tran.TotalAmount;
jewelTransactionDataTable.Rows.Add(jewelTransactionRow);
counter = counter + 1;
});
}
return(jewelTransactionsDataSet);
}
private DataSet GetCustomersReport(string customerCode)
{
var customerDataSet = new CustomerDataSet();
var customerDataTable = customerDataSet.Tables["Customers"];
var firmDataTable = customerDataSet.Tables["FirmMaster"];
_firmDataSetService.GetFirmDataTable(firmDataTable);
var customerList = new List <Customer>();
if (customerCode == "0")
{
customerList = _customerService.GetAllCustomers().ToList();
}
else
{
customerList.Add(_customerService.GetCustomerByCode(customerCode));
}
foreach (var cust in customerList)
{
var customerRow = customerDataTable.NewRow();
customerRow["CustomerId"] = cust.CustomersId;
customerRow["CustomerCode"] = cust.CustomersCode;
customerRow["CompanyName"] = cust.CompanyName;
customerRow["ContactName"] = cust.ContactName;
customerRow["Phone/Mobile"] = cust.Address.Phone;
customerRow["Email"] = cust.Properties.Email1;
customerRow["Website"] = cust.Properties.Website;
customerRow["VATNumber"] = cust.VATNumber;
customerRow["Note"] = cust.Properties.Note;
customerDataTable.Rows.Add(customerRow);
}
return(customerDataSet);
}
private void btnShowReport_Click(object sender, EventArgs e)
{
var jewelStockDataSet = new JewelStockDataSet();
var jewelStockDataTable = jewelStockDataSet.Tables["JewelStockLedger"];
var firmDataTable = jewelStockDataSet.Tables["FirmMaster"];
var jewelStockSummaryDataTable = jewelStockDataSet.Tables["JewelStockSummary"];
_firmDataSetService.GetFirmDataTable(firmDataTable);
IQueryable <JewelStockLedger> jewelStockList; JewelItemCategory metalType;
var stoneType = cboStoneType.SelectedItem.ToString();
Enum.TryParse(cboKT.SelectedItem.ToString(), out metalType);
if (metalType == JewelItemCategory.NotSet && cboStoneType.SelectedItem.ToString() == ALL)
{
jewelStockList = _transactionsServices.GetJewelStockLedgers();
}
else if (metalType != JewelItemCategory.NotSet && cboStoneType.SelectedItem.ToString() == ALL)
{
jewelStockList = _transactionsServices.GetJewelStockLedgers()
.Where(tr => tr.JewelItemCategory_Enum == (int)metalType);
}
else
{
jewelStockList = _transactionsServices.GetJewelStockLedgers()
.Where(tr => tr.JewelItemCategory_Enum == (short)metalType && tr.JewelType == stoneType);
}
int counter = 1;
var list = jewelStockList.Where(x => x.StockStatus_Enum == (short)StockStatus.ItemIsInStock).ToList();
foreach (var jewel in list)
{
var jewelRow = jewelStockDataTable.NewRow();
jewelRow["SrNo"] = counter;
jewelRow["JewelStockMasterId"] = jewel.JewelStockMasterId;
jewelRow["JewelNumber"] = jewel.JewelNumber;
jewelRow["DesignCode"] = jewel.DesignCode;
jewelRow["TotalWeight"] = jewel.TotalWeight;
jewelRow["MetalType"] = jewel.JewelItemCategory;
jewelRow["KT"] = jewel.KT;
jewelRow["StoneType"] = jewel.JewelType;
jewelRow["MetalWeight"] = jewel.MetalWeight;
jewelRow["StoneWeight"] = jewel.StoneWeight;
jewelRow["StonePcs"] = jewel.StonePcs;
jewelRow["ColorStonePcs"] = jewel.CStonePcs;
jewelRow["ColorStoneWt"] = jewel.CStoneWeight;
jewelStockDataTable.Rows.Add(jewelRow);
counter = counter + 1;
}
var summaryRow = jewelStockSummaryDataTable.NewRow();
summaryRow["TotalInStock"] = jewelStockList.Count(x => x.StockStatus_Enum == (short)StockStatus.ItemIsInStock);
summaryRow["TotalOutOfStock"] = jewelStockList.Count(x => x.JewelState_Enum == (short)JewelState.OnMarketing && x.StockStatus_Enum == (short)StockStatus.ItemLockedInStock);
summaryRow["TotalOnApproval"] = jewelStockList.Count(x => x.JewelState_Enum == (short)JewelState.OnApproval && x.StockStatus_Enum == (short)StockStatus.ItemOutOfStock);
jewelStockSummaryDataTable.Rows.Add(summaryRow);
var reportDocument = new ReportDocument();
reportDocument.Load(ReportUtility.ResolveReportPath(ReportConstants.JEWELSTOCKREPORTPATH));
crystalReportViewer1.ReportSource = reportDocument;
reportDocument.SetDataSource(jewelStockDataSet);
crystalReportViewer1.Refresh();
}
