public static void insert(string text, string textOld, string reference, string survey)
{
using (SqlConnection objConnection = Nuce_Common.GetConnectionD())
{
if (objConnection == null)
{
return;
}
try
{
//Execute select command
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(objConnection, "Nuce_KS_OutputText_insert", text, textOld, reference, survey);
}
catch
{
return;
}
}
return;
}
public static DataTable get()
{
using (SqlConnection objConnection = Nuce_Common.GetConnection())
{
if (objConnection == null)
{
return(null);
}
try
{
//Execute select command
string strSql = string.Format(@"SELECT * FROM [dbo].[AS_Edu_Survey_ReportTotal] where (QuestionId=41 or QuestionId=42 or QuestionId=43) and Value is not null");
return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, CommandType.Text, strSql).Tables[0]);
}
catch
{
return(null);
}
}
}
public static DataSet getThongKe2018()
{
using (SqlConnection objConnection = Nuce_Common.GetConnectionD())
{
if (objConnection == null)
{
return(null);
}
try
{
//Execute select command
string strSql = string.Format(@"dnn_Nuce_KS_OutputText_GetThongKe_2018");
return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, strSql));
}
catch
{
return(null);
}
}
}
public static DataTable getSubject()
{
using (SqlConnection objConnection = Nuce_Common.GetConnection())
{
if (objConnection == null)
{
return(null);
}
try
{
//Execute select command
string strSql = string.Format(@"SELECT * FROM [dbo].[AS_Academy_Subject]");
return(Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(objConnection, CommandType.Text, strSql).Tables[0]);
}
catch
{
return(null);
}
}
}