public object SurveyDetails(Cls_Input Input)
{
dynamic surveysteps;
// List<object> data = new List<object>();
try
{
List <Cls_Input> data = servey.SurveyDetails(Input);
//for (int i = 0; i < Result.Count; i++)
//{
// data.Add(new { data = Result[i] });
//}
if (data != null)
{
surveysteps = new { status = "0", message = "success", data };
}
else
{
surveysteps = new { status = "0", message = "Record not found" };
}
}
catch
{
surveysteps = new { status = "1", message = "failed" };
}
return(new { surveysteps });
}
public object Survey_List(Cls_Input Input)
{
dynamic TBSurveyListResult;
List <object> data = new List <object>();
try
{
List <Cls_Input> Result = servey.getSurvey_List(Input);
//for (int i = 0; i < Result.Count; i++)
//{
// data.Add(new { data = Result[i] });
//}
if (Result != null)
{
TBSurveyListResult = new { status = "0", message = "success", Result };
}
else
{
TBSurveyListResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBSurveyListResult = new { status = "1", message = "failed" };
}
return(new { TBSurveyListResult });
}
public object AddEditSevey(Cls_Input Input)
{
dynamic AddSurvey;
List <object> AddSurveyResult = new List <object>();
try
{
int Result = servey.AddEditSevey(Input);
if (Result > 0)
{
AddSurvey = new { status = "0", message = "success" };
}
else
{
AddSurvey = new { status = "1", message = "failed" };
}
}
catch
{
AddSurvey = new { status = "1", message = "failed" };
}
return(new { AddSurvey });
}
//private static TouchBaseWebAPI.Data.row_productionEntities _DbTouchbase = new TouchBaseWebAPI.Data.row_productionEntities();
public static int AddEditSevey(Cls_Input obj)
{
int result = 0;
MySqlParameter[] parameterList = new MySqlParameter[13];
parameterList[0] = new MySqlParameter("?P_Pk_ServeyID", obj.Pk_ServeyID);
parameterList[1] = new MySqlParameter("?P_Fk_GroupID", obj.groupId);
parameterList[2] = new MySqlParameter("?P_publicServeyID", obj.publicsurveyid);
parameterList[3] = new MySqlParameter("?P_datecreated", obj.datecreated);
parameterList[4] = new MySqlParameter("?P_dateupdated", obj.dateupdated);
parameterList[5] = new MySqlParameter("?P_ExpiredDate", obj.expirydate);
parameterList[6] = new MySqlParameter("?P_Name", obj.name);
parameterList[7] = new MySqlParameter("?P_Status", obj.status);
parameterList[8] = new MySqlParameter("?P_ResultCount", obj.resultcount);
parameterList[9] = new MySqlParameter("?P_surveysteps", obj.surveysteps);
parameterList[10] = new MySqlParameter("?P_surveylink", obj.surveylink);
parameterList[11] = new MySqlParameter("?P_profileId", obj.profileId);
parameterList[12] = new MySqlParameter("?P_Fk_ServeyID", DbType.Int32);
parameterList[12].Direction = ParameterDirection.InputOutput;
try
{
result = MySqlHelper.ExecuteNonQuery(GlobalVar.strAppConn, CommandType.StoredProcedure, "USP_API_Mobile_AddEditSevey", parameterList);
result = Convert.ToInt32(parameterList[12].Value);
}
catch
{
throw;
}
return(result);
}
public static int DeleteSevey(Cls_Input obj)
{
int result = 0;
MySqlParameter[] parameterList = new MySqlParameter[3];
parameterList[0] = new MySqlParameter("?P_groupId", obj.groupId);
parameterList[1] = new MySqlParameter("?P_profileId", obj.profileId);
parameterList[2] = new MySqlParameter("?P_Pk_ServeyID", obj.Pk_ServeyID);
try
{
result = MySqlHelper.ExecuteNonQuery(GlobalVar.strAppConn, CommandType.StoredProcedure, "USP_API_DeleteSevey", parameterList);
}
catch
{
throw;
}
return(result);
}
public static List <Cls_Input> getSurvey_List(Cls_Input Obj)
{
try
{
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("?p_groupId", Obj.groupId);
param[1] = new MySqlParameter("?p_profileId", Obj.profileId);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <Cls_Input>("CALL USPGetSurvey_List(?p_groupId,?p_profileId)", param).ToList();
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
