public DataTable GetAllActivity()
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ActivityGet_sp", this._connection);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "atultblactivity";
da.Fill(returnTable);
return returnTable;
}
/// <summary> /// Gets all activity. /// </summary> /// <returns></returns> public string GetAllActivity() { DataTable returnTable = new DataTable(); Atul_v1Data adb = new Atul_v1Data(); returnTable = adb.GetAllActivity(); return JsonMethods.GetJSONString(returnTable); }