private void TxtAcPostingCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AccCode,AccName from ActMst", " Where AccCode", txtAcPostingCode, txtAcPostingdesc, txtRate, HelpGrid, HelpGridView, e);
}
}
private void TxtUMCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select UomCode,UomDesc from UomMst", " Where UomCode", txtUMCode, txtUMDesc, txtSGrpCode, HelpGrid, HelpGridView, e);
}
e.Handled = true;
}
private void TxtSurPostingCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AccCode,AccName from ActMst ", " Where AccCode", txtIGSTPostingCode, txtCGSTPostingDesc, txtMessage, HelpGrid, HelpGridView, e);
}
e.Handled = true;
}
private void txtAgainstInvNo_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes(" Select ImNo,ImDate from InvoiceMst Where ImDate<='" + Convert.ToDateTime(dtInvoiceDate.Text).AddDays(-10).ToString("yyyy-MM-dd") + "'", string.Empty, txtAgainstInvNo, txtAgainstInvDate, txtProductACode, HelpGrid, HelpGridView, e);
}
e.Handled = true;
}
private void TxtDealerCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AccCode,AccName from ActMst Where AccActive='Y' And AccLedger='0001' ", " And AccCode ", txtDealerCode, txtDealerName, txtDealerCode, HelpGrid, HelpGridView, e);
}
e.Handled = true;
}
private void txtRouteCode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select RouteCode,RouteDesc from RouteMst", " Where RouteCode", txtRouteCode, txtRouteName, txtTelNo, HelpGrid, HelpGridView, e);
}
e.Handled = true;
}
private void TxtSTL_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select TaxCode,TaxDesc from TaxMst", " Where TaxCode", txtTaxCodePL, txtTaxCodePLDesc, txtTaxCodePL, HelpGrid, HelpGridView, e);
}
e.Handled = true;
}
private void TxtStateCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select STSYSID,STNAME from STATEMASTER", " Where STSYSID", txtStateCode, txtStateName, txtStateCode, HelpGrid, HelpGridView, e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtUnitCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("select UNITID,UNITNAME from UNITS", " Where UNITID", txtUnitCode, txtUnitName, txtUnitCode, HelpGrid, HelpGridView, e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtGroupCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AddressBookGroupCode,AddressBookGroupDesc from AddressBookGroup", " Where AddressBookGroupCode", txtGroupCode, txtGroupDesc, txtTitle, HelpGrid, HelpGridView, e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
//private void txtStateCode_KeyDown(object sender, KeyEventArgs e)
//{
// try
// {
// ProjectFunctions.CreatePopUpForTwoBoxes("Select STSYSID,STNAME from STATEMASTER", " Where STSYSID", txtStateCode, txtStateName, txtCityCode, HelpGrid, HelpGridView, e);
// }
// catch (Exception ex)
// {
// ProjectFunctions.SpeakError(ex.Message);
// }
//}
private void TxtCityCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("SELECT CITYMASTER.CTSYSID, CITYMASTER.CTNAME,STATEMASTER.STNAME FROM CITYMASTER INNER JOIN STATEMASTER ON CITYMASTER.UNDERSTID = STATEMASTER.STSYSID", " Where CTSYSID", txtCityCode, txtCityName, txtState, HelpGrid, HelpGridView, e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtAgentCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AgentCode,AgentName from AgentMst", " Where AgentCode", txtAgentCode, txtAgentName, txtBSCode, HelpGrid, HelpGridView, e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtSLCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select LgrCode,LgrDesc from LgrMst", " Where LgrCode", txtSLCode, txtSLDesc, txtBSCode, HelpGrid, HelpGridView, e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtTaxCodeC_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select TaxCode,TaxDesc from TaxMst",
" Where TaxCode",
txtTaxCodeC,
txtTaxCodeCDesc,
txtTaxCodeC,
HelpGrid,
HelpGridView,
e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtBrandCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select BRSYSID,BRNAME from BRANDS",
" Where BRSYSID",
txtBrandCode,
txtBrandDesc,
txtUMCode,
HelpGrid,
HelpGridView,
e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtUMCode_KeyDown(object sender, KeyEventArgs e)
{
try
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select UomCode,UomDesc from UomMst",
" Where UomCode",
txtUMCode,
txtUMDesc,
txtUMCode,
HelpGrid,
HelpGridView,
e);
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void TxtWorkerCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select WRKSYSID,WRKNAME from WORKER", " Where WRKSYSID", txtWorkerCode, txtWorkerName, txtWorkerCode, HelpGrid, HelpGridView, e);
}
private void TxtCategory_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select CatgCode,CatgDesc from CatgMst", " Where CatgCode", txtCategoryCode, txtCategoryDesc, txtDOJ, HelpGrid, HelpGridView, e);
}
private void TxtUnitCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select UnitCode, UnitName from UNITS", " Where UnitCode", txtUnitCode, txtUnitDesc, txtRemarks, HelpGrid, HelpGridView, e);
}
private void TxtEmpCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select EmpMst.EmpCode,EmpMst.EmpName from EmpMst", " Where EmpMst.EmpCode", txtEmpCode, txtEmpName, txtPrePaidTag, HelpGrid, HelpGridView, e);
}
private void TxtSMCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AccCode,AccName from ActMst Where AccActive='Y' And AccLedger='0003' ", " And AccCode", txtSMCode, txtSMName, txtDebitPartyCode, HelpGrid, HelpGridView, e);
}
private void TxtYarnTypeCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select FabricTypeCode,FabricTypeName from FabricTypeMst", " Where FabricTypeCode", txtFabricTypeCode, txtFabricTypeDesc, txtFabricContent, HelpGrid, HelpGridView, e);
}
private void TxtColorCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("select COLSYSID,COLNAME from COLOURS", " Where COLSYSID", txtColorCode, txtColorName, txtColorCode, HelpGrid, HelpGridView, e);
}
private void TxtPCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AccCode,AccName from ActMst", " Where AccCode=", txtPCode, txtPDesc, txtTDSCode, HelpGrid, HelpGridView, e);
}
private void txtDealerCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select AccCode,AccName from ActMst", " Where AccCode", txtDealerCode, txtDealerName, txtPrdAsgnCode, HelpGrid, HelpGridView, e);
}
private void TxtDesgCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select DesgCode,DesgDesc from DesgMst", " Where DesgCode", txtDesgCode, txtDesgDesc, txtUnitCode, HelpGrid, HelpGridView, e);
}
private void TxtBrandCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select BrandCode,BrandDesc from MachineBrandMst", " Where BrandCode", txtBrandCode, txtBrandDesc, txtGauge, HelpGrid, HelpGridView, e);
}
private void TxtBrandCode_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("select BRSYSID,BRNAME from BRANDS", " Where BRSYSID", txtBrandCode, txtBrandName, txtBrandCode, HelpGrid, HelpGridView, e);
}
private void TxtContractorCode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select CNTSYSID,CNTNAME from CONTRACTOR", " Where CNTSYSID", txtContractorCode, txtContractorDesc, txtWorkerName, HelpGrid, HelpGridView, e);
}
private void TxtDelCitycode_KeyDown(object sender, KeyEventArgs e)
{
ProjectFunctions.CreatePopUpForTwoBoxes("Select CTSYSID,CTNAME from CITYMASTER", " Where CTSYSID", txtDelCitycode, txtDelCityName, txtDelGSTNo, HelpGrid, HelpGridView, e);
}