/// <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"); }