public GetProviderByID ( long providerID ) : |
||
providerID | long | |
return |
public DataTable GetProviderByID(long providerID)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ServiceProviderGetByID_sp @AtulServiceProviderID", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulServiceProviderID", providerID));
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable returnTable = new DataTable(); returnTable.TableName = "providers";
da.Fill(returnTable);
return returnTable;
}
public string GetProviderByID(long providerID) { DataTable returnTable = new DataTable(); Atul_v1Data adb = new Atul_v1Data(); returnTable = adb.GetProviderByID(providerID); return JsonMethods.GetJSONString(returnTable); }