private void btnFinalize_Click(object sender, EventArgs e)
{
try
{
StockOBNewDB sobdb = new StockOBNewDB();
DialogResult dialog = MessageBox.Show("Are you sure to Finalize the document ?", "Yes", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
if (sobdb.FinalizeStockOB(prevsboh))
{
MessageBox.Show(" Document Finalized");
closeAllPanels();
listOption = 1;
FilteredStockOBList(listOption);
setButtonVisibility("btnEditPanel"); //activites are same for cance, forward,approce and reverse
}
else
{
MessageBox.Show("Failed to Finalize");
}
}
}
catch (Exception)
{
}
}
private void FilteredStockOBList(int opt)
{
try
{
grdList.Rows.Clear();
StockOBNewDB AccDB = new StockOBNewDB();
List <stockObNewHeader> SBList = StockOBNewDB.getStockOblist(opt);
if (opt == 1)
{
lblActionHeader.Text = "List of Action Pending Documents";
}
//else if (opt == 2)
// lblActionHeader.Text = "List of Approved Documents";
else if (opt == 2 || opt == 6)
{
lblActionHeader.Text = "List of Approved Documents";
}
foreach (stockObNewHeader sobh in SBList)
{
grdList.Rows.Add();
grdList.Rows[grdList.RowCount - 1].Cells["DocumentID"].Value = sobh.DocumentID;
grdList.Rows[grdList.RowCount - 1].Cells["DocumentNo"].Value = sobh.DocumentNo;
grdList.Rows[grdList.RowCount - 1].Cells["DocumentName"].Value = sobh.DocumentName;
grdList.Rows[grdList.RowCount - 1].Cells["DocumentDate"].Value = sobh.DocumentDate;
grdList.Rows[grdList.RowCount - 1].Cells["FYID"].Value = sobh.FYID;
grdList.Rows[grdList.RowCount - 1].Cells["StoreLocation"].Value = sobh.StoreLocation;
grdList.Rows[grdList.RowCount - 1].Cells["Value"].Value = sobh.Value;
grdList.Rows[grdList.RowCount - 1].Cells["Status"].Value = sobh.Status;
grdList.Rows[grdList.RowCount - 1].Cells["DocumentStatus"].Value = sobh.DocumentStatus;
grdList.Rows[grdList.RowCount - 1].Cells["CreateTime"].Value = sobh.CreateTime;
grdList.Rows[grdList.RowCount - 1].Cells["CreateUser"].Value = sobh.CreateUser;
grdList.Rows[grdList.RowCount - 1].Cells["Creator"].Value = sobh.CreatorName;
grdList.Rows[grdList.RowCount - 1].Cells["Remarks"].Value = sobh.Remarks;
grdList.Rows[grdList.RowCount - 1].Cells["TransferStatus"].Value = sobh.Transferstatus;
}
}
catch (Exception ex)
{
MessageBox.Show("Error in StockOB Listing");
}
setButtonVisibility("init");
pnlList.Visible = true;
try
{
grdList.Columns["gCreateUser"].Visible = true;
grdList.Columns["Creator"].Visible = true;
}
catch (Exception ex)
{
}
}
private void btnTransfer_Click(object sender, EventArgs e)
{
string FYID = cmbFY.SelectedItem.ToString().Trim().Substring(0, cmbFY.SelectedItem.ToString().Trim().IndexOf(':')).Trim();
if (!StockOBNewDB.checkAvailabilityOfFY(FYID))
{
DialogResult dialog = MessageBox.Show("Stock For this year is available , Are you sure to Transfer ?", "Yes", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
List <stockObNewHeader> SBList = StockOBNewDB.getStockOblistForTransfer(FYID);
if (StockOBNewDB.TransferStockOB(SBList, FYID))
{
if (StockOBNewDB.changeTransferStatus(FYID))
{
MessageBox.Show("stock Updated");
listStockOBList(FYID);
}
else
{
MessageBox.Show("Failed to Update Transfer Status");
}
}
else
{
MessageBox.Show("Failed to Update Stock");
}
}
}
else
{
List <stockObNewHeader> SBList = StockOBNewDB.getStockOblistForTransfer(FYID);
if (StockOBNewDB.TransferStockOB(SBList, FYID))
{
if (StockOBNewDB.changeTransferStatus(FYID))
{
MessageBox.Show("stock Updated");
listStockOBList(FYID);
}
else
{
MessageBox.Show("Failed to Update Transfer Status");
}
}
else
{
MessageBox.Show("Failed to Update Stock");
}
}
}
private void listStockOBList(string FYID)
{
try
{
grdList.Rows.Clear();
StockOBNewDB AccDB = new StockOBNewDB();
List <stockObNewHeader> SBList = StockOBNewDB.getStockOblist(3);
int i = 1;
foreach (stockObNewHeader sobh in SBList)
{
if (sobh.FYID.Equals(FYID))
{
grdList.Rows.Add();
grdList.Rows[grdList.RowCount - 1].Cells["LineNo"].Value = i;
grdList.Rows[grdList.RowCount - 1].Cells["FYID"].Value = sobh.FYID;
grdList.Rows[grdList.RowCount - 1].Cells["DocumentNo"].Value = sobh.DocumentNo;
grdList.Rows[grdList.RowCount - 1].Cells["DocumentDate"].Value = sobh.DocumentDate;//.ToString("dd-MM-yyyy");
grdList.Rows[grdList.RowCount - 1].Cells["StoreLocation"].Value = sobh.StoreLocation;
grdList.Rows[grdList.RowCount - 1].Cells["StoreLocationName"].Value = sobh.StoreLocationName;
grdList.Rows[grdList.RowCount - 1].Cells["Value"].Value = sobh.Value;
i++;
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error in Stock OB Listing");
}
try
{
enableBottomButtons();
grdList.Visible = true;
pnlList.Visible = true;
//btnNew.Visible = false;
}
catch (Exception ex)
{
}
}
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
}
}
