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