public bool Update(TotalExpenses totalExpenses)
{
try
{
var updateEntity = _totalExpensesRepo.Find(totalExpenses.Id);
AutoMapper.Mapper.DynamicMap(totalExpenses, updateEntity);
_totalExpensesRepo.Update(updateEntity);
_uow.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Insert(TotalExpenses totalExpenses)
{
try
{
var newEntity = AutoMapper.Mapper.DynamicMap <TotalExpenses>(totalExpenses);
newEntity.Status = Status.Active;
_totalExpensesRepo.Insert(newEntity);
_uow.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
private void Update()
{
var month = this.MonthName;
if (month.Equals("All"))
{
Expenses = TotalExpenses;
var max = TotalExpenses.Where(x => x.AccountType == AccountType.Negative).Max(x => x.Amount);
var maxExpense = TotalExpenses.First(x => x.Amount.Equals(max));
MostSpent = max.ToString("c") + " in " +
CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(maxExpense.DateTime.Month) + " " +
maxExpense.DateTime.Year;
var min = TotalExpenses.Where(x => x.AccountType == AccountType.Negative).Min(x => x.Amount);
var minExpense = TotalExpenses.First(x => x.Amount.Equals(min));
LeastSpent = min.ToString("c") + " in " +
CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(minExpense.DateTime.Month) + " " +
minExpense.DateTime.Year;
var avg = TotalExpenses.Where(x => x.AccountType == AccountType.Negative).Average(x => x.Amount);
AverageSpent = avg.ToString("c") + "/month";
}
else
{
Expenses = TotalExpenses.Where(ed =>
{
var m = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(ed.DateTime.Month);
return(m.ToLower().Equals(month.ToString().ToLower()));
}).ToList();
if (Expenses.Count > 0)
{
var max = Expenses.Where(x => x.AccountType == AccountType.Negative).Max(x => x.Amount);
var maxExpense = Expenses.First(x => x.Amount.Equals(max));
MostSpent = max.ToString("c") + " on " +
CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(maxExpense.DateTime.Month) + " " +
maxExpense.DateTime.Day;
var min = Expenses.Where(x => x.AccountType == AccountType.Negative).Min(x => x.Amount);
var minExpense = Expenses.First(x => x.Amount.Equals(max));
LeastSpent = min.ToString("c") + " on " +
CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(minExpense.DateTime.Month) + " " +
minExpense.DateTime.Day;
var avg = Expenses.Where(x => x.AccountType == AccountType.Negative).Average(x => x.Amount);
AverageSpent = avg.ToString("c") + "/month";
}
}
if (Expenses.Count > 0)
{
PositiveAmount = Expenses.Where(x => x.AccountType == AccountType.Positve).Sum(x => x.Amount);
NegativeAmount = Expenses.Where(x => x.AccountType == AccountType.Negative).Sum(x => x.Amount);
BalanceAmount = PositiveAmount - NegativeAmount;
NoPositiveTransactions = Expenses.Count(x => x.AccountType == AccountType.Positve);
NoNegativeTransactions = Expenses.Count(x => x.AccountType == AccountType.Negative);
NoTotalTransactions = NoPositiveTransactions + NoNegativeTransactions;
}
#region PieData
_homeAmount = Expenses.Where(x => x.CategoryName == "Home").Sum(x => x.Amount);
_securityAmount = Expenses.Where(x => x.CategoryName == "Daily Living").Sum(x => x.Amount);
_entertainmentAmount = Expenses.Where(x => x.CategoryName == "Entertainment").Sum(x => x.Amount);
_healthAmount = Expenses.Where(x => x.CategoryName == "Health").Sum(x => x.Amount);
_transportAmount = Expenses.Where(x => x.CategoryName == "Transportation").Sum(x => x.Amount);
_mortgage = Expenses.Where(x => x.SubCategory == "Mortgage/rent").Sum(x => x.Amount);
_homerepair = Expenses.Where(x => x.SubCategory == "Home repairs").Sum(x => x.Amount);
_utilities = Expenses.Where(x => x.SubCategory == "Utilities").Sum(x => x.Amount);
_homeImprovement = Expenses.Where(x => x.SubCategory == "Home improvement").Sum(x => x.Amount);
_mobileTelephone = Expenses.Where(x => x.SubCategory == "Mobile telephone").Sum(x => x.Amount);
_drycleaing = Expenses.Where(x => x.SubCategory == "Dry cleaning").Sum(x => x.Amount);
_dininout = Expenses.Where(x => x.SubCategory == "Dining out").Sum(x => x.Amount);
_groceries = Expenses.Where(x => x.SubCategory == "Groceries").Sum(x => x.Amount);
_movies = Expenses.Where(x => x.SubCategory == "Movies/plays").Sum(x => x.Amount);
_clubs = Expenses.Where(x => x.SubCategory == "Concerts/clubs").Sum(x => x.Amount);
_insurance = Expenses.Where(x => x.SubCategory == "Insurance (H)").Sum(x => x.Amount);
_prescriptions = Expenses.Where(x => x.SubCategory == "Prescriptions").Sum(x => x.Amount);
_gas = Expenses.Where(x => x.SubCategory == "Gas/fuel").Sum(x => x.Amount);
_repairs = Expenses.Where(x => x.SubCategory == "Repairs").Sum(x => x.Amount);
_parking = Expenses.Where(x => x.SubCategory == "Parking").Sum(x => x.Amount);
_clothing = Expenses.Where(x => x.SubCategory == "Clothing").Sum(x => x.Amount);
_gifts = Expenses.Where(x => x.SubCategory == "Gifts").Sum(x => x.Amount);
_books = Expenses.Where(x => x.SubCategory == "Books").Sum(x => x.Amount);
PieExpense = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Home", Amount = _homeAmount
},
new CompanyExpense {
ExpenseCategory = "Daily Living", Amount = _securityAmount
},
new CompanyExpense {
ExpenseCategory = "Entertainment", Amount = _entertainmentAmount
},
new CompanyExpense {
ExpenseCategory = "Health", Amount = _healthAmount
},
new CompanyExpense {
ExpenseCategory = "Transportation", Amount = _transportAmount
},
new CompanyExpense {
ExpenseCategory = "Personal", Amount = _transportAmount
}
};
Home = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Mortgage/rent", Amount = _mortgage
},
new CompanyExpense {
ExpenseCategory = "Home repairs", Amount = _homerepair
},
new CompanyExpense {
ExpenseCategory = "Utilities", Amount = _utilities
},
new CompanyExpense {
ExpenseCategory = "Home improvement", Amount = _homeImprovement
},
new CompanyExpense {
ExpenseCategory = "Mobile telephone", Amount = _mobileTelephone
}
};
DailyLiving = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Dry cleaning", Amount = _drycleaing
},
new CompanyExpense {
ExpenseCategory = "Dining out", Amount = _dininout
},
new CompanyExpense {
ExpenseCategory = "Groceries", Amount = _groceries
}
};
Entertainment = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Movies/plays", Amount = _movies
},
new CompanyExpense {
ExpenseCategory = "Concerts/clubs", Amount = _clubs
}
};
Health = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Insurance (H)", Amount = _insurance
},
new CompanyExpense {
ExpenseCategory = "Prescriptions", Amount = _prescriptions
}
};
Transportation = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Gas/fuel", Amount = _gas
},
new CompanyExpense {
ExpenseCategory = "Repairs", Amount = _repairs
},
new CompanyExpense {
ExpenseCategory = "Parking", Amount = _parking
}
};
Personal = new List <CompanyExpense>
{
new CompanyExpense {
ExpenseCategory = "Clothing", Amount = _clothing
},
new CompanyExpense {
ExpenseCategory = "Gifts", Amount = _gifts
},
new CompanyExpense {
ExpenseCategory = "Books", Amount = _books
}
};
PieConverter = new List <CompanyExpense>();
PieConverter = PieExpense;
#endregion
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (DailyCastingEntryType == 1)
{
#region Variables
DateTime ExpenseDate = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", DateTime.Now));
decimal Price = nudPrice.Value;
string Descriptions = txtDesciptions.Text;
#endregion
#region Service
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Vehicle_Service expense_Vehicle_Service = new Expense_Vehicle_Service(unitofWork);
TotalExpenses_Service totalExpenses_Service = new TotalExpenses_Service(unitofWork);
#endregion
if (Price > 0 && !string.IsNullOrEmpty(Descriptions))
{
DialogResult dialogResult = MessageBox.Show("Kaydı Eklemek İstediğinize Emin misiniz?", "Yeni Kayıt", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
Expense_Vehicle expense_Vehicle = new Expense_Vehicle()
{
ExpenseDate = ExpenseDate,
Descriptions = Descriptions,
Price = Price
};
if (expense_Vehicle_Service.Insert(expense_Vehicle))
{
TotalExpenses totalExpenses = totalExpenses_Service.GetTotalExpenses(ExpenseDate, ExpenseType.Vehicle);
if (totalExpenses != null)
{
totalExpenses.Price += Price;
if (totalExpenses_Service.Update(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
txtDesciptions.Text = "";
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
totalExpenses = new TotalExpenses()
{
ExpenseDate = ExpenseDate,
ExpenseType = ExpenseType.Vehicle,
ExpenseTypeDesciptions = "Araç",
Price = Price,
Status = Status.Active,
};
if (totalExpenses_Service.Insert(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
txtDesciptions.Text = "";
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Boş Geçilemez.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else if (DailyCastingEntryType == 2)
{
#region Variables
DateTime ExpenseDate = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", DateTime.Now));
InvoiceType invoiceType = new InvoiceType();
switch (cmbInvoice.SelectedValue)
{
case "0":
invoiceType = InvoiceType.That; break;
case "1":
invoiceType = InvoiceType.Electricity; break;
case "2":
invoiceType = InvoiceType.NaturalGas; break;
case "3":
invoiceType = InvoiceType.Internet; break;
case "4":
invoiceType = InvoiceType.Other; break;
default:
break;
}
string Descriptions = txtDesciptions.Text;
decimal Price = nudPrice.Value;
#endregion
#region Service
UnitofWork unitofWork = new UnitofWork(ctx);
Expense_Invoice_Service expense_Invoice_Service = new Expense_Invoice_Service(unitofWork);
TotalExpenses_Service totalExpenses_Service = new TotalExpenses_Service(unitofWork);
#endregion
if (Price > 0 && cmbInvoice.Text != "Fatura Tipi Seçiniz...")
{
DialogResult dialogResult = MessageBox.Show("Kaydı Eklemek İstediğinize Emin misiniz?", "Yeni Kayıt", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
Expense_Invoice expense_Invoice = new Expense_Invoice()
{
ExpenseDate = ExpenseDate,
InvoiceType = enumHelper.GetEnumDescription(invoiceType),
Descriptions = Descriptions,
Price = Price,
Status = Status.Active
};
if (expense_Invoice_Service.Insert(expense_Invoice))
{
TotalExpenses totalExpenses = totalExpenses_Service.GetTotalExpenses(ExpenseDate, ExpenseType.Invoice);
if (totalExpenses != null)
{
totalExpenses.Price += Price;
if (totalExpenses_Service.Update(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
cmbInvoice.SelectedIndex = 0;
txtDesciptions.Text = "";
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
totalExpenses = new TotalExpenses()
{
ExpenseDate = ExpenseDate,
ExpenseType = ExpenseType.Invoice,
ExpenseTypeDesciptions = "Fatura",
Price = Price,
Status = Status.Active,
};
if (totalExpenses_Service.Insert(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
cmbInvoice.SelectedIndex = 0;
txtDesciptions.Text = "";
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Boş Geçilemez.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else if (DailyCastingEntryType == 3)
{
#region Variables
DateTime ExpenseDate = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", DateTime.Now));
string SupplirsCode = cmbSuppliers.SelectedValue.ToString();
decimal Price = nudPrice.Value;
string Descriptions = txtDesciptions.Text;
#endregion
#region Service
UnitofWork unitofWork = new UnitofWork(ctx);
SupplierCompanies_Service supplierCompanies_Service = new SupplierCompanies_Service(unitofWork);
Expense_Suppliers_Service expense_Suppliers_Service = new Expense_Suppliers_Service(unitofWork);
TotalExpenses_Service totalExpenses_Service = new TotalExpenses_Service(unitofWork);
#endregion
if (!string.IsNullOrEmpty(SupplirsCode) && Price > 0)
{
DialogResult dialogResult = MessageBox.Show("Kaydı Eklemek İstediğinize Emin misiniz?", "Yeni Kayıt", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
SupplierCompanies supplierCompanies = supplierCompanies_Service.GetSupplierCompanies(SupplirsCode);
Expense_Suppliers expense_Suppliers = new Expense_Suppliers()
{
Status = Status.Active,
ExpenseDate = ExpenseDate,
Price = Price,
Descriptions = Descriptions,
SupplierCode = supplierCompanies.Code,
SupplierName = supplierCompanies.Name
};
if (expense_Suppliers_Service.Insert(expense_Suppliers))
{
TotalExpenses totalExpenses = totalExpenses_Service.GetTotalExpenses(ExpenseDate, ExpenseType.Suppliers);
if (totalExpenses != null)
{
totalExpenses.Price += Price;
if (totalExpenses_Service.Update(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
cmbSuppliers.SelectedIndex = 0;
txtDesciptions.Text = "";
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
totalExpenses = new TotalExpenses()
{
ExpenseDate = ExpenseDate,
ExpenseType = ExpenseType.Suppliers,
ExpenseTypeDesciptions = "Tedarikçi",
Price = Price,
Status = Status.Active,
};
if (totalExpenses_Service.Insert(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
cmbSuppliers.SelectedIndex = 0;
txtDesciptions.Text = "";
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Boş Geçilemez.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else if (DailyCastingEntryType == 4)
{
#region Variables
DateTime ExpenseDate = Convert.ToDateTime(string.Format("{0: dd/MM/yyyy 00:00:00}", DateTime.Now));
string FullName = cmbStaffs.Text;
string StaffExpenseType = cmbStaffExpense.Text;
decimal Price = nudPrice.Value;
#endregion
#region Service
UnitofWork unitofWork = new UnitofWork(ctx);
Staff_Service staff_Service = new Staff_Service(unitofWork);
Expense_Staff_Service expense_Staff_Service = new Expense_Staff_Service(unitofWork);
TotalExpenses_Service totalExpenses_Service = new TotalExpenses_Service(unitofWork);
#endregion
if (!string.IsNullOrEmpty(FullName) && !string.IsNullOrEmpty(StaffExpenseType) && Price > 0)
{
DialogResult dialogResult = MessageBox.Show("Kaydı Eklemek İstediğinize Emin misiniz?", "Yeni Kayıt", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dialogResult == DialogResult.Yes)
{
Expense_Staff expense_Staff = new Expense_Staff()
{
ExpenseDate = ExpenseDate,
FullName = FullName,
Price = Price,
StaffExpenseType = StaffExpenseType,
Status = Status.Active
};
if (expense_Staff_Service.Insert(expense_Staff))
{
TotalExpenses totalExpenses = totalExpenses_Service.GetTotalExpenses(ExpenseDate, ExpenseType.Staff);
if (totalExpenses != null)
{
totalExpenses.Price += Price;
if (totalExpenses_Service.Update(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
cmbStaffs.SelectedIndex = 0;
cmbStaffExpense.SelectedIndex = 0;
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
totalExpenses = new TotalExpenses()
{
ExpenseDate = ExpenseDate,
ExpenseType = ExpenseType.Staff,
ExpenseTypeDesciptions = "Personel",
Price = Price,
Status = Status.Active,
};
if (totalExpenses_Service.Insert(totalExpenses))
{
MessageBox.Show("İşlem Başarılı.");
cmbStaffs.SelectedIndex = 0;
cmbStaffExpense.SelectedIndex = 0;
nudPrice.Value = 0;
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("İşlem Başarısız.", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Boş Geçilemez.", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
