public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crptQuotation rpt = new crptQuotation();
rpt.Site = this.Site;
return(rpt);
}
private void frm_QuoteReport_Load(object sender, EventArgs e)
{
string expDate = DateTime.Now.Date.AddDays(10).ToString("dd/MM/yyyy");
DataRow companyInfo = com.getCompanyInfo();
string comEmail = companyInfo["ccEmail"].ToString();
string comPhone = companyInfo["ccPhone"].ToString();
string comAddress = companyInfo["ccAddress"].ToString();
DataTable dataTable = com.DataForGrid("select top 1 * from [CompanyBranch] where brStatus = 'working' ");
DataRow branchInfor = dataTable.Rows[0];
string branchName = branchInfor["brName"].ToString();
string branchCode = branchInfor["brCode"].ToString();
string branchAddress = branchInfor["brAddress"].ToString();
ParameterFields data = new ParameterFields();
//customer details
ParameterField PID = new ParameterField();
ParameterField address = new ParameterField();
ParameterField phone = new ParameterField();
ParameterField email = new ParameterField();
//company details
ParameterField ccEmail = new ParameterField();
ParameterField ccPhone = new ParameterField();
ParameterField ccAddress = new ParameterField();
//branch details
ParameterField brName = new ParameterField();
ParameterField brCode = new ParameterField();
ParameterField brAddress = new ParameterField();
//quotation code
ParameterField expiryDate = new ParameterField();
ParameterField quoteNumber = new ParameterField();
//amounts
ParameterField parSubtotal = new ParameterField();
ParameterField parDiscount = new ParameterField();
ParameterField parVat = new ParameterField();
ParameterField parTotalPrice = new ParameterField();
//aligning with parameter fields at the report
//customer
PID.Name = "customerName";
address.Name = "customerAddress";
phone.Name = "customerPhone";
email.Name = "customerEmail";
//company
ccEmail.Name = "companyEmail";
ccPhone.Name = "companyPhone";
ccAddress.Name = "companyAddress";
//branch
brName.Name = "branchName";
brCode.Name = "branchCode";
brAddress.Name = "branchAddress";
//quotation code and epxiry date
expiryDate.Name = "expiryDate";
quoteNumber.Name = "quotationNumber";
//amounts
parSubtotal.Name = "subTotal";
parDiscount.Name = "discount";
parVat.Name = "vat";
parTotalPrice.Name = "totalGoodsPrice";
//exact values for customer details
ParameterDiscreteValue val = new ParameterDiscreteValue();
ParameterDiscreteValue val1 = new ParameterDiscreteValue();
ParameterDiscreteValue val2 = new ParameterDiscreteValue();
ParameterDiscreteValue val3 = new ParameterDiscreteValue();
//exact values for company details
ParameterDiscreteValue valComEmail = new ParameterDiscreteValue();
ParameterDiscreteValue valComPhone = new ParameterDiscreteValue();
ParameterDiscreteValue valComAddress = new ParameterDiscreteValue();
//exact values for branch details
ParameterDiscreteValue valBrName = new ParameterDiscreteValue();
ParameterDiscreteValue valBrCode = new ParameterDiscreteValue();
ParameterDiscreteValue valBrAddress = new ParameterDiscreteValue();
//exact values for quotation number
ParameterDiscreteValue valQuoteNumber = new ParameterDiscreteValue();
ParameterDiscreteValue valExpiryDate = new ParameterDiscreteValue();
//discrete values
ParameterDiscreteValue valSubtotal = new ParameterDiscreteValue();
ParameterDiscreteValue valDiscount = new ParameterDiscreteValue();
ParameterDiscreteValue valVat = new ParameterDiscreteValue();
ParameterDiscreteValue valTotalPrice = new ParameterDiscreteValue();
//aisgning customer values
val.Value = this.customerName;
val1.Value = this.customerAddress;
val2.Value = this.customerPhone;
val3.Value = this.customerEmail;
//asigning company details
valComEmail.Value = comEmail;
valComPhone.Value = comPhone;
valComAddress.Value = comAddress;
//asigning branch details
valBrName.Value = branchName;
valBrCode.Value = branchCode;
valBrAddress.Value = branchAddress;
//asigning values to quote number and expiry date
valQuoteNumber.Value = this.quotationNumber;
valExpiryDate.Value = expDate;
//asigning amounts
valSubtotal.Value = this.subtotal;
valDiscount.Value = this.discount;
valVat.Value = this.vat;
valTotalPrice.Value = this.totalProductPrice;
//adding customer values to the destined ids
PID.CurrentValues.Add(val);
address.CurrentValues.Add(val1);
phone.CurrentValues.Add(val2);
email.CurrentValues.Add(val3);
//adding company details
ccEmail.CurrentValues.Add(valComEmail);
ccAddress.CurrentValues.Add(valComAddress);
ccPhone.CurrentValues.Add(valComPhone);
//adding branch details
brName.CurrentValues.Add(valBrName);
brAddress.CurrentValues.Add(valBrAddress);
brCode.CurrentValues.Add(valBrCode);
//adding quoteNumber and expiry date
quoteNumber.CurrentValues.Add(valQuoteNumber);
expiryDate.CurrentValues.Add(valExpiryDate);
//adding values to the parametes
parSubtotal.CurrentValues.Add(valSubtotal);
parDiscount.CurrentValues.Add(valDiscount);
parVat.CurrentValues.Add(valVat);
parTotalPrice.CurrentValues.Add(valTotalPrice);
data.Add(PID);
data.Add(address);
data.Add(phone);
data.Add(email);
data.Add(ccEmail);
data.Add(ccAddress);
data.Add(ccPhone);
data.Add(brName);
data.Add(brAddress);
data.Add(brCode);
data.Add(quoteNumber);
data.Add(expiryDate);
data.Add(parSubtotal);
data.Add(parDiscount);
data.Add(parVat);
data.Add(parTotalPrice);
crystalReportQuotation.ParameterFieldInfo = data;
DataTable dataTb = this.dt;
dataTb.TableName = "tbl_quotation";
All_Reports.crptQuotation rpt = new All_Reports.crptQuotation();
rpt.Database.Tables["tbl_quotation"].SetDataSource(dataTb);
crystalReportQuotation.ReportSource = null;
crystalReportQuotation.ReportSource = rpt;
}