/// <summary>
/// Add Expense
/// </summary>
/// <param name="expenseSaveData">Expense Save Data</param>
public void AddExpense(ExpenseMembers expenseSaveData)
{
SqlCommand objSqlCmd = new SqlCommand();
objSqlCmd.CommandType = CommandType.StoredProcedure;
objSqlCmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = expenseSaveData.Description;
objSqlCmd.Parameters.Add("@BudgetCategoryId", SqlDbType.Int).Value = expenseSaveData.BudgetCategory;
objSqlCmd.Parameters.Add("@SpentOn", SqlDbType.DateTime).Value = expenseSaveData.SpentOn;
objSqlCmd.Parameters.Add("@SpentBy", SqlDbType.Text).Value = expenseSaveData.SpentBy;
objSqlCmd.Parameters.Add("@SpentAmount", SqlDbType.Money).Value = expenseSaveData.SpentAmount;
objSqlCmd.Parameters.Add("@GroupIds", SqlDbType.Structured).Value = StructuredParameterHelper.ListToDataTableConverter <string>(expenseSaveData.SelectedGroupId, "Groups", "GroupID");
objSqlCmd.Parameters.Add("@UserIds", SqlDbType.Structured).Value = StructuredParameterHelper.ListToDataTableConverter <string>(expenseSaveData.ExcludedUsers, "Users", "UserId");
objSqlCmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = expenseSaveData.CreatedBy;
objSqlCmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = userSession.CompanyId;
DataLibrary.ExecuteProcedureWithDefinedParameters(objSqlCmd, "bspAddExpenses");
}
