private List <stockObNewDetail> getStockOBDetails(stockObNewHeader sobh)
{
List <stockObNewDetail> SNDetails = new List <stockObNewDetail>();
try
{
stockObNewDetail sondb = new stockObNewDetail();
for (int i = 0; i < grdStockOBDetail.Rows.Count; i++)
{
sondb = new stockObNewDetail();
sondb.DocumentID = sobh.DocumentID;
sondb.DocumentNo = sobh.DocumentNo;
sondb.DocumentDate = sobh.DocumentDate;
sondb.StockItemID = grdStockOBDetail.Rows[i].Cells["Item"].Value.ToString();
sondb.ModelNo = grdStockOBDetail.Rows[i].Cells["ModelNo"].Value.ToString();
sondb.Quantity = Convert.ToInt32(grdStockOBDetail.Rows[i].Cells["Quantity"].Value.ToString());
sondb.Price = Convert.ToDouble(grdStockOBDetail.Rows[i].Cells["PurchasePrice"].Value.ToString());
SNDetails.Add(sondb);
}
}
catch (Exception)
{
MessageBox.Show("getStockOBDetails() : Error getting StockOb Details");
SNDetails = null;
}
return(SNDetails);
}
public void clearData()
{
try
{
removeControlsFromModelPanel();
removeControlsFromPnlLvPanel();
//pnlAddEdit.Controls.Remove(pnllv);
txtDocNo.Text = "";
txtRemarks.Text = "";
txtcredittotal.Text = "";
lbltotal.Visible = false;
dtDocDate.Value = DateTime.Parse("01-01-1900");
cmbFYID.SelectedIndex = -1;
cmbStoreLocation.SelectedIndex = -1;
grdStockOBDetail.Rows.Clear();
prevsboh = new stockObNewHeader();
}
catch (Exception)
{
}
}
private void grdList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex < 0)
{
return;
}
string columnName = grdList.Columns[e.ColumnIndex].Name;
if (columnName.Equals("Finalize") || columnName.Equals("Edit") || columnName.Equals("View"))
{
clearData();
setButtonVisibility(columnName);
docID = grdList.Rows[e.RowIndex].Cells[0].Value.ToString();
int rowID = e.RowIndex;
btnSave.Text = "Update";
DataGridViewRow row = grdList.Rows[rowID];
prevsboh = new stockObNewHeader();
prevsboh.DocumentID = grdList.Rows[e.RowIndex].Cells["DocumentID"].Value.ToString();
prevsboh.DocumentNo = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["DocumentNo"].Value.ToString());
prevsboh.DocumentDate = DateTime.Parse(grdList.Rows[e.RowIndex].Cells["DocumentDate"].Value.ToString());
prevsboh.FYID = grdList.Rows[e.RowIndex].Cells["FYID"].Value.ToString();
prevsboh.StoreLocation = grdList.Rows[e.RowIndex].Cells["StoreLocation"].Value.ToString();
prevsboh.Value = Convert.ToInt32(grdList.Rows[e.RowIndex].Cells["Value"].Value.ToString());
prevsboh.Remarks = grdList.Rows[e.RowIndex].Cells["Remarks"].Value.ToString();
txtDocNo.Text = prevsboh.DocumentNo.ToString();
dtDocDate.Value = prevsboh.DocumentDate;
cmbFYID.SelectedIndex = cmbFYID.FindString(prevsboh.FYID);
cmbStoreLocation.SelectedIndex =
Structures.ComboFUnctions.getComboIndex(cmbStoreLocation, prevsboh.StoreLocation);
//cmbStoreLocation.SelectedIndex = cmbStoreLocation.FindString(prevsboh.StoreLocation);
txtRemarks.Text = prevsboh.Remarks;
dtDocDate.Value = prevsboh.DocumentDate;
//txtcredittotal.Text = prevsboh.Value.ToString();
List <stockObNewDetail> sobdetail = StockOBNewDB.getstockObNewDetail(prevsboh);
grdStockOBDetail.Rows.Clear();
int i = 0;
double dd = 0;
foreach (stockObNewDetail sobd in sobdetail)
{
if (!AddStockOBDetailRow())
{
MessageBox.Show("Error found in stock Detail. Please correct before updating the details");
}
else
{
grdStockOBDetail.Rows[i].Cells["LineNo"].Value = i + 1;
grdStockOBDetail.Rows[i].Cells["item"].Value = sobd.StockItemID;
grdStockOBDetail.Rows[i].Cells["Description"].Value = sobd.StockItemName;
grdStockOBDetail.Rows[i].Cells["ModelNo"].Value = sobd.ModelNo;
grdStockOBDetail.Rows[i].Cells["ModelName"].Value = sobd.ModelName;
grdStockOBDetail.Rows[i].Cells["Quantity"].Value = sobd.Quantity;
grdStockOBDetail.Rows[i].Cells["PurchasePrice"].Value = sobd.Price;
grdStockOBDetail.Rows[i].Cells["ItemValue"].Value = sobd.Quantity * sobd.Price;
dd = dd + Convert.ToDouble(grdStockOBDetail.Rows[i].Cells["ItemValue"].Value);
i++;
}
}
txtcredittotal.Text = dd.ToString();;
btnSave.Text = "Update";
pnlList.Visible = false;
txtcredittotal.Visible = true;
lbltotal.Visible = true;
pnlAddEdit.Visible = true;
btnSave.Text = "Update";
pnlList.Visible = false;
pnlAddEdit.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
}
private void btnSave_Click_1(object sender, EventArgs e)
{
Boolean status = true;
try
{
StockOBNewDB sobDB = new StockOBNewDB();
stockObNewHeader sobh = new stockObNewHeader();
System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button;
string btnText = btnSave.Text;
if (!verifyAndReworkAccGridRows())
{
MessageBox.Show("Error found in StockOB details. Please correct before updating the details");
return;
}
try
{
sobh.DocumentID = docID;
sobh.FYID = cmbFYID.SelectedItem.ToString().Trim().Substring(0, cmbFYID.SelectedItem.ToString().Trim().IndexOf(':')).Trim();
//sobh.StoreLocation = cmbStoreLocation.SelectedItem.ToString().Substring(0, cmbStoreLocation.SelectedItem.ToString().IndexOf('-'));
sobh.StoreLocation = ((Structures.ComboBoxItem)cmbStoreLocation.SelectedItem).HiddenValue;
sobh.Remarks = txtRemarks.Text;
sobh.Value = Convert.ToDouble(txtcredittotal.Text);
}
catch (Exception ex)
{
MessageBox.Show("Validation failed");
status = false;
return;
}
if (btnText.Equals("Save"))
{
// sobh.DocumentNo = DocumentNumberDB.getNewNumber(docID, 1);
sobh.DocumentStatus = 1;
sobh.DocumentDate = UpdateTable.getSQLDateTime();
}
else
{
sobh.DocumentNo = Convert.ToInt32(txtDocNo.Text);
sobh.DocumentStatus = prevsboh.DocumentStatus;
sobh.DocumentDate = prevsboh.DocumentDate;
}
if (!sobDB.validateStockOB(sobh))
{
MessageBox.Show("Validation Failed");
status = false;
return;
}
if (btnText.Equals("Save"))
{
if (!sobDB.verifyFYLoc(sobh.FYID, sobh.StoreLocation))
{
MessageBox.Show("For this Financial Year and Location Document already Available.Reenter not allow.");
return;
}
List <stockObNewDetail> StockList = getStockOBDetails(sobh);
if (sobDB.InsertStockHeaderAndDetail(sobh, StockList))
{
MessageBox.Show("Details Added");
closeAllPanels();
listOption = 1;
FilteredStockOBList(listOption);
pnlAddEdit.Visible = false;
}
else
{
MessageBox.Show("Failed to insert StockOB Detail");
status = false;
}
if (!status)
{
MessageBox.Show("Failed to Insert");
status = false;
}
}
else if (btnText.Equals("Update"))
{
List <stockObNewDetail> StockList = getStockOBDetails(sobh);
if (sobDB.updateStockHeaderAndDetail(sobh, StockList))
{
MessageBox.Show(" details updated");
closeAllPanels();
listOption = 1;
FilteredStockOBList(listOption);
}
else
{
status = false;
}
if (!status)
{
MessageBox.Show("Failed to update");
}
}
else
{
MessageBox.Show("Validation failed");
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Validation failed");
status = false;
}
if (status)
{
setButtonVisibility("btnEditPanel"); //activites are same for cancel, forward,approve, reverse and save
}
}
