public string Get(string ITCode1, string ITCode2) { ManageSQLConnection manageSQLConnection = new ManageSQLConnection(); DataSet ds = new DataSet(); ManageStock manageStock = new ManageStock(); try { List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >(); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode1", ITCode1)); sqlParameters.Add(new KeyValuePair <string, string>("@ITCode2", ITCode2)); ds = manageSQLConnection.GetDataSetValues("GetDailyStatements", sqlParameters); //Convert to list. var result = manageStock.GetDailyStockStatments(ds); return(JsonConvert.SerializeObject(result)); } finally { ds.Dispose(); } }