/// <summary>
/// CT_Event_Genre
/// </summary>
/// <param name="Utype"></param>
/// <param name="AD_OM_Code"></param>
/// <returns></returns>
public MD_GenreList getGenre(int Utype, int AD_OM_Code)
{
string sqlGenre = "select * from CT_Event_Genre where EG_UType="
+ Utype + " and EG_AD_OM_Code="
+ AD_OM_Code + ";";
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, sqlGenre);
MD_GenreList GenreList = new MD_GenreList();
GenreList.GenreList = DataHelper.ConvertToList <CT_Event_Genre>(ds);
return(GenreList);
}
private string getGenre()
{
BL_Event Event = new BL_Event();
MD_GenreList Genre = Event.getGenre(UserSession.User.UG_UType, UserSession.DealerEmpl.DE_AD_OM_Code);
if (Genre != null && Genre.GenreList.Count > 0)
{
StringBuilder str = new StringBuilder();
for (int i = 0; i < Genre.GenreList.Count; i++)
{
str.Append("<option value='" + Genre.GenreList[i].EG_Code + "'>" + Genre.GenreList[i].EG_Desc + "</option>");
}
return(str.ToString());
}
return("");
}
public MD_GenreList getGenre(int Utype, int AD_OM_Code)
{
MD_GenreList dd = new MD_GenreList();
return(Event.getGenre(Utype, AD_OM_Code));
}