private void textBoxSearch_TextChanged(object sender, EventArgs e)
{
DAL.Doner doner = new Doner();
doner.Search = textBoxSearch.Text;
dataGridViewShowDonar.DataSource = doner.Select().Tables[0];
buttonSearch.PerformClick();
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (dataGridViewShowDonar.SelectedRows.Count <= 0)
{
return;
}
DialogResult confrmDelete = MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNoCancel,
MessageBoxIcon.Question);
if (confrmDelete != DialogResult.Yes)
{
return;
}
DAL.Doner doner = new Doner();
string ids = "";
for (int i = 0; i < dataGridViewShowDonar.SelectedRows.Count; i++)
{
ids += dataGridViewShowDonar.SelectedRows[i].Cells["ColId"].Value.ToString() + ", ";
}
ids = ids.Substring(0, ids.Length - 2);
if (doner.Delete(ids))
{
MessageBox.Show("Donar is deleted");
buttonSearch.PerformClick();
}
else
{
MessageBox.Show(doner._Error);
}
}
public async Task <IActionResult> Return(int?Id)
{
if (Id != null)
{
PartYearEvent partYearEvent = await db.PartYearEvents.FirstOrDefaultAsync(p => p.Id == Id);
if (partYearEvent != null)
{
if (await Success(partYearEvent))
{
Doner doner = new Doner();
PartYearEventViewModel partYearEventViewModel = new PartYearEventViewModel
{
Id = partYearEvent.Id,
YearEventId = partYearEvent.YearEventId,
NumberYearEvent = partYearEvent.NumberYearEvent,
Done = partYearEvent.Done,
Img = partYearEvent.Img,
Pdf = partYearEvent.Pdf,
PriceB = partYearEvent.PriceB,
PriceNotB = partYearEvent.PriceNotB,
DateTime = partYearEvent.DateTime,
UserNameСonfirmed = partYearEvent.UserNameСonfirmed,
UserNameSent = partYearEvent.UserNameSent,
Сomment = partYearEvent.Сomment,
maxDone = await doner.GetMaxDone(partYearEvent.Id, db)
};
return(View(partYearEventViewModel));
}
}
}
return(RedirectToAction("Index", "Home"));
}
private static void Main()
{
var myDoner = new Doner();
myDoner.OrderDoner();
// myDoner.DummyDoner();
myDoner.MakeDoner();
}
public void AddToDb(DonerDTO donerDto)
{
var Doner = new Doner();
Doner = Mapper.Map <Doner>(donerDto);
Doner.Location = Mapper.Map <Location>(donerDto.Location);
context.DonerTab.Add(Doner);
context.SaveChanges();
}
private async Task <IActionResult> SupprtEntry(int id)
{
var donation = await DbContext.Donations.FindAsync(id);
if (donation == null)
{
return(NotFound());
}
var userContext = CoreService.GetUserContext();
var escrowUser = DbContext.VetMembers.FirstOrDefault(c => c.MemberType == MemberType.Escrow);
if (DonateAmount <= 0)
{
IsSuppotError = true;
ErrorMessage = "数値の入力が必要です";
return(await OnGetAsync(id));
}
if (userContext.Amount < DonateAmount)
{
IsSuppotError = true;
ErrorMessage = "残高不足です";
return(await OnGetAsync(id));
}
var coinTransaction = new CoinTransaction
{
SendeVetMemberId = userContext.CurrentUser.Id,
RecivedVetMemberId = escrowUser.Id,
Amount = DonateAmount,
Text = $"{donation.Title} へ {PostMessage}",
TransactionType = CoinTransactionType.Donate
};
var doner = new Doner
{
Amount = DonateAmount,
Comment = PostMessage,
DonationId = donation.Id,
VetMemberId = userContext.CurrentUser.Id,
CoinTransaction = coinTransaction
};
DbContext.Doners.Add(doner);
DbContext.CoinTransactions.Add(coinTransaction);
await DbContext.SaveChangesAsync();
await Notification(userContext, donation, doner);
return(RedirectToPage("Details", new { id = id }));
}
public ActionResult <Doner> ReceiveFile([FromForm] DonerInput data)
{
var newDoner = new Doner()
{
Name = data.Name,
LastName = data.LastName,
ImgPath = data.ImgPath,
PayDate = data.PayDate,
Donation = data.Donation
};
_donerService.Create(newDoner);
return(Ok(200));
}
public IActionResult Update([FromForm] Doner donerIn)
{
var newDoner = new Doner()
{
Name = donerIn.Name,
LastName = donerIn.LastName,
ImgPath = donerIn.ImgPath,
PayDate = donerIn.PayDate,
Donation = donerIn.Donation,
};
_donerService.Update(donerIn.Id, donerIn);
return(NoContent());
}
private async Task Notification(UserContext userContext, Donation donation, Doner doner)
{
var fields = new List <DiscordService.DiscordEmbed.Field>();
fields.Add(new DiscordService.DiscordEmbed.Field
{
name = "金額",
value = $"{doner.Amount}{StaticSettings.CurrenryUnit}",
inline = false
});
if (!string.IsNullOrWhiteSpace(doner.Comment))
{
fields.Add(new DiscordService.DiscordEmbed.Field
{
name = "メッセージ",
value = doner.Comment,
inline = false
});
}
var total = DbContext.Doners.AsQueryable().Where(c => c.DonationId == donation.Id)
.Where(c => c.DonerState != DonerState.Cancel)
.Where(c => c.VetMemberId != donation.VetMemberId)
.Sum(c => c.Amount);
fields.Add(new DiscordService.DiscordEmbed.Field
{
name = "支援総額",
value = $"{total}{StaticSettings.CurrenryUnit}",
inline = false
});
await DiscordService.SendMessage(DiscordService.Channel.CrowdFundingNotification, string.Empty, new DiscordService.DiscordEmbed
{
title = donation.Title,
url = $"{StaticSettings.SiteBaseUrl}Donations/Details?id={donation.Id}",
author = new DiscordService.DiscordEmbed.Author
{
url = userContext.CurrentUser.GetMemberPageUrl(StaticSettings.SiteBaseUrl),
icon_url = userContext.CurrentUser.GetAvaterIconUrl(),
name = userContext.CurrentUser.Name
},
fields = fields.ToArray()
});
}
public void Remove(Doner donerIn) => _doner.DeleteOne(doner => doner.Id == donerIn.Id);
public void Update(string id, Doner donerIn) => _doner.ReplaceOne(doner => doner.Id == id, donerIn);
public void Create(Doner newDoner) => _doner.InsertOne(newDoner);
public async Task <IActionResult> Index(string userName, string dataYear)
{
if (userName == User.Identity.Name)
{
if (User.Identity.Name != null)
{
List <YearEvent> yearEvents = await db.YearEvents.Where(y => y.DataYear == dataYear).ToListAsync();
if (yearEvents.Count == 0)
{
dataYear = DateTime.Now.Year.ToString();
yearEvents = await db.YearEvents.Where(y => y.DataYear == dataYear).ToListAsync();
if (yearEvents.Count == 0)
{
return(RedirectToAction("Index", "Home"));
}
}
List <Agency> agencies = await db.Agencies.ToListAsync();
agencies = AgencyFilter.GetAgenciesFilterYearEvent(agencies, yearEvents);
var agenciessort = from a in agencies
orderby a.Name
select a;// сортировка по имени учреждения
agencies = agenciessort.ToList();
if (agencies != null)
{
List <YearEventViewModel> YearEventViewModels = new List <YearEventViewModel>();
Procenter procenter = new Procenter();
foreach (YearEvent yearEvent in yearEvents)
{
YearEventViewModels.Add(new YearEventViewModel()
{
Id = yearEvent.Id,
AgencyId = yearEvent.AgencyId,
Number = yearEvent.Number,
EventText = yearEvent.EventText,
FirstQuarter = yearEvent.FirstQuarter,
SecondQuarter = yearEvent.SecondQuarter,
ThirdQuarter = yearEvent.ThirdQuarter,
FourthQuarter = yearEvent.FourthQuarter,
Unit = yearEvent.Unit,
Section = yearEvent.Section,
SubSection = yearEvent.SubSection,
SubSection1 = yearEvent.SubSection1,
TypeSection = yearEvent.TypeSection,
DataYear = yearEvent.DataYear,
PartYearEvents = await db.PartYearEvents.Where(p => p.YearEventId == yearEvent.Id).ToListAsync(),
Procent = await procenter.GetProcentYearEvent(yearEvent.Id, db),
TrClass = await Overdue.GetOverdueYearEventColor(yearEvent.Id, db)
});
}
Pricer pricer = new Pricer();
Doner doner = new Doner();
List <AgencyYearPlanViewModel> agencyYearPlanViewModels = new List <AgencyYearPlanViewModel>();
foreach (Agency ag in agencies)
{
agencyYearPlanViewModels.Add(new AgencyYearPlanViewModel()
{
Id = ag.Id,
Name = ag.Name,
YearEventViewModels = YearEventViewModels.Where(y => y.AgencyId == ag.Id).ToList(),
FullDonePlan = await db.YearEvents.Where(y => y.AgencyId == ag.Id).
Where(y => y.DataYear == dataYear).
CountAsync(),
NowDonePlan = await doner.GetYearAgencyDoneNow(ag, db, dataYear),
Procent = await procenter.GetProcentAgency(ag.Id, db, dataYear),
FullPriceBnow = await pricer.GetFullPriceBNowAgency(ag.Id, db, dataYear),
FullPriceNotBnow = await pricer.GetFullPriceNotBNowAgency(ag.Id, db, dataYear)
});
}
TotalYearPlanViewModel totalYearPlanViewModel = new TotalYearPlanViewModel();
totalYearPlanViewModel.AgencyYearPlanViewModels = agencyYearPlanViewModels;
totalYearPlanViewModel.Procent = await procenter.GetProcentTotal(agencies, db, dataYear);
totalYearPlanViewModel.FullDonePlan = await doner.GetYearPlanCount(agencies, db, dataYear);
totalYearPlanViewModel.NowDonePlan = await doner.GetYearPlanDoneCount(agencies, db, dataYear);
totalYearPlanViewModel.FullPriceBnow = await pricer.GetFullPriceBNowTotal(agencies, db, dataYear);
totalYearPlanViewModel.FullPriceNotBnow = await pricer.GetFullPriceNotBNowTotal(agencies, db, dataYear);
totalYearPlanViewModel.FullPrice = totalYearPlanViewModel.FullPriceBnow + totalYearPlanViewModel.FullPriceNotBnow;
totalYearPlanViewModel.DataYear = dataYear;
totalYearPlanViewModel.DataYears = await db.DataYears.ToListAsync();
return(View(totalYearPlanViewModel));
}
}
}
return(RedirectToAction("Index", "Home"));
}