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); }