public async Task <IActionResult> Edit(int id, [Bind("ID,Score")] PersonScore personScore)
{
if (id != personScore.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(personScore);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PersonScoreExists(personScore.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(personScore));
}
public async Task <IActionResult> Create([Bind("ID,Score")] PersonScore personScore)
{
if (ModelState.IsValid)
{
_context.Add(personScore);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(personScore));
}
public async Task <ImportDataVM> ImportAsync(ImportDataInput data, int periodId)
{
var res = await _uow.ReportRepository.DeleteAllPersonInPeriodReportAsync(periodId);
var res1 = await _uow.PersonScoreRepository.DeleteAllPersonScoreInPeriodAsync(periodId);
//await Task.Yield();
var branchList = await _uow.BranchRepository.GetAllAsync();
var personList = await _uow.PersonRepository.GetAllAsync();
var personInBranchList = await _uow.PersonInBranchRepository.GetAllAsync();
var meritPayFactorList = await _uow.MeritPayFactorRepository.GetMeritPayFactorByPeriodIdAsync(periodId);
var meritPayFactorBranchList = meritPayFactorList.Where(d => d.MeritPayTypeId == 1);
var TarakoneshAmalkardiId = meritPayFactorBranchList.FirstOrDefault(d => d.Title == "تراکنش های عملکردی").Id;
var EmtiazGrohiShobeId = meritPayFactorBranchList.FirstOrDefault(d => d.Title == "امتیاز گروهی").Id;
var ArzeshYabiShobeId = meritPayFactorBranchList.FirstOrDefault(d => d.Title == "ارزشیابی فردی").Id;
var meritPayFactorSetadList = meritPayFactorList.Where(d => d.MeritPayTypeId == 2);
var EmtiazGrohiSetadId = meritPayFactorSetadList.FirstOrDefault(d => d.Title == "امتیاز گروهی").Id;
var ArzeshYabiSetadId = meritPayFactorSetadList.FirstOrDefault(d => d.Title == "ارزشیابی فردی").Id;
foreach (ImportDataInputVM item in data.Data)
{
var branchId = branchList.FirstOrDefault(d => d.BranchCode == item.BranchCode).Id;
var personId = personList.FirstOrDefault(d => d.PersonCode == item.PersonCode).Id;
var personInBranch = personInBranchList.FirstOrDefault(x => x.BranchId == branchId && x.PersonId == personId);
int personInBranchId = 0;
if (personInBranch == null)
{
//insert to db
personInBranchId = 1;
}
else
{
personInBranchId = personInBranch.Id;
}
if (item.BranchCode != 21000)
{
Report report1 = new Report();
report1.MeritPayFactorId = TarakoneshAmalkardiId;
report1.PersonInBranchId = personInBranchId;
report1.Score = item.TaScore;
report1.RankInBranch = item.TaRankInBranch;
report1.RankInZone = item.TaRankInZone;
report1.RankInBank = item.TaRankInBank;
await _uow.ReportRepository.AddAsync(report1);
Report report2 = new Report();
report2.MeritPayFactorId = EmtiazGrohiShobeId;
report2.PersonInBranchId = personInBranchId;
report2.Score = item.GroupScore;
report2.RankInBranch = item.GroupRankInBranch;
report2.RankInZone = item.GroupRankInZone;
report2.RankInBank = item.GroupRankInBank;
await _uow.ReportRepository.AddAsync(report2);
Report report3 = new Report();
report3.MeritPayFactorId = ArzeshYabiShobeId;
report3.PersonInBranchId = personInBranchId;
report3.Score = item.ArzeshScore;
report3.RankInBranch = item.ArzeshRankInBranch;
report3.RankInZone = item.ArzeshRankInZone;
report3.RankInBank = item.ArzeshRankInBank;
await _uow.ReportRepository.AddAsync(report3);
//ثبت تراکنش های عملکردی
//ارزان قیمت
PersonScore ps1 = new PersonScore();
ps1.PersonInBranchId = personInBranchId;
ps1.ScoreSubIndexId = 1;
ps1.Value = item.TajhizManabeArzan;
ps1.RankInBranch = item.ArzanRankInBranch;
ps1.RankInZone = item.ArzanRankInZone;
ps1.RankInBank = item.ArzanRankInBank;
ps1.Score = item.ArzanScore;
await _uow.PersonScoreRepository.AddAsync(ps1);
//گران قیمت
PersonScore ps2 = new PersonScore();
ps2.PersonInBranchId = personInBranchId;
ps2.ScoreSubIndexId = 2;
ps2.Value = item.TajhizManabeGeran;
ps2.RankInBranch = item.GeranRankInBranch;
ps2.RankInZone = item.GeranRankInZone;
ps2.RankInBank = item.GeranRankInBank;
ps2.Score = item.GeranScore;
await _uow.PersonScoreRepository.AddAsync(ps2);
// تسهیلات
PersonScore ps3 = new PersonScore();
ps3.PersonInBranchId = personInBranchId;
ps3.ScoreSubIndexId = 3;
ps3.Value = item.TakhsisManabeMablaghTashilat;
ps3.RankInBranch = item.MablaghTashilatRankInBranch;
ps3.RankInZone = item.MablaghTashilatRankInZone;
ps3.RankInBank = item.MablaghTashilatRankInBank;
ps3.Score = item.MablaghTashilatScore;
await _uow.PersonScoreRepository.AddAsync(ps3);
//ضمانتنامه
PersonScore ps4 = new PersonScore();
ps4.PersonInBranchId = personInBranchId;
ps4.ScoreSubIndexId = 4;
ps4.Value = item.TakhsisManabeMablaghZemanat;
ps4.RankInBranch = item.MablaghZemantRankInBranch;
ps4.RankInZone = item.MablaghZemantRankInZone;
ps4.RankInBank = item.MablaghZemantRankInBank;
ps4.Score = item.MablaghZemantScore;
await _uow.PersonScoreRepository.AddAsync(ps4);
//اعتبار اسنادی
PersonScore ps5 = new PersonScore();
ps5.PersonInBranchId = personInBranchId;
ps5.ScoreSubIndexId = 5;
ps5.Value = item.TakhsisManabeEtebaratAsnadi;
ps5.RankInBranch = item.EtebaratAsnadiRankInBranch;
ps5.RankInZone = item.EtebaratAsnadiRankInZone;
ps5.RankInBank = item.EtebaratAsnadiRankInBank;
ps5.Score = item.EtebaratAsnadiScore;
await _uow.PersonScoreRepository.AddAsync(ps5);
//درآمد کارمزدی
PersonScore ps6 = new PersonScore();
ps6.PersonInBranchId = personInBranchId;
ps6.ScoreSubIndexId = 7;
ps6.Value = item.DaramadKarmozdi;
ps6.RankInBranch = item.DaramadKarmozdiRankInBranch;
ps6.RankInZone = item.DaramadKarmozdiRankInZone;
ps6.RankInBank = item.DaramadKarmozdiRankInBank;
ps6.Score = item.DaramadKarmozdiScore;
await _uow.PersonScoreRepository.AddAsync(ps6);
//کارت هدیه
PersonScore ps7 = new PersonScore();
ps7.PersonInBranchId = personInBranchId;
ps7.ScoreSubIndexId = 8;
ps7.Value = item.BankdariElectronicKartHadiye;
ps7.RankInBranch = item.KartHadiyeRankInBranch;
ps7.RankInZone = item.KartHadiyeRankInZone;
ps7.RankInBank = item.KartHadiyeRankInBank;
ps7.Score = item.KartHadiyeScore;
await _uow.PersonScoreRepository.AddAsync(ps7);
//ایران کارت
PersonScore ps8 = new PersonScore();
ps8.PersonInBranchId = personInBranchId;
ps8.ScoreSubIndexId = 9;
ps8.Value = item.BankdariElectronicIranKart;
ps8.RankInBranch = item.IranKartRankInBranch;
ps8.RankInZone = item.IranKartRankInZone;
ps8.RankInBank = item.IranKartRankInBank;
ps8.Score = item.IranKartScore;
await _uow.PersonScoreRepository.AddAsync(ps8);
//کیلید
PersonScore ps9 = new PersonScore();
ps9.PersonInBranchId = personInBranchId;
ps9.ScoreSubIndexId = 10;
ps9.Value = item.BankdariElectronicKilid;
ps9.RankInBranch = item.KilidRankInBranch;
ps9.RankInZone = item.KilidRankInZone;
ps9.RankInBank = item.KilidRankInBank;
ps9.Score = item.KilidScore;
await _uow.PersonScoreRepository.AddAsync(ps9);
//اسناد نقدی و غیر نقدی
PersonScore ps10 = new PersonScore();
ps10.PersonInBranchId = personInBranchId;
ps10.ScoreSubIndexId = 12;
ps10.Value = item.SayerAsnadNaghdiVaGheirNaghdi;
ps10.RankInBranch = item.AsnadNaghdiVaGhirNaghdiRankInBranch;
ps10.RankInZone = item.AsnadNaghdiVaGhirNaghdiRankInZone;
ps10.RankInBank = item.AsnadNaghdiVaGhirNaghdiRankInBank;
ps10.Score = item.AsnadNaghdiVaGhirNaghdiScore;
await _uow.PersonScoreRepository.AddAsync(ps10);
//اسناد برگشتی
PersonScore ps11 = new PersonScore();
ps11.PersonInBranchId = personInBranchId;
ps11.ScoreSubIndexId = 13;
ps11.Value = item.SayerAsnadBarghashti;
ps11.RankInBranch = item.AsnadBarghashtiRankInBranch;
ps11.RankInZone = item.AsnadBarghashtiRankInZone;
ps11.RankInBank = item.AsnadBarghashtiRankInBank;
ps11.Score = item.AsnadBarghashtiScore;
await _uow.PersonScoreRepository.AddAsync(ps11);
//تعریف مشتری
PersonScore ps12 = new PersonScore();
ps12.PersonInBranchId = personInBranchId;
ps12.ScoreSubIndexId = 14;
ps12.Value = item.SayerTarifMoshtari;
ps12.RankInBranch = item.TarifMoshtariRankInBranch;
ps12.RankInZone = item.TarifMoshtariRankInZone;
ps12.RankInBank = item.TarifMoshtariRankInBank;
ps12.Score = item.TarifMoshtariScore;
await _uow.PersonScoreRepository.AddAsync(ps12);
//افتتاح حساب
PersonScore ps13 = new PersonScore();
ps13.PersonInBranchId = personInBranchId;
ps13.ScoreSubIndexId = 15;
ps13.Value = item.SayerEftetahHesab;
ps13.RankInBranch = item.EftetahHesabRankInBranch;
ps13.RankInZone = item.EftetahHesabRankInZone;
ps13.RankInBank = item.EftetahHesabRankInBank;
ps13.Score = item.EftetahHesabScore;
await _uow.PersonScoreRepository.AddAsync(ps13);
//بخش نامه خوانی
PersonScore ps14 = new PersonScore();
ps14.PersonInBranchId = personInBranchId;
ps14.ScoreSubIndexId = 16;
ps14.Value = item.SayerBakhshnameKhani;
ps14.RankInBranch = item.BakhshnameKhaniRankInBranch;
ps14.RankInZone = item.BakhshnameKhaniRankInZone;
ps14.RankInBank = item.BakhshnameKhaniRankInBank;
ps14.Score = item.BakhshnameKhaniScore;
await _uow.PersonScoreRepository.AddAsync(ps14);
//تاخیر و تاجیل
PersonScore ps15 = new PersonScore();
ps15.PersonInBranchId = personInBranchId;
ps15.ScoreSubIndexId = 17;
ps15.Value = item.SayerTakhirVaTajil;
ps15.RankInBranch = item.TakhirVaTajilRankInBranch;
ps15.RankInZone = item.TakhirVaTajilRankInZone;
ps15.RankInBank = item.TakhirVaTajilRankInBank;
ps15.Score = item.TakhirVaTajilScore;
await _uow.PersonScoreRepository.AddAsync(ps15);
}
else
{
Report report4 = new Report();
report4.MeritPayFactorId = EmtiazGrohiSetadId;
report4.PersonInBranchId = personInBranchId;
report4.Score = item.GroupScore;
report4.RankInBranch = item.GroupRankInBranch;
report4.RankInZone = item.GroupRankInZone;
report4.RankInBank = item.GroupRankInBank;
await _uow.ReportRepository.AddAsync(report4);
Report report5 = new Report();
report5.MeritPayFactorId = ArzeshYabiSetadId;
report5.PersonInBranchId = personInBranchId;
report5.Score = item.ArzeshScore;
report5.RankInBranch = item.ArzeshRankInBranch;
report5.RankInZone = item.ArzeshRankInZone;
report5.RankInBank = item.ArzeshRankInBank;
await _uow.ReportRepository.AddAsync(report5);
}
}
await _uow.CommitAsync();
return(null);
}
