public DataTable GetDataTable(ItemsSummeryClass itemsSummeryClass)
{
SqlCommand command = new SqlCommand(@"Select * From vm_StockIn WHERE CompanyName='" + itemsSummeryClass.CompanyName + "' " + itemsSummeryClass.Operation + " CategoryName='" + itemsSummeryClass.CategoryName + "'", connection);
connection.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(command);
da.Fill(dt);
connection.Close();
return(dt);
}
public DataTable GetDataTable(ItemsSummeryClass itemsSummeryClass)
{
if (itemsSummeryClass.CompanyName != "----Select----" &&
itemsSummeryClass.CategoryName != "----Select----")
{
if (itemsSummeryClass.CompanyName != String.Empty && itemsSummeryClass.CategoryName != String.Empty)
{
itemsSummeryClass.Operation = "AND";
}
else if (itemsSummeryClass.CompanyName != String.Empty || itemsSummeryClass.CategoryName != String.Empty)
{
itemsSummeryClass.Operation = "OR";
}
else
{
throw new Exception("Select a Company or Category to View Item summary");
}
}
else if (itemsSummeryClass.CompanyName == "----Select----" ||
itemsSummeryClass.CategoryName == "----Select----")
{
if (itemsSummeryClass.CompanyName != String.Empty &&
itemsSummeryClass.CategoryName != String.Empty)
{
itemsSummeryClass.Operation = "OR";
}
else
{
throw new Exception("Select a Company or Category to View Item summary");
}
}
else
{
throw new Exception("Select a Company or Category to View Item summary");
}
DataTable dt = new DataTable();
dt = itemsSummeryRepository.GetDataTable(itemsSummeryClass);
return(dt);
}
