/// <summary>
/// insert Subgroup Into Subgroup Table
/// </summary>
/// <param name="dataPrefix">DataPrefix like UT_</param>
/// <param name="languageCode">language code like _en</param>
/// <param name="subgroupName">Subgroup Name</param>
/// <param name="subgroupGID">Subgroup Gid</param>
/// <param name="isSubgroupGlobal">true/false .True if it is global </param>
/// <param name="subgroupType">Type of subgroup like age ,sex ...</param>
/// <returns></returns>
public static string InsertSubgroup(string dataPrefix, string languageCode, string subgroupName, string subgroupGID, bool isSubgroupGlobal, SubgroupType subgroupType)
{
string RetVal = string.Empty;
RetVal = "INSERT INTO " + dataPrefix + Insert.TableName + languageCode + " (" + DIColumns.Subgroup.SubgroupName + ","
+ DIColumns.Subgroup.SubgroupGId + ","
+ DIColumns.Subgroup.SubgroupGlobal + ","
+ DIColumns.Subgroup.SubgroupType + ")"
+ " values('" + DIQueries.RemoveQuotesForSqlQuery(subgroupName) + "','" + DIQueries.RemoveQuotesForSqlQuery(subgroupGID) + "'," + isSubgroupGlobal + "," + (int)subgroupType + ")";
return RetVal;
}
private SubgroupType GetSubgroupTypeByName(string SubgroupTypeGID)
{
SubgroupType RetVal = SubgroupType.Others;
if (SubgroupTypeGID == SubgroupType.Age.ToString().ToUpper())
{
RetVal = SubgroupType.Age;
}
else if (SubgroupTypeGID.ToString().ToUpper() == SubgroupType.Sex.ToString().ToUpper())
{
RetVal = SubgroupType.Sex;
}
else if (SubgroupTypeGID.ToString().ToUpper() == SubgroupType.Location.ToString().ToUpper())
{
RetVal = SubgroupType.Location;
}
else if (SubgroupTypeGID == SubgroupType.Others.ToString().ToUpper())
{
RetVal = SubgroupType.Others;
}
return(RetVal);
}
/// <summary>
/// Returns a query to delete columns from subgroupVal table
/// </summary>
/// <param name="tableName"></param>
/// <param name="columnName"></param>
/// <returns></returns>
public static string DeleteColumnForDI6(string tableName,SubgroupType columnName)
{
string RetVal=string.Empty;
RetVal = "ALTER TABLE " + tableName + " DROP COLUMN ";
switch (columnName)
{
case SubgroupType.Sex:
RetVal += DIColumns.SubgroupValRemovedColumns.SubgroupValSex;
break;
case SubgroupType.Location:
RetVal += DIColumns.SubgroupValRemovedColumns.SubgroupValLocation;
break;
case SubgroupType.Age:
RetVal += DIColumns.SubgroupValRemovedColumns.SubgroupValAge;
break;
case SubgroupType.Others:
RetVal += DIColumns.SubgroupValRemovedColumns.SubgroupValOthers;
break;
default:
break;
}
return RetVal;
}
/// <summary>
/// Update Subgroup Into Subgroup Table
/// </summary>
/// <param name="dataPrefix">DataPrefix like UT_</param>
/// <param name="languageCode">language code like _en</param>
/// <param name="subgroupName">Subgroup Name</param>
/// <param name="subgroupGID">Subgroup Gid</param>
/// <param name="isSubgroupGlobal">true/false .True if it is global </param>
/// <param name="subgroupType">Type of subgroup like age ,sex ...</param>
/// <param name="Nid"> Subgorup nid</param>
/// <returns></returns>
public static string UpdateSubgroupByNid(string dataPrefix, string languageCode, string subgroupName, string subgroupGID, bool isSubgroupGlobal, SubgroupType subgroupType, int Nid)
{
string RetVal = string.Empty;
RetVal = "UPDATE " + dataPrefix + Update.TableName + languageCode + " SET "
+ DIColumns.Subgroup.SubgroupName + "= '" + DIQueries.RemoveQuotesForSqlQuery( subgroupName) + "',"
+ DIColumns.Subgroup.SubgroupGId + "='" +DIQueries.RemoveQuotesForSqlQuery( subgroupGID )+ "',"
+DIColumns.Subgroup.SubgroupGlobal +"="+ isSubgroupGlobal + ","
+ DIColumns.Subgroup.SubgroupType +"="+ subgroupType + " WHERE " + DIColumns.Subgroup.SubgroupNId + "=" + Nid;
return RetVal;
}
