protected virtual DataSet GenerateDataSet()
{
var dataset = new SupplierDataSet();
AddAdditionalDataToDataSet(dataset);
AddSuppliersToDataSet(dataset);
return(dataset);
}
private void AddAdditionalDataToDataSet(SupplierDataSet dataset)
{
var reportFooter = new GlobalTermsProvider()["ReportFooter"].ToString();
var reportFooterPrepared = new GlobalTermsProvider()["ReportFooterPrepared"].ToString();
var reportFooterLink = new GlobalTermsProvider()["ProductWebsite"].ToString();
_dateAsOf = DateTime.Today.ToString("dd MM yyyy");
dataset.AdditionalDataTAble.AddAdditionalDataTAbleRow(_reportTitle, _operatorLogotype, _filterSelection, _dateAsOf, reportFooter, reportFooterPrepared, reportFooterLink, _formName);
}
private void AddSuppliersToDataSet(SupplierDataSet dataset)
{
foreach (var supplier in _reportedSuppliers)
{
var name = supplier.Name;
var subject = supplier.Subject;
var vendor = supplier.VendorCode;
var approved = supplier.SupplierClass.ToString();
var adress = supplier.Address;
var contactPerson = supplier.ContactPerson;
var faxPhone = $"{supplier.Fax} / {supplier.Phone}";
var email = supplier.Email;
var site = supplier.WebSite;
var remark = supplier.Remarks;
dataset.SupplierDataTable.AddSupplierDataTableRow(name, subject, vendor, approved, "", adress, contactPerson, faxPhone, email, site, remark);
}
}
private DataSet GetSuppliersReport(string supplierCode)
{
var supplierDataSet = new SupplierDataSet();
var supplierDataTable = supplierDataSet.Tables["Suppliers"];
var firmDataTable = supplierDataSet.Tables["FirmMaster"];
_firmDataSetService.GetFirmDataTable(firmDataTable);
var supplierList = new List <Supplier>();
if (supplierCode == "0")
{
supplierList = _supplierService.GetAllSuppliers().ToList();
}
else
{
supplierList.Add(_supplierService.GetSupplierByCode(supplierCode));
}
foreach (var supplier in supplierList)
{
var supplierRow = supplierDataTable.NewRow();
supplierRow["SupplierId"] = supplier.SupplierId;
supplierRow["SupplierCode"] = supplier.SupplierCode;
supplierRow["CompanyName"] = supplier.CompanyName;
supplierRow["ContactName"] = supplier.ContactName;
supplierRow["Phone/Mobile"] = supplier.Address.Phone;
supplierRow["Email"] = supplier.Properties.Email1;
supplierRow["Website"] = supplier.Properties.Website;
supplierRow["VATNumber"] = supplier.VATNumber;
supplierRow["Note"] = supplier.Properties.Note;
supplierDataTable.Rows.Add(supplierRow);
}
return(supplierDataSet);
}
