public static YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse DoesContainerIdExist(string containerId, string clientOrderDetailId)
{
YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse result = new YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select count(*) from tblClientOrderDetail where ContainerId = @ContainerId and ClientOrderDetailId <> @ClientOrderDetailId";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@ContainerId", SqlDbType.VarChar).Value = containerId;
cmd.Parameters.Add("@ClientOrderDetailId", SqlDbType.VarChar).Value = clientOrderDetailId;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
int count = (int)dr[0];
if (count > 0)
{
result.Found = true;
}
}
}
}
return(result);
}
public static YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse DoesContainerIdExist(string containerId, string clientOrderDetailId)
{
YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse result = new YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select count(*) from tblClientOrderDetail where ContainerId = @ContainerId and ClientOrderDetailId <> @ClientOrderDetailId";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.Add("@ContainerId", SqlDbType.VarChar).Value = containerId;
cmd.Parameters.Add("@ClientOrderDetailId", SqlDbType.VarChar).Value = clientOrderDetailId;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
int count = (int)dr[0];
if (count > 0)
{
result.Found = true;
}
}
}
}
return result;
}
private bool ContainerExists()
{
YellowstonePathology.YpiConnect.Proxy.ClientOrderServiceProxy proxy = new Proxy.ClientOrderServiceProxy();
YellowstonePathology.Business.ClientOrder.Model.ContainerIdLookupResponse containerIdLookupResponse = proxy.DoesContainerIdExist(this.TextBlockContainerId.Text, this.m_ClientOrderDetailClone.ClientOrderDetailId);
return(containerIdLookupResponse.Found);
}
