public static string GetStatReasonNotAvail(string bedRowId)
{
string result = string.Empty;
string cmdString = QueryString.GetStatReasonNotAvailQueryString(bedRowId);
var value = InterSystemsDA.ExecuteScalarBindDataCommand(cmdString, Constants.Cache89ConnectionString);
if (!string.IsNullOrEmpty(value))
{
int intValue = 0;
if (Int32.TryParse(value, out intValue))
{
if (intValue == 3)
{
result = "W";
}
else if (intValue == 6)
{
result = "R";
}
else if (intValue == 7)
{
result = "O";
}
else if (intValue > 0)
{
result = "C";
}
}
}
return(result);
}
public static string GetBedType(string bedRowId)
{
string result = string.Empty;
string cmdString = QueryString.GetBedTypeQueryString(bedRowId);
result = InterSystemsDA.ExecuteScalarBindDataCommand(cmdString, Constants.Cache89ConnectionString);
result = result.Substring(2, 1);
return(result.Trim());
}