public int AddShipmentHeader(ShipmentHeader mShipment) { //insert databse values SqlCommand insetComm = new SqlCommand(); insetComm.Connection = this.mConnectionUser; insetComm.CommandType = CommandType.Text; insetComm.Parameters.Add("@Shh_ShipmentID", SqlDbType.NVarChar); insetComm.Parameters.Add("@Shh_FileCount", SqlDbType.Int); insetComm.Parameters.Add("@Shh_DownloadedDate", SqlDbType.DateTime); insetComm.Parameters["@Shh_ShipmentID"].Value = mShipment.ShipmentID; insetComm.Parameters["@Shh_FileCount"].Value = mShipment.FileCount; insetComm.Parameters["@Shh_DownloadedDate"].Value = mShipment.DownloadedDate; insetComm.CommandText = "insert into ShipmentHeader(ShipmentID,FileCount,DownloadedDate)values(@Shh_ShipmentID,@Shh_FileCount,@Shh_DownloadedDate)"; int ans = insetComm.ExecuteNonQuery(); if (ans > 0) { return(ans); } else { return(0); } }
public DataTable GetFileCount(ShipmentHeader mShipment) { //insert databse values SqlCommand deleteComm = new SqlCommand(); deleteComm.Connection = this.mConnectionUser; deleteComm.CommandType = CommandType.Text; deleteComm.Parameters.Add("@Shh_ShipmentID", SqlDbType.VarChar); deleteComm.Parameters["@Shh_ShipmentID"].Value = mShipment.ShipmentID; //Data adapter with select command SqlDataAdapter da = new SqlDataAdapter(); //Cast Table Data da.SelectCommand = new SqlCommand("SELECT FileCount FROM ShipmentHeader", this.mConnectionUser); DataTable table = new DataTable(); da.Fill(table); return(table); }
private void button3_Click(object sender, EventArgs e) { try{ DialogResult result; result = MessageBox.Show("Do you really want to register this shipment?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (cmbShipmentName.Text != "") { if (cmbPDTeam.Text != "") { if (result == DialogResult.Yes) { if (dataGridViewDCDImport.DataSource != null) { //Create Object From User Object ShipmetDetail mShDetail = new ShipmetDetail(); ShipmentHeader mShHeader = new ShipmentHeader(); ShipmentDetailFormats mShFormats = new ShipmentDetailFormats(); ShipmentHeaderMng ShHeader = new ShipmentHeaderMng(conn); ShipmentDetailMng ShDetail = new ShipmentDetailMng(conn); ShipmentDetailFormatsMng ShFormats = new ShipmentDetailFormatsMng(conn); mShHeader.ShipmentID = cmbShipmentName.Text; mShHeader.DownloadedDate = dateTimePickerDCDImport.Value; mShHeader.FileCount = int.Parse(lblFileCount.Text.ToString()); if (ShHeader.AddShipmentHeader(mShHeader) > 0) { //Loop until total Shipment File Count Registerd into the ShipmentDetails Tabele for (int i = 0; i < dataGridViewDCDImport.Rows.Count; i++) { //Load Selected Grid Row to frm_EditImportedFile for Edit // int rowIndex = dataGridViewDCDImport.CurrentRow.Index; string sISBN = dataGridViewDCDImport.Rows[i].Cells[0].Value.ToString(); string sdISBN = dataGridViewDCDImport.Rows[i].Cells[1].Value.ToString(); string stxtBookTitle = dataGridViewDCDImport.Rows[i].Cells[2].Value.ToString(); string stxtAuthor = dataGridViewDCDImport.Rows[i].Cells[3].Value.ToString(); string stxtAuthor1 = dataGridViewDCDImport.Rows[i].Cells[4].Value.ToString(); int sPageCount = int.Parse(dataGridViewDCDImport.Rows[i].Cells[5].Value.ToString()); DateTime sPubDate = DateTime.Parse(dataGridViewDCDImport.Rows[i].Cells[6].Value.ToString()); string sPublisher = dataGridViewDCDImport.Rows[i].Cells[7].Value.ToString(); string sLanguage = dataGridViewDCDImport.Rows[i].Cells[8].Value.ToString(); string sFormat = dataGridViewDCDImport.Rows[i].Cells[9].Value.ToString(); string sComment = dataGridViewDCDImport.Rows[i].Cells[10].Value.ToString(); string sTeam = cmbPDTeam.Text; // Assign User Interface data to User Object mShDetail.DownloadedDate = dateTimePickerDCDImport.Value; mShDetail.ID = cmbShipmentName.Text; mShDetail.Publisher = sPublisher; mShDetail.ISBN = sISBN; mShDetail.DISBN = sdISBN; mShDetail.Title = stxtBookTitle; mShDetail.Author = stxtAuthor; mShDetail.Author1 = stxtAuthor1; mShDetail.PageCount = sPageCount; mShDetail.PubDate = sPubDate; mShDetail.Language = sLanguage; mShDetail.Format = sFormat; mShDetail.Comment = sComment; mShDetail.DateOfAllocation = dateTimePickerAllocatedDate.Value; mShDetail.Team = sTeam; mShDetail.TATDelivery = 0; mShDetail.ProductionDone = 0; mShDetail.QRDone = 0; mShDetail.TransmissionDone = 0; mShDetail.ClientFeedback = 0; if (ShDetail.AddSipmentFile(mShDetail) > 0) { // For each uutput formats dedicate a column //string fePub //string fMobi //string fWEB //string fDoc //string fAFF For Apple Fixed Book //string fKF8 For Kindle Fixed Book //string fKCC For Kindle Comic Book //string fePib For B&N Fixed Book mShFormats.ShipmentID = cmbShipmentName.Text; mShFormats.ShpID = ShDetail.GetLastID(); List <String> LFormat = ShFormats.GetAllFormats(); mShFormats.ProductionStatus = "Not Assigned"; var s1 = sFormat.Split('/'); for (int x = 0; x < s1.Length; x++) { for (int y = 0; y < LFormat.Count(); y++) { if (s1[x].ToString() == LFormat[y]) { mShFormats.FormatName = LFormat[y].ToString(); } } ShFormats.AddShimpentFormats(mShFormats); } } } MessageBox.Show("New Shipment been registered..!\n\nShipment Name: " + mShDetail.ID + "\nTotal File(s): " + (dataGridViewDCDImport.Rows.Count), "Shipment Registerd", MessageBoxButtons.OK, MessageBoxIcon.Information); //Clear Header Details registered after shipment dataGridViewDCDImport.DataSource = null; lblFileCount.Text = ""; lblImportPath.Text = ""; dataGridViewDCDInventory.Focus(); RefreshData(); cmbShipmentName.Text = ""; btnImport.Enabled = false; } } else { MessageBox.Show("There is no new Shipment to import! \nPlease import provided excel file.", "Empty Shipment", MessageBoxButtons.OK, MessageBoxIcon.Error); btnImport.Focus(); } } else { } } else { MessageBox.Show("Please select a Team to allocate shipment!", "Empty Team", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbPDTeam.Focus(); } } else { MessageBox.Show("There is no Shipment to import!.", "Empty Shipment", MessageBoxButtons.OK, MessageBoxIcon.Error); cmbShipmentName.Focus(); } } catch (Exception ex) { if (ex.HResult == -2146232060) { MessageBox.Show("This shipment is already imported..!\n Please check shipment name again.", "Cannot Import", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Error" + ex.Message); } } }
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); } } }