public static RationCardDetail FetchFamilyCount(string custId)
{
ErrorEnum errType = ErrorEnum.Other;
string errMsg = string.Empty;
bool isSuccess = false;
Exception errObj = new Exception();
int convertedNum = 0;
RationCardDetail card = new RationCardDetail();
try
{
DataSet ds = DBoperationsManager.FetchFamilyCount(custId, out errType, out errMsg, out isSuccess, out errObj);
if ((ds != null) && (ds.Tables.Count > 1))
{
card.FamilyCount = (( //TOTAL_CARD_COUNT
(ds.Tables[0].Rows.Count > 0) && Int32.TryParse(ds.Tables[0].Rows[0][0].ToString(), out convertedNum))
? convertedNum : 0).ToString();
card.CardCount = (( //Active_CARD_COUNT
(ds.Tables[1].Rows.Count > 0) && Int32.TryParse(ds.Tables[1].Rows[0][0].ToString(), out convertedNum))
? convertedNum : 0).ToString();
}
}
catch (Exception ex)
{
Logger.LogError(ex);
}
return(card);
}
