public void GetProductsWithNoCategoryImperativeTest() { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> productTable = db.GetTable <Product>(); List <Product> allProducts = (from product in productTable select product).ToList(); Assert.AreEqual(209, allProducts.GetProductsWithNoCategoryImperative().Count); } }
public MainWindow() { InitializeComponent(); string connestionString = ConfigurationManager.ConnectionStrings ["LINQToSQL.Properties.Settings.C_MasterclassConnectionString"].ConnectionString; dataContext = new LINQToSQLDataContext(connestionString); //InsertUniviersities("Kyiv Politech"); //InsertStudents(); InsertLectures(); }
public static List <Product> GetNProductsFromCategory(string categoryName, int n) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> products = db.GetTable <Product>(); List <Product> result = (from product in products orderby product.ProductSubcategory.Name.Equals(categoryName) select product).Take(n).ToList(); return(result); } }
public static List <Product> GetProductsByName(string namePart) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> products = db.GetTable <Product>(); List <Product> result = (from product in products where product.Name.Contains(namePart) select product).ToList(); return(result); } }
public static List <Product> GetNRecentlyReviewedProducts(int howManyProducts) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { List <Product> result = (from product in db.Product join review in db.ProductReview on product.ProductID equals review.ProductID orderby review.ReviewDate descending select product).Take(howManyProducts).ToList(); return(result); } }
public static List <Product> GetProductsWithNRecentReviews(int howManyReviews) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> products = db.GetTable <Product>(); List <Product> result = (from product in products where product.ProductReview.Count == howManyReviews select product).ToList(); return(result); } }
public static string GetProductVendorByProductName(string productName) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <ProductVendor> vendors = db.GetTable <ProductVendor>(); String result = (from vendor in vendors where vendor.Product.Name.Equals(productName) select vendor.Vendor.Name).First(); return(result); } }
public static List <string> GetProductNamesByVendorName(string vendorName) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <ProductVendor> vendors = db.GetTable <ProductVendor>(); List <String> result = (from vendor in vendors where vendor.Vendor.Name.Equals(vendorName) select vendor.Product.Name).ToList(); return(result); } }
public static List <MyProduct> GetMyProductsByVendorName(this List <MyProduct> myProducts, string vendorName) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <ProductVendor> vendors = db.GetTable <ProductVendor>(); return((from myProduct in myProducts join vendor in db.ProductVendor on myProduct.ProductID equals vendor.ProductID where vendor.Vendor.Name == vendorName select myProduct).ToList()); } }
public static int GetTotalStandardCostByCategory(ProductCategory category) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> products = db.GetTable <Product>();; int result = (int)(from product in products where (product.ProductSubcategory.ProductCategory.ProductCategoryID.Equals(category.ProductCategoryID) && product.ProductSubcategory.ProductCategory.Name.Equals(category.Name)) select product.StandardCost).ToList().Sum(); return(result); } }
public void GetNProductsOnPageImperativeTest() { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> productTable = db.GetTable <Product>(); List <Product> allProducts = (from product in productTable select product).ToList(); List <Product> result = allProducts.GetNProductsOnPageImperative(3, 2); Assert.AreEqual(3, result.Count); Assert.AreEqual(4, result.ElementAt(0).ProductID); Assert.AreEqual(316, result.ElementAt(1).ProductID); Assert.AreEqual(317, result.ElementAt(2).ProductID); } }
private static void FillMyProducts(List <MyProduct> myProducts) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> productTable = db.GetTable <Product>(); List <Product> products = (from product in productTable select product).Take(100).ToList(); string[] countries = { "Poland", "Germany", "USA" }; Random random = new Random(); foreach (Product p in products) { myProducts.Add(new MyProduct(p, countries[random.Next(0, countries.Length)])); } } }
public void GetProductAndVendorNamesTest() { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <Product> productTable = db.GetTable <Product>(); List <Product> allProducts = (from product in productTable select product).ToList(); string result = allProducts.GetProductAndVendorNames(); Assert.AreEqual(460, result.Split(new[] { Environment.NewLine }, StringSplitOptions.None).Length); Assert.AreEqual("Adjustable Race - Litware, Inc.", result.Split(new[] { Environment.NewLine }, StringSplitOptions.None).First()); Assert.AreEqual("Chain - Varsity Sport Co.", result.Split(new[] { Environment.NewLine }, StringSplitOptions.None).Last()); } }
public static string GetProductAndVendorNames(this List <Product> products) { using (LINQToSQLDataContext db = new LINQToSQLDataContext()) { Table <ProductVendor> productVendorTable = db.GetTable <ProductVendor>(); List <ProductVendor> productVendorAll = (from productVendor in productVendorTable select productVendor).ToList(); var query = from p in products from pv in productVendorAll where p.ProductID == pv.ProductID select new { ProductName = p.Name, VendorName = pv.Vendor.Name }; return(String.Join(Environment.NewLine, (from q in query select q.ProductName + " - " + q.VendorName).ToList())); } }
public MainWindow() { InitializeComponent(); connectionString = ConfigurationManager.ConnectionStrings["MyClinic.Properties.Settings.ClinicConnectionString"].ToString(); Db = new LINQToSQLDataContext(connectionString); clinicEmployees = new DataTable(); specialists = new DataTable(); medicines = new DataTable(); medicalServices = new DataTable("MedicalServices"); connection = new SqlConnection("Data Source=ASIA-HP;Initial Catalog=Clinic;Persist Security Info=True;User ID=sa;Password=praktyka"); adapter = new SqlDataAdapter(); Update_combobox(specialists, comboBoxSchedulerDoctor, "select * from specialists_view", "{0} - {1} {2}", "MedicalSpecializationName", "FirstName", "LastName"); Update_combobox(medicalServices, comboBoxSchedulerService, "select * from MedicalServices", "{0} {1}", "ServiceName", "ServiceDescription"); Update_combobox(medicalServices, comboBoxServicesServiceName, "select * from MedicalServices", "{0} {1}", "ServiceName", "ServiceDescription"); Update_combobox(clinicEmployees, comboBoxVisitDoctor, "select * from specialists_view", "{0} - {1} {2}", "MedicalSpecializationName", "FirstName", "LastName"); Update_combobox(clinicEmployees, comboBoxServicesDoctor, "select * from ClinicEmployees", "{0} {1}", "FirstName", "LastName"); Update_combobox(medicines, comboBoxSelectMedicines, "select * from Medicines", "{0} {1}", "MedicineName", "Amount"); FillAutoCompleteValues(textBoxSchedulerPesel, Db.Patients.Select(patient => patient.PESEL).ToArray()); FillAutoCompleteValues(textBoxVisitPesel, Db.Patients.Select(patient => patient.PESEL).ToArray()); FillAutoCompleteValues(textBoxSchedulerLastName, Db.Patients.Select(patient => patient.LastName).Distinct().ToArray()); FillAutoCompleteValues(textBoxLastNameSchedulerExamination, Db.Patients.Select(patient => patient.LastName).Distinct().ToArray()); FillAutoCompleteValues(textBoxServicesPesel, Db.Patients.Select(patient => patient.PESEL).ToArray()); FillAutoCompleteValues(textBoxPeselSchedulerExamination, Db.Patients.Select(patient => patient.PESEL).ToArray()); patients_viewBindingSource.Filter = "Zapisany = 1"; visitBasics_viewBindingSource.Filter = string.Format("EmployeeID = {0} and VisitDate >= '{1}' and VisitDate <= '{2}'", Authenticator.Instance.LoggedEmployee.EmployeeID, DateTime.Now.Date, DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59)); e_viewBindingSource.Filter = string.Format("ExaminationDate >= '{0}' and ExaminationDate <= '{1}'", DateTime.Now.Date, DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59)); ControllAccess(); Instance = this; }
public DepartmentRepository() { dataContext = new LINQToSQLDataContext(); departments = dataContext.GetTable <Department>(); employeeDepartments = dataContext.GetTable <EmployeeDepartmentHistory>(); }