private object getConvertedDatatable(DataTable data, Type returnType)
{
if (data.Rows.Count == 0)
{
return(null);
}
object convertedDatatable = null;
if (returnType == typeof(MemberPreferencesDTO))
{
MemberPreferencesDTO enMemberPreferences = new MemberPreferencesDTO();
enMemberPreferences.memberId = (int)data.Rows[0]["id"];
enMemberPreferences.realName = (string)data.Rows[0]["realName"];
enMemberPreferences.displayName = (string)data.Rows[0]["displayName"];
enMemberPreferences.email = (string)data.Rows[0]["email"];
convertedDatatable = enMemberPreferences;
}
else if (returnType == typeof(LanguagePreferencesDTO))
{
LanguagePreferencesDTO enLanguagePreferences = new LanguagePreferencesDTO();
enLanguagePreferences.memberId = (int)data.Rows[0]["id"];
enLanguagePreferences.language = (string)data.Rows[0]["language"];
convertedDatatable = enLanguagePreferences;
}
return(convertedDatatable);
}
public void updateLanguagePreferences(LanguagePreferencesDTO languagePreferences)
{
string sqlSentence = "";
try
{
sqlSentence += "UPDATE members SET ";
sqlSentence += "members.language = @language ";
sqlSentence += "WHERE members.id = @memberId ";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@language", languagePreferences.language));
sqlParameters.Add(new SqlParameter("@memberId", memberInfo.id));
dbWrapper.UpdateDelete(sqlSentence, sqlParameters);
}
catch (Exception ex)
{
throw ex;
}
}
