public void Form_Load(object sender, EventArgs e) { try { using (var repo = new AccountRepo()) { incomeAccountComboBox.DataSource = repo.GetAll(); outlayAccountComboBox.DataSource = repo.GetAll(); } using (var repo = new TypeRepo()) { incomeTypeComboBox.DataSource = repo.GetAll(); outlayTypeComboBox.DataSource = repo.GetAll(); } using (var repo = new PersonRepo()) { incomePersonComboBox.DataSource = repo.GetAll(); outlayPersonComboBox.DataSource = repo.GetAll(); } incomeDatePicker.Value = DateTime.Now; outlayDatePicker.Value = DateTime.Now; if (i != null) { tabControl1.TabPages.Remove(tabPage2); incomeAccountComboBox.SelectedIndex = incomeAccountComboBox.Items.Cast <Account>().ToList().FindIndex(x => (x.ID == i.Account_ID)); incomeDatePicker.Value = new DateTime(int.Parse(i.Year.ToString()), int.Parse(i.Month.ToString()), int.Parse(i.Day.ToString())); incomeTypeComboBox.SelectedIndex = incomeTypeComboBox.Items.Cast <Type>().ToList().FindIndex(x => (x.ID == i.Type_ID)); incomePersonComboBox.SelectedIndex = incomePersonComboBox.Items.Cast <Person>().ToList().FindIndex(x => (x.ID == i.Person_ID)); incomeValueBox.Text = i.Value.ToString(); incomeCommentBox.Text = i.Comment; } else if (o != null) { tabControl1.TabPages.Remove(tabPage1); outlayAccountComboBox.SelectedIndex = outlayAccountComboBox.Items.Cast <Account>().ToList().FindIndex(x => (x.ID == o.Account_ID)); outlayDatePicker.Value = new DateTime(int.Parse(o.Year.ToString()), int.Parse(o.Month.ToString()), int.Parse(o.Day.ToString())); outlayTypeComboBox.SelectedIndex = outlayTypeComboBox.Items.Cast <Type>().ToList().FindIndex(x => (x.ID == o.Type_ID)); outlayPersonComboBox.SelectedIndex = outlayPersonComboBox.Items.Cast <Person>().ToList().FindIndex(x => (x.ID == o.Person_ID)); outlayValueBox.Text = o.Value.ToString(); outlayCommentBox.Text = o.Comment; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadType() { var list = _TypeRepo.GetAll(); ddlType.DataSource = list; ddlType.DataBind(); }
public void UpdateGrid() { try { using (var repo = new TypeRepo()) { accountDataGrid.DataSource = repo.GetAll(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void LoadType() { try { var list = _TypeRepo.GetAll(); HttpContext.Current.Session["listType"] = list; ASPxGridView1_Type.DataSource = list; ASPxGridView1_Type.DataBind(); } catch //(Exception) { //throw; } }
public void ExportDatabase(object sender, EventArgs e) { if (folderBrowserDialog1.ShowDialog() != DialogResult.OK) { return; } var path = folderBrowserDialog1.SelectedPath; using (var repo = new AccountRepo()) { var xEle = new XElement("Accounts", repo.GetAll().Select(account => new XElement("Account", new XAttribute("ID", account.ID), new XElement("Name", account.Name), new XElement("CurrentAmount", account.CurrentAmount) ))); xEle.Save($"{path}\\accounts.xml"); } using (var repo = new TypeRepo()) { var xEle = new XElement("Types", repo.GetAll().Select(type => new XElement("Type", new XAttribute("ID", type.ID), new XElement("Name", type.Name) ))); xEle.Save($"{path}\\types.xml"); } using (var repo = new PersonRepo()) { var xEle = new XElement("Persons", repo.GetAll().Select(account => new XElement("Person", new XAttribute("ID", account.ID), new XElement("Name", account.Name) ))); xEle.Save($"{path}\\persons.xml"); } using (var repo = new IncomeRepo()) { var xEle = new XElement("Incomes", repo.GetAll().Select(income => new XElement("Income", new XAttribute("ID", income.ID), new XElement("Account", income.Account), new XElement("Day", income.Day), new XElement("Month", income.Month), new XElement("Year", income.Year), new XElement("Person", income.Person), new XElement("Type", income.Type), new XElement("Account", income.Value), new XElement("Comment", income.Comment) ))); xEle.Save($"{path}\\incomes.xml"); } using (var repo = new OutlayRepo()) { var xEle = new XElement("Outlays", repo.GetAll().Select(outlay => new XElement("Outlay", new XAttribute("ID", outlay.ID), new XElement("Account", outlay.Account), new XElement("Day", outlay.Day), new XElement("Month", outlay.Month), new XElement("Year", outlay.Year), new XElement("Person", outlay.Person), new XElement("Type", outlay.Type), new XElement("Account", outlay.Value), new XElement("Comment", outlay.Comment) ))); xEle.Save($"{path}\\outlays.xml"); } }
private IEnumerable <OrganizationType> GetAllTypesInternal() { return(TypeRepo.GetAll()); }
public void UpdateForm() { string month = currMonthLabel.Text.Substring(0, (currMonthLabel.Text.Length - 5)); string year = currMonthLabel.Text.Substring(currMonthLabel.Text.Length - 4); int index = Array.IndexOf(_monthArray, month); int monthQuery = index + 1; int yearQuery = int.Parse(year); List <Type> typeList; try { using (var repo = new TypeRepo()) { typeList = repo.GetAll(); } if (_typeOfData == 1) { List <Income> incomeList; using (var repo = new IncomeRepo()) { incomeList = (repo.GetAll()).FindAll(x => (x.Month == monthQuery && x.Year == yearQuery)); } var list = (from a in incomeList from b in typeList where (a.Type_ID == b.ID) select new { Name = b.Name, Sum = (from m in incomeList where m.Type_ID == b.ID select m.Value).Sum() }) .Distinct().ToList(); chart1.DataSource = list; chart2.DataSource = list; } else { List <Outlay> outlayList; using (var repo = new OutlayRepo()) { outlayList = (repo.GetAll()).FindAll(x => (x.Month == monthQuery && x.Year == yearQuery)); } var list = (from a in outlayList from b in typeList where (a.Type_ID == b.ID) select new { Name = b.Name, Sum = (from m in outlayList where m.Type_ID == b.ID select m.Value).Sum() }) .Distinct().ToList(); chart1.DataSource = list; chart2.DataSource = list; chart1.Series["Series1"].Color = System.Drawing.Color.Red; chart2.Series["Series1"].Color = System.Drawing.Color.Red; } chart1.Series["Series1"].XValueMember = "Name"; chart1.Series["Series1"].XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32; chart1.Series["Series1"].YValueMembers = "Sum"; chart1.Series["Series1"].YValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32; chart2.Series["Series1"].XValueMember = "Name"; chart2.Series["Series1"].XValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32; chart2.Series["Series1"].YValueMembers = "Sum"; chart2.Series["Series1"].YValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.Int32; } catch (Exception ex) { MessageBox.Show(ex.Message); } }