public void AddToTypesOfOffices()
{
using (var context = new BusinessCodingModelContex())
{
TypesOfOffices tmp = new TypesOfOffices();
tmp.Capacity = 10;
tmp.CostOfHiring = 10;
tmp.Name = "testUnit";
context.TypesOfOffices.Add(tmp);
}
}
public void AddToTypesOfEmployees()
{
using (var context = new BusinessCodingModelContex())
{
TypesOfEmployees tmp = new TypesOfEmployees();
tmp.Codity = 10;
tmp.Name = "testUnit";
tmp.Salary = 10;
context.TypesOfEmployees.Add(tmp);
}
}
public void AddToDescriptions()
{
using (var contex = new BusinessCodingModelContex())
{
Descriptions tmp = new Descriptions();
tmp.String = "testUnit";
var restult = from x in contex.Projects where x.Name == "Nowy iOS" select x;
tmp.ProjectsProjectID = restult.First().ProjectID;
contex.Descriptions.Add(tmp);
}
}
/// <summary>
/// Dodanie rekordu do tabeli Companies.
/// </summary>
/// <param name="entryForm">okno z którego pobieramy dane</param>
private void AddRecordToCompanies(object entry)
{
Companies newCompany = (Companies)entry;
using (var db = new BusinessCodingModelContex())
{
try
{
newCompany.CompanyID = db.Companies.Max(x => x.CompanyID) + 1;
}
catch
{
newCompany.CompanyID = 1;
}
db.Companies.Add(newCompany);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to add a good reference.");
return;
}
Thread newThread = new Thread(DisplayAllRecordsFromCompanies);
newThread.Start();
}
}
private void ModyfingUsersInNewThread()
{
using (var db = new BusinessCodingModelContex())
{
db.Users.Attach(selectedUser);
var entry = db.Entry(selectedUser);
entry.Property(x => x.ActivationDate).IsModified = true;
entry.Property(x => x.Email).IsModified = true;
entry.Property(x => x.LastLogin).IsModified = true;
entry.Property(x => x.Login).IsModified = true;
entry.Property(x => x.Password).IsModified = true;
db.SaveChanges();
}
Thread newThread = new Thread(DisplayAllRecordsFromUsers);
newThread.Start();
}
private void ModyfingProjectsInNewThread()
{
using (var db = new BusinessCodingModelContex())
{
db.Projects.Attach(selectedProject);
var entry = db.Entry(selectedProject);
entry.Property(x => x.CompaniesCompanyID).IsModified = true;
entry.Property(x => x.Complexity).IsModified = true;
entry.Property(x => x.Gratification).IsModified = true;
entry.Property(x => x.MinCodity).IsModified = true;
entry.Property(x => x.MinRespect).IsModified = true;
entry.Property(x => x.Name).IsModified = true;
entry.Property(x => x.TimeRounds).IsModified = true;
entry.Property(x => x.TimeToEnd).IsModified = true;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to give a reference to existing record.");
}
}
Thread newThread = new Thread(DisplayAllRecordsFromProjects);
newThread.Start();
}
public void TestAddTOoUsers()
{
using (var context = new BusinessCodingModelContex())
{
context.Users.Add(new Users()
{
UserID = 100,
Login = "******",
Password = "******",
Email = "*****@*****.**",
ActivationDate = DateTime.Parse("2013-11-05 22:12:28.990"),
LastLogin = DateTime.Parse("2013-11-05 22:12:28.990")
});
}
}
/// <summary>
/// Usuwanie zaznaczonego elementu z tabeli "Users"
/// </summary>
private void DeleteRecordFromUsers()
{
using (var db = new BusinessCodingModelContex())
{
try
{
db.Users.Attach(selectedUser);
db.Users.Remove(selectedUser);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error!");
return;
}
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("Cannot delete a record to which reference is.");
return;
}
Thread newThread = new Thread(DisplayAllRecordsFromUsers);
newThread.Start();
}
}
/// <summary>
/// Dodanie rekordu do tabeli Users.
/// </summary>
/// <param name="entryForm">okno z którego pobieramy dane</param>
private void AddRecordToUsers(object entry)
{
Users newUser = (Users)entry;
using (var db = new BusinessCodingModelContex())
{
try
{
newUser.UserID = db.Users.Max(x => x.UserID) + 1;
}
catch
{
newUser.UserID = 1;
}
db.Users.Add(newUser);
db.SaveChanges();
Thread newThread = new Thread(DisplayAllRecordsFromUsers);
newThread.Start();
}
}
/// <summary>
/// Dodanie rekordu do tabeli Projects.
/// </summary>
/// <param name="entryForm">okno z którego pobieramy dane</param>
private void AddRecordToProjects(object entry)
{
Projects newProject = (Projects)entry;
using (var db = new BusinessCodingModelContex())
{
try
{
newProject.ProjectID = db.Projects.Max(x => x.ProjectID) + 1;
}
catch
{
newProject.ProjectID = 1;
}
db.Projects.Add(newProject);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to add a good reference.");
return;
}
Thread newThread = new Thread(DisplayAllRecordsFromProjects);
newThread.Start();
}
}
public void TestAddToCompanies()
{
using (var context = new BusinessCodingModelContex())
{
Companies tmp = new Companies();
tmp.CostOfLiving = 12;
tmp.Money = 3242;
tmp.Name = "testUnit";
tmp.Respect = 12;
var result1 = from x in context.TypesOfOffices where x.Name == "Duże biuro" select x;
tmp.TypesOfOfficesTOOfficeID = result1.First().TOOfficeID;
var result2 = from x in context.Users where x.Login == "test3" select x;
tmp.UsersUserID = result2.First().UserID;
context.Companies.Add(tmp);
}
}
public void Initialize()
{
DbConnection connection = Effort.DbConnectionFactory.CreateTransient();
_context = new BusinessCodingModelContex(connection);
}
public void TestAddToProject()
{
using (var context = new BusinessCodingModelContex())
{
Projects tmp = new Projects();
var result1 = from x in context.Companies where x.Name == "Apple Inc." select x;
tmp.CompaniesCompanyID = result1.First().CompanyID;
tmp.Complexity = 10;
tmp.Gratification = 10000;
tmp.MinCodity = 10;
tmp.MinRespect = 10;
tmp.Name = "testUnit";
tmp.TimeRounds = 10;
tmp.TimeToEnd = 10;
context.Projects.Add(tmp);
}
}
/// <summary>
/// Dodanie rekordu do tabeli Descriptions.
/// </summary>
/// <param name="entryForm">okno z którego pobieramy dane</param>
private void AddRecordToDescriptions(object entry)
{
Descriptions newDescription = (Descriptions)entry;
using (var db = new BusinessCodingModelContex())
{
try
{
newDescription.DescriptionID = db.Descriptions.Max(x => x.DescriptionID) + 1;
}
catch
{
newDescription.DescriptionID = 1;
}
db.Descriptions.Add(newDescription);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to add a good reference.");
return;
}
Thread newThread = new Thread(DisplayAllRecordsFromDescriptions);
newThread.Start();
}
}
private void ModifyingCompaniesInNewThread()
{
using (var db = new BusinessCodingModelContex())
{
db.Companies.Attach(selectedCompany);
var entry = db.Entry(selectedCompany);
entry.Property(x => x.CostOfLiving).IsModified = true;
entry.Property(x => x.Money).IsModified = true;
entry.Property(x => x.Name).IsModified = true;
entry.Property(x => x.Respect).IsModified = true;
entry.Property(x => x.TypesOfOfficesTOOfficeID).IsModified = true;
entry.Property(x => x.UsersUserID).IsModified = true;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to give a reference to existing record.");
}
}
Thread newThread = new Thread(DisplayAllRecordsFromCompanies);
newThread.Start();
}
/// <summary>
/// Dodanie rekordu do tabeli Employees.
/// </summary>
/// <param name="entryForm">okno z którego pobieramy dane</param>
private void AddRecordToEmployees(object entry)
{
Empolyees newEmployee = (Empolyees)entry;
using (var db = new BusinessCodingModelContex())
{
try
{
newEmployee.EmployeeID = db.Empolyees.Max(x => x.EmployeeID) + 1;
}
catch
{
newEmployee.EmployeeID = 1;
}
db.Empolyees.Add(newEmployee);
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to add a good reference.");
return;
}
Thread newThread = new Thread(DisplayAllRecordsFromEmployees);
newThread.Start();
}
}
private void ModifyingDescriptionsInNewThread()
{
using (var db = new BusinessCodingModelContex())
{
db.Descriptions.Attach(selectedDesciption);
var entry = db.Entry(selectedDesciption);
entry.Property(x => x.ProjectsProjectID).IsModified = true;
entry.Property(x => x.String).IsModified = true;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to give a reference to existing record.");
}
}
Thread newThread = new Thread(DisplayAllRecordsFromDescriptions);
newThread.Start();
}
/// <summary>
/// Dodanie rekordu do tabeli TypesOfOffices.
/// </summary>
/// <param name="entryForm">okno z którego pobieramy dane</param>
private void AddRecordToTypesOfOffices(object entry)
{
TypesOfOffices too = (TypesOfOffices)entry;
using (var db = new BusinessCodingModelContex())
{
try
{
too.TOOfficeID = db.TypesOfOffices.Max(x => x.TOOfficeID) + 1;
}
catch
{
too.TOOfficeID = 1;
}
db.TypesOfOffices.Add(too);
db.SaveChanges();
Thread newThread = new Thread(DisplayAllRecordsFromTypesOfOffices);
newThread.Start();
}
}
private void ModifyingTypeOfOfficesInNewThread()
{
using (var db = new BusinessCodingModelContex())
{
db.TypesOfOffices.Attach(selectedTypesOfOffice);
var entry = db.Entry(selectedTypesOfOffice);
entry.Property(x => x.Capacity).IsModified = true;
entry.Property(x => x.CostOfHiring).IsModified = true;
entry.Property(x => x.Name).IsModified = true;
db.SaveChanges();
}
Thread newThread = new Thread(DisplayAllRecordsFromTypesOfOffices);
newThread.Start();
}
/// <summary>
/// Obsługa przycisku "Execute"
/// </summary>
private void buttonExecute_Click(object sender, RoutedEventArgs e)
{
int result;
using (var db = new BusinessCodingModelContex())
{
string query = richTextBoxQuery();
try
{
result = db.Database.ExecuteSqlCommand(query);
}
catch
{
MessageBox.Show("Wrong query");
return;
}
if (result < 0)
{
result = 0;
}
MessageBox.Show(string.Format("Result: {0} row(s) affected", result));
db.SaveChanges();
}
}
private void ModifyingTypesOfEmployeesInNewThread()
{
using (var db = new BusinessCodingModelContex())
{
db.TypesOfEmployees.Attach(selectedTypesOfEmployee);
var entry = db.Entry(selectedTypesOfEmployee);
entry.Property(x => x.Codity).IsModified = true;
entry.Property(x => x.Name).IsModified = true;
entry.Property(x => x.Salary).IsModified = true;
try
{
db.SaveChanges();
}
catch
{
MessageBox.Show("You have to give a reference to existing record.");
}
}
Thread newThread = new Thread(DisplayAllRecordsFromTypesOfEmployees);
newThread.Start();
}
/// <summary>
/// Wyświetlanie wszystkich rekordó z tabeli "Descriptions"
/// </summary>
private void DisplayAllRecordsFromDescriptions()
{
using (var db = new BusinessCodingModelContex())
{
var query = from x in db.Descriptions select x;
var result = query.ToList();
dataGrid.InvokeIfRequired((value) => dataGrid.ItemsSource = value, result);
}
}
public void TestAddToEmployee()
{
using (var context = new BusinessCodingModelContex())
{
Empolyees tmp = new Empolyees();
tmp.DateOfHiring = DateTime.Parse("2013-11-05 22:12:28.990");
var result = from x in context.TypesOfEmployees where x.Name == "Senior Developer" select x;
tmp.TypesOfEmployeesTOEmployeeID = result.First().TOEmployeeID;
context.Empolyees.Add(tmp);
}
}