public List <SystemDropDown> getSystemDropDown(SystemDropDown systemDropDownList)
{
List <SystemDropDown> lsSystemDropDown = new List <SystemDropDown>();
CommonData commonData = new CommonData();
DataSet dataset = new DataSet();
try
{
dataset = commonData.getSystemDropDown(systemDropDownList);
if (dataset.Tables["DROPDOWNLIST"].Rows.Count > 0)
{
for (int i = 0; i < dataset.Tables["DROPDOWNLIST"].Rows.Count; i++)
{
SystemDropDown localSDD = new SystemDropDown();
localSDD.Category = dataset.Tables["DROPDOWNLIST"].Rows[i]["CATEGORY"].ToString().ToUpper();
localSDD.DisplayText = dataset.Tables["DROPDOWNLIST"].Rows[i]["DISPLAYTEXT"].ToString();
localSDD.Key = dataset.Tables["DROPDOWNLIST"].Rows[i]["KEY"].ToString();
localSDD.Value = dataset.Tables["DROPDOWNLIST"].Rows[i]["VALUE"].ToString();
localSDD.ParentCategory = dataset.Tables["DROPDOWNLIST"].Rows[i]["PARENTCATEGORY"].ToString().ToUpper();
localSDD.ParentValue = dataset.Tables["DROPDOWNLIST"].Rows[i]["PARENTVALUE"].ToString();
localSDD.ParentKey = dataset.Tables["DROPDOWNLIST"].Rows[i]["PARENTKEY"].ToString();
lsSystemDropDown.Add(localSDD);
}
}
}
catch (Exception ex)
{
LoggerHelper.WriteToLog(ex);
}
return(lsSystemDropDown);
}
public DataSet getSystemDropDown(SystemDropDown systemDropDownList)
{
DataSet dataSet = new DataSet();
try
{
string storedProcedure = "pSRGg_SystemDropDown";
string parameterName = "@aXMLString";
string parameterValue = ObjectHelper.GetXMLFromObject(systemDropDownList);
sqlCommand = new SqlCommand(storedProcedure, sqlConnection);
sqlCommand.Parameters.AddWithValue(parameterName, parameterValue);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlConnection.Open();
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(dataSet);
dataSet.Tables[0].TableName = "DROPDOWNLIST";
}
catch (Exception)
{
throw;
}
finally
{
sqlConnection.Close();
}
return(dataSet);
}
public static T getDropDownList <T>(string filterCategory, DropDownControlType ddlControlType, string filterValue = null, string parentFilterCategory = null, string parentFilterValue = null, bool getFromCache = false)
{
SystemDropDown systemDropDown = new SystemDropDown();
filterCategory = filterCategory.ToUpper();
parentFilterCategory = !string.IsNullOrEmpty(parentFilterCategory) ? parentFilterCategory.ToUpper() : "";
if (!getFromCache)
{
systemDropDown.Category = filterCategory;
systemDropDown.Value = filterValue;
systemDropDown.ParentCategory = parentFilterCategory;
systemDropDown.ParentValue = parentFilterValue;
}
switch (ddlControlType)
{
case DropDownControlType.Html:
return(getFromCache
? (T)Convert.ChangeType(getHtmlDropDown(filterCategory, filterValue, parentFilterCategory, parentFilterValue), typeof(T))
: (T)Convert.ChangeType(getHtmlDropDown(filterCategory, filterValue, parentFilterCategory, parentFilterValue, systemDropDown), typeof(T)));
case DropDownControlType.Asp:
return(getFromCache
? (T)Convert.ChangeType(getHtmlDropDown(filterCategory, filterValue, parentFilterCategory, parentFilterValue), typeof(T))
: (T)Convert.ChangeType(getHtmlDropDown(filterCategory, filterValue, parentFilterCategory, parentFilterValue, systemDropDown), typeof(T)));
}
return((T)Convert.ChangeType(new Object(), typeof(T)));
}
public static List <SelectListItem> getMVCDropDown(string filterCategory = null, string filterValue = null, string parentFilterCategory = null, string parentFilterValue = null, bool getFromCache = false)
{
List <SelectListItem> lsSelectListItem = new List <SelectListItem>();
SystemDropDown systemDropDown = new SystemDropDown();
filterCategory = filterCategory.ToUpper();
parentFilterCategory = !string.IsNullOrEmpty(parentFilterCategory) ? parentFilterCategory.ToUpper() : "";
if (!getFromCache)
{
systemDropDown.Category = filterCategory;
systemDropDown.Value = filterValue;
systemDropDown.ParentCategory = parentFilterCategory;
systemDropDown.ParentValue = parentFilterValue;
}
lsSelectListItem = getMVCDropDownList(filterCategory, filterValue, parentFilterCategory, parentFilterValue);
return(lsSelectListItem);
}
private static List <SystemDropDown> getSystemDropDownList(SystemDropDown systemDropDown)
{
//return new CommonService().getSystemDropDown(systemDropDown);
return(new List <SystemDropDown>());
}
private static List <SelectListItem> getMVCDropDownList(string filterCategory, string filterValue, string parentFilterCategory, string parentFilterValue, SystemDropDown systemDropDown)
{
List <SelectListItem> lsSelectListItem = new List <SelectListItem>();
List <SystemDropDown> lsSystemDropDown = new List <SystemDropDown>();
lsSystemDropDown = WebHelper.getSystemDropDownList(systemDropDown);
foreach (var item in lsSystemDropDown)
{
lsSelectListItem.Add(new SelectListItem()
{
Text = item.Value, Value = item.Key
});
}
return(lsSelectListItem);
}
private static HtmlSelect getHtmlDropDown(string filterCategory, string filterValue, string parentFilterCategory, string parentFilterValue, SystemDropDown systemDropDown)
{
HtmlSelect htmlSelect = new HtmlSelect();
List <SystemDropDown> lsSystemDropDown = new List <SystemDropDown>();
lsSystemDropDown = WebHelper.getSystemDropDownList(systemDropDown);
htmlSelect.DataTextField = "VALUE";
htmlSelect.DataValueField = "KEY";
htmlSelect.DataSource = lsSystemDropDown;
htmlSelect.DataBind();
return(htmlSelect);
}
