public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CustomerCategories rpt = new CustomerCategories();
rpt.Site = this.Site;
return(rpt);
}
private void ViewLoad(object sender, EventArgs e)
{
if (_RepNo == 1)
{
DataSet ds = new DataSet();
DataSet1.TLADM_CustomerTypesDataTable typesTable = new DataSet1.TLADM_CustomerTypesDataTable();
using (var context = new TTI2Entities())
{
var Data = context.TLADM_CustomerTypes.OrderBy(x => x.CT_Description).ToList();
foreach (var record in Data)
{
DataSet1.TLADM_CustomerTypesRow tr = typesTable.NewTLADM_CustomerTypesRow();
tr.CT_Description = record.CT_Description;
tr.CT_Id = record.CT_Id;
tr.CT_ShortCode = record.CT_ShortCode;
typesTable.AddTLADM_CustomerTypesRow(tr);
}
}
ds.Tables.Add(typesTable);
CustomerCategories xtst = new CustomerCategories();
xtst.SetDataSource(ds);
crystalReportViewer1.ReportSource = xtst;
}
else if (_RepNo == 2)
{
DataSet ds = new DataSet();
DataSet2.TLADM_CustomerFileDataTable custTable = new DataSet2.TLADM_CustomerFileDataTable();
DataSet2.TLADM_CustomerTypesDataTable typesTable = new DataSet2.TLADM_CustomerTypesDataTable();
using (var context = new TTI2Entities())
{
var Data = context.TLADM_CustomerTypes.OrderBy(x => x.CT_Description).ToList();
foreach (var record in Data)
{
DataSet2.TLADM_CustomerTypesRow tr = typesTable.NewTLADM_CustomerTypesRow();
tr.CT_Description = record.CT_Description;
tr.CT_Id = record.CT_Id;
tr.CT_ShortCode = record.CT_ShortCode;
typesTable.AddTLADM_CustomerTypesRow(tr);
}
var Cust = context.TLADM_CustomerFile.OrderBy(x => x.Cust_Description).ToList();
foreach (var record in Cust)
{
DataSet2.TLADM_CustomerFileRow cr = custTable.NewTLADM_CustomerFileRow();
cr.Cust_ContactPerson = record.Cust_ContactPerson;
cr.Cust_ContactPersonEMail = record.Cust_ContactPersonEmail;
cr.Cust_CustomerCat_FK = record.Cust_CustomerCat_FK;
cr.Cust_Description = record.Cust_Description;
cr.Cust_Pk = record.Cust_Pk;
cr.Cust_Telephone = record.Cust_Telephone;
cr.Cust_Code = record.Cust_Code;
custTable.AddTLADM_CustomerFileRow(cr);
}
}
ds.Tables.Add(typesTable);
ds.Tables.Add(custTable);
CustomerByCategory xtst = new CustomerByCategory();
xtst.SetDataSource(ds);
crystalReportViewer1.ReportSource = xtst;
}
else if (_RepNo == 3)
{
DataSet ds = new DataSet();
DataSet3.TLADM_StockTypesDataTable typeTable = new DataSet3.TLADM_StockTypesDataTable();
using (var context = new TTI2Entities())
{
var Data = context.TLADM_StockTypes.OrderBy(x => x.ST_Description);
foreach (var row in Data)
{
DataSet3.TLADM_StockTypesRow tr = typeTable.NewTLADM_StockTypesRow();
tr.ST_Description = row.ST_Description;
tr.ST_Id = row.ST_Id;
tr.ST_ShortCode = row.ST_ShortCode;
typeTable.AddTLADM_StockTypesRow(tr);
}
}
ds.Tables.Add(typeTable);
SupplierCategories xtst = new SupplierCategories();
xtst.SetDataSource(ds);
crystalReportViewer1.ReportSource = xtst;
}
else if (_RepNo == 4)
{
DataSet ds = new DataSet();
DataSet4.TLADM_StockTypesDataTable typeTable = new DataSet4.TLADM_StockTypesDataTable();
DataSet4.TLADM_SuppliersDataTable supplierTable = new DataSet4.TLADM_SuppliersDataTable();
using (var context = new TTI2Entities())
{
var Data = context.TLADM_ProductTypes.ToList();
foreach (var row in Data)
{
DataSet4.TLADM_StockTypesRow tr = typeTable.NewTLADM_StockTypesRow();
tr.ST_Description = row.PT_Description;
tr.ST_Id = row.PT_pk;
tr.ST_ShortCode = row.PT_ShortCode;
typeTable.AddTLADM_StockTypesRow(tr);
}
var Supplier = context.TLADM_Suppliers.OrderBy(x => x.Sup_Description).ToList();
foreach (var record in Supplier)
{
DataSet4.TLADM_SuppliersRow sr = supplierTable.NewTLADM_SuppliersRow();
sr.Suip_ShippingAddress1 = record.Suip_ShippingAddress1;
sr.Sup_AllowsConsignment = record.Sup_AllowsConsignment;
sr.Sup_AllowsEMail = (bool)record.Sup_AllowsEMail;
sr.Sup_Blocked = record.Sup_Blocked;
sr.Sup_Code = record.Sup_Code;
sr.Sup_ContactPerson = record.Sup_ContactPerson;
sr.Sup_Description = record.Sup_Description;
sr.Sup_DiscountStructure = record.Sup_DiscountStructure;
sr.Sup_EMailContact = record.Sup_EMailContact;
sr.Sup_Fax = record.Sup_Fax;
sr.Sup_Notes = record.Sup_Notes;
sr.Sup_Pk = record.Sup_Pk;
sr.Sup_PostalAddress = record.Sup_PostalAddress;
sr.Sup_ProductGroups_FK = record.Sup_ProductGroups_FK;
sr.Sup_ProductTypes_FK = record.Sup_ProductTypes_FK;
sr.Sup_ShippingAddress2 = record.Sup_ShippingAddress2;
sr.Sup_ShippingAddress3 = record.Sup_ShippingAddress3;
sr.Sup_ShippingAddress4 = record.Sup_ShippingAddress4;
sr.Sup_StdPayMentTerms = record.Sup_StdPayMentTerms;
sr.Sup_Telephone = record.Sup_Telephone;
sr.Sup_VatReference = record.Sup_VatReference;
supplierTable.AddTLADM_SuppliersRow(sr);
}
}
ds.Tables.Add(typeTable);
ds.Tables.Add(supplierTable);
Supplierlist rep = new Supplierlist();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 5)
{
DataSet ds = new DataSet();
DataSet5.TLADM_DepartmentsDataTable DeptTable = new DataSet5.TLADM_DepartmentsDataTable();
DataSet5.TLADM_StoreTypesDataTable storeTypeTable = new DataSet5.TLADM_StoreTypesDataTable();
DataSet5.TLADM_WhseStoreDataTable whseStoreTable = new DataSet5.TLADM_WhseStoreDataTable();
using (var context = new TTI2Entities())
{
var Dept = context.TLADM_Departments.ToList();
foreach (var record in Dept)
{
DataSet5.TLADM_DepartmentsRow dr = DeptTable.NewTLADM_DepartmentsRow();
dr.Dep_Description = record.Dep_Description;
dr.Dep_Id = record.Dep_Id;
dr.Dep_ShortCode = record.Dep_ShortCode;
dr.Dep_UOM = record.Dep_UOM;
dr.Dep_PowerN = record.Dep_PowerN;
DeptTable.AddTLADM_DepartmentsRow(dr);
}
var Type = context.TLADM_StoreTypes.ToList();
foreach (var record in Type)
{
DataSet5.TLADM_StoreTypesRow tr = storeTypeTable.NewTLADM_StoreTypesRow();
tr.StoreT_Description = record.StoreT_Description;
tr.StoreT_Hazardous = record.StoreT_Hazardous;
tr.StoreT_Id = record.StoreT_Id;
tr.StoreT_ProdTypeFK = record.StoreT_ProdTypeFK;
tr.StoreT_ShortCode = record.StoreT_ShortCode;
tr.StoreT_UOMFK = record.StoreT_UOMFK;
storeTypeTable.AddTLADM_StoreTypesRow(tr);
}
var whse = context.TLADM_WhseStore.OrderBy(x => x.WhStore_DepartmentFK).ToList();
foreach (var record in whse)
{
DataSet5.TLADM_WhseStoreRow wr = whseStoreTable.NewTLADM_WhseStoreRow();
wr.WhStore_Code = record.WhStore_Code;
wr.WhStore_DepartmentFK = record.WhStore_DepartmentFK;
wr.WhStore_Description = record.WhStore_Description;
wr.WhStore_Id = record.WhStore_Id;
wr.WhStore_TypeFK = record.WhStore_TypeFK;
whseStoreTable.AddTLADM_WhseStoreRow(wr);
}
}
ds.Tables.Add(DeptTable);
ds.Tables.Add(storeTypeTable);
ds.Tables.Add(whseStoreTable);
WhseStore rep = new WhseStore();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 6)
{
DataSet ds = new DataSet();
DataSet6.TLADM_NonStockItemsDataTable nsiTable = new DataSet6.TLADM_NonStockItemsDataTable();
DataSet6.TLADM_NonStockCatDataTable catTable = new DataSet6.TLADM_NonStockCatDataTable();
DataSet6.TLADM_UOMDataTable uomTable = new DataSet6.TLADM_UOMDataTable();
using (var context = new TTI2Entities())
{
var NSI = context.TLADM_NonStockItems.OrderBy(x => x.NSI_Code).ToList();
foreach (var record in NSI)
{
DataSet6.TLADM_NonStockItemsRow nsr = nsiTable.NewTLADM_NonStockItemsRow();
nsr.NSI_Category_FK = record.NSI_Category_FK;
nsr.NSI_Code = record.NSI_Code;
nsr.NSI_Department_PWN = record.NSI_Department_PWN;
nsr.NSI_Description = record.NSI_Description;
nsr.NSI_Pk = record.NSI_Pk;
nsr.NSI_ShowUnitCost = record.NSI_ShowUnitCost;
nsr.NSI_StockType_FK = record.NSI_StockType_FK;
nsr.NSI_UnitCost = record.NSI_UnitCost;
nsr.NSI_UOM_FK = record.NSI_UOM_FK;
nsiTable.AddTLADM_NonStockItemsRow(nsr);
}
var UOM = context.TLADM_UOM.ToList();
foreach (var record in UOM)
{
DataSet6.TLADM_UOMRow uomr = uomTable.NewTLADM_UOMRow();
uomr.UOM_Description = record.UOM_Description;
uomr.UOM_Pk = record.UOM_Pk;
uomr.UOM_ShortCode = record.UOM_ShortCode;
uomTable.AddTLADM_UOMRow(uomr);
}
var CAT = context.TLADM_NonStockCat.ToList();
foreach (var record in CAT)
{
DataSet6.TLADM_NonStockCatRow ncr = catTable.NewTLADM_NonStockCatRow();
ncr.NSC_Description = record.NSC_Description;
ncr.NSC_Pk = record.NSC_Pk;
ncr.NSC_ShortCode = record.NSC_ShortCode;
catTable.AddTLADM_NonStockCatRow(ncr);
}
}
ds.Tables.Add(nsiTable);
ds.Tables.Add(catTable);
ds.Tables.Add(uomTable);
NSIItems rep = new NSIItems();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 7)
{
DataSet ds = new DataSet();
DataSet7.TLADM_DepartmentsDataTable DeptsTable = new DataSet7.TLADM_DepartmentsDataTable();
DataSet7.TLADM_MachineOperatorsDataTable OperatorsTable = new DataSet7.TLADM_MachineOperatorsDataTable();
using (var context = new TTI2Entities())
{
var DT = context.TLADM_Departments.ToList();
foreach (var record in DT)
{
DataSet7.TLADM_DepartmentsRow dtr = DeptsTable.NewTLADM_DepartmentsRow();
dtr.Dep_Description = record.Dep_Description;
dtr.Dep_Id = record.Dep_Id;
dtr.Dep_PowerN = record.Dep_PowerN;
dtr.Dep_ProductType_FK = (int)record.Dep_ProductType_FK;
dtr.Dep_ShortCode = record.Dep_ShortCode;
dtr.Dep_UOM = record.Dep_UOM;
DeptsTable.AddTLADM_DepartmentsRow(dtr);
}
var OPS = context.TLADM_MachineOperators.OrderBy(x => x.MachOp_Department_FK).ToList();
foreach (var record in OPS)
{
DataSet7.TLADM_MachineOperatorsRow opr = OperatorsTable.NewTLADM_MachineOperatorsRow();
opr.MachOp_Code = record.MachOp_Code;
opr.MachOp_Department_FK = record.MachOp_Department_FK;
opr.MachOp_Description = record.MachOp_Description;
opr.MachOp_Inspector = record.MachOp_Inspector;
opr.MachOp_Payroll_Code = record.MachOp_Payroll_Code;
opr.MachOp_Pk = record.MachOp_Pk;
OperatorsTable.AddTLADM_MachineOperatorsRow(opr);
}
}
ds.Tables.Add(DeptsTable);
ds.Tables.Add(OperatorsTable);
OpsByDept rep = new OpsByDept();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 8)
{
DataSet ds = new DataSet();
DataSet8.TLADM_DepartmentsDataTable DeptTable = new DataSet8.TLADM_DepartmentsDataTable();
DataSet8.DataTable1DataTable dataTable1 = new DataSet8.DataTable1DataTable();
using (var context = new TTI2Entities())
{
var Dept = context.TLADM_Departments.ToList();
foreach (var record in Dept)
{
DataSet8.TLADM_DepartmentsRow dr = DeptTable.NewTLADM_DepartmentsRow();
dr.Dep_Description = record.Dep_Description;
dr.Dep_Id = record.Dep_Id;
dr.Dep_PowerN = record.Dep_PowerN;
dr.Dep_ProductType_FK = (int)record.Dep_ProductType_FK;
dr.Dep_ShortCode = record.Dep_ShortCode;
dr.Dep_UOM = record.Dep_UOM;
DeptTable.AddTLADM_DepartmentsRow(dr);
}
var Mach = context.TLADM_MachineDefinitions.OrderBy(x => x.MD_MachineCode).ToList();
foreach (var record in Mach)
{
DataSet8.DataTable1Row mr = dataTable1.NewDataTable1Row();
mr.MD_Code = record.MD_MachineCode;
mr.MD_Description = record.MD_Description;
mr.MD_Department_FK = record.MD_Department_FK;
var dpt = context.TLADM_Departments.Find(record.MD_Department_FK);
if (dpt != null)
{
if (dpt.Dep_ShortCode.Contains("DYE"))
{
var fab = context.TLADM_FabricProduct.Find(record.MD_FabricType_FK);
if (fab != null)
{
mr.MD_SubCode = fab.FP_Description;
}
}
else if (dpt.Dep_ShortCode.Contains("KNIT"))
{
var greig = context.TLADM_Griege.Find(record.MD_GreigeType_FK);
if (greig != null)
{
mr.MD_SubCode = greig.TLGreige_Description;
}
}
else if (dpt.Dep_ShortCode.Contains("SPIN"))
{
var fab = context.TLADM_FabricProduct.Find(record.MD_FabricType_FK);
if (fab != null)
{
mr.MD_SubCode = fab.FP_Description;
}
}
}
mr.MD_CapacityMax = record.MD_MaxCapacity;
mr.MD_CapacityRealistic = record.MD_Realistic;
mr.MD_UOM = "Kg";
mr.MD_Measure1 = (int)record.MD_FirstMeasure_Qty;
if (record.MD_SecMeasure_Qty != null)
{
mr.MD_Measure2 = (int)record.MD_SecMeasure_Qty;
}
if (record.MD_ThirdMeasure_Qty != null)
{
mr.MD_Measure3 = (int)record.MD_ThirdMeasure_Qty;
}
// mr.MD_SerialNo = record.MD_SerialNo;
mr.MD_SerialNo = record.MD_LastNumberUsed.ToString();
dataTable1.AddDataTable1Row(mr);
}
}
ds.Tables.Add(DeptTable);
ds.Tables.Add(dataTable1);
ListOfMachines rep = new ListOfMachines();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 9)
{
DataSet ds = new DataSet();
DataSet9.TLADM_ConsumablesDCDataTable dataTable = new DataSet9.TLADM_ConsumablesDCDataTable();
DataSet9.TLADM_UOMDataTable uomTable = new DataSet9.TLADM_UOMDataTable();
using (var context = new TTI2Entities())
{
var ExistingData = context.TLADM_ConsumablesDC.OrderBy(x => x.ConsDC_Code).ToList();
foreach (var row in ExistingData)
{
DataSet9.TLADM_ConsumablesDCRow dcr = dataTable.NewTLADM_ConsumablesDCRow();
dcr.ConsDC_Code = row.ConsDC_Code;
dcr.ConsDC_Description = row.ConsDC_Description;
dcr.ConsDC_Economic_ReOrderQty = row.ConsDC_Economic_ReOrderQty;
dcr.ConsDC_MinReorderQty = row.ConsDC_MinReorderQty;
dcr.ConsDC_Pk = row.ConsDC_Pk;
dcr.ConsDC_StandardCost = row.ConsDC_StandardCost;
dcr.ConsDC_UOM_Fk = row.ConsDC_UOM_Fk;
dcr.ConsDC_ReOrderLevel = row.ConsDC_ReOrderLevel;
dcr.ConsDC_Discontinued = row.ConsDC_Discontinued;
if (row.ConsDC_DiscontinuedDate != null)
{
dcr.ConsDC_DiscontinuedDate = (DateTime)row.ConsDC_DiscontinuedDate;
}
dataTable.AddTLADM_ConsumablesDCRow(dcr);
}
var UOM = context.TLADM_UOM.ToList();
foreach (var row in UOM)
{
DataSet9.TLADM_UOMRow ur = uomTable.NewTLADM_UOMRow();
ur.UOM_Description = row.UOM_Description;
ur.UOM_Pk = row.UOM_Pk;
ur.UOM_ShortCode = row.UOM_ShortCode;
uomTable.AddTLADM_UOMRow(ur);
}
}
ds.Tables.Add(dataTable);
ds.Tables.Add(uomTable);
ConsumableStock rep = new ConsumableStock();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 10)
{
DataSet ds = new DataSet();
DataSet10.TLADM_ConsumablesOtherDataTable dataTable = new DataSet10.TLADM_ConsumablesOtherDataTable();
DataSet10.TLADM_UOMDataTable uomTable = new DataSet10.TLADM_UOMDataTable();
DataSet10.TLADM_StockTypesDataTable stockTable = new DataSet10.TLADM_StockTypesDataTable();
using (var context = new TTI2Entities())
{
var ExistingData = context.TLADM_ConsumablesOther.OrderBy(x => x.ConsOther_Code).ToList();
foreach (var row in ExistingData)
{
DataSet10.TLADM_ConsumablesOtherRow cor = dataTable.NewTLADM_ConsumablesOtherRow();
cor.ConsOther_Code = row.ConsOther_Code;
cor.ConsOther_Description = row.ConsOther_Description;
cor.ConsOther_EconomicReOrderQty = row.ConsOther_EconomicReOrderQty;
cor.ConsOther_Pk = row.ConsOther_Pk;
cor.ConsOther_ReOrderLevel = row.ConsOther_ReOrderLevel;
cor.ConsOther_StdCost = row.ConsOther_StdCost;
cor.ConsOther_StockType_Fk = row.ConsOther_StockType_Fk;
cor.ConsOther_UOM_FK = row.ConsOther_UOM_FK;
dataTable.AddTLADM_ConsumablesOtherRow(cor);
}
var UOM = context.TLADM_UOM.ToList();
foreach (var row in UOM)
{
DataSet10.TLADM_UOMRow ur = uomTable.NewTLADM_UOMRow();
ur.UOM_Description = row.UOM_Description;
ur.UOM_Pk = row.UOM_Pk;
ur.UOM_ShortCode = row.UOM_ShortCode;
uomTable.AddTLADM_UOMRow(ur);
}
var ST = context.TLADM_StockTypes.ToList();
foreach (var row in ST)
{
DataSet10.TLADM_StockTypesRow tr = stockTable.NewTLADM_StockTypesRow();
tr.ST_Id = row.ST_Id;
tr.ST_ShortCode = row.ST_ShortCode;
tr.ST_Description = row.ST_Description;
stockTable.AddTLADM_StockTypesRow(tr);
}
}
ds.Tables.Add(dataTable);
ds.Tables.Add(uomTable);
ds.Tables.Add(stockTable);
ConsumableStockOther rep = new ConsumableStockOther();
rep.SetDataSource(ds);
crystalReportViewer1.ReportSource = rep;
}
else if (_RepNo == 11)
{
DataSet ds = new DataSet();
DataSet11.DataTable1DataTable dataTable1 = new DataSet11.DataTable1DataTable();
using (var context = new TTI2Entities())
{
var Existing = context.TLADM_TranactionType.OrderBy(x => x.TrxT_Department_FK).ThenBy(x => x.TrxT_Number).ToList();
foreach (var Department in Existing)
{
DataSet11.DataTable1Row nr = dataTable1.NewDataTable1Row();
nr.Department = context.TLADM_Departments.Find(Department.TrxT_Department_FK).Dep_Description;
nr.TransNumber = Department.TrxT_Number;
nr.TransDescription = Department.TrxT_Description;
nr.FromWareHouse = context.TLADM_WhseStore.Find(Department.TrxT_FromWhse_FK).WhStore_Description;
nr.ToWareHouse = context.TLADM_WhseStore.Find(Department.TrxT_ToWhse_FK).WhStore_Description;
dataTable1.AddDataTable1Row(nr);
}
}
ds.Tables.Add(dataTable1);
TransTypes TransTypes = new TransTypes();
TransTypes.SetDataSource(ds);
crystalReportViewer1.ReportSource = TransTypes;
}
else if (_RepNo == 12)
{
DataSet ds = new DataSet();
DataSet12.DataTable1DataTable dataTable1 = new DataSet12.DataTable1DataTable();
DataSet12.DataTable2DataTable dataTable2 = new DataSet12.DataTable2DataTable();
Util core = new Util();
IList <int> Sizes = null;
using (var context = new TTI2Entities())
{
var ProductRatings = context.TLADM_ProductRating.OrderBy(x => x.Pr_Customer_FK).ToList();
ProductRatings = ProductRatings.OrderByDescending(x => x.Pr_BodyorRibbing).ToList();
foreach (var ProductRating in ProductRatings)
{
DataSet12.DataTable1Row nr = dataTable1.NewDataTable1Row();
nr.Pk = ProductRating.Pr_Id;
var Customer = context.TLADM_CustomerFile.Find(ProductRating.Pr_Customer_FK);
if (Customer == null)
{
continue;
}
nr.Customer = Customer.Cust_Description;
nr.Style = context.TLADM_Styles.Find(ProductRating.Pr_Style_FK).Sty_Description;
if (ProductRating.Pr_BodyorRibbing == 1)
{
StringBuilder sb = new StringBuilder();
int cnt = 0;
List <int> xx = core.ExtrapNumber(ProductRating.Pr_PowerN, context.TLADM_Sizes.Count());
xx.Sort();
foreach (var Size in xx)
{
var SI = context.TLADM_Sizes.Where(x => x.SI_PowerN == Size).FirstOrDefault();
if (SI != null)
{
sb.Append(SI.SI_Description);
}
if (++cnt < xx.Count)
{
sb.Append(",");
}
}
nr.Display = sb.ToString();
}
else
{
nr.Display = context.TLADM_Trims.Find(ProductRating.Pr_Trim_FK).TR_Description;
}
nr.Ratio = ProductRating.Pr_Ratio;
nr.Marker_Length = ProductRating.Pr_Marker_Length;
nr.Numeric_Rating = ProductRating.Pr_numeric_Rating;
if (ProductRating.Pr_BodyorRibbing == 1)
{
nr.Body = true;
}
else
{
nr.Body = false;
}
dataTable1.AddDataTable1Row(nr);
var Details = context.TLADM_ProductRating_Detail.Where(x => x.prd_Parent_FK == ProductRating.Pr_Id).ToList();
foreach (var Detail in Details)
{
DataSet12.DataTable2Row xnr = dataTable2.NewDataTable2Row();
xnr.Pk = ProductRating.Pr_Id;
xnr.Size = context.TLADM_Sizes.Find(Detail.Prd_SizePN).SI_Description;
xnr.Ratio = Detail.Prd_MarkerRatio;
dataTable2.AddDataTable2Row(xnr);
}
}
}
ds.Tables.Add(dataTable1);
ds.Tables.Add(dataTable2);
ProductRating TransTypes = new ProductRating();
TransTypes.SetDataSource(ds);
crystalReportViewer1.ReportSource = TransTypes;
}
crystalReportViewer1.Refresh();
}