private void buildPageSizeList() { ResultJobPageSizes resultPageSizes = new ResultJobPageSizes(); resultPageSizes = DBTransactions.GetPageSizesByJobID(Data.GlovalVariables.currentJobID); PageSizesListView.Items.Clear(); if (resultPageSizes.RecordsCount != 0) { foreach (JobPageSize jobPageSize in resultPageSizes.ReturnValue) { string[] row = { jobPageSize.ID.ToString(), jobPageSize.CategoryName, jobPageSize.High.ToString(), jobPageSize.Width.ToString() }; var listViewItem = new ListViewItem(row); PageSizesListView.Items.Add(listViewItem); JobPageSize jobPageSizeItem = new JobPageSize(); jobPageSizeItem.ID = jobPageSize.ID; jobPageSizeItem.JobID = jobPageSize.JobID; jobPageSizeItem.CategoryName = jobPageSize.CategoryName; jobPageSizeItem.Width = jobPageSize.Width; jobPageSizeItem.High = jobPageSize.High; originalJobPageSizes.Add(jobPageSizeItem); } } ResetButtons(); }
private void Save(string action) { try { foreach (ListViewItem item in PageSizesListView.Items) { // Check for Deletion if (item.ForeColor == Color.DarkRed) { // Delete Record DBTransactions.DeleteJobPageSize(Convert.ToInt32(item.SubItems[0].Text)); } // Check for New if (item.ForeColor == Color.DarkGreen) { // Add Record JobPageSize jobPageZise = new JobPageSize(); jobPageZise.JobID = Data.GlovalVariables.currentJobID; jobPageZise.CategoryName = item.SubItems[1].Text; jobPageZise.High = Convert.ToDouble(item.SubItems[2].Text); jobPageZise.Width = Convert.ToDouble(item.SubItems[3].Text); DBTransactions.NewJobPageSize(jobPageZise); } //Check for Update if (item.ForeColor == Color.DarkViolet) { // Update Record JobPageSize jobPageZise = new JobPageSize(); jobPageZise.ID = Convert.ToInt32(item.SubItems[0].Text); jobPageZise.JobID = Data.GlovalVariables.currentJobID; jobPageZise.CategoryName = item.SubItems[1].Text; jobPageZise.High = Convert.ToDouble(item.SubItems[2].Text); jobPageZise.Width = Convert.ToDouble(item.SubItems[3].Text); DBTransactions.UpdateJobPageSize(jobPageZise); } } if (action == "Save") { // Rebuild PageSizesListView buildPageSizeList(); } else { this.Close(); } } catch (Exception ex) { nlogger.Fatal(General.ErrorMessage(ex)); MessageBox.Show(General.ErrorMessage(ex), "Error ...", MessageBoxButtons.OK, MessageBoxIcon.Error); } }