public int AddQRHeader(QRHeader mDetail) { //insert databse values SqlCommand insetComm = new SqlCommand(); insetComm.Connection = this.mConnectionUser; insetComm.CommandType = CommandType.Text; insetComm.Parameters.Add("@QRD_ShpID", SqlDbType.BigInt); insetComm.Parameters.Add("@QRD_ShipmentID", SqlDbType.NVarChar); insetComm.Parameters.Add("@QRD_FormatName", SqlDbType.NVarChar); insetComm.Parameters.Add("@QRD_ISBN", SqlDbType.NVarChar); insetComm.Parameters["@QRD_ShpID"].Value = mDetail.ProductID; insetComm.Parameters["@QRD_ShipmentID"].Value = mDetail.ShipmentID; insetComm.Parameters["@QRD_FormatName"].Value = mDetail.FormatName; insetComm.Parameters["@QRD_ISBN"].Value = mDetail.ISBN; insetComm.CommandText = "INSERT INTO QRHeader(ProductID,ShipmentID,FormatName,ISBN) VALUES(@QRD_ShpID,@QRD_ShipmentID,@QRD_FormatName,@QRD_ISBN)"; int ans = insetComm.ExecuteNonQuery(); if (ans > 0) { return(ans); } else { return(0); } }
public int DeleteQRHeader(QRHeader mDetail) { //insert databse values SqlCommand deleteComm = new SqlCommand(); deleteComm.Connection = this.mConnectionUser; deleteComm.CommandType = CommandType.Text; deleteComm.Parameters.Add("@Sh_ShpID", SqlDbType.BigInt); deleteComm.Parameters.Add("@Sh_ShipmentID", SqlDbType.VarChar); deleteComm.Parameters.Add("@Sh_FormatName", SqlDbType.VarChar); deleteComm.Parameters.Add("@Sh_ISBN", SqlDbType.VarChar); deleteComm.Parameters["@Sh_ShpID"].Value = mDetail.ProductID; deleteComm.Parameters["@Sh_ShipmentID"].Value = mDetail.ShipmentID; deleteComm.Parameters["@Sh_FormatName"].Value = mDetail.FormatName; deleteComm.Parameters["@Sh_ISBN"].Value = mDetail.ISBN; deleteComm.CommandText = "DELETE FROM QRHeader WHERE ProductID=@Sh_ShpID AND ShipmentID=@Sh_ShipmentID AND FormatName=@Sh_FormatName AND ISBN=@Sh_ISBN"; int ans = deleteComm.ExecuteNonQuery(); if (ans > 0) { return(ans); } else { return(0); } }
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); } } }