private void btnSave_Click_1(object sender, EventArgs e) { Boolean status = true; try { StockIssueDB siDB = new StockIssueDB(); List <stockissuedetail> SIDetails = new List <stockissuedetail>(); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; int planNo = Convert.ToInt32(txtProductionPlanNo.Text); DateTime planDate = dtProductionPlanDate.Value; string btnText = btnSave.Text; SIDetails = getStockIssueDetails(); if (SIDetails == null) { MessageBox.Show("Check Issue Detail Grid"); return; } if (btnText.Equals("Save")) { DialogResult dialog = MessageBox.Show("Are you sure to Save Entries?", "Yes", MessageBoxButtons.YesNo); if (dialog == DialogResult.Yes) { if (siDB.updateStockIssueUsage(SIDetails)) { MessageBox.Show("STOCK Issue Details updated"); pnlAddEdit.Visible = false; grdSIDetail.Rows.Clear(); ListFilteredProductionPlan(); } else { MessageBox.Show("STOCK Issue Details updation Failed."); status = false; } } else { status = false; } } else { MessageBox.Show("Production Details Validation failed"); status = false; } } catch (Exception ex) { MessageBox.Show("btnSave_Click_1() : Error"); status = false; } if (status) { setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save } }
private Boolean AddDetailgridForDetail(stockissueheader sih) { Boolean status = true; try { List <stockissuedetail> SIDetail = StockIssueDB.getPRDetail(sih); foreach (stockissuedetail sid in SIDetail) { if (!AddGridSIDetailRow()) { MessageBox.Show("failed to Add Rows."); return(false); } grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["TempNo"].Value = sih.TemporaryNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["TempDate"].Value = sih.TemporaryDate; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["DocumentNo"].Value = sih.DocumentNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["DocumentDate"].Value = sih.DocumentDate; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["IssueType"].Value = sih.IssueType; //----- grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["StockRefNo"].Value = sid.StockReferenceNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["ReferenceNo"].Value = sid.RowID; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["StockItemID"].Value = sid.StockItemID; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["StockItemName"].Value = sid.StockItemName; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["ModelNo"].Value = sid.ModelNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["ModelName"].Value = sid.ModelName; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["IssueQuantity"].Value = sid.IssueQuantity; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["MRNNo"].Value = sid.MRNNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["MRNDate"].Value = sid.MRNDate; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["BatchNo"].Value = sid.BatchNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["SerielNo"].Value = sid.SerialNo; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["ExpiryDate"].Value = sid.ExpiryDate; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["PurchaseQuantity"].Value = sid.PurchaseQuantity; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["PurchasePrice"].Value = sid.PurchasePrice; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["PurchaseTax"].Value = sid.PurchaseTax; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["SupplierID"].Value = sid.SupplierID; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["SupplierName"].Value = sid.SupplierName; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["UsedQuantity"].Value = sid.UsedQuantity; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["ReturnedQuantity"].Value = sid.ReturnedQuantity; grdSIDetail.Rows[grdSIDetail.RowCount - 1].Cells["DamagedQuantity"].Value = sid.DamagedQuantity; } } catch (Exception ex) { status = false; } return(status); }
private Boolean AddGridDetailRowForMU(int planNo, DateTime planDate) { grdSIDetail.Rows.Clear(); Boolean status = true; int count = 0; StockIssueDB siDB = new StockIssueDB(); List <stockissueheader> SIheader = siDB.getFilteredSIHeaderForRawMaterial(planNo, planDate); foreach (stockissueheader sih in SIheader) { count++; if (!AddDetailgridForDetail(sih)) { MessageBox.Show("Unable to show Grid Detail"); return(false); } } if (count == 0) { MessageBox.Show("Stock Issue not prepared For selected Production plan"); status = false; } return(status); }