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