private void btnUpdate_Click(object sender, EventArgs e)
{
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Project currentProject = BLProject.GetProjectById(APCContext, id);
if (currentProject != null)
{
currentProject.Name = tbName.Text;
int currentClientId = 0;
int.TryParse(cbClient.SelectedValue.ToString(), out currentClientId);
Client currentClient = BLClient.GetClientById(APCContext, currentClientId);
currentProject.Client = currentClient;
APCContext.SaveChanges();
ClearContent();
MessageBox.Show("Project Details Successfully Updated");
}
else
{
MessageBox.Show("Project Id not found");
}
}
else
{
MessageBox.Show("Project Id not found");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Project currentProject = BLProject.GetProjectById(APCContext, id);
if (currentProject != null)
{
APCContext.DeleteObject(currentProject);
APCContext.SaveChanges();
ClearContent();
MessageBox.Show("Delete Successfully");
}
else
{
MessageBox.Show("Project Id not found");
}
}
else
{
MessageBox.Show("Project Id not found");
}
}
public List <Project> searchById(int id)
{
if (id != 0)
{
List <Project> projectList = BLProject.GetProjectListById(APCContext, id);
if (projectList != null)
{
tbId.Text = projectList[0].Id.ToString();
tbName.Text = projectList[0].Name;
Client currentClient = BLClient.GetClientByName(APCContext, projectList[0].Client.Name)[0];
cbClient.SelectedValue = currentClient.Id;
return(projectList);
}
else
{
MessageBox.Show("Project Id not found");
}
}
else
{
MessageBox.Show("Project Id not found");
}
return(null);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Supplier selectedSupplier = BLSupplier.GetSupplierById(APCContext, int.Parse(cbSupplier.SelectedValue.ToString()));
Project selectedProject = BLProject.GetProjectById(APCContext, int.Parse(cbProject.SelectedValue.ToString()));
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
PO currentPO = BLPO.GetPOById(APCContext, id);
if (currentPO != null)
{
currentPO.Supplier = selectedSupplier;
currentPO.Project = selectedProject;
APCContext.SaveChanges();
deletePO_Product(currentPO);
insertPO_Product(currentPO);
MessageBox.Show("PO Details Successfully Updated");
ClearContent();
SetComboToDefault();
}
else
{
MessageBox.Show("PO Id not found");
}
}
else
{
MessageBox.Show("PO Id not found");
}
}
private void InvoiceForm_Load(object sender, EventArgs e)
{
APCContext = new APCEntities();
List <Project> projectList = BLProject.GetAllProject(APCContext);
ddlProject.DataSource = projectList;
ddlProject.DisplayMember = "Name";
ddlProject.ValueMember = "Id";
dgInvoiceProduct.AutoGenerateColumns = false;
dgInvoiceProduct.DataSource = createInvoiceProductTable();
//dgInvoiceProduct.Columns.Remove("Name");
//dgInvoiceProduct.Columns.Remove("Kurs");
//dgInvoiceProduct.Columns.Remove("SubCon");
DataGridViewComboBoxColumn colName = BLHelper.ReturnDataGridComboBoxColumn("Name", "Name", "Name", "Name");
colName.AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet;
colName.DataSource = APCContext.Category;
DataGridViewComboBoxColumn colKurs = BLHelper.ReturnDataGridComboBoxColumn("Name", "Name", "Name", "Name");
colName.AutoSizeMode = DataGridViewAutoSizeColumnMode.NotSet;
colKurs.DataSource = APCContext.Kurs;
DataGridViewCheckBoxColumn colSubCon = BLHelper.ReturnDataGridCBColumn("SubCon");
//dgInvoiceProduct.Columns.Insert(0, colName);
//dgInvoiceProduct.Columns.Insert(5, colKurs);
dgInvoiceProduct.Columns.Add(colName);
dgInvoiceProduct.Columns.Add(colKurs);
dgInvoiceProduct.Columns.Add(colSubCon);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int id = 0;
int currentWorkerId = 0;
int currentProjectId = 0;
decimal totalWorkingHours = 0;
decimal salary = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Project_Workers currentProject_Workers = BLProject_Workers.GetProject_WorkersById(APCContext, id);
if (currentProject_Workers != null)
{
if (int.TryParse(ddlWorker.SelectedValue.ToString(), out currentWorkerId))
{
if (int.TryParse(ddlProject.SelectedValue.ToString(), out currentProjectId))
{
if (decimal.TryParse(tbWorkingHours.Text, out totalWorkingHours))
{
if (decimal.TryParse(tbSalary.Text, out salary))
{
Workers currentWorker = BLWorkers.GetWorkersById(APCContext, currentWorkerId);
Project currentProject = BLProject.GetProjectById(APCContext, currentProjectId);
currentProject_Workers.Project = currentProject;
currentProject_Workers.Workers = currentWorker;
currentProject_Workers.StartDate = calStartDate.Value;
currentProject_Workers.EndDate = calEndDate.Value;
currentProject_Workers.TotalHours = totalWorkingHours;
currentProject_Workers.Salary = salary;
currentProject_Workers.TotalSalary = totalWorkingHours * salary;
APCContext.SaveChanges();
MessageBox.Show("Project Workers Details Successfully Updated");
ClearContent();
}
else
{
MessageBox.Show("Salary has to be decimal");
}
}
else
{
MessageBox.Show("Working hours has to be decimal");
}
}
}
}
else
{
MessageBox.Show("Project_Workers Id not found");
}
}
else
{
MessageBox.Show("Project_Workers Id not found");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
Supplier selectedSupplier = BLSupplier.GetSupplierById(APCContext, int.Parse(cbSupplier.SelectedValue.ToString()));
Project selectedProject = BLProject.GetProjectById(APCContext, int.Parse(cbProject.SelectedValue.ToString()));
PO po = BLPO.insertPO(APCContext, selectedSupplier, selectedProject);
insertPO_Product(po);
MessageBox.Show("PO Successfully Added");
ClearContent();
SetComboToDefault();
}
public void TestGetTemplatePlaceHolderList()
{
BLProject blProject = new BLProject();
//TemplateDTO templateDTO = BLL.BLTemplateType.getTypeByName("");// blProject.getTemplate(1);
BLTemplateType bLTemplateType = new BLTemplateType();
TemplateTypeDTO templateTypeDTO = bLTemplateType.getTypeByName("angularJs-Materil");
List <string> tokenList = Parser.getPlaceHolderList(templateTypeDTO.TokenizeString, Constant.pattern);
Assert.AreEqual(tokenList.Count, 15);
Assert.AreEqual(tokenList[3], "<<<Page.AppName>>>");
}
private void btnInsert_Click(object sender, EventArgs e)
{
decimal paymentDue = 0;
if (decimal.TryParse(tbPaymentDue.Text, out paymentDue))
{
if (calDueDate.Value != null)
{
//if (ddlPO.SelectedValue != null)
//{
if (ddlProject.SelectedValue != null)
{
Project selectedProject = BLProject.GetProjectById(APCContext, int.Parse(ddlProject.SelectedValue.ToString()));
bool success = false;
Invoice selectedInvoice = BLInvoice.insertInvoice(APCContext, DateTime.Today, paymentDue, calDueDate.Value, tbScannedDoc.Text, selectedProject);
if (InsertInvoicePO(selectedInvoice))
{
insertInvoice_Product(selectedInvoice);
success = true;
}
if (success == true)
{
MessageBox.Show("Invoice Successfully Added");
ClearContent();
}
else
{
MessageBox.Show("Please check your input");
}
}
else
{
MessageBox.Show("Please select the associated Project Number");
}
//}
//else
// MessageBox.Show("Please select the associated PO Number");
}
else
{
MessageBox.Show("Please specify Due Date");
}
}
else
{
MessageBox.Show("Please specify correct amount of Payment Due");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
int currentClientId = 0;
int.TryParse(cbClient.SelectedValue.ToString(), out currentClientId);
Client currentClient = BLClient.GetClientById(APCContext, currentClientId);
if (BLProject.insertProject(APCContext, tbName.Text, currentClient))
{
ClearContent();
MessageBox.Show("Project Successfully Added");
}
else
{
MessageBox.Show("Please check your input");
}
}
private void btnInsert_Click(object sender, EventArgs e)
{
int currentWorkerId = 0;
int currentProjectId = 0;
decimal totalWorkingHours = 0;
decimal salary = 0;
if (int.TryParse(ddlWorker.SelectedValue.ToString(), out currentWorkerId))
{
if (int.TryParse(ddlProject.SelectedValue.ToString(), out currentProjectId))
{
if (decimal.TryParse(tbWorkingHours.Text, out totalWorkingHours))
{
if (decimal.TryParse(tbSalary.Text, out salary))
{
Workers currentWorker = BLWorkers.GetWorkersById(APCContext, currentWorkerId);
Project currentProject = BLProject.GetProjectById(APCContext, currentProjectId);
if (BLProject_Workers.insertProject_Workers(APCContext, currentProject, currentWorker, calStartDate.Value, calEndDate.Value, totalWorkingHours, salary))
{
MessageBox.Show("Project_Workers Successfully Added");
ClearContent();
}
else
{
MessageBox.Show("Please check your input");
}
}
else
{
MessageBox.Show("Salary has to be decimal");
}
}
else
{
MessageBox.Show("Working hours has to be decimal");
}
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int id = 0;
int.TryParse(tbId.Text, out id);
if (id != 0)
{
Invoice currentInvoice = BLInvoice.GetInvoiceById(APCContext, id);
if (currentInvoice != null)
{
decimal paymentDue = 0;
if (decimal.TryParse(tbPaymentDue.Text, out paymentDue))
{
if (calDueDate.Value != null)
{
//if (ddlPO.SelectedValue != null)
//{
if (ddlProject.SelectedValue != null)
{
PO selectedPO = BLPO.GetPOById(APCContext, int.Parse(ddlPO.SelectedValue.ToString()));
Project selectedProject = BLProject.GetProjectById(APCContext, int.Parse(ddlProject.SelectedValue.ToString()));
currentInvoice.TotalDue = paymentDue;
currentInvoice.DueDate = calDueDate.Value;
currentInvoice.ScannedDoc = tbScannedDoc.Text;
currentInvoice.Project = selectedProject;
APCContext.SaveChanges();
DeleteInvoicePO(currentInvoice);
InsertInvoicePO(currentInvoice);
deleteInvoice_Product(currentInvoice);
insertInvoice_Product(currentInvoice);
MessageBox.Show("Invoice Details Successfully Updated");
ClearContent();
}
else
{
MessageBox.Show("Please select the associated Project");
}
//}
//else
// MessageBox.Show("Please select the associated PO Number");
}
else
{
MessageBox.Show("Please specify a correct due date");
}
}
else
{
MessageBox.Show("Please specify correct amount of Payment Due");
}
}
else
{
MessageBox.Show("Invoice Id not found");
}
}
else
{
MessageBox.Show("Invoice Id not found");
}
}
static void Main(string[] args)
{
BLEmployee employee = new BLEmployee();
BLProject project = new BLProject();
Model.Project p1 = new Model.Project()
{
Name = "sfdsd"
};
Model.Project p2 = new Model.Project()
{
Name = "tyuhg"
};
Model.Employee e1 = new Model.Employee()
{
Name = "Tdfsdf", Age = 39, Status = Model.EnumStatus.Employee, Position = Model.EnumPosition.Developer, Salary = 5675
};
e1.Project.Add(p2);
e1.Project.Add(p1);
p1.Employees.Add(e1);
//employee.CreateEmployee(e1);
//project.CreateProject(p1);
//project.CreateProject(p2);
//employee.Commit();
Console.WriteLine("\n GetAllEmployees \n");
foreach (var employees in employee.GetAllEmployees())
{
foreach (var i in employees.Project)
{
Console.Write("{0} ", i.Name);
}
Console.WriteLine("связанные проекты c Employee: {0} {1}", employees.Id, employees.Name);
}
Console.WriteLine("\n GetByIdEmployee \n");
var employeeById = employee.GetByIdEmployee(19);
Console.WriteLine("GetByIdEmployee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employeeById.Id, employeeById.Name, employeeById.Age, employeeById.Salary, employeeById.Status, employeeById.Position);
foreach (var i in employeeById.Project)
{
Console.WriteLine("Project: {0} {1}", i.Id, i.Name);
}
Console.WriteLine("\n GetAllProjects \n");
foreach (var projects in project.GetAllProjects())
{
Console.WriteLine("Project: {0} {1}", projects.Id, projects.Name);
}
Console.WriteLine("\n GetByIdProject \n");
var projectById = project.GetByIdProject(27);
Console.WriteLine("GetByIdProject Id: {0}, Name: {1}", projectById.Id, projectById.Name);
foreach (var i in projectById.Employees)
{
Console.WriteLine("Employee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", i.Id, i.Name, i.Age, i.Salary, i.Status, i.Position);
}
Console.WriteLine("\n End EntityRepository. \n");
//ADOBLEmployee adoEmployee = new ADOBLEmployee();
//ADOBLProject adoProject = new ADOBLProject();
//Console.WriteLine("\n GetAllEmployees \n");
//foreach (var employees in adoEmployee.GetAllEmployees())
//{
// Console.WriteLine("Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employees.Id, employees.Name, employees.Age, employees.Salary, employees.Status, employees.Position);
// foreach (var projects in employees.Project)
// {
// Console.WriteLine("ProjectId: {0} ProjectName: {1}", projects.Id, projects.Name);
// }
//}
//Console.WriteLine("\n GetByIdEmployee \n");
//var employeeById = adoEmployee.GetByIdEmployee(19);
//Console.WriteLine("GetByIdEmployee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employeeById.Id, employeeById.Name, employeeById.Age, employeeById.Salary, employeeById.Status, employeeById.Position);
//foreach (var i in employeeById.Project)
//{
// Console.WriteLine("Project 19: {0} {1}", i.Id, i.Name);
//}
//Console.WriteLine("\n GetAllProjects \n");
//foreach (var project in adoProject.GetAllProjects())
//{
// Console.WriteLine("Project: {0} {1}", project.Id, project.Name);
// foreach (var employees in project.Employees)
// {
// Console.WriteLine("Employees Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", employees.Id, employees.Name, employees.Age, employees.Salary, employees.Status, employees.Position);
// }
//}
//Console.WriteLine("\n GetByIdProject \n");
//var projectById = adoProject.GetByIdProject(27);
//Console.WriteLine("GetByIdProject Id: {0}, Name: {1}", projectById.Id, projectById.Name);
//foreach (var i in projectById.Employees)
//{
// Console.WriteLine("Employee Id: {0} Name: {1} Age: {2} Salary: {3} Status: {4} Position: {5}", i.Id, i.Name, i.Age, i.Salary, i.Status, i.Position);
//}
//Console.WriteLine("\n End ADORepository.");
Console.ReadKey();
}
