public void process(ServiceRequest request, ServiceResponse response)
{
List<Category> list = new List<Category>();
string sqlStr = "select * from category";
MySqlConnection conn = ConnectionManager.getInstance().getConnection();
conn.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(sqlStr, conn);
DataSet ds = new DataSet();
mda.Fill(ds,"table1");
conn.Close();
int count = ds.Tables["table1"].Rows.Count;
for (int i = 0; i < count; i++)
{
Category c = new Category();
c.categoryId = (int)ds.Tables["table1"].Rows[i][0];
c.categoryName = (string)ds.Tables["table1"].Rows[i][1];
list.Add(c);
}
GetCategoryResponse serviceResponse = new GetCategoryResponse();
serviceResponse.categories = list;
response.responseObj = serviceResponse;
response.returnCode = 0;
}
public void DiaryUnitTest()
{
IService service = ServiceFactory.getInstance().getService(service_type.PUBLISH_TRAVEL_DIARY);
PublishTravelDiaryRequest serviceRequest = new PublishTravelDiaryRequest();
TravelDiary td = new TravelDiary();
td.userId = 9;
td.tags = "3452,532,df3";
td.content = "fajlsfjlkjl3kj4lk3j4l34lj343";
td.title = "zhangzhenrep9834";
Category c = new Category();
c.categoryId = 2;
c.categoryName = "oversea";
td.belongCategory = c;
td.addrs = new List<string>();
td.addrs.Add("fjladsfjkdsf");
td.addrs.Add("fjladsfjkdsfd");
td.addrs.Add("fjladsfjkdsfh");
serviceRequest.diary = td;
ServiceRequest request = new ServiceRequest(serviceRequest);
ServiceResponse response = new ServiceResponse();
service.process(request, response);
Assert.AreEqual(0, response.returnCode);
}
