public static decimal getReserveAmt(int clWfId, int isEmergency)
{
DataAccess dba = new DataAccess();
dba.dxAddParameter("@WfId", clWfId);
object RetValue;
if (isEmergency == 1)
{
RetValue = dba.dxGetData("select IsNull(AppReserve1, 0) as AppReserve1 from ClaimPrelimReport where ClaimId = (select claimId from claims where wfId = @WfId)");
}
else
{
RetValue = dba.dxGetData("select IsNull(AppReserve2, 0) as AppReserve2 from ClaimPrelimReport where ClaimId = (select claimId from claims where wfId = @WfId)");
}
if (RetValue != null)
{
return(Decimal.Parse(RetValue.ToString()));
}
else
{
return(Decimal.Parse("0"));
}
}
