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)
{
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);
}
}