public response GetStoryCategorytName() { var dataTable = new System.Data.DataTable(); dataTable = new System.Data.DataTable { TableName = "StoryCategorytName" }; string connString = URLInfo.GetDataBaseConnectionString(); System.IO.StringWriter writer = new System.IO.StringWriter(); string returnString = ""; response response = new response(); response.result = 0; using (System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connString)) { using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("GetStoryCategorytName", con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); var dataReader = cmd.ExecuteReader(); dataTable.Load(dataReader); dataTable.WriteXml(writer, System.Data.XmlWriteMode.WriteSchema, false); returnString = writer.ToString(); int numberOfRecords = dataTable.Rows.Count; response.result = numberOfRecords; StoryCategorytNameList list = new StoryCategorytNameList(); foreach (System.Data.DataRow row in dataTable.Rows) { storyCategorytName myprod = new storyCategorytName(); myprod.ID = row["ID"].ToString(); myprod.StoryCategorytName = row["StoryCategorytName"].ToString(); list.storyCategorytNameLists.Add(myprod); } response.AddStoryCategorytNameList(list); response.log.Add(numberOfRecords + " Records found"); } } return(response); }
public System.Collections.IList AddStoryCategorytNameList(StoryCategorytNameList list) { data.Add(list); return(data); }