public PartyResults GetPartiesByName(string name)
{
try
{
string baseUrl = WebOperationContext.Current.IncomingRequest.UriTemplateMatch.BaseUri.AbsoluteUri;
PartyResults partyResults = database.GetPartyByName(name, baseUrl);
return(partyResults);
}
catch (Exception ex)
{
throw MakeWebFaultException(ex);
}
}
public PartyResults GetPartyByName(string name, string baseUrl)
{
DataSet ds = new DataSet();
SqlConnection cn = Connect();
try
{
using (SqlCommand cmd = new SqlCommand("GetPartyByName", cn))
{
cmd.Parameters.AddWithValue("@Name", name);
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
}
PartyResults pr = new PartyResults();
DataTable t = FirstTable(ds);
if (t == null)
{
return(pr);
}
foreach (DataRow r in t.Rows)
{
int id = Convert.ToInt32(r["id"]);
string type = Convert.ToString(r["type"]);
string partyName = Convert.ToString(r["name"]);
string link = string.Format("{0}party/{1}", baseUrl, id);
PartySummary ps = new PartySummary(id, type, partyName, link);
pr.PartyList.Add(ps);
}
return(pr);
}
finally
{
Disconnect(cn);
}
}
public PartyResults GetPartyByName(string name, string baseUrl)
{
using (PartyEntities context = new PartyEntities(this.connectionString))
{
PartyResults partyResults = new PartyResults();
var nameQuery = context.ExecuteStoreQuery <PartySummary>(
"execute dbo.GetPartyByName {0}",
name);
foreach (PartySummary partySummary in nameQuery)
{
partySummary.Link =
string.Format("{0}/party/{1}", baseUrl, partySummary.Id);
partyResults.PartyList.Add(partySummary);
}
return(partyResults);
}
}
public PartyResults GetPartyByName(string name, string baseUrl)
{
DataSet ds = new DataSet();
SqlConnection cn = Connect();
try
{
using (SqlCommand cmd = new SqlCommand("GetPartyByName", cn))
{
cmd.Parameters.AddWithValue("@Name", name);
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
}
PartyResults pr = new PartyResults();
DataTable t = FirstTable(ds);
if (t == null) { return pr; }
foreach (DataRow r in t.Rows)
{
int id = Convert.ToInt32(r["id"]);
string type = Convert.ToString(r["type"]);
string partyName = Convert.ToString(r["name"]);
string link = string.Format("{0}party/{1}", baseUrl, id);
PartySummary ps = new PartySummary(id, type, partyName, link);
pr.PartyList.Add(ps);
}
return pr;
}
finally
{
Disconnect(cn);
}
}
public PartyResults GetPartyByName(string name, string baseUrl)
{
using (PartyEntities context = new PartyEntities(this.connectionString))
{
PartyResults partyResults = new PartyResults();
var nameQuery = context.ExecuteStoreQuery<PartySummary>(
"execute dbo.GetPartyByName {0}",
name);
foreach (PartySummary partySummary in nameQuery)
{
partySummary.Link =
string.Format("{0}/party/{1}", baseUrl, partySummary.Id);
partyResults.PartyList.Add(partySummary);
}
return partyResults;
}
}
