private void AdjustmentDetailUI_Load(object sender, EventArgs e)
{
cboType.DataSource = loInventoryType.getAllData("ViewAll", "");
cboType.DisplayMember = "Description";
cboType.ValueMember = "Id";
cboType.SelectedIndex = -1;
cboSupplier.DataSource = loSupplier.getAllData("ViewAll", "");
cboSupplier.DisplayMember = "Name";
cboSupplier.ValueMember = "Id";
cboSupplier.SelectedIndex = -1;
cboCustomer.DataSource = loCustomer.getAllData("ViewAll", "");
cboCustomer.DisplayMember = "Name";
cboCustomer.ValueMember = "Id";
cboCustomer.SelectedIndex = -1;
if (lOperation == GlobalVariables.Operation.Edit)
{
foreach (DataRow _dr in loInventoryHeader.getAllData("", lInventoryId, "", "Stock Adjustment").Rows)
{
txtStockAdjustmentNo.Text = _dr["Id"].ToString();
dtpDate.Value = GlobalFunctions.ConvertToDate(_dr["Date"].ToString());
cboType.Text = _dr["Type"].ToString();
txtReference.Text = _dr["Reference"].ToString();
cboSupplier.Text = _dr["Supplier"].ToString();
cboCustomer.Text = _dr["Customer"].ToString();
txtTotalQtyIN.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty-IN"].ToString()));
txtTotalQtyOUT.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty-OUT"].ToString()));
txtTotalAmount.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Amount"].ToString()));
txtRemarks.Text = _dr["Remarks"].ToString();
foreach (DataRow _drDetails in loInventoryDetail.getInventoryDetail(lInventoryId).Rows)
{
int i = dgvDetail.Rows.Add();
dgvDetail.Rows[i].Cells[0].Value = _drDetails["Id"].ToString();
dgvDetail.Rows[i].Cells[1].Value = _drDetails["Stock Id"].ToString();
dgvDetail.Rows[i].Cells[2].Value = _drDetails["Stock Description"].ToString();
dgvDetail.Rows[i].Cells[3].Value = _drDetails["Unit"].ToString();
dgvDetail.Rows[i].Cells[4].Value = _drDetails["LocationId"].ToString();
dgvDetail.Rows[i].Cells[5].Value = _drDetails["Location"].ToString();
dgvDetail.Rows[i].Cells[6].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty-IN"].ToString()));
dgvDetail.Rows[i].Cells[7].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty-OUT"].ToString()));
dgvDetail.Rows[i].Cells[8].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Balance"].ToString()));
dgvDetail.Rows[i].Cells[9].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Unit Price"].ToString()));
dgvDetail.Rows[i].Cells[10].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Total Price"].ToString()));
dgvDetail.Rows[i].Cells[11].Value = _drDetails["Remarks"].ToString();
dgvDetail.Rows[i].Cells[12].Value = "Saved";
}
computeTotalAmount();
}
}
else
{
foreach (DataRow _dr in loInventoryHeader.getNextInventoryHeaderNo().Rows)
{
txtStockAdjustmentNo.Text = _dr[0].ToString();
}
cboSupplier.Focus();
}
}
private void StockAdjustmentUI_Load(object sender, EventArgs e)
{
try
{
Type _Type = typeof(Inventory);
FieldInfo[] myFieldInfo;
myFieldInfo = _Type.GetFields(BindingFlags.NonPublic | BindingFlags.Instance
| BindingFlags.Public);
loSearches = new SearchesUI(myFieldInfo, _Type, "tsmStockAdjustment");
cboInventoryType.DataSource = loInventoryType.getAllData("ViewAll", "", "");
cboInventoryType.ValueMember = "Id";
cboInventoryType.DisplayMember = "Description";
cboInventoryType.SelectedIndex = 0;
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "StockAdjustmentUI_Load");
em.ShowDialog();
return;
}
}
private void StockAdjustmentDetailUI_Load(object sender, EventArgs e)
{
try
{
this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor));
cboInventoryType.DataSource = loInventoryType.getAllData("ViewAll", "", "");
cboInventoryType.ValueMember = "Id";
cboInventoryType.DisplayMember = "Description";
cboInventoryType.SelectedIndex = 0;
cboSupplier.DataSource = loSupplier.getAllData("ViewAll", "", "");
cboSupplier.DisplayMember = "Name";
cboSupplier.ValueMember = "Id";
cboSupplier.SelectedIndex = -1;
cboCustomer.DataSource = loCustomer.getAllData("ViewAll", "", "");
cboCustomer.DisplayMember = "Name";
cboCustomer.ValueMember = "Id";
cboCustomer.SelectedIndex = -1;
if (lOperation == GlobalVariables.Operation.Edit)
{
foreach (DataRow _dr in loInventory.getAllData("", "", lInventoryId, "").Rows)
{
txtStockAdjustmentNo.Text = _dr["Id"].ToString();
cboInventoryType.Text = _dr["Type"].ToString();
dtpDate.Value = GlobalFunctions.ConvertToDate(_dr["Date"].ToString());
txtReference.Text = _dr["Reference"].ToString();
cboSupplier.Text = _dr["Supplier"].ToString();
cboCustomer.Text = _dr["Customer"].ToString();
txtTotalQtyIN.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty In"].ToString()));
txtTotalQtyOUT.Text = string.Format("{0:n}", decimal.Parse(_dr["Total Qty OuT"].ToString()));
txtRemarks.Text = _dr["Remarks"].ToString();
foreach (DataRow _drDetails in loInventoryDetail.getInventoryDetails("", lInventoryId).Rows)
{
int i = dgvDetail.Rows.Add();
dgvDetail.Rows[i].Cells["Id"].Value = _drDetails["Id"].ToString();
dgvDetail.Rows[i].Cells["StockId"].Value = _drDetails["StockId"].ToString();
dgvDetail.Rows[i].Cells["StockCode"].Value = _drDetails["Stock Code"].ToString();
dgvDetail.Rows[i].Cells["StockDescription"].Value = _drDetails["Stock Description"].ToString();
dgvDetail.Rows[i].Cells["Unit"].Value = _drDetails["Unit"].ToString();
dgvDetail.Rows[i].Cells["LocationId"].Value = _drDetails["LocationId"].ToString();
dgvDetail.Rows[i].Cells["Location"].Value = _drDetails["Location"].ToString();
dgvDetail.Rows[i].Cells["QtyIn"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty In"].ToString()));
dgvDetail.Rows[i].Cells["QtyOut"].Value = string.Format("{0:n}", decimal.Parse(_drDetails["Qty Out"].ToString()));
dgvDetail.Rows[i].Cells["Remarks"].Value = _drDetails["Remarks"].ToString();
dgvDetail.Rows[i].Cells["Status"].Value = "Saved";
}
computeTotalQty();
}
}
else
{
foreach (DataRow _dr in loCommon.getNextTabelSequenceId("Inventory").Rows)
{
txtStockAdjustmentNo.Text = _dr[0].ToString();
}
cboSupplier.Focus();
}
}
catch (Exception ex)
{
ErrorMessageUI em = new ErrorMessageUI(ex.Message, this.Name, "StockAdjustmentDetailUI_Load");
em.ShowDialog();
return;
}
}
