private void txtCategoryName_TextChanged(object sender, EventArgs e) { try { if (isEdit) { return; } if (ObjUtil.IsControlTextEmpty(txtName)) { txtUserID.Clear(); ObjUtil.CloseAutoExtender(); return; } DataTable dt = ObjCon.ExecuteSelectStatement("SELECT USERNAME,USERID FROM " + clsUtility.DBName + ".dbo.UserManagement WITH(NOLOCK) WHERE IsAdmin=0 AND UserName LIKE '" + txtName.Text + "%'"); if (ObjUtil.ValidateTable(dt)) { ObjUtil.SetControlData(txtName, "USERNAME"); ObjUtil.SetControlData(txtUserID, "USERID"); ObjUtil.ShowDataPopup(dt, txtName, this, grpUserName); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { // if there is only one column ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["UserID"].Visible = false; ObjUtil.SetDataPopupSize(200, 0); } } //ObjUtil.GetDataPopup().CellClick += Sales_Bill_Details_CellClick; //ObjUtil.GetDataPopup().KeyDown += Sales_Bill_Details_KeyDown; } else { txtUserID.Clear(); ObjUtil.CloseAutoExtender(); } } catch (Exception) { } }
private void txtPurchaseInvoice_TextChanged(object sender, EventArgs e) { try { DataTable dt = ObjCon.ExecuteSelectStatement("exec " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_Popup '" + txtPurchaseInvoice.Text + "', 1"); if (ObjUtil.ValidateTable(dt)) { ObjUtil.SetControlData(txtPurchaseInvoice, "SupplierBillNo"); ObjUtil.SetControlData(txtPurchaseID, "PurchaseInvoiceID"); ObjUtil.ShowDataPopup(dt, txtPurchaseInvoice, this, this); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { // if there is only one column ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["PurchaseInvoiceID"].Visible = false; ObjUtil.GetDataPopup().Columns["SupplierID"].Visible = false; ObjUtil.SetDataPopupSize(400, 0); } } //ObjUtil.GetDataPopup().CellClick += frmSalecounter_CellClick; //ObjUtil.GetDataPopup().KeyDown += frmSalecounter_KeyDown; } else { ObjUtil.CloseAutoExtender(); } } catch (Exception) { } }
private void txtSalesMan_TextChanged(object sender, EventArgs e) { try { if (txtSalesMan.Text.Trim().Length == 0) { return; } DataTable dt = ObjDAL.ExecuteSelectStatement("select Empid,Name from " + clsUtility.DBName + ".dbo.employeeDetails where Name Like '" + txtSalesMan.Text + "%'"); if (ObjUtil.ValidateTable(dt)) { ObjUtil.SetControlData(txtSalesMan, "Name"); ObjUtil.SetControlData(txtEmpID, "Empid"); ObjUtil.ShowDataPopup(dt, txtSalesMan, this, groupBox1); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { // if there is only one column ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["Empid"].Visible = false; ObjUtil.SetDataPopupSize(450, 0); } } //ObjUtil.GetDataPopup().CellClick += Sales_Bill_Details_CellClick; //ObjUtil.GetDataPopup().KeyDown += Sales_Bill_Details_KeyDown; } else { ObjUtil.CloseAutoExtender(); } } catch (Exception) { } }
private void txtSupplierBillNo_TextChanged(object sender, EventArgs e) { try { if (txtSupplierBillNo.Text.Length > 0) { DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_PurchaseInvoice_Popup '" + txtSupplierBillNo.Text + "'"); if (ObjUtil.ValidateTable(dt)) { ObjUtil.SetControlData(txtSupplierBillNo, "SupplierBillNo"); ObjUtil.SetControlData(txtPurchaseInvoiceID, "PurchaseInvoiceID"); ObjUtil.ShowDataPopup(dt, txtSupplierBillNo, this, this); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { // if there is only one column ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["PurchaseInvoiceID"].Visible = false; ObjUtil.GetDataPopup().Columns["SupplierID"].Visible = false; ObjUtil.SetDataPopupSize(300, 0); } } ObjUtil.GetDataPopup().CellClick += Posting_Delivery_CellClick; ObjUtil.GetDataPopup().KeyDown += Posting_Delivery_KeyDown; } else { ObjUtil.CloseAutoExtender(); } } else { txtPurchaseInvoiceID.Clear(); txtTotalQTY.Clear(); ObjUtil.CloseAutoExtender(); } } catch (Exception ex) { clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle); } }
private void txtSearchByProductName_TextChanged(object sender, EventArgs e) { try { if (txtSearchByProductName.Text.Length > 0) { DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_ProductDetails_Popup '" + txtSearchByProductName.Text + "'"); if (ObjUtil.ValidateTable(dt)) { ObjUtil.SetControlData(txtSearchByProductName, "ProductName"); ObjUtil.SetControlData(txtProductID, "ProductID"); ObjUtil.ShowDataPopup(dt, txtSearchByProductName, this, groupBox1); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["ProductID"].Visible = false; ObjUtil.GetDataPopup().Columns["CategoryID"].Visible = false; ObjUtil.SetDataPopupSize(300, 0); } } ObjUtil.GetDataPopup().CellClick += Material_Details_SearchByProductName_CellClick; ObjUtil.GetDataPopup().KeyDown += Material_Details_SearchByProductName_KeyDown; } else { ObjUtil.CloseAutoExtender(); } } else { txtProductID.Clear(); ObjUtil.CloseAutoExtender(); } } catch (Exception) { } }
private void txtSearchByProductName_TextChanged(object sender, EventArgs e) { try { if (txtSearchByProductName.Text.Length == 0) { dgvProductDetails.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.EnableResizing; //Most time consumption enum is DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders dgvProductDetails.RowHeadersVisible = false; // set it to false if not needed LoadItemModelDetails(); return; } if (txtSearchByProductName.Text.Length > 0) { DataTable dt = ObjDAL.ExecuteSelectStatement("EXEC " + clsUtility.DBName + ".dbo.Get_ProductDetails_Popup '" + txtSearchByProductName.Text + "'"); if (ObjUtil.ValidateTable(dt)) { ObjUtil.SetControlData(txtSearchByProductName, "ItemName"); ObjUtil.SetControlData(txtProductID, "ProductID"); ObjUtil.ShowDataPopup(dt, txtSearchByProductName, this, groupBox1); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["ProductID"].Visible = false; ObjUtil.GetDataPopup().Columns["CategoryID"].Visible = false; ObjUtil.SetDataPopupSize(300, 0); } } ObjUtil.GetDataPopup().CellClick += frmItemWiseModelNo_SearchByProductName_CellClick; ObjUtil.GetDataPopup().KeyDown += frmItemWiseModelNo_SearchByProductName_KeyDown; } else { ObjUtil.CloseAutoExtender(); } } else { txtProductID.Clear(); ObjUtil.CloseAutoExtender(); } } catch (Exception ex) { clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle); } }
private void txtProductName_TextChanged(object sender, EventArgs e) { try { if (txtProductName.Text.Length > 0) // if manual entry { string query = "SELECT ProductID, ProductName FROM " + clsUtility.DBName + ".dbo.ProductMaster WITH(NOLOCK) WHERE ISNULL(ActiveStatus,1)=1 AND ProductName Like '" + txtProductName.Text + "%'"; DataTable dt = ObjDAL.ExecuteSelectStatement(query); if (ObjUtil.ValidateTable(dt)) { linkAddPurchaseBillItems.Enabled = true; ObjUtil.SetControlData(txtProductName, "ProductName"); ObjUtil.SetControlData(txtProductID, "ProductID"); ObjUtil.ShowDataPopup(dt, txtProductName, this, grpPurchaseBillDetail); if (ObjUtil.GetDataPopup() != null && ObjUtil.GetDataPopup().DataSource != null) { ObjUtil.GetDataPopup().AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; if (ObjUtil.GetDataPopup().ColumnCount > 0) { ObjUtil.GetDataPopup().Columns["ProductID"].Visible = false; ObjUtil.SetDataPopupSize(300, 0); } } ObjUtil.GetDataPopup().CellClick += Purchase_Bill_Details_CellClick; ObjUtil.GetDataPopup().KeyDown += Purchase_Bill_Details_KeyDown; } else { ObjUtil.CloseAutoExtender(); if (ObjUtil.IsControlTextEmpty(txtProductID)) { clsUtility.ShowInfoMessage("Item Name " + txtProductName.Text + " is not available in Item Master.", clsUtility.strProjectTitle); txtProductName.Focus(); } linkAddPurchaseBillItems.Enabled = false; } } else { txtProductID.Clear(); ObjUtil.CloseAutoExtender(); } } catch (Exception ex) { clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle); } }