private void btnRemoveUID_Click(object sender, EventArgs e) { try { DialogResult result; int rowIndex = dataGridAfterAssignedUID.CurrentRow.Index; if (dataGridAfterAssignedUID.Rows[rowIndex].Cells[7].Value.ToString() == "Process By User") { String ISBN = dataGridAfterAssignedUID.Rows[rowIndex].Cells[2].Value.ToString(); result = MessageBox.Show("Do you really want to remove User ID from ISBN: " + ISBN + "?", "Remove User from Assign File", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { QRDetail mQRD = new QRDetail(); QRHeader mQRH = new QRHeader(); EmployeeProduction mEMP = new EmployeeProduction(); ProductionManagementDetail mProductionDtl = new ProductionManagementDetail(); ProductionManagementHeader mProductionHdr = new ProductionManagementHeader(); ShipmentDetailFormats mShipmentDetailFormats = new ShipmentDetailFormats(); ProductionStatus mLog = new ProductionStatus(); //initilize values for QR Detail to delete mQRD.ProductID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mQRD.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mQRD.ISBN = ISBN; mQRD.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); //initilize values for QR Header to delete mQRH.ProductID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mQRH.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mQRH.ISBN = ISBN; mQRH.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); //initilize values for Employee Production to delete mEMP.ProductID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mEMP.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mEMP.ISBN = ISBN; mEMP.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); mEMP.Status = "Complete By User"; //initilize values for Production Detail to delete mProductionDtl.ShpID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mProductionDtl.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mProductionDtl.ISBN = ISBN; mProductionDtl.Format = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); //initilize values for Production Detail Header to delete mProductionHdr.ShpID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mProductionHdr.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mProductionHdr.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); //initilize values for Detail Format to delete mShipmentDetailFormats.ShpID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mShipmentDetailFormats.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mShipmentDetailFormats.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); //Production Status Log Value mLog.ProductID = int.Parse(dataGridAfterAssignedUID.Rows[rowIndex].Cells[0].Value.ToString()); mLog.ShipmentID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[1].Value.ToString(); mLog.ISBN = dataGridBeforeAssignedUID.Rows[rowIndex].Cells[2].Value.ToString(); mLog.StartDate = DateTime.Now; mLog.FormatName = dataGridAfterAssignedUID.Rows[rowIndex].Cells[3].Value.ToString(); mLog.UserID = lblCUID.Text; String aUID = dataGridAfterAssignedUID.Rows[rowIndex].Cells[4].Value.ToString(); mLog.Status = "Removed assigned User " + aUID + " from Assgned Production by System Access User " + lblCUID.Text; QRDetailMng mQRDMng = new QRDetailMng(conn); QRHeaderMng mQRHMng = new QRHeaderMng(conn); EmployeeProductionMng mEPMMng = new EmployeeProductionMng(conn); ProductionManagementDetailMng mShipmentDetailMng = new ProductionManagementDetailMng(conn); ProductionManagementHeaderMng mProductionHdrMng = new ProductionManagementHeaderMng(conn); ShipmentDetailFormatsMng mShipmentDetailFormatsMng = new ShipmentDetailFormatsMng(conn); // Delete Production Manegement Detail if (mShipmentDetailMng.DeleteAssignedProductionManagementDetail(mProductionDtl) > 0) { // Delete Production Manegement Header mProductionHdrMng.DeleteProductionManagementHeader(mProductionHdr); // Delete QR Detail if (mQRDMng.DeleteQRDetail(mQRD) > 0) { // Delete QR Header mQRHMng.DeleteQRHeader(mQRH); } // Delete Employee Production mEPMMng.DeleteUserProdcutionDone(mEMP); // Update Employee Shipment Detail Formats to Not Assign mShipmentDetailFormatsMng.UpdateProductionOnToBeAssignFormatFile(mShipmentDetailFormats); MessageBox.Show("Selected assigned User successfully cleared from File..!", "Assigned File Clear", MessageBoxButtons.OK, MessageBoxIcon.Information); //Production Log table new ProductionStatusLogMng(this.conn).AddProdustionStatus(mLog); RefreshData(); } } } else { MessageBox.Show("This file is already in process by User. \nFirst modify status before remove User ID.", "Cannot Remove", MessageBoxButtons.OK, MessageBoxIcon.Error); btnModifyUID.Focus(); } } catch (Exception ex) { if (ex.HResult == -2147467261) { MessageBox.Show("First select a file to remove User ID.", "Cannot Remove", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbShipment.Focus(); } else { MessageBox.Show("Error" + ex.Message); } } }
private void btnGenerate_Click(object sender, EventArgs e) { if (radioAllUser.Checked == true) { EmployeeProductionMng mEMP = new EmployeeProductionMng(conn); //Report Document Object ReportDocument cryUser = new ReportDocument(); cryUser.Load("E:\\MyProject\\ProductionManagementSystem\\ProductionManagementSystem\\ProductionManagementSystem\\Reprots\\rptEmployeeProductionAllShipment.rpt"); //Data Source set cryUser.SetDataSource(mEMP.GetAllEmployeeProduction()); frm_UserEvaluvation fUE = new frm_UserEvaluvation(); fUE.crystalReportViewer1.ReportSource = cryUser; fUE.crystalReportViewer1.Refresh(); fUE.Show(); } if (radioUserWise.Checked == true) { if (cmbUID.Text == "") { MessageBox.Show("User ID cannot be empty!", "Invalid User ID", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbUID.Focus(); } else { EmployeeProductionMng mEMP = new EmployeeProductionMng(conn); //Report Document Object ReportDocument cryUser = new ReportDocument(); cryUser.Load("E:\\MyProject\\ProductionManagementSystem\\ProductionManagementSystem\\ProductionManagementSystem\\Reprots\\rpt_EmpProduction.rpt"); //Data Source set cryUser.SetDataSource(mEMP.GetAllEmployeeProduction()); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = cmbUID.Text; crParameterFieldDefinitions = cryUser.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["UserID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); frm_UserEvaluvation fUE = new frm_UserEvaluvation(); fUE.crystalReportViewer1.ReportSource = cryUser; fUE.crystalReportViewer1.Refresh(); fUE.Show(); } } if (radioButtonShipmentName.Checked == true) { if (cmbShipment.Text == "") { MessageBox.Show("Shipment name cannot be empty!", "Invalid Shipment", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbShipment.Focus(); } else { EmployeeProductionMng mEMP = new EmployeeProductionMng(conn); //Report Document Object ReportDocument cryUser = new ReportDocument(); cryUser.Load("E:\\MyProject\\ProductionManagementSystem\\ProductionManagementSystem\\ProductionManagementSystem\\Reprots\\rptEmployeeProductionShipmentWise.rpt"); //Data Source set cryUser.SetDataSource(mEMP.GetAllEmployeeProduction()); ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crParameterDiscreteValue.Value = cmbShipment.Text; crParameterFieldDefinitions = cryUser.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions["ShipmentID"]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); frm_UserEvaluvation fUE = new frm_UserEvaluvation(); fUE.crystalReportViewer1.ReportSource = cryUser; fUE.crystalReportViewer1.Refresh(); fUE.Show(); } } }