private void _grid_KeyDownEdit(object sender, KeyEditEventArgs e)
{
// get editor which contains user input
Control ctl = _grid.Editor;
// handle manual user input for department code
if (e.Col == _grid.Cols["ItemCode"].SafeIndex)
{
if (e.KeyCode == Keys.Enter)
{
if (String.IsNullOrEmpty(ctl.Text.Trim()))
{
// display data
_grid.SetData(e.Row, "ItemID", DBNull.Value);
_grid.SetData(e.Row, "ItemCode", DBNull.Value);
_grid.SetData(e.Row, "ItemName", DBNull.Value);
_grid.SetData(e.Row, "MeasureCode", DBNull.Value);
_grid.SetData(e.Row, "UnitPrice", 0);
_grid.SetData(e.Row, "TaxPct", 0);
_grid.SetData(e.Row, "TrxType", 0);
_grid.SetData(e.Row, "Quantity", 1);
_grid.SetData(e.Row, "Remarks", DBNull.Value);
}
else
{
dsCore.ItemsDataTable data = daItems1.GetDataByCode(ctl.Text);
if (data.Rows.Count > 0)
{
// display data
_grid.SetData(e.Row, "ItemID", data[0].ID);
_grid.SetData(e.Row, "ItemCode", data[0].Code);
_grid.SetData(e.Row, "ItemName", data[0].Name);
_grid.SetData(e.Row, "MeasureCode", data[0].IsMeasureCodeNull() ? "" : data[0].MeasureCode);
_grid.SetData(e.Row, "UnitPrice", data[0].IsSellingPriceNull() ? 0 : data[0].SellingPrice);
_grid.SetData(e.Row, "TaxPct", 0);
_grid.SetData(e.Row, "TrxType", 0);
_grid.SetData(e.Row, "Quantity", 1);
// display default remark
_grid.SetData(e.Row, "Remarks", c1TextBox2.Text);
}
else
{
_grid_CellButtonClick(sender, new RowColEventArgs(e.Row, e.Col));
}
}
// Auto counting for kredit each time
c1Label1.Value = CountDetails();
}
}
}
private void _grid_CellButtonClick(object sender, RowColEventArgs e)
{
Cursor = Cursors.AppStarting;
try
{
// open item list form
if (e.Col == _grid.Cols["ItemCode"].SafeIndex)
{
frmItemSearch fx;
if (_grid[e.Row, "ItemCode"] == DBNull.Value)
{
fx = new frmItemSearch();
}
else
{
fx = new frmItemSearch((int)_grid[e.Row, "ItemID"]);
}
fx.ShowDialog();
if (fx.SelectedOK)
{
dsCore.ItemsDataTable data = daItems1.GetDataByID(fx.SelectedID);
// item info
if (data.Rows.Count > 0)
{
// display data
_grid.SetData(e.Row, "ItemID", data[0].ID);
_grid.SetData(e.Row, "ItemCode", data[0].Code);
_grid.SetData(e.Row, "ItemName", data[0].Name);
_grid.SetData(e.Row, "MeasureCode", data[0].IsMeasureCodeNull() ? "" : data[0].MeasureCode);
_grid.SetData(e.Row, "UnitPrice", data[0].IsSellingPriceNull() ? 0 : data[0].SellingPrice);
_grid.SetData(e.Row, "TaxPct", 0);
_grid.SetData(e.Row, "TrxType", 0);
_grid.SetData(e.Row, "Quantity", 1);
// display default remark
_grid.SetData(e.Row, "Remarks", c1TextBox2.Text);
}
}
}
// Auto counting for kredit each time
c1Label1.Value = CountDetails();
}
catch (Exception ex)
{
Logger.ErrorRoutine(ex);
RibbonMessageBox.Show("ERROR Adding Detail Items: " + ex.Message,
Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
Cursor = Cursors.Default;
}
private void _grid_AfterEdit(object sender, RowColEventArgs e)
{
NumberFormatInfo nfi = Application.CurrentCulture.NumberFormat;
if (e.Col == _grid.Cols["ItemID"].SafeIndex || e.Col == _grid.Cols["ItemCode"].SafeIndex)
{
if (_grid.GetData(e.Row, "ItemCode") != DBNull.Value &&
_grid.GetData(e.Row, "ItemCode").ToString().Trim() != "")
{
// read data
string code = _grid.GetData(e.Row, "ItemCode").ToString().Trim();
dsCore.ItemsDataTable data = daItems1.GetDataByCode(code);
if (data.Rows.Count > 0)
{
// display data
_grid.SetData(e.Row, "ItemID", data[0].ID);
_grid.SetData(e.Row, "ItemCode", data[0].Code);
_grid.SetData(e.Row, "ItemName", data[0].Name);
_grid.SetData(e.Row, "MeasureCode", data[0].IsMeasureCodeNull() ? "" : data[0].MeasureCode);
_grid.SetData(e.Row, "UnitPrice", data[0].IsBasePriceNull() ? 0 : data[0].BasePrice);
_grid.SetData(e.Row, "TaxPct", 0);
_grid.SetData(e.Row, "TrxType", 0);
_grid.SetData(e.Row, "Quantity", 1);
// display default remark
_grid.SetData(e.Row, "Remarks", c1TextBox2.Text);
}
}
}
// update converted credit column value
if (e.Col == _grid.Cols["Quantity"].SafeIndex)
{
if (_grid.GetData(e.Row, "Quantity") != DBNull.Value &&
_grid.GetData(e.Row, "Quantity").ToString() != "")
{
//_grid.SetData(e.Row, "ExtendedPrice", (double)_grid.GetData(e.Row, "Quantity") * (double)_grid.GetData(e.Row, "UnitPrice"));
}
}
// Auto counting for kredit each time
c1Label1.Value = CountDetails();
}
public virtual dsCore.ItemsDataTable GetDataDenormalized() {
this.Adapter.SelectCommand = this.CommandCollection[4];
dsCore.ItemsDataTable dataTable = new dsCore.ItemsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual dsCore.ItemsDataTable GetDataByID(int p1) {
this.Adapter.SelectCommand = this.CommandCollection[3];
this.Adapter.SelectCommand.Parameters[0].Value = ((int)(p1));
dsCore.ItemsDataTable dataTable = new dsCore.ItemsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual dsCore.ItemsDataTable GetDataByCode(string p1) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((p1 == null)) {
throw new global::System.ArgumentNullException("p1");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(p1));
}
dsCore.ItemsDataTable dataTable = new dsCore.ItemsDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
