private static void AddDefaultExpenseTypes(int userID)
{
if (DBMethods.GetAccountType(userID) == "Corporate")
{
DBMethods.AddExpenseTypetoCategory("User1", userID, "Salaries");
DBMethods.AddExpenseTypetoCategory("User2", userID, "Salaries");
DBMethods.AddExpenseTypetoCategory("Flour", userID, "Raw Materials");
DBMethods.AddExpenseTypetoCategory("Sugar", userID, "Raw Materials");
DBMethods.AddExpenseTypetoCategory("Cacao", userID, "Raw Materials");
DBMethods.AddExpenseTypetoCategory("Flour", userID, "Raw Materials");
DBMethods.AddExpenseTypetoCategory("KDV", userID, "Taxes");
DBMethods.AddExpenseTypetoCategory("OTV", userID, "Taxes");
DBMethods.AddExpenseTypetoCategory("TV Ads", userID, "Marketing");
DBMethods.AddExpenseTypetoCategory("Internet Ads", userID, "Marketing");
DBMethods.AddExpenseTypetoCategory("Street Posters", userID, "Marketing");
}
else
{
DBMethods.AddExpenseType("Shopping", userID);
DBMethods.AddExpenseType("Food", userID);
DBMethods.AddExpenseType("Transport", userID);
DBMethods.AddExpenseType("Electric", userID);
DBMethods.AddExpenseType("Gas", userID);
DBMethods.AddExpenseType("Home", userID);
DBMethods.AddExpenseType("Entertainment", userID);
DBMethods.AddExpenseType("Water", userID);
DBMethods.AddExpenseType("Health", userID);
DBMethods.AddExpenseType("Beauty", userID);
DBMethods.AddExpenseType("Gift", userID);
}
}
private void TryLogin()
{
int login = DBMethods.TryLogin(txtUser.Text, txtPass.Text);
int userID = DBMethods.GetUserID(txtUser.Text);
if (login == 0) //login failed
{
MessageBox.Show("Wrong username or password");
}
else //login successful
{
this.Hide();
if (login == 3) //corporate
{
FormMainCorporate f = new FormMainCorporate(userID, _DomainController);
f.Show();
}
else //not corporate
{
FormMain formMain = new FormMain(userID, _DomainController);
formMain.Show();
if (login == 1) //admin
{
FormAdmin formAdmin = new FormAdmin(_DomainController, formMain);
formAdmin.Show();
}
}
}
}
public FormMain(int userID, DomainController domainController)
{
this._DomainController = domainController;
this.UserID = userID;
InitializeComponent();
InitializeUI();
lblUsername.Text = DBMethods.GetUser(userID).UserName;
}
public FormMainCorporate(int userID, DomainController domainController)
{
this._DomainController = domainController;
this.UserID = userID;
InitializeComponent();
InitializeUI();
lblUsername.Text = DBMethods.GetUser(userID).UserName;
listBoxEmployees.SelectedIndex = -1;
}
/// <summary>
/// Add expense types radio buttons of given category
/// </summary>
/// <param name="eCat"></param>
public void AddExpenseTypeControls(string eCat)
{
List <string> ExpenseTypes = DBMethods.GetExpenseTypesOfCat(eCat, UserID);
foreach (string e in ExpenseTypes)
{
AddExpenseTypeRadiotoUI(e);
}
}
/// <summary>
/// Adds Income Radio Buttons to UI
/// </summary>
public void AddIncomeControls()
{
List <string> Cats = DBMethods.GetIncomeCats(UserID);
foreach (string c in Cats)
{
AddIncomeCatRadiotoUI(c);
}
}
/// <summary>
/// Add income types radio buttons of given category
/// </summary>
/// <param name="iCat"></param>
public void AddIncomeTypeControls(string iCat)
{
List <string> IncomeTypes = DBMethods.GetIncomeTypesOfCat(iCat, UserID);
foreach (string i in IncomeTypes)
{
AddIncomeTypeRadiotoUI(i);
}
}
/// <summary>
/// Adds Expense Radio Buttons to UI
/// </summary>
public void AddExpenseControls()
{
List <string> ExpenseTypes = DBMethods.GetExpenseTypeNames(UserID);
foreach (string e in ExpenseTypes)
{
AddExpenseTypeRadiotoUI(e);
}
}
/// <summary>
/// Adds Income Radio Buttons to UI
/// </summary>
public void AddIncomeControls()
{
List <string> IncomeTypes = DBMethods.GetIncomeTypeNames(UserID);
foreach (string i in IncomeTypes)
{
AddIncomeTypeRadiotoUI(i);
}
}
private void BtnDeleteIncome_Click(object sender, EventArgs e)
{
int id = (int)dataGridIncomes.SelectedRows[0].Cells["IncomeID"].Value;
DBMethods.DeleteIncome(id);
UpdateDataGrids();
_MainUI.UpdateBalance();
_MainUI.UpdateCharts();
}
public void UpdateCharts()
{
Dictionary <String, decimal> ExpenseDict = DBMethods.GetExpenseData(UserID);
chartExpenses.Series["ExpenseData"].Points.DataBindXY(ExpenseDict.Keys, ExpenseDict.Values);
Dictionary <String, decimal> CategoryDict = DBMethods.GetCategoryExpenseDictionary(UserID);
chartCategoryExpenses.Series["ExpenseData"].Points.DataBindXY(CategoryDict.Keys, CategoryDict.Values);
}
/// <summary>
/// Method to use for clicking enter or add button
/// </summary>
private void AddIncomeOrExpense()
{
RadioButton selectedExp = flowLayoutExpenses.Controls.OfType <RadioButton>()
.FirstOrDefault(r => r.Checked);
RadioButton selectedInc = flowLayoutIncomes.Controls.OfType <RadioButton>()
.FirstOrDefault(r => r.Checked);
if (selectedExp == null && selectedInc == null)
{
MessageBox.Show("Please select a type");
return;
}
int recur = (int)numRecur.Value;
if (recur > 1 && comboBoxRecur.Text == "")
{
MessageBox.Show("Please select recurring interval");
return;
}
if (selectedExp != null)
{
string eType = selectedExp.Text;
DBMethods.AddExpense(numAmount.Value, eType, UserID, dateTimeExpInc.Value);
if (recur > 1)
{
DBMethods.AddRecurringExpense(recur, comboBoxRecur.Text, numAmount.Value, eType, UserID, dateTimeExpInc.Value);
}
MessageBox.Show("Expense added!");
}
else if (selectedInc != null)
{
string iType = selectedInc.Text;
DBMethods.AddIncome(numAmount.Value, iType, UserID, dateTimeExpInc.Value);
if (recur > 1)
{
DBMethods.AddRecurringIncome(recur, comboBoxRecur.Text, numAmount.Value, iType, UserID, dateTimeExpInc.Value);
}
MessageBox.Show("Income added!");
}
UpdateFormHistory();
UpdateBalance();
UpdateCharts();
}
private void PopulateListBoxs()
{
foreach (string e in DBMethods.GetExpenseTypeNames(UserID))
{
listExpenseTypes.Items.Add(e);
}
foreach (string i in DBMethods.GetIncomeTypeNames(UserID))
{
listIncomeTypes.Items.Add(i);
}
}
private void UpdateCategoryListBoxs()
{
List <String> inc1 = DBMethods.GetIncomeCats(UserID);
List <String> exp1 = DBMethods.GetExpenseCats(UserID);
List <String> inc2 = DBMethods.GetIncomeCats(UserID);
List <String> exp2 = DBMethods.GetExpenseCats(UserID);
listIncomeCategories.DataSource = inc1;
listIncomeCategories2.DataSource = inc2;
listExpenseCategories.DataSource = exp1;
listExpenseCategories2.DataSource = exp2;
}
internal static int CreateAccount(string username, string password, string userType)
{
int userID = DBMethods.AddUser(username, password, userType);
if (userID > 0) //User Added
{
AddDefaultCategories(userID);
AddDefaultExpenseTypes(userID);
AddDefaultIncomeTypes(userID);
}
return(userID);
}
internal static void AddCategory(string name, string incexp, int userID)
{
if (incexp == "Expense")
{
DBMethods.AddExpenseCategory(name, userID);
}
else if (incexp == "Income")
{
DBMethods.AddIncomeCategory(name, userID);
}
else
{
throw new ArgumentException("Invalid Type");
}
}
public static void AddTypetoCategory(string name, string incexp, string cat, int userID)
{
if (incexp == "Expense")
{
DBMethods.AddExpenseTypetoCategory(name, userID, cat);
}
else if (incexp == "Income")
{
DBMethods.AddIncomeTypetoCategory(name, userID, cat);
}
else
{
throw new ArgumentException("Invalid Type");
}
}
public static void AddType(string name, string type, int userID)
{
if (type == "Expense")
{
DBMethods.AddExpenseType(name, userID);
}
else if (type == "Income")
{
DBMethods.AddIncomeType(name, userID);
}
else
{
throw new ArgumentException("Invalid Type");
}
}
public void UpdateBalance()
{
if (radioTotal.Checked)
{
decimal balance = DBMethods.CalculateBalance(UserID);
lblBalance.Text = balance.ToString();
}
else if (radioToDate.Checked)
{
decimal balance = DBMethods.CalculateBalanceToDate(UserID);
lblBalance.Text = balance.ToString();
}
else
{
lblBalance.Text = "How?";
}
}
private static void AddDefaultCategories(int userID)
{
if (DBMethods.GetAccountType(userID) == "Corporate")
{
DBMethods.AddExpenseCategory("Salaries", userID);
DBMethods.AddExpenseCategory("Raw Materials", userID);
DBMethods.AddExpenseCategory("Taxes", userID);
DBMethods.AddExpenseCategory("Marketing", userID);
DBMethods.AddIncomeCategory("Domestic Sales", userID);
DBMethods.AddIncomeCategory("International Sales", userID);
}
else
{
DBMethods.AddExpenseCategory("General Expense", userID);
DBMethods.AddIncomeCategory("General Income", userID);
}
}
private void BtnDeleteExpenseCategory_Click(object sender, EventArgs e)
{
if (DBMethods.TypeOfExpenseCategoryExists(listExpenseCategories.Text, UserID))
{
DialogResult result = MessageBox.Show("This action will also delete types and expenses of the selected category. Do you wish to continue?",
"Confirm Delete", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
DBMethods.DeleteTypesAndExpensesofExpenseCategory(listExpenseCategories.Text, UserID);
}
else if (result == DialogResult.No)
{
return;
}
}
DBMethods.DeleteExpenseCategory(listExpenseCategories.Text, UserID);
UpdateCategoryListBoxs();
fm.UpdateUI();
}
private static void AddDefaultIncomeTypes(int userID)
{
if (DBMethods.GetAccountType(userID) == "Corporate")
{
DBMethods.AddIncomeTypetoCategory("İstanbul", userID, "Domestic Sales");
DBMethods.AddIncomeTypetoCategory("İzmir", userID, "Domestic Sales");
DBMethods.AddIncomeTypetoCategory("Ankara", userID, "Domestic Sales");
DBMethods.AddIncomeTypetoCategory("New York", userID, "International Sales");
DBMethods.AddIncomeTypetoCategory("Paris", userID, "International Sales");
DBMethods.AddIncomeTypetoCategory("London", userID, "International Sales");
}
else
{
DBMethods.AddIncomeType("Salary", userID);
DBMethods.AddIncomeType("Rent", userID);
DBMethods.AddIncomeType("Dividents", userID);
}
}
private void BtnShow_Click(object sender, EventArgs e)
{
_MainUI.Close();
int userID = DBMethods.GetUserID(listUsers.Text);
if (DBMethods.GetAccountType(userID) == "Corporate")
{
FormMainCorporate f = new FormMainCorporate(userID, _DomainController);
f.Show();
_MainUI = f;
}
else
{
FormMain f = new FormMain(userID, _DomainController);
f.Show();
_MainUI = f;
}
}
private void BtnDeleteIncomeType_Click(object sender, EventArgs e)
{
if (DBMethods.IncomeOfTypeExists(listExpenseTypes.Text, UserID))
{
DialogResult result = MessageBox.Show("This action will also delete recorded incomes of the selected type. Do you wish to continue?",
"Confirm Delete", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
DBMethods.DeleteIncomesOfType(listExpenseTypes.Text, UserID);
}
else if (result == DialogResult.No)
{
return;
}
}
dc.DeleteIncomeType(listIncomeTypes.Text, UserID);
UpdateListBoxs();
formMain.UpdateUI();
}
/// <summary>
/// Add recurring Income
/// </summary>
/// <param name="recur"></param>
/// <param name="interval"></param>
/// <param name="amount"></param>
/// <param name="iType"></param>
/// <param name="userID"></param>
/// <param name="dt"></param>
internal static void AddRecurringIncome(int recur, string interval, decimal amount, string iType, int userID, DateTime dt)
{
if (interval == "Months")
{
int toAdd = 1;
for (int r = recur; r > 1; r--)
{
DBMethods.AddIncome(amount, iType, userID, dt.AddMonths(toAdd));
toAdd++;
}
}
else if (interval == "Weeks")
{
int toAdd = 1;
for (int r = recur; r > 1; r--)
{
DBMethods.AddIncome(amount, iType, userID, dt.AddDays(toAdd * 7));
toAdd++;
}
}
}
public void UpdateDataGrids()
{
dataGridExpenses.DataSource = DBMethods.GetExpenseHistory(UserID);
dataGridIncomes.DataSource = DBMethods.GetIncomeHistory(UserID);
}
private void UpdateListIncomeTypes()
{
listIncomeTypes.DataSource = DBMethods.GetIncomeTypesOfCat(listIncomeCategories2.Text, UserID);
}
internal void InitializeUserTypes()
{
DBMethods.AddUserType("Admin");
DBMethods.AddUserType("User");
DBMethods.AddUserType("Corporate");
}
internal static void DeleteIncomeType(string itName, int userID)
{
DBMethods.DeleteIncomeType(itName, userID);
}
internal static void DeleteExpenseType(string etName, int userID)
{
DBMethods.DeleteExpenseType(etName, userID);
}