public void GetBorang(string npm)
{
List <MhsBdkClass> list = new List <MhsBdkClass>();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MainDb"].ConnectionString))
{
connection.Open();
SqlCommand command = new SqlCommand("SELECT ukt_pribadi.no_daftar, UntidarDb.dbo.bak_mahasiswa.nama FROM ukt_pribadi INNER JOIN UntidarDb.dbo.bak_mahasiswa ON\tUntidarDb.dbo.bak_mahasiswa.no_daftar = dbo.ukt_pribadi.no_daftar WHERE npm=@npm", connection)
{
CommandType = CommandType.Text
};
command.Parameters.AddWithValue("@npm", npm);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
MhsBdkClass item = new MhsBdkClass
{
no_pendaftaran = reader["no_daftar"].ToString()
};
list.Add(item);
}
}
}
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
base.Context.Response.Write(serializer.Serialize(list));
}
public void GetEmployees(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch)
{
int num = iDisplayLength;
int num2 = iDisplayStart;
int num3 = iSortCol_0;
string str = sSortDir_0;
string str2 = sSearch;
string connectionString = ConfigurationManager.ConnectionStrings["Tidar"].ConnectionString;
List <MhsBdkClass> list = new List <MhsBdkClass>();
int num4 = 0;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("spGetEmployees", connection)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter parameter = new SqlParameter
{
ParameterName = "@DisplayLength",
Value = num
};
command.Parameters.Add(parameter);
SqlParameter parameter2 = new SqlParameter
{
ParameterName = "@DisplayStart",
Value = num2
};
command.Parameters.Add(parameter2);
SqlParameter parameter3 = new SqlParameter
{
ParameterName = "@SortCol",
Value = num3
};
command.Parameters.Add(parameter3);
SqlParameter parameter4 = new SqlParameter
{
ParameterName = "@SortDir",
Value = str
};
command.Parameters.Add(parameter4);
SqlParameter parameter5 = new SqlParameter
{
ParameterName = "@Search",
Value = string.IsNullOrEmpty(str2) ? null : str2
};
command.Parameters.Add(parameter5);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
MhsBdkClass item = new MhsBdkClass
{
npm = reader["npm"].ToString()
};
num4 = Convert.ToInt32(reader["TotalCount"]);
item.nama = reader["nama"].ToString();
item.gender = reader["gender"].ToString();
item.prog_study = reader["prog_study"].ToString();
item.gelombang = reader["gelombang"].ToString();
item.poto = reader["poto"].ToString();
item.thn_angkatan = reader["thn_angkatan"].ToString();
list.Add(item);
}
}
var type = new
{
iTotalRecords = this.GetEmployeeTotalCount(),
iTotalDisplayRecords = num4,
aaData = list
};
JavaScriptSerializer serializer = new JavaScriptSerializer();
base.Context.Response.Write(serializer.Serialize(type));
}
