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