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