private bool _Deletedt(string _ID) { bool _retval = false; if (_ID == string.Empty || _ID == null) { Program.MsgBox_Show("Nothing to Delete"); return(_retval); } int countDt = 0; var omdt = new MutationDt(); omdt.ID = _ID; omdt.UserDelete = _loginInfo.UserID; omdt.Delete(); omdt.TxnNo = txtTxnNo.Text.Trim(); countDt = omdt.SelectAllByTxnNo().Rows.Count; omdt.Dispose(); omdt = null; if (countDt == 0) { _DeleteHd(); } _retval = true; Program.MsgBox_Show("Deleted is Successfully"); return(_retval); }
private void PopulateGrid() { grdItem.SuspendLayout(); grdItem.AutoGenerateColumns = false; var oMutationDt = new MutationDt(); oMutationDt.TxnNo = txtTxnNo.Text.Trim(); grdItem.DataSource = oMutationDt.SelectAllByTxnNo().DefaultView; oMutationDt.Dispose(); oMutationDt = null; grdItem.ResumeLayout(); }
private bool _DeleteAll() { bool _retval = false; if (txtTxnNo.Text.Trim() == string.Empty) { Program.MsgBox_Show("Nothing to Delete"); return(_retval); } var omdt = new MutationDt(); omdt.TxnNo = txtTxnNo.Text.Trim(); omdt.UserDelete = _loginInfo.UserID; omdt.DeleteAllByTxnNo(); omdt.Dispose(); omdt = null; _DeleteHd(); Program.MsgBox_Show("Deleted is Successfully"); _retval = true; return(_retval); }
private bool _save() { bool _retval = false; //if (txtTxnNo.Text.Trim() == string.Empty) //{ // Program.MsgBox_Show("Transaction no. cannot empty."); // return _retval; //} if (txtItemSeqNo.Text.Trim() == string.Empty) { Program.MsgBox_Show("Item cannot empty."); return(_retval); } if (txtItemName.Text.Trim() == string.Empty) { Program.MsgBox_Show("Item Name cannot empty."); return(_retval); } if (Convert.ToString(cboItemUnit.SelectedValue) == string.Empty || Convert.ToString(cboItemUnit.SelectedValue) == null) { Program.MsgBox_Show("Item Unit cannot empty."); return(_retval); } try { decimal.Parse(txtItemFactor.Text.Trim()); } catch { Program.MsgBox_Show("Item Factor must be numeric."); return(_retval); } if (Convert.ToDecimal(txtItemFactor.Text.Trim()) < 1) { Program.MsgBox_Show("Item Factor must be equal or greater than 1"); return(_retval); } try { decimal.Parse(txtQty.Text.Trim()); } catch { Program.MsgBox_Show("Qty must be numeric."); return(_retval); } if (Convert.ToDecimal(txtQty.Text.Trim()) < 1) { Program.MsgBox_Show("Qty must be equal or greater than 1"); return(_retval); } bool isNew = true; var omhd = new MutationHd(); omhd.InventoryTxnID = Convert.ToString(cboTxnType.SelectedValue).Trim(); omhd.TxnNo = txtTxnNo.Text.Trim(); if (omhd.SelectOne().Rows.Count > 0) { isNew = false; } else { string prefix; if (Convert.ToString(cboTxnType.SelectedValue).Trim() == "111") { prefix = "AJM"; } else { prefix = "AJP"; } isNew = true; omhd.TxnNo = BussinessRules.ID.GenerateIDNumber("MutationHD", "TxnNo", prefix, "Where txnNo like '" + prefix + "%'"); } omhd.TxnDate = dtpTxnDate.Value.Date; omhd.AdjustmentReasonID = Convert.ToString(cboReason.SelectedValue).Trim(); omhd.Description = txtDescription.Text.Trim(); omhd.SourceWHID = Convert.ToString(cboWarehouse.SelectedValue); omhd.SourceUnitID = Convert.ToString(cboUnit.SelectedValue); omhd.DestinationWHID = ""; omhd.DestinationUnitID = ""; omhd.UserInsert = _loginInfo.UserID; omhd.UserUpdate = _loginInfo.UserID; if (isNew) { if (omhd.Insert()) { txtTxnNo.Text = omhd.TxnNo; } } else { omhd.Update(); } omhd.Dispose(); omhd = null; var omdt = new MutationDt(); omdt.InventoryTxnID = Convert.ToString(cboTxnType.SelectedValue).Trim(); omdt.ID = txtID.Text.Trim(); if (omdt.SelectOne().Rows.Count > 0) { isNew = false; } else { string prefix; if (Convert.ToString(cboTxnType.SelectedValue).Trim() == "111") { prefix = "AJM"; } else { prefix = "AJP"; } isNew = true; omdt.ID = BussinessRules.ID.GenerateIDNumber("MutationDt", "ID", prefix, "Where ID like '" + prefix + "%'"); } omdt.ItemSeqNo = txtItemSeqNo.Text.Trim(); omdt.TxnNo = txtTxnNo.Text.ToUpper().Trim(); omdt.ItemUnitID = Convert.ToString(cboItemUnit.SelectedValue).Trim(); omdt.ItemFactor = Convert.ToDecimal(txtItemFactor.Text.Trim()); if (Convert.ToString(cboTxnType.SelectedValue) == "111") { omdt.Qty = Convert.ToDecimal(txtQty.Text.Trim()) * -1; } else { omdt.Qty = Convert.ToDecimal(txtQty.Text.Trim()); } omdt.UserInsert = _loginInfo.UserID; omdt.UserUpdate = _loginInfo.UserID; if (isNew) { if (omdt.Insert()) { txtID.Text = omdt.ID; } } else { omdt.Update(); } omdt.Dispose(); omdt = null; _retval = true; return(_retval); }