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);
}
