/// <summary>
///
/// </summary>
/// <param name="providerGroupId"></param>
/// <param name="grpBlncId"></param>
/// <returns></returns>
public ExpenditureEntity GetIndividualExpenditure(int providerGroupId, int grpBlncId)
{
ExpenditureEntity expenditureEntity = null;
ExpenditureEntityList expenditure = null;
ItemList itemData = null;
var expenditureList = new List <ExpenditureEntityList>();
object[] param = { providerGroupId, grpBlncId };
var dbCommand = _db.GetCommand("GET_INDIVIDUAL_EXPENDITURE_LIST", param);
var expenditureReader = _db.ExecuteDataSet(dbCommand);
for (int i = 0; i < expenditureReader.Tables[0].Rows.Count; i++)
{
var data = expenditureReader.Tables[0].Rows[i];
expenditureEntity = new ExpenditureEntity
{
TotalAmount = Convert.ToDecimal(data["totalamount"]),
RemainingAmount = Convert.ToDecimal(data["remainingamount"])
};
}
for (int i = 0; i < expenditureReader.Tables[1].Rows.Count; i++)
{
var data = expenditureReader.Tables[1].Rows[i];
expenditure = new ExpenditureEntityList
{
ProviderId = Convert.ToInt32(data["providerid"]),
ProviderName = data["firstname"].ToString(),
IndividualTotal = Convert.ToDecimal(data["total"])
};
var itemlist = new List <ItemList>();
for (int j = 0; j < expenditureReader.Tables[2].Rows.Count; j++)
{
var itemDetails = expenditureReader.Tables[2].Rows[j];
if (expenditure.ProviderId == Convert.ToInt32(itemDetails["providerid"]))
{
itemData = new ItemList
{
Cost = Convert.ToDecimal(itemDetails["cost"]),
ItemName = itemDetails["itemname"].ToString(),
SpentDate = Convert.ToString(itemDetails["createddate"]),
};
itemlist.Add(itemData);
}
}
expenditure.ItemList = itemlist;
expenditureList.Add(expenditure);
}
expenditureEntity.ExpenditureEntityList = expenditureList;
return(expenditureEntity);
}
/// <summary>
///
/// </summary>
/// <param name="providerGroupId"></param>
/// <param name="grpBlncId"></param>
/// <returns></returns>
public ExpenditureEntity GetExpenditure(int providerGroupId, int grpBlncId)
{
ExpenditureEntity expenditureEntity = null;
object[] param = { providerGroupId, grpBlncId };
var dbCommand = _db.GetCommand("GET_TOTAL_EXPENDITURE", param);
var expenditureReader = _db.ExecuteReader(dbCommand);
while (expenditureReader.Read())
{
expenditureEntity = new ExpenditureEntity
{
TotalAmount = Convert.ToDecimal(expenditureReader["TotalAmount"]),
RemainingAmount = Convert.ToDecimal(expenditureReader["RemainingAmount"])
};
}
return(expenditureEntity);
}
