public static Int32 DeleteSurvey(Int32 surveyId)
{
SurveyDSTableAdapter ta = new SurveyDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.Delete(surveyId));
}
public static Int32 UpdateSurvey(Int32 surveyId, string surveyName)
{
SurveyDSTableAdapter ta = new SurveyDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.Update(surveyId, surveyName));
}
public static SurveyDS.SurveyDSDataTable SelectSurvey(Int32 surveyId)
{
SurveyDSTableAdapter ta = new SurveyDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetData(surveyId));
}
public static Int32 InsertSurvey(string surveyName)
{
SurveyDSTableAdapter ta = new SurveyDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(Convert.ToInt32(ta.InsertSurvey(surveyName)));
}
public static SurveyDS.SurveyDSDataTable GetAllSurveys()
{
SurveyDSTableAdapter ta = new SurveyDSTableAdapter();
ta.Connection.ConnectionString = UcConnection.ConnectionString;
return(ta.GetAllSurveys());
}