private FabricReportDS GetFabricData(string FabricData)
{
string con = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
if ((con.ToLower().StartsWith("metadata=")))
{
EntityConnectionStringBuilder RefineCon = new EntityConnectionStringBuilder(con);
con = RefineCon.ProviderConnectionString;
}
string fabCon = con;
SqlCommand cmd = new SqlCommand(FabricData);
using (SqlConnection sqlCon = new SqlConnection(fabCon))
{
using (SqlDataAdapter adap = new SqlDataAdapter())
{
cmd.Connection = sqlCon;
adap.SelectCommand = cmd;
using (FabricReportDS fabricData = new FabricReportDS())
{
adap.Fill(fabricData, "FabricReportDS");
return(fabricData);
}
}
}
}
protected void btnDetails_Click(object sender, EventArgs e)
{
try
{
//if (Convert.ToInt32(ddlFactory.SelectedValue) >= 0)
//{
string FabricData;
string FactoryPara = ddlFactory.SelectedItem.Text;
string FactoryId = ddlFactory.SelectedValue;
// string FabricData = "SELECT dbo.Fabrics.FabricId, dbo.Suppliers.SupplierName AS Supplier, dbo.Fabrics.Quality, dbo.Fabrics.Compisition1, dbo.Fabrics.Compisition2, dbo.Fabrics.Compisition3, dbo.Fabrics.Compisition4, dbo.Fabrics.Compisition5, " +
//"dbo.Constructions.ConstructionType AS Construction, dbo.Yarns.YarnCount, dbo.Fabrics.WidthInches, dbo.Fabrics.WidthCm, dbo.Fabrics.AddedDate, dbo.Fabrics.Weight, dbo.Fabrics.Price, dbo.Locations.LocationName AS Location, " +
//"dbo.Knits.KnitType AS Knit, dbo.Structures.StructureValue AS Structure, dbo.Colours.ColourName AS Colour, dbo.Factories.FactoryName AS Factory, dbo.FabCatoes.FabricCat AS FabricCategory, dbo.Fabrics.Remarks, " +
//"dbo.FinishCatoes.FinishCat AS FinishingCategory " +
//"FROM dbo.Colours INNER JOIN " +
//"dbo.Fabrics ON dbo.Colours.ColourId = dbo.Fabrics.ColourId INNER JOIN " +
//"dbo.Constructions ON dbo.Fabrics.ConstructionId = dbo.Constructions.ConstructionId INNER JOIN " +
//"dbo.FabCatoes ON dbo.Fabrics.FabCatoId = dbo.FabCatoes.FabCatoId INNER JOIN " +
//"dbo.Factories ON dbo.Fabrics.FactoryId = dbo.Factories.FactoryId INNER JOIN " +
//"dbo.Knits ON dbo.Fabrics.KnitId = dbo.Knits.KnitId INNER JOIN " +
//"dbo.Locations ON dbo.Fabrics.LocationsId = dbo.Locations.LocationsId INNER JOIN " +
//"dbo.Structures ON dbo.Fabrics.StructureId = dbo.Structures.StructureId INNER JOIN " +
//"dbo.Suppliers ON dbo.Fabrics.SupplierId = dbo.Suppliers.SupplierId INNER JOIN " +
//"dbo.Yarns ON dbo.Fabrics.YarnId = dbo.Yarns.YarnId INNER JOIN " +
//"dbo.FinishCatoes ON dbo.Fabrics.FinishCatoId = dbo.FinishCatoes.FinishCatoId " +
//"WHERE(dbo.Factories.FactoryId = '" + ddlFactory.SelectedValue + "')";
if (FactoryId != "ALL")
{
FabricData = "SELECT dbo.Fabrics.FabricId, dbo.Suppliers.SupplierName AS Supplier, dbo.Fabrics.Quality, dbo.Fabrics.Compisition1, dbo.Fabrics.Compisition2, dbo.Fabrics.Compisition3, dbo.Fabrics.Compisition4, dbo.Fabrics.Compisition5, " +
"dbo.Constructions.ConstructionType AS Construction, dbo.Yarns.YarnCount, dbo.Fabrics.WidthInches, dbo.Fabrics.WidthCm, dbo.Fabrics.AddedDate, dbo.Fabrics.Weight, dbo.Fabrics.Price, dbo.Locations.LocationName AS Location, " +
"dbo.Knits.KnitType AS Knit, dbo.Structures.StructureValue AS Structure, dbo.Colours.ColourName AS Colour, dbo.Factories.FactoryName AS Factory, dbo.FabCatoes.FabricCat AS FabricCategory, dbo.Fabrics.Remarks, " +
"dbo.FinishCatoes.FinishCat AS FinishingCategory, dbo.Fabrics.SourcingRoute, dbo.Fabrics.LeadTime, dbo.Fabrics.SustainableProduct, dbo.Fabrics.YarnGuage, dbo.SourcingTypes.SourcingTypeName, " +
"dbo.ProductCatagories.ProductCatagoryName " +
"FROM dbo.Colours INNER JOIN " +
"dbo.Fabrics ON dbo.Colours.ColourId = dbo.Fabrics.ColourId INNER JOIN " +
"dbo.Constructions ON dbo.Fabrics.ConstructionId = dbo.Constructions.ConstructionId INNER JOIN " +
"dbo.FabCatoes ON dbo.Fabrics.FabCatoId = dbo.FabCatoes.FabCatoId INNER JOIN " +
"dbo.Factories ON dbo.Fabrics.FactoryId = dbo.Factories.FactoryId INNER JOIN " +
"dbo.Knits ON dbo.Fabrics.KnitId = dbo.Knits.KnitId INNER JOIN " +
"dbo.Locations ON dbo.Fabrics.LocationsId = dbo.Locations.LocationsId INNER JOIN " +
"dbo.Structures ON dbo.Fabrics.StructureId = dbo.Structures.StructureId INNER JOIN " +
"dbo.Suppliers ON dbo.Fabrics.SupplierId = dbo.Suppliers.SupplierId INNER JOIN " +
"dbo.Yarns ON dbo.Fabrics.YarnId = dbo.Yarns.YarnId INNER JOIN " +
"dbo.FinishCatoes ON dbo.Fabrics.FinishCatoId = dbo.FinishCatoes.FinishCatoId INNER JOIN " +
"dbo.ProductCatagories ON dbo.Fabrics.ProductCatagoryId = dbo.ProductCatagories.ProductCatagoryId INNER JOIN " +
"dbo.SourcingTypes ON dbo.Fabrics.SourcingTypeId = dbo.SourcingTypes.SourcingTypeId " +
"WHERE (dbo.Factories.FactoryId = '" + FactoryId + "') AND (dbo.Fabrics.IsDeleted = 0) " +
"ORDER BY dbo.Fabrics.FabricId";
}
else
{
FabricData = "SELECT dbo.Fabrics.FabricId, dbo.Suppliers.SupplierName AS Supplier, dbo.Fabrics.Quality, dbo.Fabrics.Compisition1, dbo.Fabrics.Compisition2, dbo.Fabrics.Compisition3, dbo.Fabrics.Compisition4, dbo.Fabrics.Compisition5, " +
"dbo.Constructions.ConstructionType AS Construction, dbo.Yarns.YarnCount, dbo.Fabrics.WidthInches, dbo.Fabrics.WidthCm, dbo.Fabrics.AddedDate, dbo.Fabrics.Weight, dbo.Fabrics.Price, dbo.Locations.LocationName AS Location, " +
"dbo.Knits.KnitType AS Knit, dbo.Structures.StructureValue AS Structure, dbo.Colours.ColourName AS Colour, dbo.Factories.FactoryName AS Factory, dbo.FabCatoes.FabricCat AS FabricCategory, dbo.Fabrics.Remarks, " +
"dbo.FinishCatoes.FinishCat AS FinishingCategory, dbo.Fabrics.SourcingRoute, dbo.Fabrics.LeadTime, dbo.Fabrics.SustainableProduct, dbo.Fabrics.YarnGuage, dbo.SourcingTypes.SourcingTypeName, " +
"dbo.ProductCatagories.ProductCatagoryName " +
"FROM dbo.Colours INNER JOIN " +
"dbo.Fabrics ON dbo.Colours.ColourId = dbo.Fabrics.ColourId INNER JOIN " +
"dbo.Constructions ON dbo.Fabrics.ConstructionId = dbo.Constructions.ConstructionId INNER JOIN " +
"dbo.FabCatoes ON dbo.Fabrics.FabCatoId = dbo.FabCatoes.FabCatoId INNER JOIN " +
"dbo.Factories ON dbo.Fabrics.FactoryId = dbo.Factories.FactoryId INNER JOIN " +
"dbo.Knits ON dbo.Fabrics.KnitId = dbo.Knits.KnitId INNER JOIN " +
"dbo.Locations ON dbo.Fabrics.LocationsId = dbo.Locations.LocationsId INNER JOIN " +
"dbo.Structures ON dbo.Fabrics.StructureId = dbo.Structures.StructureId INNER JOIN " +
"dbo.Suppliers ON dbo.Fabrics.SupplierId = dbo.Suppliers.SupplierId INNER JOIN " +
"dbo.Yarns ON dbo.Fabrics.YarnId = dbo.Yarns.YarnId INNER JOIN " +
"dbo.FinishCatoes ON dbo.Fabrics.FinishCatoId = dbo.FinishCatoes.FinishCatoId INNER JOIN " +
"dbo.ProductCatagories ON dbo.Fabrics.ProductCatagoryId = dbo.ProductCatagories.ProductCatagoryId INNER JOIN " +
"dbo.SourcingTypes ON dbo.Fabrics.SourcingTypeId = dbo.SourcingTypes.SourcingTypeId " +
"WHERE (dbo.Fabrics.IsDeleted = 0) " +
"ORDER BY dbo.Fabrics.FabricId";
}
rvFabrics.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
rvFabrics.LocalReport.ReportPath = Server.MapPath("/Reports/FabricReportWizard.rdlc");
FabricReportDS fabricListData = GetFabricData(FabricData);
ReportDataSource RptSource = new ReportDataSource("FabricReportDS", fabricListData.Tables[0]);
rvFabrics.LocalReport.DataSources.Clear();
rvFabrics.LocalReport.DataSources.Add(RptSource);
ReportParameter Factory = new ReportParameter("FactoryName", FactoryPara);
this.rvFabrics.LocalReport.SetParameters(new ReportParameter[] { Factory });
//}
//else
//{
// lblMessage.InnerText = "Select a Factory";
//}
}
catch (Exception ex)
{
lblMessage.InnerText = ex.Message.ToString();
}
}
