private void FillCombo()
{
string str = "";
str = "select * from CountryCodes order by countryCode";
objMainClass.fnFillComboBox(str, cmbCountryName, "countrycode", "countryName", "");
}
private void cmbFormat_Click(object sender, EventArgs e)
{
string strState = "";
strState = "select max(Formatid) as Formatid, formatname from tbSpecialFormat group by formatname";
objMainClass.fnFillComboBox(strState, cmbFormat, "FormatId", "FormatName", "");
}
private void cmbCustomer_Click(object sender, EventArgs e)
{
string str = "";
str = "select DFClientID, RIGHT(ClientName, LEN(ClientName) - 3) as ClientName from DFClients where CountryCode is not null and DFClients.IsDealer=1 ";
str = str + " order by RIGHT(ClientName, LEN(ClientName) - 3) ";
objMainClass.fnFillComboBox(str, cmbCustomer, "DFClientID", "ClientName", "");
}
private void frmOnlineStreaming_Load(object sender, EventArgs e)
{
string str = "";
str = "select DFClientID,RIGHT(ClientName, LEN(ClientName) - 3) as ClientName from DFClients where CountryCode is not null and DFClients.IsDealer=1 ";
str = str + " and DFClientID in (select distinct clientid from AMPlayerTokens) ";
str = str + " order by RIGHT(ClientName, LEN(ClientName) - 3) ";
objMainClass.fnFillComboBox(str, cmbCustomer, "DFClientID", "ClientName", "");
}
private void frmSeparation_Load(object sender, EventArgs e)
{
string strState = "";
strState = "select max(Formatid) as Formatid, formatname from tbSpecialFormat group by formatname";
objMainClass.fnFillComboBox(strState, cmbFormat, "FormatId", "FormatName", "");
InitilizeGrid();
}
private void FillClient()
{
string str = "";
str = "select distinct DFClients.DFClientID,DFClients.ClientName from DFClients ";
str = str + " inner join AMPlayerTokens on DFClients.DfClientid=AMPlayerTokens.Clientid ";
str = str + " where DFClients.CountryCode is not null and DFClients.IsDealer=0 and DFClients.IsDealerclient is null and AMPlayerTokens.isAsian=1 ";
str = str + " order by DFClients.DFClientID desc ";
objMainClass.fnFillComboBox(str, cmbClientName, "DFClientID", "ClientName", "");
}
private void FillClient()
{
string str = "";
str = "select DFClientID,ClientName from DFClients where CountryCode is not null and DFClients.IsDealer=1 order by DFClientID desc";
objMainClass.fnFillComboBox(str, cmbClientName, "DFClientID", "ClientName", "");
}
private void cmbClientName_Click(object sender, EventArgs e)
{
string str = "";
str = "select DFClientID,ClientName from DFClients where CountryCode is not null and DFClients.IsDealer=1 ";
str = str + " order by DFClientID desc ";
objMainClass.fnFillComboBox(str, cmbClientName, "DFClientID", "ClientName", "");
}
private void FillCountry()
{
//string strCountry = "";
//strCountry = "select * from CountryCodes order by countryName";
//objMainClass.fnFillComboBox(strCountry, cmbCountryName, "countrycode", "countryName", "");
string str = "";
str = "select distinct DFClients.DFClientID,DFClients.ClientName from DFClients ";
str = str + " inner join AMPlayerTokens on DFClients.DfClientid=AMPlayerTokens.Clientid ";
str = str + " where DFClients.CountryCode is not null and DFClients.IsDealer=0 and DFClients.IsDealerclient is null ";
str = str + " and AMPlayerTokens.IsDam=1 ";
str = str + " order by DFClients.ClientName ";
objMainClass.fnFillComboBox(str, cmbClientName, "DFClientID", "ClientName", "");
}