[HttpPost]// To update options of all the view public bool UpdatePreferenceColumnOfViewAll(int idView, string[] primaryList, string[] secondaryLsit) { SQLServerManager SQL = new SQLServerManager(SqlCnxStr); string primaryListStr = ""; string secondaryListStr = ""; if (primaryList != null) { foreach (string ele in primaryList) { primaryListStr += ele + ", "; } primaryListStr.Remove(primaryListStr.Length - 2, 2); } if (secondaryLsit != null) { foreach (string ele in secondaryLsit) { secondaryListStr += ele + ", "; } secondaryListStr.Remove(secondaryListStr.Length - 2, 2); } return(SQL.SP_UpdatePreferenceColumnOfViewAll(SqlCnxStr, idView, primaryListStr, secondaryListStr)); }