public void AcceptButton_Click(object sender, EventArgs e)
{
try
{
using (var repo = new TypeRepo())
{
if (t == null)
{
repo.Add(new Type()
{
Name = typeNameBox.Text
});
}
else
{
t.Name = Name = typeNameBox.Text;
repo.Save(t);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void DelButton_Click(object sender, EventArgs e)
{
var t = accountDataGrid.CurrentRow?.DataBoundItem as Type;
if (t == null)
{
return;
}
if (MessageBox.Show("Видалити обране поле?", "Видалення", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) ==
DialogResult.OK)
{
try
{
using (var repo = new TypeRepo())
{
repo.Delete(t);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
UpdateGrid();
}
}
public override void InitializeLoading(Log log)
{
if (_elementType != null)
{
_listTypeRepo = Serializer.GetOrCreateRepo(log, _elementType);
}
}
public override void InitializeLoading(Log log)
{
if (_elementType != null)
{
_listTypeRepo = Serializer.GetOrCreateRepo(log, _elementType);
}
_propertyInfoCapacity = LoadableType.GetProperty("Capacity");
}
public void UpdateType(OrganizationType type)
{
var unit_of_work = UnitOfWorkProvider.GetUnitOfWork();
unit_of_work.BeginTransaction();
TypeRepo.Update(type);
unit_of_work.Commit();
_is_type_cache_valid = false;
}
public void DeleteType(long typeId)
{
var unit_of_work = UnitOfWorkProvider.GetUnitOfWork();
unit_of_work.BeginTransaction();
TypeRepo.Delete(typeId);
unit_of_work.Commit();
_is_type_cache_valid = false;
}
public PropertyRepo(PropertySchema propertySchema, TypeRepo typeRepo = null)
{
PropertySchema = propertySchema;
TypeRepo = typeRepo;
if (typeRepo?.Serializer.PublicOnly == true && PropertySchema.IsPrivate)
{
PropertySchema.IsLoadable = false;
}
}
public FieldRepo(FieldSchema fieldSchema, TypeRepo typeRepo = null)
{
FieldSchema = fieldSchema;
TypeRepo = typeRepo;
if (typeRepo?.Serializer.PublicOnly == true && FieldSchema.IsPrivate)
{
FieldSchema.IsLoadable = false;
}
}
public override void InitializeLoading(Log log)
{
// these base types might not be serialized
if (_typeKey != null)
{
_list1TypeRepo = Serializer.GetOrCreateRepo(log, _typeKey);
}
if (_typeValue != null)
{
_list2TypeRepo = Serializer.GetOrCreateRepo(log, _typeValue);
}
}
public void UpdateGrid()
{
try
{
using (var repo = new TypeRepo())
{
accountDataGrid.DataSource = repo.GetAll();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
app.UseSwagger();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
using (var scope = app.ApplicationServices.CreateScope())
{
var repo = scope.ServiceProvider.GetRequiredService <IAvatarRepository>();
var orepo = scope.ServiceProvider.GetRequiredService <IOwnerRepository>();
var trepo = scope.ServiceProvider.GetRequiredService <ITypeRepository>();
/* repo.Create(new Avatar { Name = "Chili", AvatarType = "Magician", Color = "Pink" });
* repo.Create(new Avatar { Name = "Bunsy", AvatarType = "Healer", Color = "Black" });*/
IAvatarRepository aRepo = new AvatarRepo();
IOwnerRepository owRepo = new OwnerRepo();
ITypeRepository tyrepo = new TypeRepo();
DBInit.InitData(); // Mock data
IAvatarService aService = new AvatarService(aRepo);
IOwnerService owService = new OwnerService(owRepo);
ITypeService tService = new TypeService(tyrepo);
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "My API V1");
// c.RoutePrefix = string.Empty;
});
app.UseHttpsRedirection();
app.UseRouting();
app.UseCors("CustomerAppAllowSpecificOrigins");
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
}
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);
}
}
public long CreateType(string caption)
{
Debug.Assert(!string.IsNullOrEmpty(caption));
OrganizationType type = new OrganizationType {
Caption = caption
};
var unit_of_work = UnitOfWorkProvider.GetUnitOfWork();
unit_of_work.BeginTransaction();
TypeRepo.Create(type);
unit_of_work.Commit();
_is_type_cache_valid = false;
return(0);
}
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);
}
}
