private void btnItemLOV_Click(object sender, EventArgs e)
{
try
{
NameValueCollection para = new NameValueCollection();
para.Add("@i_FYID", CurrentUser.FYID.ToString());
para.Add("@i_GodownID", cmbgodown.SelectedValue.ToString());
para.Add("@i_CompId", CurrentCompany.CompId.ToString());
frmItemLOV fLOV = new frmItemLOV("usp_Item_LOV", para);
fLOV.ShowDialog();
txtItemName.Text = fLOV.ItemName;
txtItemDesc.Text = fLOV.Specification;
if (fLOV.ItemName == null)
{
// _ItemID = 0;
// txtQty.Text = "0.000";
// txtQOH.Text = "";
// txtUOM.Text = "";
}
else
{
DataView dvItem = new DataView();
dvItem = dtItemList.DefaultView;
dvItem.RowFilter = "ItemName like '%" + PrepareFilterString(txtItemName.Text) + "%'";
DataTable dtTempItem = new DataTable();
dtTempItem = dvItem.ToTable();
if (dtTempItem.Rows.Count > 0)
{
lblErrorMessage.Text = "No error";
_ItemID = Convert.ToInt64(dtTempItem.Rows[0]["ItemID"]);
txtQOH.Text = dtTempItem.Rows[0]["QOH"].ToString();
txtUOM.Text = dtTempItem.Rows[0]["UOM"].ToString();
txtRate.Text = dtTempItem.Rows[0]["Price"].ToString();
txtItemDesc.Text = dtTempItem.Rows[0]["Specification"].ToString();
btnSaveExit.Enabled = true;
//txtQty.Text = "0.000";
}
else
{
lblErrorMessage.Text = "Invalid item";
// _ItemID = 0;
// txtQOH.Text = "0.000";
txtUOM.Text = "";
txtItemName.Focus();
btnSaveExit.Enabled = false;
//txtQty.Text = "0.000";
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
private void btnItemLOV_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToInt16(cmbgodown.SelectedValue) == 0)
{
MessageBox.Show("First Select Godown.");
cmbgodown.Focus();
return;
}
else
{
NameValueCollection para = new NameValueCollection();
para.Add("@i_FYID", CurrentUser.FYID.ToString());
para.Add("@i_GodownID", cmbgodown.SelectedValue.ToString());
para.Add("@i_CompId", CurrentCompany.CompId.ToString());
frmItemLOV fLOV = new frmItemLOV("usp_Item_LOV", para);
fLOV.ShowDialog();
txtItemName.Text = fLOV.ItemName;
_itemcode = fLOV.ItemCode;
LoadItemList();
if (fLOV.ItemName == null)
{
_ItemID = 0;
}
else
{
DataView dvItem = new DataView();
dvItem = dtItemList.DefaultView;
dvItem.RowFilter = "ItemName like '%" + PrepareFilterString(txtItemName.Text) + "'";
DataTable dtTempItem = new DataTable();
dtTempItem = dvItem.ToTable();
if (dtTempItem.Rows.Count > 0)
{
lblErrorMessage.Text = "No error";
_ItemID = Convert.ToInt64(dtTempItem.Rows[0]["ItemID"]);
}
else
{
lblErrorMessage.Text = "Invalid Item name";
_ItemID = 0;
txtItemName.Focus();
}
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("MaterialIssue", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
private void btnItemLOV_Click(object sender, EventArgs e)
{
try
{
_godown = Convert.ToInt32(cmbgodown.SelectedValue);
NameValueCollection para = new NameValueCollection();
para.Add("@i_GodownID", _godown.ToString());
para.Add("@i_CompId", CurrentCompany.CompId.ToString());
frmItemLOV fLOV = new frmItemLOV("usp_Item_AdjustItemLOV", para);
fLOV.ShowDialog();
txtItemName.Text = fLOV.ItemName;
if (fLOV.ItemName == null)
{
_ItemID = 0;
txtQty.Text = "0.000";
}
else
{
LoadItemList();
DataView dvItem = new DataView();
dvItem = dtItemList.DefaultView;
dvItem.RowFilter = "ItemName='" + PrepareFilterString(txtItemName.Text) + "'";
DataTable dtTempItem = new DataTable();
dtTempItem = dvItem.ToTable();
if (dtTempItem.Rows.Count > 0)
{
lblErrorMessage.Text = "No error";
_ItemID = Convert.ToInt64(dtTempItem.Rows[0]["ItemID"]);
txtQty.Text = dtTempItem.Rows[0]["QOH"].ToString();
txtDiffQty.Focus();
}
else
{
lblErrorMessage.Text = "Invalid Item name";
_ItemID = 0;
txtQty.Text = "0.000";
txtItemName.Focus();
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("ItemAdjustment", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
private void btnItemLOV_Click(object sender, EventArgs e)
{
try
{
frmItemLOV fLOV = new frmItemLOV("usp_Item_StockItemLOV", null);
fLOV.ShowDialog();
txtItemName.Text = fLOV.ItemName;
if (fLOV.ItemName == null)
{
_ItemID = 0;
txtUOM.Text = "";
txtfinalprod.Text = "";
}
else
{
DataView dvItem = new DataView();
dvItem = dtItemList.DefaultView;
dvItem.RowFilter = "ItemName='" + PrepareFilterString(txtItemName.Text) + "'";
DataTable dtTempItem = new DataTable();
dtTempItem = dvItem.ToTable();
if (dtTempItem.Rows.Count > 0)
{
lblErrorMessage.Text = "No error";
_ItemID = Convert.ToInt64(dtTempItem.Rows[0]["ItemID"]);
txtUOM.Text = dtTempItem.Rows[0]["UOM"].ToString();
txtfinalprod.Text = dtTempItem.Rows[0]["ProductCode"].ToString();
dtpDate.Focus();
}
else
{
lblErrorMessage.Text = "Invalid Item name";
_ItemID = 0;
txtUOM.Text = "";
txtItemName.Focus();
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("ItemStock", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
private void btnItemLOV_Click(object sender, EventArgs e)
{
try
{
if (Convert.ToInt16(cmbgodown.SelectedValue) == 0)
{
MessageBox.Show("First Select Godown.");
return;
}
else
{
NameValueCollection para = new NameValueCollection();
para.Add("@i_FYID", CurrentUser.FYID.ToString());
para.Add("@i_GodownID", cmbgodown.SelectedValue.ToString());
para.Add("@i_CompId", CurrentCompany.CompId.ToString());
frmItemLOV fLOV = new frmItemLOV("usp_Item_LOV", para);
fLOV.ShowDialog();
//for (int i = 0; i < _dtDetail.Rows.Count; i++)
//{
// if (fLOV.ItemID == Convert.ToInt64(_dtDetail.Rows[i]["ItemID"]))
// {
// lblErrorMessage.Text = "Item already exists in Sales Invoice";
// _ItemID = 0;
// txtQty.Text = "0.000";
// txtQOH.Text = "0.000";
// txtUOM.Text = "";
// txtItemName.Text = fLOV.ItemName;
// btnItemLOV.Focus();
// return;
// }
//}
txtItemName.Text = fLOV.ItemName;
txtItemDesc.Text = fLOV.Specification;
LoadItemList();
if (fLOV.ItemName == null)
{
_ItemID = 0;
txtQty.Text = "0.000";
txtQOH.Text = "";
txtUOM.Text = "";
}
else
{
DataView dvItem = new DataView();
dtItemList = objList.ListOfRecord("usp_Item_LOV", para, "Service Invoice Detail - LoadItemList");
dvItem = dtItemList.DefaultView;
dvItem.RowFilter = "ItemName='" + PrepareFilterString(txtItemName.Text) + "'";
DataTable dtTempItem = new DataTable();
dtTempItem = dvItem.ToTable();
if (dtTempItem.Rows.Count > 0)
{
lblErrorMessage.Text = "No error";
_ItemID = Convert.ToInt64(dtTempItem.Rows[0]["ItemID"]);
txtQOH.Text = dtTempItem.Rows[0]["QOH"].ToString();
txtUOM.Text = dtTempItem.Rows[0]["UOM"].ToString();
txtRate.Text = dtTempItem.Rows[0]["Price"].ToString();
txtItemDesc.Text = dtTempItem.Rows[0]["Specification"].ToString();
cmbCurrency.SelectedValue = Convert.ToInt64(dtTempItem.Rows[0]["CurrencyID"].ToString());
// btnSaveExit.Enabled = true;
txtQty.Text = "0.000";
}
else
{
lblErrorMessage.Text = "Invalid item";
_ItemID = 0;
txtQOH.Text = "0.000";
txtUOM.Text = "";
txtItemName.Focus();
// btnSaveExit.Enabled = false;
txtQty.Text = "0.000";
}
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Sales Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
private void btnItemLOV_Click(object sender, EventArgs e)
{
try
{
NameValueCollection para = new NameValueCollection();
para.Add("@i_FYID", CurrentUser.FYID.ToString());
para.Add("@i_CompId", CurrentUser.CompId.ToString());
para.Add("@i_GodownID", _godown.ToString());
frmItemLOV fLOV = new frmItemLOV("usp_Item_LOV", para);
fLOV.ShowDialog();
//for (int i = 0; i < _dtDetail.Rows.Count; i++)
//{
// if (fLOV.ItemID == Convert.ToInt64(_dtDetail.Rows[i]["ItemID"]))
// {
// lblErrorMessage.Text = "Item already exists in Purchase Invoice";
// _ItemID = 0;
// txtQty.Text = "0.000";
// txtQOH.Text = "0.000";
// txtUOM.Text = "";
// txtItemName.Text = fLOV.ItemName;
// btnItemLOV.Focus();
// return;
// }
//}
txtItemName.Text = fLOV.ItemName;
if (fLOV.ItemName == null)
{
_ItemID = 0;
txtQty.Text = "0.000";
txtQOH.Text = "";
txtUOM.Text = "";
}
else
{
DataView dvItem = new DataView();
dvItem = dtItemList.DefaultView;
dvItem.RowFilter = "ItemName='" + PrepareFilterString(txtItemName.Text) + "'";
// ItemName
DataTable dtTempItem = new DataTable();
dtTempItem = dvItem.ToTable();
if (dtTempItem.Rows.Count > 0)
{
lblErrorMessage.Text = "No error";
_ItemID = Convert.ToInt64(dtTempItem.Rows[0]["ItemID"]);
NameValueCollection para1 = new NameValueCollection();
para1.Add("@i_ItemID", _ItemID.ToString());
DataTable dtrate = objList.ListOfRecord("usp_Indent_Rate", para1, "Purchase Invoice Detail - LoadItemList");
if (dtrate.Rows.Count == 0)
{
txtRate.Text = "0.00";
}
else
{
txtRate.Text = dtrate.Rows[0]["Rate"].ToString();
}
txtRemainingQty.Text = dtTempItem.Rows[0]["QOH"].ToString();
txtQty.Text = dtTempItem.Rows[0]["QOH"].ToString();
txtUOM.Text = dtTempItem.Rows[0]["UOM"].ToString();
//cmbTaxClass.SelectedValue = dtTempItem.Rows[0]["TaxClassID"].ToString();
btnSaveExit.Enabled = true;
//txtQty.Text = "0.000";
}
else
{
lblErrorMessage.Text = "Invalid item";
_ItemID = 0;
txtRemainingQty.Text = "0.000";
txtQty.Text = "0.00";
txtUOM.Text = "";
txtItemName.Focus();
btnSaveExit.Enabled = false;
txtQty.Text = "0.000";
}
}
}
catch (Exception exc)
{
Utill.Common.ExceptionLogger.writeException("Purchase Invoice", exc.StackTrace);
MessageBox.Show(Utill.Common.CommonMessage.ExceptionMesg, "Exception");
}
}
