static public Employee FromModelEmployee(Expenses.Model.Employee employee)
{
return
new Employee()
{
Alias = employee.Alias,
EmployeeId = employee.EmployeeId,
Manager = employee.Manager,
Name = employee.Name,
};
}
public Facede(Bll.Facede Application)
{
corporationExpenses = new CorporationExpenses(Application);
corporationRevenues = new CorporationRevenues(Application);
expenseItem = new ExpenseItem(Application);
expenses = new Expenses(Application);
memberExpenses = new MemberExpenses(Application);
memberRevenues = new MemberRevenues(Application);
revenueItem = new RevenueItem(Application);
revenues = new Revenues(Application);
}
public async Task <IActionResult> Create([Bind("Id,Name,Details,Amount,Date")] Expenses expenses)
{
if (ModelState.IsValid)
{
_context.Add(expenses);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(expenses));
}
public void GetExpenses()
{
var expenses = Expense.GetExpenses();
Expenses.Clear();
foreach (var expense in expenses)
{
Expenses.Add(expense);
}
}
public async Task <IHttpActionResult> PostExpenses(Expenses expenses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Expenses.Add(expenses);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = expenses.Id }, expenses));
}
public void Save(ExpensesModel expeModel)
{
using (var c = new EntityContext())
{
ExpensesOperation operation = new ExpensesOperation();
Expenses dto = new Expenses();
dto.Amount = Amount;
dto.Description = Description;
dto.BudgetId = expeModel.BudgetId;
operation.Add(dto, c);
}
}
public async Task <IActionResult> Delete(int id)
{
Expenses expenses = await _expensesRepository.GetItem(id);
if (expenses == null)
{
return(NotFound());
}
await _expensesRepository.Remove(expenses);
return(Ok());
}
private Expenses toExpenses(Expenses p, ExpensesModel i)
{
p.Category_FK = i.Category_FK;
p.Date_purchase = i.Date_purchase;
p.Expenses_PK = i.Expenses_PK;
p.Login_FK = i.Login_FK;
p.Name_expenses = i.Name_expenses;
p.Necessity = i.Necessity;
p.Sum_expenses = i.Sum_expenses;
return(p);
}
public static void GetCSVData(ref Expenses dtsExpenses, ref List <string> errorlog)
{
string[] csvFiles = Directory.GetFiles(Model.ModelBusinessRules.GetCSVLocation());
foreach (string csvFile in csvFiles)
{
MessageBox.Show("" + csvFile);
DataTable t = DataUtils.GetDataTabletFromCSVFile(csvFile);
DataUtils.ConsolidateDataTableToExpenses(t, ref dtsExpenses, csvFile, ref errorlog);
}
}
public double GetMaxExpense()
{
try
{
return(Expenses.Max(x => x.Value));
}
catch (Exception e)
{
Console.WriteLine(e);
return(0);
}
}
public Result GetExpenses(int ExpenseTypeId, string descriptionSearch, DateTime fromDate, DateTime toDate, string orderBy, string direction,
int startRowIndex, int maximumRows, int branchId)
{
Result objResult = new Result();
try
{
var param = new DbParam[9];
param[0] = new DbParam("@SortBy", orderBy, SqlDbType.VarChar);
param[1] = new DbParam("@SortDirection", direction, SqlDbType.VarChar);
param[2] = new DbParam("@StartRowIndex", startRowIndex, SqlDbType.Int);
param[3] = new DbParam("@MaximumRows", maximumRows, SqlDbType.Int);
param[4] = new DbParam("@ExpenseTypeId", ExpenseTypeId, SqlDbType.Int);
param[5] = new DbParam("@DescriptionSearch", descriptionSearch, SqlDbType.VarChar);
param[6] = new DbParam("@FromDate", fromDate, SqlDbType.DateTime);
param[7] = new DbParam("@ToDate", toDate, SqlDbType.DateTime);
param[8] = new DbParam("@BranchId", branchId, SqlDbType.Int);
DataSet ds = Db.GetDataSet("SP_EXPENSES_GET", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
IList <Expenses> expenses = new List <Expenses>();
foreach (DataRow row in ds.Tables[0].Rows)
{
Expenses expense = new Expenses();
expense.ExpenseId = Db.ToInteger(row["ExpenseId"]);
expense.ExpenseType = new ExpenseType();
expense.ExpenseType.TypeName = Db.ToString(row["TypeName"]);
expense.ExpenseAmount = Db.ToString(row["ExpenseAmount"]);
expense.ExpenseDate = Db.ToDateTime(row["ExpenseDate"]);
expense.ExpenseDescription = Db.ToString(row["ExpenseDescription"]);
expenses.Add(expense);
}
objResult.Items = expenses;
objResult.ItemCount = 0;
if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0)
{
objResult.ItemCount = Db.ToInteger(ds.Tables[1].Rows[0]["ExpenseCount"]);
}
}
}
catch (Exception ex)
{
//CommonFunctions.LogError(ex, ErrorLog.LogSeverity.Error);
}
return(objResult);
}
private async Task ExecuteLoadExpenses()
{
Initialized = true;
IsBusy = true;
Expenses.Clear();
//var expenses = await AzureService.Instance.GetExpensesAsync();
//foreach (var expense in expenses)
// Expenses.Add(expense);
IsBusy = false;
}
public async Task <IActionResult> PostExpenses([FromBody] Expenses expenses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Expenses.Add(expenses);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetExpenses", new { id = expenses.ExpenseId }, expenses));
}
public async Task <IActionResult> PostExpenses([FromBody] Expenses expenses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_expensesRepository.CreateExpense(expenses);
await _expensesRepository.Save();
return(CreatedAtAction("GetExpenses", new { id = expenses.Id }, expenses));
}
public async Task CreateComunication(Expenses expenses,
ExpensesCategory expensesCategory)
{
var expCategory = new ExpCategory()
{
ExpensesId = expenses.Id,
ExpensesCategoryId = expensesCategory.Id
};
_context.ExpCategories.Add(expCategory);
await _context.SaveChangesAsync();
}
public IHttpActionResult PostExpenses(Expenses expenses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Expenses.Add(expenses);
db.SaveChanges();
return(CreatedAtRoute("API", new { id = expenses.Id }, expenses));
}
public IEnumerator SaveData(Expenses a_expenses)
{
ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Bazaar[m_myDate.Day - 1] = a_expenses.Bazaar;
ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Shopping[m_myDate.Day - 1] = a_expenses.Shopping;
ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Office[m_myDate.Day - 1] = a_expenses.Office;
ExpenseDataHandler.m_yearlyExpenseInfo.expenseInfo[m_myDate.Month - 1].Others[m_myDate.Day - 1] = a_expenses.Other;
yield return(new WaitForSeconds(0.5f));
ExpenseDataHandler.SaveData("2018", ExpenseDataHandler.m_yearlyExpenseInfo);
MonthManager.m_instance.m_Start();
}
public static Expenses GetDailyExpenseData(DateTime a_dateTime)
{
Expenses expenses = new Expenses();
ExpenseInfo l_expenseInfo = m_yearlyExpenseInfo.expenseInfo[a_dateTime.Month - 1];
expenses.Bazaar = l_expenseInfo.Bazaar[a_dateTime.Day - 1];
expenses.Shopping = l_expenseInfo.Shopping[a_dateTime.Day - 1];
expenses.Office = l_expenseInfo.Office[a_dateTime.Day - 1];
expenses.Other = l_expenseInfo.Others[a_dateTime.Day - 1];
return(expenses);
}
public async Task DeleteExpense(Expense expense)
{
var result = await _apiClient.DeleteAsync($"Expenses/{expense.StatementId}");
if (!result.IsSuccessStatusCode)
{
return;
}
Expenses.Remove(expense);
await OnDeleted();
}
public void ReadExpenses()
{
IsRefreshing = true;
var expenses = Expense.ReadExpenses();
Expenses.Clear();
foreach (var expense in expenses)
{
Expenses.Add(expense);
}
IsRefreshing = false;
}
public static Expenses ReadExpense(string prompt)
{
Expenses result = new Expenses();
Console.WriteLine(prompt);
result.expense = ReadInteger("Enter Cost: ");
result.kind = Expenses.ReadKind("Enter type of expense: ");
return(result);
}
public Expenses GetExpenses(int id)
{
List <Expenses> Expensess = new List <Expenses>();
DataTable data = DataProvider.Instance.ExecuteQuery("Select * from doan where id_chi_phi = @id ;", new object[] { id });
foreach (DataRow item in data.Rows)
{
Expenses Expenses = new Expenses(item);
Expensess.Add(Expenses);
}
return(Expensess[0]);
}
public List <Expenses> GetAllExpenses()
{
List <Expenses> expensess = new List <Expenses>();
DataTable data = DataProvider.Instance.ExecuteQuery("Select * from chi_phi;");
foreach (DataRow item in data.Rows)
{
Expenses expenses = new Expenses(item);
expensess.Add(expenses);
}
return(expensess);
}
public double GetSpendings()
{
try
{
return(Expenses.Sum(x => x.Value));
}
catch (Exception e)
{
Console.WriteLine(e);
return(0);
}
}
public async Task <bool> DeleteExpenseAsync(int id)
{
var item = await Expenses.FirstOrDefaultAsync(x => x.Id == id).ConfigureAwait(false);
if (item != null)
{
Expenses.Remove(item);
await SaveChangesAsync().ConfigureAwait(false);
}
return(true);
}
static void Main(string[] args)
{
/* CRIANDO OS QUARTOS DO HOTEL */
//var _simple = new SimpleBuilder();
//var _double = new DoubleBuilder();
//var _triple = new TripleBuilder();
/* DIRETORES QUE CONSTROEM PELO TIPO DO HOTEL*/
//var _DirectorSimple = new DirectorRoom(_simple);
//var _DirectorDouble = new DirectorRoom(_double);
//var _DirectorTriple = new DirectorRoom(_triple);
//_DirectorSimple.Make();
//SimpleRoom a = _simple.build();
//Console.WriteLine(a.DescriptionRoom);
//a.Message();
// FACTORYYYYYYYYYYYY
ExpensesFactory expensesFactory = null;
Console.Write("Digite o tipo de cartão que gostaria de obter:");
string console = Console.ReadLine();
switch (console.ToLower())
{
case "diaria":
expensesFactory = new DailyFactory("Diaria Do Hotel", 200);
break;
case "alimento":
expensesFactory = new FoodFactory("Barra de Cereal", 5);
break;
case "Telefone":
expensesFactory = new TelephoneFactory("Ligação 01", 19);
break;
default:
break;
}
Expenses expenses = expensesFactory.getExpenses();
Console.WriteLine($"Tipo de despesa: {expenses.DescricaoDespesa} e valor: {expenses.Valor}");
Console.ReadKey();
expensesFactory = new TelephoneFactory("Ligação 01", 19);
}
public async Task <IActionResult> Edit(int id, [Bind("ExpenseId,UserId,MortgageRent,Phone,Gas,WaterSewerTrash,Electricity,CableInternet,HomeAlarmSystem,MaintenanceRepairs,VehiclePayment,Insurance,Fuel,UberLyft,LicenseRegistration,Maintenance,HomeRenters,Health,Dental,Vision,Pet,Life,Groceries,DiningOut,Coffee,ClothesShoes,SchoolTuitionSupplies,SportsOrganizationFees,Childcare,LunchMoney,ToysGames,HairCutsSalon,ManiPediWaxing,ClothesShoesAccessories,DryCleaning,GymSupplements,OrganizationDuesFees,Music,Video,MovieTheater,Concerts,SportingEvents,DateNights,Alchohol,TobaccoVaping,PersonalLoan,CreditCard,StudentLoan,Federal,State,Medicare,SocialSecurityFICA,EmergencySavings,CDsMoneyMarkets,IRA401k,StocksMutualFunds,Tithesffering,Charity,RetirementHome,Attorney,AlimonyChildSupport,LienJudgmentPayment,MonthlyIncome,TotalCost,IncomeVsTotal")] Expenses expenses)
{
expenses.ExpenseId = id;
if (id != expenses.ExpenseId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
expenses.UserId = HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
expenses.TotalCost = expenses.MortgageRent + expenses.Phone + expenses.Gas + expenses.WaterSewerTrash +
expenses.Electricity + expenses.CableInternet +
expenses.HomeAlarmSystem + expenses.MaintenanceRepairs + expenses.VehiclePayment + expenses.Insurance +
expenses.Fuel + expenses.UberLyft + expenses.LicenseRegistration + expenses.Maintenance +
expenses.HomeRenters + expenses.Health + expenses.Dental + expenses.Vision + expenses.Pet +
expenses.Life + expenses.Groceries + expenses.DiningOut +
expenses.Coffee + expenses.ClothesShoes + expenses.SchoolTuitionSupplies +
expenses.SportsOrganizationFees + expenses.Childcare +
expenses.LunchMoney + expenses.ToysGames + expenses.HairCutsSalon + expenses.ManiPediWaxing +
expenses.ClothesShoesAccessories +
expenses.DryCleaning + expenses.GymSupplements + expenses.OrganizationDuesFees + expenses.Music +
expenses.Video + expenses.MovieTheater +
expenses.Concerts + expenses.SportingEvents + expenses.DateNights + expenses.Alchohol +
expenses.TobaccoVaping + expenses.PersonalLoan + expenses.CreditCard +
expenses.StudentLoan + expenses.Federal + expenses.State + expenses.Medicare +
expenses.SocialSecurityFICA + expenses.EmergencySavings + expenses.CDsMoneyMarkets +
expenses.IRA401k + expenses.StocksMutualFunds + expenses.Tithesffering + expenses.Charity +
expenses.RetirementHome + expenses.Attorney +
expenses.AlimonyChildSupport + expenses.LienJudgmentPayment;
expenses.IncomeVsTotal = expenses.MonthlyIncome - expenses.TotalCost;
_context.Update(expenses);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ExpensesExists(expenses.ExpenseId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["UserId"] = new SelectList(_context.ApplicationUsers, "Id", "Id", expenses.UserId);
return(View(expenses));
}
private Expenses convertSelectedRowDataToExpenses(DataGridView dtGridExpenses)
{
if (dtGridExpenses.SelectedRows.Count >= 1)
{
DataRow dr = getSelectedDataRowForExpenses(dtGridExpenses);
if (dr != null)
{
Expenses Expenses = GetById(int.Parse(dr.Field <string>("ID")), int.Parse(dr.Field <string>("PID")));
return(Expenses);
}
}
return(null);
}
private void _PopulateDetails(Expenses trans)
{
lblID.Text = trans.Id.ToString();
txtAmount.Text = trans.Amount.ToString();
txtCostCenter.Text = trans.CostCenter;
txtCurrency.Text = trans.Currency;
txtDate.Text = trans.DateofExpenses.ToString("dd-MMM-yyyy");
txtDescription.Text = trans.Description;
txtExchangeRate.Text = trans.ExchangeRate.ToString();
txtGLCode.Text = trans.GLCode;
txtGST.Text = trans.GST.ToString();
txtTotalAmount.Text = trans.TotalAmount.ToString();
}
public object Clone()
{
FinancialPlan clone = new FinancialPlan
{
Income = Income,
Savings = Savings,
PlannedSavings = PlannedSavings,
FinancialGoals = (List <FinancialGoal>)FinancialGoals.Clone(),
Expenses = (List <Expense>)Expenses.Clone()
};
return(clone);
}
private async Task UpdateExpensesInView()
{
Expenses.Clear();
var expenses = await GetExpenses();
var sortedExpenses = expenses.Cast <Expense>().OrderByDescending((x) => x.CreationDateTime).Select(x => x);
foreach (var expense in sortedExpenses)
{
Expenses.Add(expense);
}
//Expenses = new ObservableCollection<Expense>(sortedExpenses);
}
public static int DeleteOtherExpense(int id)
{
Entities entities = new Entities();
DateTime current = DateTime.Now;
Expenses otherExpense = entities.Expenses.Where(x => x.Id == id).FirstOrDefault();
otherExpense.DisabledDate = current;
otherExpense.DisabledBy = Constants.Constants.USER;
entities.Expenses.Attach(otherExpense);
entities.Entry(otherExpense).State = System.Data.Entity.EntityState.Modified;
return(entities.SaveChanges());
}
static public SummaryItem FromModelSummaryItem(Expenses.Model.SummaryItem summaryItem)
{
return
new SummaryItem()
{
Amount = summaryItem.Amount,
Date = summaryItem.Date,
Description = summaryItem.Description,
Id = summaryItem.Id,
ItemType = (ItemType) summaryItem.ItemType,
Submitter = summaryItem.Submitter,
};
}
static public ExpenseReport FromModelExpenseReport(Expenses.Model.ExpenseReport expenseReport)
{
return
new ExpenseReport()
{
Amount = expenseReport.Amount,
Approver = expenseReport.Approver,
CostCenter = expenseReport.CostCenter,
DateResolved = expenseReport.DateResolved,
DateSaved = expenseReport.DateSaved,
DateSubmitted = expenseReport.DateSubmitted,
EmployeeId = expenseReport.EmployeeId,
ExpenseReportId = expenseReport.ExpenseReportId,
Notes = expenseReport.Notes,
OwedToCreditCard = expenseReport.OwedToCreditCard,
OwedToEmployee = expenseReport.OwedToEmployee,
Purpose = expenseReport.Purpose,
Status = (int) expenseReport.Status,
};
}
static public Charge FromModelCharge(Expenses.Model.Charge charge)
{
Charge newCharge =
new Charge()
{
AccountNumber = charge.AccountNumber,
BilledAmount = charge.BilledAmount,
ChargeId = charge.ChargeId,
Category = charge.Category,
Description = charge.Description,
EmployeeId = charge.EmployeeId,
ExpenseDate = charge.ExpenseDate,
ExpenseReportId = charge.ExpenseReportId,
ExpenseType = charge.ExpenseType,
Location = charge.Location,
Merchant = charge.Merchant,
Notes = charge.Notes,
ReceiptRequired = charge.ReceiptRequired,
TransactionAmount = charge.TransactionAmount,
};
return newCharge;
}
public static void ProcessExpensesRepaidClosed (BasicEvent newEvent)
{
Person expenser = Person.FromIdentity(newEvent.VictimPersonId);
Person payer = Person.FromIdentity(newEvent.PerpetratorPersonId);
// The ParameterText field is like a,b,c,d where a..d are expense IDs
string[] idStrings = newEvent.ParameterText.Split(',');
Expenses expenses = new Expenses();
decimal totalAmount = 0.0m;
foreach (string idString in idStrings)
{
Expense newExpense = Expense.FromIdentity(Int32.Parse(idString));
totalAmount += newExpense.Amount;
expenses.Add (newExpense);
}
string body = "The following expenses, totaling " + totalAmount.ToString ("#,##0.00") + ", have been repaid to your registered account, " + expenser.BankName + " " + expenser.BankAccount + ".\r\n\r\n";
body += FormatExpenseLine ("#", "Description", "Amount");
body += FormatExpenseLine ("===", "========================================", "=========");
foreach (Expense expense in expenses)
{
body += FormatExpenseLine (expense.Identity.ToString(), expense.Description, expense.Amount.ToString ("#,##0.00"));
}
body += FormatExpenseLine ("---", "----------------------------------------", "---------");
body += FormatExpenseLine (string.Empty, "TOTAL", totalAmount.ToString ("#,##0.00"));
body += "\r\nIf you see any problems with this, please contact the treasurer, " + payer.Name + ", at " + payer.PPMailAddress + ". Thank you for helping the pirate movement succeed.\r\n";
new PirateWeb.Utility.Mail.MailTransmitter("PirateWeb", "*****@*****.**",
"Expenses Repaid: " + totalAmount.ToString("#,##0.00"), body, expenser, true).Send();
}
public static ICollection<Expenses> ReadExpensesFromXml()
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
using (supermarketEntities sqlDb = new supermarketEntities())
{
Dictionary<string, int> vendorIds = new Dictionary<string, int>();
var vendors = sqlDb.Vendors;
foreach (var item in vendors)
{
vendorIds.Add(item.VendorName, item.ID);
}
List<Expenses> expenses = new List<Expenses>();
using (XmlReader reader = XmlReader.Create("../../../Vendor-Expences.xml"))
{
string name = "";
string date = null;
decimal expense = 0;
while (reader.Read())
{
if ((reader.NodeType == XmlNodeType.Element) &&
(reader.Name == "sale"))
{
name = reader.GetAttribute(0);
}
else if ((reader.NodeType == XmlNodeType.Element) &&
(reader.Name == "expenses"))
{
date = reader.GetAttribute("month");
expense = decimal.Parse(reader.ReadElementContentAsString());
Expenses newExpense = new Expenses()
{
ID = expenses.Count+1,
VendorID = vendorIds[name],
Expenses1 = expense,
Mounth = date
};
expenses.Add(newExpense);
}
}
}
return expenses;
}
}
/// <summary>
/// There are no comments for Expenses in the schema.
/// </summary>
public void AddToExpenses(Expenses expenses)
{
base.AddObject("Expenses", expenses);
}
/// <summary>
/// Create a new Expenses object.
/// </summary>
/// <param name="id">Initial value of Id.</param>
/// <param name="description">Initial value of Description.</param>
/// <param name="title">Initial value of Title.</param>
public static Expenses CreateExpenses(long id, string description, string title)
{
Expenses expenses = new Expenses();
expenses.Id = id;
expenses.Description = description;
expenses.Title = title;
return expenses;
}
