public int UpdateAssignedFile(ProductionManagementDetail mProductionDtl) { //insert values into databse SqlCommand updateComm = new SqlCommand(); updateComm.Connection = this.mConnectionUser; updateComm.CommandType = CommandType.Text; updateComm.Parameters.Add("@PMD_ProductionID", SqlDbType.NVarChar); updateComm.Parameters.Add("@PMD_ShipmentID", SqlDbType.NVarChar); updateComm.Parameters.Add("@PMD_ISBN", SqlDbType.NVarChar); updateComm.Parameters.Add("@PMD_Format", SqlDbType.NVarChar); updateComm.Parameters.Add("@PMD_UserID", SqlDbType.NVarChar); updateComm.Parameters.Add("@PMD_Status", SqlDbType.NVarChar); updateComm.Parameters["@PMD_ProductionID"].Value = mProductionDtl.ShpID; updateComm.Parameters["@PMD_ShipmentID"].Value = mProductionDtl.ShipmentID; updateComm.Parameters["@PMD_ISBN"].Value = mProductionDtl.ISBN; updateComm.Parameters["@PMD_Format"].Value = mProductionDtl.Format; updateComm.Parameters["@PMD_UserID"].Value = mProductionDtl.UserID; updateComm.Parameters["@PMD_Status"].Value = mProductionDtl.ProductionStatus; updateComm.CommandText = "UPDATE ProductionManagementDetail SET UserID=@PMD_UserID WHERE ShpID=@PMD_ProductionID AND ShipmentID=@PMD_ShipmentID AND ISBN=@PMD_ISBN AND FormatName=@PMD_Format"; int ans = updateComm.ExecuteNonQuery(); if (ans > 0) { return(ans); } else { return(0); } }
public int DeleteAssignedProductionManagementDetail(ProductionManagementDetail mProductionDtl) { //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 = mProductionDtl.ShpID; deleteComm.Parameters["@Sh_ShipmentID"].Value = mProductionDtl.ShipmentID; deleteComm.Parameters["@Sh_FormatName"].Value = mProductionDtl.Format; deleteComm.Parameters["@Sh_ISBN"].Value = mProductionDtl.ISBN; deleteComm.CommandText = "DELETE FROM ProductionManagementDetail WHERE ShpID=@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); } }
public int AddProductionManagementDetail(ProductionManagementDetail mProductionDtl) { //insert databse values SqlCommand insetComm = new SqlCommand(); insetComm.Connection = this.mConnectionUser; insetComm.CommandType = CommandType.Text; insetComm.Parameters.Add("@PMD_ShpID", SqlDbType.BigInt); insetComm.Parameters.Add("@PMD_ShipmentID", SqlDbType.NVarChar); insetComm.Parameters.Add("@PMD_FormatName", SqlDbType.NVarChar); insetComm.Parameters.Add("@PMD_ISBN", SqlDbType.NVarChar); insetComm.Parameters.Add("@PMD_UID", SqlDbType.NVarChar); insetComm.Parameters.Add("@PMD_PageCount", SqlDbType.BigInt); insetComm.Parameters.Add("@PMD_StartDate", SqlDbType.DateTime); insetComm.Parameters.Add("@PMD_PrStatus", SqlDbType.NVarChar); insetComm.Parameters["@PMD_ShpID"].Value = mProductionDtl.ShpID; insetComm.Parameters["@PMD_ShipmentID"].Value = mProductionDtl.ShipmentID; insetComm.Parameters["@PMD_FormatName"].Value = mProductionDtl.Format; insetComm.Parameters["@PMD_ISBN"].Value = mProductionDtl.ISBN; insetComm.Parameters["@PMD_UID"].Value = mProductionDtl.UserID; insetComm.Parameters["@PMD_PageCount"].Value = mProductionDtl.PageCount; insetComm.Parameters["@PMD_StartDate"].Value = mProductionDtl.StartDate; insetComm.Parameters["@PMD_PrStatus"].Value = mProductionDtl.ProductionStatus; insetComm.CommandText = "INSERT INTO ProductionManagementDetail(ShpID,ShipmentID,FormatName,ISBN,UserID,PageCount,StartDate,ProductionStatus) VALUES(@PMD_ShpID,@PMD_ShipmentID,@PMD_FormatName,@PMD_ISBN,@PMD_UID,@PMD_PageCount,@PMD_StartDate,@PMD_PrStatus)"; int ans = insetComm.ExecuteNonQuery(); if (ans > 0) { return(ans); } else { return(0); } }
private void btnRemove_Click(object sender, EventArgs e) { try{ //Message for Error when Shipment Fied is empty if (cmbShipment.Text.ToString() == "") { MessageBox.Show("Please select a Shipment", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (cbmSAllFiles.Checked == true && cmbShipment.Text.ToString() != "") { //Initialize Message Result DialogResult result; result = MessageBox.Show("Do you really want to delete \"" + cmbShipment.Text + "\"?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { //Create Object From ShipmetDetail Object ShipmetDetail mShipment = new ShipmetDetail(); ShipmentHeader mShipmentHeader = new ShipmentHeader(); ShipmentDetailFormats mShipmentDetailFormats = new ShipmentDetailFormats(); TATDelivery mTATDelivery = new TATDelivery(); ProductionManagementDetail mProductionManagementDetail = new ProductionManagementDetail(); ProductionManagementHeader mProductionManagementHeader = new ProductionManagementHeader(); // Assign Shipment Delete Interface data to mShipmentID String mShipmentID = cmbShipment.Text.ToString(); //Create Services ShipmentDetailMng mShipmentMng = new ShipmentDetailMng(conn); ShipmentHeaderMng mShipmentHeaderMng = new ShipmentHeaderMng(conn); ShipmentDetailFormatsMng mShipmentDetailFormatsMng = new ShipmentDetailFormatsMng(conn); TATDeliveryMng mTATDeliveryMng = new TATDeliveryMng(conn); ProductionManagementDetailMng mProductionManagementDetailMng = new ProductionManagementDetailMng(conn); ProductionManagementHeaderMng mProductionManagementHeaderMng = new ProductionManagementHeaderMng(conn); mShipmentDetailFormatsMng.DeleteShimpentFormats(mShipmentID); mShipmentMng.DeleteShipment(mShipmentID); mShipmentHeaderMng.DeleteShipmentHeader(mShipmentID); MessageBox.Show("\"" + cmbShipment.Text + "\" successfully deleted..!", " Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); frm_DCDImport DCDFrm = new frm_DCDImport(); RefreshData(); this.Dispose(); } else { this.Dispose(); } } else if (cmbISBN.Text != "" && cmbShipment.Text.ToString() != "") { //Initialize Message Result DialogResult result; result = MessageBox.Show("Do you really want to delete ISBN " + cmbISBN.Text + "?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == System.Windows.Forms.DialogResult.Yes) { //Create Object From ShipmetDetail Object ShipmetDetail mShipmentISBN = new ShipmetDetail(); ShipmetDetail mShipment = new ShipmetDetail(); ShipmentDetailFormats mShipmentDetailFormats = new ShipmentDetailFormats(); // Assign Shipment Delete Interface data to mShipmentwithISBN Object mShipment.ID = cmbShipment.Text; mShipmentISBN.ISBN = cmbISBN.Text; ShipmentDetailMng mShipmentMng = new ShipmentDetailMng(conn); ShipmentDetailMng mShipmentMngShpID = new ShipmentDetailMng(conn); ShipmentDetailFormatsMng mShipmentDetailFormatsMng = new ShipmentDetailFormatsMng(conn); if (mShipmentMng.DeleteShipmentFromID(mShipmentISBN, mShipment) > 0) { MessageBox.Show("ISBN " + mShipmentISBN.ISBN + " successfully deleted..!", "ISBN Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information); RefreshData(); this.Dispose(); } } else if (result == DialogResult.No) { this.Close(); } } } } catch (Exception ex) { if (ex.HResult == -2146232060) { MessageBox.Show("This shipment is already in production!", "Cannot Delete", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Error" + ex.Message); } } }
private void btnAssignUID_Click(object sender, EventArgs e) { //validate User ID if (cmbUserID.Text != "") { try { DialogResult result; result = MessageBox.Show("Do You want to assign User " + cmbUserID.Text + " to this file?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); //Confirm by user if (result == DialogResult.Yes) { //validate Production ID if (cmbPID.Text != "") { int rowIndex = dataGridBeforeAssignedUID.CurrentRow.Index; ProductionManagementHeader mProductionHdr = new ProductionManagementHeader(); ProductionManagementDetail mProductionDtl = new ProductionManagementDetail(); ShipmentDetailFormats mShipmetDetail = new ShipmentDetailFormats(); ProductionStatus mLog = new ProductionStatus(); //Production Management Header Value mProductionHdr.ShpID = int.Parse(cmbPID.Text); mProductionHdr.ShipmentID = cmbShipment.Text; mProductionHdr.FormatName = cmbFormat.Text; //Production Management Detail Value mProductionDtl.ShpID = int.Parse(cmbPID.Text); mProductionDtl.ShipmentID = cmbShipment.Text; mProductionDtl.Format = cmbFormat.Text; mProductionDtl.ISBN = dataGridBeforeAssignedUID.Rows[rowIndex].Cells[2].Value.ToString(); mProductionDtl.UserID = cmbUserID.Text; mProductionDtl.PageCount = int.Parse(dataGridBeforeAssignedUID.Rows[rowIndex].Cells[8].Value.ToString()); mProductionDtl.StartDate = dateTimePickerStartDate.Value; mProductionDtl.ProductionStatus = "Process By User"; //Shipment Detail Formats Value mShipmetDetail.ShpID = int.Parse(cmbPID.Text); mShipmetDetail.ShipmentID = cmbShipment.Text; mShipmetDetail.FormatName = cmbFormat.Text; mShipmetDetail.ProductionStatus = "Process By User"; //Production Status Log Value mLog.ProductID = int.Parse(cmbPID.Text); mLog.ShipmentID = cmbShipment.Text; mLog.ISBN = dataGridBeforeAssignedUID.Rows[rowIndex].Cells[2].Value.ToString(); mLog.StartDate = DateTime.Now; mLog.FormatName = cmbFormat.Text; mLog.UserID = lblCUID.Text; mLog.Status = "Production assign to User " + cmbUserID.Text + " by Access User " + lblCUID.Text; ProductionManagementDetailMng mProductionDtlMng = new ProductionManagementDetailMng(conn); ShipmentDetailFormatsMng mShipmentDetailMng = new ShipmentDetailFormatsMng(conn); //Add Prodution Management Header table if (new ProductionManagementHeaderMng(this.conn).AddProductionManagementHeader(mProductionHdr) > 0) { //Update Shipment Format table mShipmentDetailMng.UpdateProductionOnSipmentFormatFile(mShipmetDetail); //Add Prodution Management Detail table mProductionDtlMng.AddProductionManagementDetail(mProductionDtl); MessageBox.Show("File has been assigned.\n\n ISBN: " + mProductionDtl.ISBN + "\n User ID: " + cmbUserID.Text + "\n Start Date: " + dateTimePickerStartDate.Value.ToString("dd/MMM/yyyy"), "File Assigned", MessageBoxButtons.OK, MessageBoxIcon.Information); //Production Log table new ProductionStatusLogMng(this.conn).AddProdustionStatus(mLog); RefreshData(); } } else { MessageBox.Show("Production ID cannot be empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbPID.Focus(); } } } catch (Exception ex) { if (ex.HResult == -2146232060) { MessageBox.Show("This Format is already assigned to a User.\n Please check Format & User ID again.", "Cannot Assign", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Error" + ex.Message); } } } else { MessageBox.Show("Plese select User ID to assign file.", "Cannot Assign", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbUserID.Focus(); } }
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); } } }