private void txtSalesMan_TextChanged(object sender, EventArgs e)
{
try
{
DataTable dt = ObjDAL.ExecuteSelectStatement("select Empid,Name from " + clsUtility.DBName + ".dbo.employeeDetails where Name Like '" + txtSalesMan.Text + "%'");
if (dt != null && dt.Rows.Count > 0)
{
ObjUtil.SetControlData(txtSalesMan, "Name");
ObjUtil.SetControlData(txtEmpID, "Empid");
ObjUtil.ShowDataPopup(dt, txtSalesMan, 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["Empid"].Visible = false;
ObjUtil.SetDataPopupSize(200, 0);
}
}
//ObjUtil.GetDataPopup().CellClick += frmSalecounter_CellClick;
//ObjUtil.GetDataPopup().KeyDown += frmSalecounter_KeyDown;
}
else
{
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);
}
}
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 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, "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 += Material_Details_SearchByProductName_CellClick;
ObjUtil.GetDataPopup().KeyDown += Material_Details_SearchByProductName_KeyDown;
}
else
{
ObjUtil.CloseAutoExtender();
}
}
else
{
txtProductID.Clear();
ObjUtil.CloseAutoExtender();
}
}
catch (Exception ex)
{
clsUtility.ShowErrorMessage(ex.ToString(), clsUtility.strProjectTitle);
}
}
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 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 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 WITH(NOLOCK) 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)
{
}
}