[HttpGet] // To update options of a selected SubLevel of view
public bool UpdatePreferenceColumnOfView(int idView, int idSubLevel, string[] primaryList, string[] secondaryList)
{
SQLServerManager SQL = new SQLServerManager(SqlCnxStr);
string primaryListStr = "";
string secondaryListStr = "";
if (primaryList != null)
{
foreach (string ele in primaryList)
{
primaryListStr += ele + ", ";
}
}
if (secondaryList != null)
{
foreach (string ele in secondaryList)
{
secondaryListStr += ele + ", ";
}
}
return(SQL.SP_UpdatePreferenceColumnOfView(SqlCnxStr, idView, idSubLevel, primaryListStr, secondaryListStr));
}