public static YellowstonePathology.Business.Client.Model.PhysicianClientDistributionList GetPhysicianClientDistributionCollection(int physicianId, int clientId)
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionList result = new Client.Model.PhysicianClientDistributionList();
string sql = "Select c.ClientId, c.ClientName, ph.PhysicianId, ph.DisplayName [PhysicianName], c.DistributionType, c.Fax [FaxNumber], c.LongDistance " +
"from tblPhysicianClient pc " +
"join tblPhysicianClientDistribution pcd on pc.PhysicianClientId = pcd.PhysicianClientId " +
"join tblPhysicianClient pc2 on pcd.DistributionId = pc2.PhysicianClientId " +
"join tblClient c on pc2.ClientId = c.ClientId " +
"join tblPhysician ph on pc2.Physicianid = ph.PhysicianId " +
"where pc.ClientId = @ClientId and pc.PhysicianId = @PhysicianId";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Parameters.Add("@PhysicianId", SqlDbType.Int).Value = physicianId;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
string distributionType = dr["DistributionType"].ToString();
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionListItem physicianClientDistribution = YellowstonePathology.Business.Client.Model.PhysicianClientDistributionFactory.GetPhysicianClientDistribution(distributionType);
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistribution);
}
}
}
return result;
}
public static Business.Client.Model.PhysicianClientDistributionList GetPhysicianClientDistributionByPhysicianLastName(string lastName)
{
Business.Client.Model.PhysicianClientDistributionList result = new Client.Model.PhysicianClientDistributionList();
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection physicianClientCollection = server.Database.GetCollection<BsonDocument>("PhysicianClient");
MongoCollection physicianCollection = server.Database.GetCollection<BsonDocument>("Physician");
MongoCollection clientCollection = server.Database.GetCollection<BsonDocument>("Client");
MongoCursor physicianCursor = physicianCollection.FindAs<BsonDocument>(Query.Matches("LastName", BsonRegularExpression.Create("^" + lastName + ".*", "i"))).SetSortOrder(SortBy.Ascending("LastName", "FirstName"));
foreach (BsonDocument physicianDocument in physicianCursor)
{
MongoCursor physicianClientCursor = physicianClientCollection.FindAs<BsonDocument>(Query.EQ("PhysicianId", physicianDocument.GetValue("PhysicianId")));
List<BsonValue> clientIdList = new List<BsonValue>();
foreach (BsonDocument physicianClientDocument in physicianClientCursor)
{
clientIdList.Add(physicianClientDocument.GetValue("ClientId"));
}
MongoCursor clientCursor = clientCollection.FindAs<BsonDocument>(Query.In("ClientId", clientIdList)).SetSortOrder(SortBy.Ascending("ClientName"));
foreach (BsonDocument clientDocument in clientCursor)
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionListItem physicianClientDistribution = BuildPhysicianClientDistribution(clientDocument, physicianDocument);
result.Add(physicianClientDistribution);
}
}
return result;
}
public static YellowstonePathology.Business.Client.Model.PhysicianClientDistributionList GetPhysicianClientDistributionCollection(int physicianId, int clientId)
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionList result = new Client.Model.PhysicianClientDistributionList();
string sql = "Select c.ClientId, c.ClientName, ph.PhysicianId, ph.DisplayName PhysicianName, pcd.DistributionType, " +
"c.Fax FaxNumber " +
"from tblPhysicianClient pc " +
"join tblPhysicianClientDistribution pcd on pc.PhysicianClientId = pcd.PhysicianClientId " +
"join tblPhysicianClient pc2 on pcd.DistributionId = pc2.PhysicianClientId " +
"join tblClient c on pc2.ClientId = c.ClientId " +
"join tblPhysician ph on pc2.PhysicianId = ph.PhysicianId " +
"where pc.ClientId = @ClientId and pc.PhysicianId = @PhysicianId;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@PhysicianId", physicianId);
cmd.Parameters.AddWithValue("@ClientId", clientId);
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
string distributionType = dr["DistributionType"].ToString();
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionListItem physicianClientDistribution = YellowstonePathology.Business.Client.Model.PhysicianClientDistributionFactory.GetPhysicianClientDistribution(distributionType);
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistribution);
}
}
}
return(result);
}
public static Business.Client.Model.PhysicianClientDistributionList GetPhysicianClientDistributionByPhysicianFirstLastNameV2(string firstName, string lastName)
{
Business.Client.Model.PhysicianClientDistributionList result = new Client.Model.PhysicianClientDistributionList();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select c.ClientId, c.ClientName, ph.PhysicianId, ph.DisplayName [PhysicianName], c.DistributionType, c.Fax [FaxNumber], c.LongDistance " +
"from tblClient c " +
"join tblPhysicianClient pp on c.clientid = pp.clientid " +
"Join tblPhysician ph on pp.ProviderId = ph.ObjectId " +
"where ph.FirstName like @FirstName + '%' and ph.LastName like @LastName + '%' order by ph.LastName, ph.FirstName, c.ClientName";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar, 50).Value = firstName;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar, 50).Value = lastName;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Business.Client.Model.PhysicianClientDistributionListItem physicianClientDistribution = new Business.Client.Model.PhysicianClientDistributionListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistribution);
}
}
}
return result;
}
