public static MsCrmResultObject GetSurveyChoices(Guid surveyId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
c.new_surveychoiceId AS Id
,c.new_name AS Name
,c.new_surveyId AS SurveyId
,c.new_surveyIdName AS SurveyIdName
FROM
new_surveychoice AS c (NOLOCK)
WHERE
c.new_surveyId='{0}'
AND
c.statecode=0";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, surveyId));
if (dt != null && dt.Rows.Count > 0)
{
List<SurveyChoices> returnList = new List<SurveyChoices>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SurveyChoices surveyChoices = new SurveyChoices();
surveyChoices.Id = (Guid)dt.Rows[i]["Id"];
surveyChoices.Name = dt.Rows[i]["Name"] != DBNull.Value ? dt.Rows[i]["Name"].ToString() : string.Empty;
if (dt.Rows[i]["SurveyId"] != DBNull.Value)
{
EntityReference er = new EntityReference()
{
Id = (Guid)dt.Rows[i]["SurveyId"],
Name = dt.Rows[i]["SurveyIdName"].ToString()
};
surveyChoices.Survey = er;
}
returnList.Add(surveyChoices);
}
returnValue.Success = true;
returnValue.ReturnObject = returnList;
}
else
{
returnValue.Success = false;
returnValue.Result = "Ankete ait şıklar bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetSurveyChoices(Guid surveyId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
c.new_surveychoiceId AS Id
,c.new_name AS Name
,c.new_surveyId AS SurveyId
,c.new_surveyIdName AS SurveyIdName
FROM
new_surveychoice AS c (NOLOCK)
WHERE
c.new_surveyId='{0}'
AND
c.statecode=0" ;
#endregion
DataTable dt = sda.getDataTable(string.Format(query, surveyId));
if (dt != null && dt.Rows.Count > 0)
{
List <SurveyChoices> returnList = new List <SurveyChoices>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SurveyChoices surveyChoices = new SurveyChoices();
surveyChoices.Id = (Guid)dt.Rows[i]["Id"];
surveyChoices.Name = dt.Rows[i]["Name"] != DBNull.Value ? dt.Rows[i]["Name"].ToString() : string.Empty;
if (dt.Rows[i]["SurveyId"] != DBNull.Value)
{
EntityReference er = new EntityReference()
{
Id = (Guid)dt.Rows[i]["SurveyId"],
Name = dt.Rows[i]["SurveyIdName"].ToString()
};
surveyChoices.Survey = er;
}
returnList.Add(surveyChoices);
}
returnValue.Success = true;
returnValue.ReturnObject = returnList;
}
else
{
returnValue.Success = false;
returnValue.Result = "Ankete ait şıklar bulunamadı.";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return(returnValue);
}
