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);
}
