private void ProcessSave()
{
var currentTime = DateTimeOffset.UtcNow;
foreach (var item in ChangeTracker.Entries()
.Where(e => e.State == EntityState.Added && e.Entity is EntityData))
{
var entidad = item.Entity as EntityData;
entidad.CreatedDate = currentTime;
entidad.CreatedByUser = currentUserService.GetCurrentUsername();
entidad.ModifiedDate = currentTime;
entidad.ModifiedByUser = currentUserService.GetCurrentUsername();
}
foreach (var item in ChangeTracker.Entries()
.Where(predicate: e => e.State == EntityState.Modified && e.Entity is EntityData))
{
var entidad = item.Entity as EntityData;
entidad.ModifiedDate = currentTime;
entidad.Edited = true;
entidad.ModifiedByUser = currentUserService.GetCurrentUsername();
item.Property(nameof(entidad.CreatedDate)).IsModified = false;
item.Property(nameof(entidad.CreatedByUser)).IsModified = false;
}
}
public GetGameSessionsListQueryHandler(IUserManagerService userManager, ICurrentUserService currentUser, IFiefAppDbContext context, IMapper mapper)
{
_userManager = userManager;
_context = context;
_mapper = mapper;
_currentUser = currentUser.GetCurrentUsername();
}
public Handler(IFiefAppDbContext context, IMediator mediator, ICurrentUserService userService, IMapper mapper)
{
_context = context;
_mediator = mediator;
_mapper = mapper;
_user = userService.GetCurrentUsername();
}
public Handler(IFiefAppDbContext context, IMediator mediator, IUserManagerService userManager, ICurrentUserService currentUser)
{
_context = context;
_mediator = mediator;
_userManager = userManager;
_user = currentUser.GetCurrentUsername();
}
public override async Task <int> SaveChangesAsync(CancellationToken cancellationToken = default(CancellationToken))
{
foreach (var entry in ChangeTracker.Entries <AuditableEntity>())
{
switch (entry.State)
{
case EntityState.Added:
entry.Entity.CreatedBy = _currentUserService.GetCurrentUsername() ?? "system";
entry.Entity.Created = DateTime.UtcNow;
break;
case EntityState.Modified:
entry.Entity.LastModifiedBy = _currentUserService.GetCurrentUsername() ?? "system";
entry.Entity.LastModified = DateTime.UtcNow;
break;
}
}
return(await base.SaveChangesAsync(cancellationToken));
}
public async Task <User> Handle(Query request, CancellationToken cancellationToken)
{
var user = await _userManager.FindByNameAsync(_currentUserService.GetCurrentUsername());
return(new User
{
DisplayName = user.DisplayName,
Username = user.UserName,
Token = _jwtGenerator.CreateToken(user),
Image = null
});
}
// GET: FKMTOTOKWANZA
public async Task <IActionResult> Index()
{
bool isAdmin = User.IsInRole("admin");
if (isAdmin)
{
return(View(await _context.FKMTOTO.ToListAsync()));
}
else
{
return(View(await _context.FKMTOTO.Where(p => p.CreatedByUser == _currentUserService.GetCurrentUsername()).ToListAsync()));
}
}
public async Task <ActionResult <IEnumerable <PmtctData> > > GetPmt()
{
//return await _context.Pmt.ToListAsync();
bool isSuperUser = User.IsInRole("admin") || User.IsInRole("analyst");
if (isSuperUser)
{
return(await _context.Pmt.ToListAsync());
}
else
{
return(await _context.Pmt.Where(p => p.CreatedByUser == currentUserService.GetCurrentUsername()).ToListAsync());
}
}
// GET: Pmtct
public async Task <IActionResult> Index()
{
using (_logger.BeginScope("Message {HoleValue}", DateTime.Now))
{
bool isAdmin = User.IsInRole("admin") || User.IsInRole("analyst");
if (isAdmin)
{
_logger.LogInformation(LoggingEvents.GetItem, "Listing all items");
return(View(await _context.Pmt.ToListAsync()));
}
else
{
_logger.LogInformation(LoggingEvents.GetItem, "Listing all items");
}
return(View(await _context.Pmt.Where(p => p.CreatedByUser == currentUserService.GetCurrentUsername()).ToListAsync()));
}
}
public async Task <ActionResult> ExcelDoc()
{
bool isSuperUser = User.IsInRole("admin") || User.IsInRole("analyst");
List <Pmtct.Models.PmtctFollowUp> pmtctUp = new List <PmtctFollowUp>();
if (isSuperUser)
{
pmtctUp = await _context.PmtctFollowUp.ToListAsync();
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("pmtctDatas");
var currentRow = 1;
worksheet.Cell(currentRow, 1).Value = "ID";
worksheet.Cell(currentRow, 2).Value = "NambaMshiriki01";
worksheet.Cell(currentRow, 3).Value = "TareheHudhurio";
worksheet.Cell(currentRow, 4).Value = "HaliYako305a";
worksheet.Cell(currentRow, 5).Value = "Mwenza305b1";
worksheet.Cell(currentRow, 6).Value = "Mwanafamiliaa305b2";
worksheet.Cell(currentRow, 7).Value = "Wazazi305b3";
worksheet.Cell(currentRow, 8).Value = "Rafiki305b1";
worksheet.Cell(currentRow, 9).Value = "Mfanyakazi305b5";
worksheet.Cell(currentRow, 10).Value = "Wengine305b6";
worksheet.Cell(currentRow, 11).Value = "Tajawengine305b7";
worksheet.Cell(currentRow, 12).Value = "Naogopakutengwa306a1";
worksheet.Cell(currentRow, 13).Value = "Naogopakuachwa306a2";
worksheet.Cell(currentRow, 14).Value = "kunyanyapaliwa306a2";
worksheet.Cell(currentRow, 15).Value = "BadosijaaminiVVUliwa306a4";
worksheet.Cell(currentRow, 16).Value = "Sinaninaemwamini306a6";
worksheet.Cell(currentRow, 17).Value = "Nyinginezo306a6";
worksheet.Cell(currentRow, 18).Value = "MpangoMtu306b";
worksheet.Cell(currentRow, 19).Value = "HaliMwenza307";
worksheet.Cell(currentRow, 20).Value = "KuhudumiwaTofautiVVU308a";
worksheet.Cell(currentRow, 21).Value = "Mwenza308b1";
worksheet.Cell(currentRow, 22).Value = "Mwanafamiliaa308b2";
worksheet.Cell(currentRow, 23).Value = "Wazazi308b3";
worksheet.Cell(currentRow, 24).Value = "Rafiki308b1";
worksheet.Cell(currentRow, 25).Value = "Mfanyakazi308b5";
worksheet.Cell(currentRow, 26).Value = "Mhudumu308b6";
worksheet.Cell(currentRow, 27).Value = "Wengine308b7";
worksheet.Cell(currentRow, 28).Value = "Tajawengine308b8";
worksheet.Cell(currentRow, 29).Value = "UmejiungaVVU309a";
worksheet.Cell(currentRow, 30).Value = "NdioTaja309b";
worksheet.Cell(currentRow, 31).Value = "MamaMwambata310a";
worksheet.Cell(currentRow, 32).Value = "Ushauri310b1";
worksheet.Cell(currentRow, 33).Value = "Elimuafya310b2";
worksheet.Cell(currentRow, 34).Value = "Ufuatiliaji310b3";
worksheet.Cell(currentRow, 35).Value = "Nyinginezo310b4";
worksheet.Cell(currentRow, 36).Value = "Rufaa";
worksheet.Cell(currentRow, 37).Value = "TareheHudhurioLijalo";
worksheet.Cell(currentRow, 38).Value = "Ufuatiliaji";
worksheet.Cell(currentRow, 39).Value = "JinaMtoHuduma";
worksheet.Cell(currentRow, 40).Value = "CreatedByUser";
worksheet.Cell(currentRow, 41).Value = "CreatedDate";
worksheet.Cell(currentRow, 42).Value = "ModifiedByUser";
worksheet.Cell(currentRow, 43).Value = "ModifiedDate";
worksheet.Cell(currentRow, 44).Value = "Edited";
foreach (var item in pmtctUp)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = item.ID;
worksheet.Cell(currentRow, 2).Value = item.NambaMshiriki01;
worksheet.Cell(currentRow, 3).Value = item.TareheHudhurio;
worksheet.Cell(currentRow, 4).Value = item.HaliYako305a;
worksheet.Cell(currentRow, 5).Value = item.Mwenza305b1;
worksheet.Cell(currentRow, 6).Value = item.Mwanafamiliaa305b2;
worksheet.Cell(currentRow, 7).Value = item.Wazazi305b3;
worksheet.Cell(currentRow, 8).Value = item.Rafiki305b1;
worksheet.Cell(currentRow, 9).Value = item.Mfanyakazi305b5;
worksheet.Cell(currentRow, 10).Value = item.Wengine305b6;
worksheet.Cell(currentRow, 11).Value = item.Tajawengine305b7;
worksheet.Cell(currentRow, 12).Value = item.Naogopakutengwa306a1;
worksheet.Cell(currentRow, 13).Value = item.Naogopakuachwa306a2;
worksheet.Cell(currentRow, 14).Value = item.kunyanyapaliwa306a2;
worksheet.Cell(currentRow, 15).Value = item.BadosijaaminiVVUliwa306a4;
worksheet.Cell(currentRow, 16).Value = item.Sinaninaemwamini306a6;
worksheet.Cell(currentRow, 17).Value = item.Nyinginezo306a6;
worksheet.Cell(currentRow, 18).Value = item.MpangoMtu306b;
worksheet.Cell(currentRow, 19).Value = item.HaliMwenza307;
worksheet.Cell(currentRow, 20).Value = item.KuhudumiwaTofautiVVU308a;
worksheet.Cell(currentRow, 21).Value = item.Mwenza308b1;
worksheet.Cell(currentRow, 22).Value = item.Mwanafamiliaa308b2;
worksheet.Cell(currentRow, 23).Value = item.Wazazi308b3;
worksheet.Cell(currentRow, 24).Value = item.Rafiki308b1;
worksheet.Cell(currentRow, 25).Value = item.Mfanyakazi308b5;
worksheet.Cell(currentRow, 26).Value = item.Mhudumu308b6;
worksheet.Cell(currentRow, 27).Value = item.Wengine308b7;
worksheet.Cell(currentRow, 28).Value = item.Tajawengine308b8;
worksheet.Cell(currentRow, 29).Value = item.UmejiungaVVU309a;
worksheet.Cell(currentRow, 30).Value = item.NdioTaja309b;
worksheet.Cell(currentRow, 31).Value = item.MamaMwambata310a;
worksheet.Cell(currentRow, 32).Value = item.Ushauri310b1;
worksheet.Cell(currentRow, 33).Value = item.Elimuafya310b2;
worksheet.Cell(currentRow, 34).Value = item.Ufuatiliaji310b3;
worksheet.Cell(currentRow, 35).Value = item.Nyinginezo310b4;
worksheet.Cell(currentRow, 36).Value = item.Rufaa;
worksheet.Cell(currentRow, 37).Value = item.TareheHudhurioLijalo;
worksheet.Cell(currentRow, 38).Value = item.Ufuatiliaji;
worksheet.Cell(currentRow, 39).Value = item.JinaMtoHuduma;
worksheet.Cell(currentRow, 40).Value = item.CreatedByUser;
worksheet.Cell(currentRow, 41).Value = item.CreatedDate;
worksheet.Cell(currentRow, 42).Value = item.ModifiedByUser;
worksheet.Cell(currentRow, 43).Value = item.ModifiedDate;
worksheet.Cell(currentRow, 44).Value = item.Edited;
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(content, "application/vnd.openxlformats-officedocument.spreadsheetml.sheet"
, "Pmtct_follow_up.xlsx"));
}
}
}
else
{
pmtctUp = await _context.PmtctFollowUp.Where(p => p.CreatedByUser == currentUserService.GetCurrentUsername()).ToListAsync();
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("pmtctDatas");
var currentRow = 1;
worksheet.Cell(currentRow, 1).Value = "ID";
worksheet.Cell(currentRow, 2).Value = "NambaMshiriki01";
worksheet.Cell(currentRow, 3).Value = "TareheHudhurio";
worksheet.Cell(currentRow, 4).Value = "HaliYako305a";
worksheet.Cell(currentRow, 5).Value = "Mwenza305b1";
worksheet.Cell(currentRow, 6).Value = "Mwanafamiliaa305b2";
worksheet.Cell(currentRow, 7).Value = "Wazazi305b3";
worksheet.Cell(currentRow, 8).Value = "Rafiki305b1";
worksheet.Cell(currentRow, 9).Value = "Mfanyakazi305b5";
worksheet.Cell(currentRow, 10).Value = "Wengine305b6";
worksheet.Cell(currentRow, 11).Value = "Tajawengine305b7";
worksheet.Cell(currentRow, 12).Value = "Naogopakutengwa306a1";
worksheet.Cell(currentRow, 13).Value = "Naogopakuachwa306a2";
worksheet.Cell(currentRow, 14).Value = "kunyanyapaliwa306a2";
worksheet.Cell(currentRow, 15).Value = "BadosijaaminiVVUliwa306a4";
worksheet.Cell(currentRow, 16).Value = "Sinaninaemwamini306a6";
worksheet.Cell(currentRow, 17).Value = "Nyinginezo306a6";
worksheet.Cell(currentRow, 18).Value = "MpangoMtu306b";
worksheet.Cell(currentRow, 19).Value = "HaliMwenza307";
worksheet.Cell(currentRow, 20).Value = "KuhudumiwaTofautiVVU308a";
worksheet.Cell(currentRow, 21).Value = "Mwenza308b1";
worksheet.Cell(currentRow, 22).Value = "Mwanafamiliaa308b2";
worksheet.Cell(currentRow, 23).Value = "Wazazi308b3";
worksheet.Cell(currentRow, 24).Value = "Rafiki308b1";
worksheet.Cell(currentRow, 25).Value = "Mfanyakazi308b5";
worksheet.Cell(currentRow, 26).Value = "Mhudumu308b6";
worksheet.Cell(currentRow, 27).Value = "Wengine308b7";
worksheet.Cell(currentRow, 28).Value = "Tajawengine308b8";
worksheet.Cell(currentRow, 29).Value = "UmejiungaVVU309a";
worksheet.Cell(currentRow, 30).Value = "NdioTaja309b";
worksheet.Cell(currentRow, 31).Value = "MamaMwambata310a";
worksheet.Cell(currentRow, 32).Value = "Ushauri310b1";
worksheet.Cell(currentRow, 33).Value = "Elimuafya310b2";
worksheet.Cell(currentRow, 34).Value = "Ufuatiliaji310b3";
worksheet.Cell(currentRow, 35).Value = "Nyinginezo310b4";
worksheet.Cell(currentRow, 36).Value = "Rufaa";
worksheet.Cell(currentRow, 37).Value = "TareheHudhurioLijalo";
worksheet.Cell(currentRow, 38).Value = "Ufuatiliaji";
worksheet.Cell(currentRow, 39).Value = "JinaMtoHuduma";
worksheet.Cell(currentRow, 40).Value = "CreatedByUser";
worksheet.Cell(currentRow, 41).Value = "CreatedDate";
worksheet.Cell(currentRow, 42).Value = "ModifiedByUser";
worksheet.Cell(currentRow, 43).Value = "ModifiedDate";
worksheet.Cell(currentRow, 44).Value = "Edited";
foreach (var item in pmtctUp)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = item.ID;
worksheet.Cell(currentRow, 2).Value = item.NambaMshiriki01;
worksheet.Cell(currentRow, 3).Value = item.TareheHudhurio;
worksheet.Cell(currentRow, 4).Value = item.HaliYako305a;
worksheet.Cell(currentRow, 5).Value = item.Mwenza305b1;
worksheet.Cell(currentRow, 6).Value = item.Mwanafamiliaa305b2;
worksheet.Cell(currentRow, 7).Value = item.Wazazi305b3;
worksheet.Cell(currentRow, 8).Value = item.Rafiki305b1;
worksheet.Cell(currentRow, 9).Value = item.Mfanyakazi305b5;
worksheet.Cell(currentRow, 10).Value = item.Wengine305b6;
worksheet.Cell(currentRow, 11).Value = item.Tajawengine305b7;
worksheet.Cell(currentRow, 12).Value = item.Naogopakutengwa306a1;
worksheet.Cell(currentRow, 13).Value = item.Naogopakuachwa306a2;
worksheet.Cell(currentRow, 14).Value = item.kunyanyapaliwa306a2;
worksheet.Cell(currentRow, 15).Value = item.BadosijaaminiVVUliwa306a4;
worksheet.Cell(currentRow, 16).Value = item.Sinaninaemwamini306a6;
worksheet.Cell(currentRow, 17).Value = item.Nyinginezo306a6;
worksheet.Cell(currentRow, 18).Value = item.MpangoMtu306b;
worksheet.Cell(currentRow, 19).Value = item.HaliMwenza307;
worksheet.Cell(currentRow, 20).Value = item.KuhudumiwaTofautiVVU308a;
worksheet.Cell(currentRow, 21).Value = item.Mwenza308b1;
worksheet.Cell(currentRow, 22).Value = item.Mwanafamiliaa308b2;
worksheet.Cell(currentRow, 23).Value = item.Wazazi308b3;
worksheet.Cell(currentRow, 24).Value = item.Rafiki308b1;
worksheet.Cell(currentRow, 25).Value = item.Mfanyakazi308b5;
worksheet.Cell(currentRow, 26).Value = item.Mhudumu308b6;
worksheet.Cell(currentRow, 27).Value = item.Wengine308b7;
worksheet.Cell(currentRow, 28).Value = item.Tajawengine308b8;
worksheet.Cell(currentRow, 29).Value = item.UmejiungaVVU309a;
worksheet.Cell(currentRow, 30).Value = item.NdioTaja309b;
worksheet.Cell(currentRow, 31).Value = item.MamaMwambata310a;
worksheet.Cell(currentRow, 32).Value = item.Ushauri310b1;
worksheet.Cell(currentRow, 33).Value = item.Elimuafya310b2;
worksheet.Cell(currentRow, 34).Value = item.Ufuatiliaji310b3;
worksheet.Cell(currentRow, 35).Value = item.Nyinginezo310b4;
worksheet.Cell(currentRow, 36).Value = item.Rufaa;
worksheet.Cell(currentRow, 37).Value = item.TareheHudhurioLijalo;
worksheet.Cell(currentRow, 38).Value = item.Ufuatiliaji;
worksheet.Cell(currentRow, 39).Value = item.JinaMtoHuduma;
worksheet.Cell(currentRow, 40).Value = item.CreatedByUser;
worksheet.Cell(currentRow, 41).Value = item.CreatedDate;
worksheet.Cell(currentRow, 42).Value = item.ModifiedByUser;
worksheet.Cell(currentRow, 43).Value = item.ModifiedDate;
worksheet.Cell(currentRow, 44).Value = item.Edited;
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(content, "application/vnd.openxlformats-officedocument.spreadsheetml.sheet"
, "Pmtct_follow_up.xlsx"));
}
}
}
}
public GetDetailedSubsidiaryQueryHandler(IFiefAppDbContext context, IMapper mapper, ICurrentUserService currentUser)
{
_context = context;
_mapper = mapper;
_user = currentUser.GetCurrentUsername();
}
public CurrentUserQueryHandler(IUserManagerService userManager, ICurrentUserService currentUser)
{
_userManager = userManager;
_currentUser = currentUser.GetCurrentUsername();
}
public UpdateRoadCommandHandler(IFiefAppDbContext context, ICurrentUserService currentUser)
{
_context = context;
_currentUser = currentUser.GetCurrentUsername();
}
public async Task <ActionResult> ExcelDoc()
{
bool isSuperUser = User.IsInRole("admin") || User.IsInRole("analyst");
List <Pmtct.Models.PmtctData> pmtctDatas = new List <PmtctData>();
if (isSuperUser)
{
pmtctDatas = await _context.Pmt.ToListAsync();
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("pmtctDatas");
var currentRow = 1;
worksheet.Cell(currentRow, 1).Value = "ID";
worksheet.Cell(currentRow, 2).Value = "InitiatedART401";
worksheet.Cell(currentRow, 3).Value = "InitiatedARTDate401";
worksheet.Cell(currentRow, 4).Value = "DeliveryFacility402";
worksheet.Cell(currentRow, 5).Value = "DeliveryFacilityDate402";
worksheet.Cell(currentRow, 6).Value = "EarlyBirth403a";
worksheet.Cell(currentRow, 7).Value = "EarlyBirthDate403a";
worksheet.Cell(currentRow, 8).Value = "InfantHIVstatus403b";
worksheet.Cell(currentRow, 9).Value = "MotherResults403c";
worksheet.Cell(currentRow, 10).Value = "MotherResultsDate403c";
worksheet.Cell(currentRow, 11).Value = "InfantBreastfeeding404a";
worksheet.Cell(currentRow, 12).Value = "InfantBreastfeedingDate404a";
worksheet.Cell(currentRow, 13).Value = "RemarksName";
worksheet.Cell(currentRow, 14).Value = "NambaMshiriki01";
worksheet.Cell(currentRow, 15).Value = "Wilaya02";
worksheet.Cell(currentRow, 16).Value = "TareheMahojiano03";
worksheet.Cell(currentRow, 17).Value = "Kituo04";
worksheet.Cell(currentRow, 18).Value = "JinaAnayehoji05";
worksheet.Cell(currentRow, 19).Value = "Ngazikituo06";
worksheet.Cell(currentRow, 20).Value = "Umri101";
worksheet.Cell(currentRow, 21).Value = "KiwangoElimu102";
worksheet.Cell(currentRow, 22).Value = "HaliNdoa103";
worksheet.Cell(currentRow, 23).Value = "KipatoMwezi104";
worksheet.Cell(currentRow, 24).Value = "Kazi105";
worksheet.Cell(currentRow, 25).Value = "IdadiMimba106";
worksheet.Cell(currentRow, 26).Value = "WilayaUnayoishi107";
worksheet.Cell(currentRow, 27).Value = "MdaKuishiZanzibar109";
worksheet.Cell(currentRow, 28).Value = "KilomitaKituo201";
worksheet.Cell(currentRow, 29).Value = "KilomitaUjazo202";
worksheet.Cell(currentRow, 30).Value = "UgumuKliniki204a";
worksheet.Cell(currentRow, 31).Value = "BasiMbaliAfya204b_1";
worksheet.Cell(currentRow, 32).Value = "UgumuUsafiriUmma204b_2";
worksheet.Cell(currentRow, 33).Value = "KukosaNauli204b_3";
worksheet.Cell(currentRow, 34).Value = "MsafaraMrefu204b_4";
worksheet.Cell(currentRow, 35).Value = "AnaishiMbaliBasi204b_5";
worksheet.Cell(currentRow, 36).Value = "AnaishiMbaliAfya204b_6";
worksheet.Cell(currentRow, 37).Value = "Mengine204b_7";
worksheet.Cell(currentRow, 38).Value = "TajaMengine204b";
worksheet.Cell(currentRow, 39).Value = "HudumaHapa205";
worksheet.Cell(currentRow, 40).Value = "UmepataHapaHuduma206";
worksheet.Cell(currentRow, 41).Value = "UmriMimba301";
worksheet.Cell(currentRow, 42).Value = "MwakaVVU302";
worksheet.Cell(currentRow, 43).Value = "MdaVVU303";
worksheet.Cell(currentRow, 44).Value = "DawaVVU304a";
worksheet.Cell(currentRow, 45).Value = "LiniDawaVVU304b";
worksheet.Cell(currentRow, 46).Value = "CTC304c";
foreach (var item in pmtctDatas)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = item.ID;
worksheet.Cell(currentRow, 2).Value = item.InitiatedART401;
worksheet.Cell(currentRow, 3).Value = item.InitiatedARTDate401;
worksheet.Cell(currentRow, 4).Value = item.DeliveryFacility402;
worksheet.Cell(currentRow, 5).Value = item.DeliveryFacilityDate402;
worksheet.Cell(currentRow, 6).Value = item.EarlyBirth403a;
worksheet.Cell(currentRow, 7).Value = item.EarlyBirthDate403a;
worksheet.Cell(currentRow, 8).Value = item.InfantHIVstatus403b;
worksheet.Cell(currentRow, 9).Value = item.MotherResults403c;
worksheet.Cell(currentRow, 10).Value = item.MotherResultsDate403c;
worksheet.Cell(currentRow, 11).Value = item.InfantBreastfeeding404a;
worksheet.Cell(currentRow, 12).Value = item.InfantBreastfeedingDate404a;
worksheet.Cell(currentRow, 13).Value = item.RemarksName;
worksheet.Cell(currentRow, 14).Value = item.NambaMshiriki01;
worksheet.Cell(currentRow, 15).Value = item.Wilaya02;
worksheet.Cell(currentRow, 16).Value = item.TareheMahojiano03;
worksheet.Cell(currentRow, 17).Value = item.Kituo04;
worksheet.Cell(currentRow, 18).Value = item.JinaAnayehoji05;
worksheet.Cell(currentRow, 19).Value = item.Ngazikituo06;
worksheet.Cell(currentRow, 20).Value = item.Umri101;
worksheet.Cell(currentRow, 21).Value = item.KiwangoElimu102;
worksheet.Cell(currentRow, 22).Value = item.HaliNdoa103;
worksheet.Cell(currentRow, 23).Value = item.KipatoMwezi104;
worksheet.Cell(currentRow, 24).Value = item.Kazi105;
worksheet.Cell(currentRow, 25).Value = item.IdadiMimba106;
worksheet.Cell(currentRow, 26).Value = item.WilayaUnayoishi107;
worksheet.Cell(currentRow, 27).Value = item.MdaKuishiZanzibar109;
worksheet.Cell(currentRow, 28).Value = item.KilomitaKituo201;
worksheet.Cell(currentRow, 29).Value = item.KilomitaUjazo202;
worksheet.Cell(currentRow, 30).Value = item.UgumuKliniki204a;
worksheet.Cell(currentRow, 31).Value = item.BasiMbaliAfya204b_1;
worksheet.Cell(currentRow, 32).Value = item.UgumuUsafiriUmma204b_2;
worksheet.Cell(currentRow, 33).Value = item.KukosaNauli204b_3;
worksheet.Cell(currentRow, 34).Value = item.MsafaraMrefu204b_4;
worksheet.Cell(currentRow, 35).Value = item.AnaishiMbaliBasi204b_5;
worksheet.Cell(currentRow, 36).Value = item.AnaishiMbaliAfya204b_6;
worksheet.Cell(currentRow, 37).Value = item.Mengine204b_7;
worksheet.Cell(currentRow, 38).Value = item.TajaMengine204b;
worksheet.Cell(currentRow, 39).Value = item.HudumaHapa205;
worksheet.Cell(currentRow, 40).Value = item.UmepataHapaHuduma206;
worksheet.Cell(currentRow, 41).Value = item.UmriMimba301;
worksheet.Cell(currentRow, 42).Value = item.MwakaVVU302;
worksheet.Cell(currentRow, 43).Value = item.MdaVVU303;
worksheet.Cell(currentRow, 44).Value = item.DawaVVU304a;
worksheet.Cell(currentRow, 45).Value = item.LiniDawaVVU304b;
worksheet.Cell(currentRow, 46).Value = item.CTC304c;
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(content, "application/vnd.openxlformats-officedocument.spreadsheetml.sheet"
, "PmtctInfo.xlsx"));
}
}
}
else
{
pmtctDatas = await _context.Pmt.Where(p => p.CreatedByUser == currentUserService.GetCurrentUsername()).ToListAsync();
using (var workbook = new XLWorkbook())
{
var worksheet = workbook.Worksheets.Add("pmtctDatas");
var currentRow = 1;
worksheet.Cell(currentRow, 1).Value = "ID";
worksheet.Cell(currentRow, 2).Value = "InitiatedART401";
worksheet.Cell(currentRow, 3).Value = "InitiatedARTDate401";
worksheet.Cell(currentRow, 4).Value = "DeliveryFacility402";
worksheet.Cell(currentRow, 5).Value = "DeliveryFacilityDate402";
worksheet.Cell(currentRow, 6).Value = "EarlyBirth403a";
worksheet.Cell(currentRow, 7).Value = "EarlyBirthDate403a";
worksheet.Cell(currentRow, 8).Value = "InfantHIVstatus403b";
worksheet.Cell(currentRow, 9).Value = "MotherResults403c";
worksheet.Cell(currentRow, 10).Value = "MotherResultsDate403c";
worksheet.Cell(currentRow, 11).Value = "InfantBreastfeeding404a";
worksheet.Cell(currentRow, 12).Value = "InfantBreastfeedingDate404a";
worksheet.Cell(currentRow, 13).Value = "RemarksName";
worksheet.Cell(currentRow, 14).Value = "NambaMshiriki01";
worksheet.Cell(currentRow, 15).Value = "Wilaya02";
worksheet.Cell(currentRow, 16).Value = "TareheMahojiano03";
worksheet.Cell(currentRow, 17).Value = "Kituo04";
worksheet.Cell(currentRow, 18).Value = "JinaAnayehoji05";
worksheet.Cell(currentRow, 19).Value = "Ngazikituo06";
worksheet.Cell(currentRow, 20).Value = "Umri101";
worksheet.Cell(currentRow, 21).Value = "KiwangoElimu102";
worksheet.Cell(currentRow, 22).Value = "HaliNdoa103";
worksheet.Cell(currentRow, 23).Value = "KipatoMwezi104";
worksheet.Cell(currentRow, 24).Value = "Kazi105";
worksheet.Cell(currentRow, 25).Value = "IdadiMimba106";
worksheet.Cell(currentRow, 26).Value = "WilayaUnayoishi107";
worksheet.Cell(currentRow, 27).Value = "MdaKuishiZanzibar109";
worksheet.Cell(currentRow, 28).Value = "KilomitaKituo201";
worksheet.Cell(currentRow, 29).Value = "KilomitaUjazo202";
worksheet.Cell(currentRow, 30).Value = "UgumuKliniki204a";
worksheet.Cell(currentRow, 31).Value = "BasiMbaliAfya204b_1";
worksheet.Cell(currentRow, 32).Value = "UgumuUsafiriUmma204b_2";
worksheet.Cell(currentRow, 33).Value = "KukosaNauli204b_3";
worksheet.Cell(currentRow, 34).Value = "MsafaraMrefu204b_4";
worksheet.Cell(currentRow, 35).Value = "AnaishiMbaliBasi204b_5";
worksheet.Cell(currentRow, 36).Value = "AnaishiMbaliAfya204b_6";
worksheet.Cell(currentRow, 37).Value = "Mengine204b_7";
worksheet.Cell(currentRow, 38).Value = "TajaMengine204b";
worksheet.Cell(currentRow, 39).Value = "HudumaHapa205";
worksheet.Cell(currentRow, 40).Value = "UmepataHapaHuduma206";
worksheet.Cell(currentRow, 41).Value = "UmriMimba301";
worksheet.Cell(currentRow, 42).Value = "MwakaVVU302";
worksheet.Cell(currentRow, 43).Value = "MdaVVU303";
worksheet.Cell(currentRow, 44).Value = "DawaVVU304a";
worksheet.Cell(currentRow, 45).Value = "LiniDawaVVU304b";
worksheet.Cell(currentRow, 46).Value = "CTC304c";
foreach (var item in pmtctDatas)
{
currentRow++;
worksheet.Cell(currentRow, 1).Value = item.ID;
worksheet.Cell(currentRow, 2).Value = item.InitiatedART401;
worksheet.Cell(currentRow, 3).Value = item.InitiatedARTDate401;
worksheet.Cell(currentRow, 4).Value = item.DeliveryFacility402;
worksheet.Cell(currentRow, 5).Value = item.DeliveryFacilityDate402;
worksheet.Cell(currentRow, 6).Value = item.EarlyBirth403a;
worksheet.Cell(currentRow, 7).Value = item.EarlyBirthDate403a;
worksheet.Cell(currentRow, 8).Value = item.InfantHIVstatus403b;
worksheet.Cell(currentRow, 9).Value = item.MotherResults403c;
worksheet.Cell(currentRow, 10).Value = item.MotherResultsDate403c;
worksheet.Cell(currentRow, 11).Value = item.InfantBreastfeeding404a;
worksheet.Cell(currentRow, 12).Value = item.InfantBreastfeedingDate404a;
worksheet.Cell(currentRow, 13).Value = item.RemarksName;
worksheet.Cell(currentRow, 14).Value = item.NambaMshiriki01;
worksheet.Cell(currentRow, 15).Value = item.Wilaya02;
worksheet.Cell(currentRow, 16).Value = item.TareheMahojiano03;
worksheet.Cell(currentRow, 17).Value = item.Kituo04;
worksheet.Cell(currentRow, 18).Value = item.JinaAnayehoji05;
worksheet.Cell(currentRow, 19).Value = item.Ngazikituo06;
worksheet.Cell(currentRow, 20).Value = item.Umri101;
worksheet.Cell(currentRow, 21).Value = item.KiwangoElimu102;
worksheet.Cell(currentRow, 22).Value = item.HaliNdoa103;
worksheet.Cell(currentRow, 23).Value = item.KipatoMwezi104;
worksheet.Cell(currentRow, 24).Value = item.Kazi105;
worksheet.Cell(currentRow, 25).Value = item.IdadiMimba106;
worksheet.Cell(currentRow, 26).Value = item.WilayaUnayoishi107;
worksheet.Cell(currentRow, 27).Value = item.MdaKuishiZanzibar109;
worksheet.Cell(currentRow, 28).Value = item.KilomitaKituo201;
worksheet.Cell(currentRow, 29).Value = item.KilomitaUjazo202;
worksheet.Cell(currentRow, 30).Value = item.UgumuKliniki204a;
worksheet.Cell(currentRow, 31).Value = item.BasiMbaliAfya204b_1;
worksheet.Cell(currentRow, 32).Value = item.UgumuUsafiriUmma204b_2;
worksheet.Cell(currentRow, 33).Value = item.KukosaNauli204b_3;
worksheet.Cell(currentRow, 34).Value = item.MsafaraMrefu204b_4;
worksheet.Cell(currentRow, 35).Value = item.AnaishiMbaliBasi204b_5;
worksheet.Cell(currentRow, 36).Value = item.AnaishiMbaliAfya204b_6;
worksheet.Cell(currentRow, 37).Value = item.Mengine204b_7;
worksheet.Cell(currentRow, 38).Value = item.TajaMengine204b;
worksheet.Cell(currentRow, 39).Value = item.HudumaHapa205;
worksheet.Cell(currentRow, 40).Value = item.UmepataHapaHuduma206;
worksheet.Cell(currentRow, 41).Value = item.UmriMimba301;
worksheet.Cell(currentRow, 42).Value = item.MwakaVVU302;
worksheet.Cell(currentRow, 43).Value = item.MdaVVU303;
worksheet.Cell(currentRow, 44).Value = item.DawaVVU304a;
worksheet.Cell(currentRow, 45).Value = item.LiniDawaVVU304b;
worksheet.Cell(currentRow, 46).Value = item.CTC304c;
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(content, "application/vnd.openxlformats-officedocument.spreadsheetml.sheet"
, "PmtctInfo.xlsx"));
}
}
}
}
public GetTaxsListQueryHandler(IFiefAppDbContext context, IMapper mapper, ICurrentUserService currentUser)
{
_context = context;
_mapper = mapper;
_user = currentUser.GetCurrentUsername();
}
// GET: Bha
public async Task <IActionResult> Index(string sortOrder, int currentFilter,
int searchString, int?pageNumber)
{
bool isAdmin = User.IsInRole("admin");
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
if (searchString != 0)
{
pageNumber = 1;
}
else
{
searchString = currentFilter;
}
IQueryable <Bhamc> bh;
ViewData["CurrentFilter"] = searchString;
if (isAdmin)
{
bh = _context.Bhamc;
}
else
{
bh = _context.Bhamc.Where(p => p.CreatedByUser == _currentUserService.GetCurrentUsername());
}
if (searchString != 0)
{
bh = bh.Where(s => s.QuestionnaireNo == searchString);
}
switch (sortOrder)
{
case "name_desc":
bh = bh.OrderByDescending(s => s.QuestionnaireNo);
break;
case "Date":
bh = bh.OrderBy(s => s.CreatedDate);
break;
case "date_desc":
bh = bh.OrderByDescending(s => s.CreatedByUser);
break;
default:
bh = bh.OrderBy(s => s.CreatedDate);
break;
}
int pageSize = 40;
return(View(await PaginatedList <Bhamc> .CreateAsync(bh.AsNoTracking(), pageNumber ?? 1, pageSize)));
//return View(await _context.Bhamc.ToListAsync());
}
public async Task <ActionResult> CSV()
{
bool isSuperUser = User.IsInRole("admin") || User.IsInRole("analyst");
List <Pmtct.Models.PmtctFollowUp> pmtctUp = new List <PmtctFollowUp>();
var builder = new StringBuilder();
if (isSuperUser)
{
pmtctUp = await _context.PmtctFollowUp.ToListAsync();
builder.AppendLine("ID,NambaMshiriki01,TareheHudhurio,HaliYako305a,Mwenza305b1," +
"Mwanafamiliaa305b2,Wazazi305b3,Rafiki305b1,Mfanyakazi305b5,Wengine305b6,Tajawengine305b7," +
"Naogopakutengwa306a1,Naogopakuachwa306a2,kunyanyapaliwa306a2,BadosijaaminiVVUliwa306a4," +
"Sinaninaemwamini306a6,Nyinginezo306a6,MpangoMtu306b,HaliMwenza307,KuhudumiwaTofautiVVU308a," +
"Mwenza308b1,Mwanafamiliaa308b2,Wazazi308b3,Rafiki308b1,Mfanyakazi308b5,Mhudumu308b6,Wengine308b7," +
"Tajawengine308b8,UmejiungaVVU309a,NdioTaja309b,MamaMwambata310a,Ushauri310b1,Elimuafya310b2," +
"Ufuatiliaji310b3,Nyinginezo310b4,Rufaa,TareheHudhurioLijalo,Ufuatiliaji,JinaMtoHuduma,CreatedByUser," +
"CreatedDate,ModifiedByUser,ModifiedDate,Edited");
foreach (var item in pmtctUp)
{
builder.AppendLine($"{item.ID},{item.NambaMshiriki01},{item.TareheHudhurio}," +
$"{item.HaliYako305a},{item.Mwenza305b1},{item.Mwanafamiliaa305b2}," +
$"{item.Wazazi305b3},{item.Rafiki305b1},{item.Mfanyakazi305b5}," +
$"{item.Wengine305b6},{item.Tajawengine305b7},{item.Naogopakutengwa306a1}," +
$"{item.Naogopakuachwa306a2},{item.kunyanyapaliwa306a2},{item.BadosijaaminiVVUliwa306a4}," +
$"{item.Sinaninaemwamini306a6},{item.Nyinginezo306a6},{item.MpangoMtu306b}," +
$"{item.HaliMwenza307},{item.KuhudumiwaTofautiVVU308a},{item.Mwenza308b1}," +
$"{item.Mwanafamiliaa308b2},{item.Wazazi308b3},{item.Rafiki308b1}," +
$"{item.Mfanyakazi308b5},{item.Mhudumu308b6},{item.Wengine308b7},{item.Tajawengine308b8}" +
$"{item.UmejiungaVVU309a},{item.NdioTaja309b},{item.MamaMwambata310a}," +
$"{item.Ushauri310b1},{item.Elimuafya310b2},{item.Ufuatiliaji},{item.Nyinginezo310b4}" +
$"{item.Rufaa},{item.TareheHudhurioLijalo},{item.Ufuatiliaji}," +
$"{item.JinaMtoHuduma},{item.CreatedByUser},{item.CreatedDate},{item.ModifiedByUser},{item.ModifiedDate}," +
$"{item.Edited}");
}
return(File(Encoding.UTF8.GetBytes(builder.ToString()), "text/csv", "Pmtct_follow_up.csv"));
}
else
{
pmtctUp = await _context.PmtctFollowUp.Where(p => p.CreatedByUser == currentUserService.GetCurrentUsername()).ToListAsync();
}
builder.AppendLine("ID,NambaMshiriki01,TareheHudhurio,HaliYako305a,Mwenza305b1," +
"Mwanafamiliaa305b2,Wazazi305b3,Rafiki305b1,Mfanyakazi305b5,Wengine305b6,Tajawengine305b7," +
"Naogopakutengwa306a1,Naogopakuachwa306a2,kunyanyapaliwa306a2,BadosijaaminiVVUliwa306a4," +
"Sinaninaemwamini306a6,Nyinginezo306a6,MpangoMtu306b,HaliMwenza307,KuhudumiwaTofautiVVU308a," +
"Mwenza308b1,Mwanafamiliaa308b2,Wazazi308b3,Rafiki308b1,Mfanyakazi308b5,Mhudumu308b6,Wengine308b7," +
"Tajawengine308b8,UmejiungaVVU309a,NdioTaja309b,MamaMwambata310a,Ushauri310b1,Elimuafya310b2," +
"Ufuatiliaji310b3,Nyinginezo310b4,Rufaa,TareheHudhurioLijalo,Ufuatiliaji,JinaMtoHuduma,CreatedByUser," +
"CreatedDate,ModifiedByUser,ModifiedDate,Edited");
foreach (var item in pmtctUp)
{
builder.AppendLine($"{item.ID},{item.NambaMshiriki01},{item.TareheHudhurio}," +
$"{item.HaliYako305a},{item.Mwenza305b1},{item.Mwanafamiliaa305b2}," +
$"{item.Wazazi305b3},{item.Rafiki305b1},{item.Mfanyakazi305b5}," +
$"{item.Wengine305b6},{item.Tajawengine305b7},{item.Naogopakutengwa306a1}," +
$"{item.Naogopakuachwa306a2},{item.kunyanyapaliwa306a2},{item.BadosijaaminiVVUliwa306a4}," +
$"{item.Sinaninaemwamini306a6},{item.Nyinginezo306a6},{item.MpangoMtu306b}," +
$"{item.HaliMwenza307},{item.KuhudumiwaTofautiVVU308a},{item.Mwenza308b1}," +
$"{item.Mwanafamiliaa308b2},{item.Wazazi308b3},{item.Rafiki308b1}," +
$"{item.Mfanyakazi308b5},{item.Mhudumu308b6},{item.Wengine308b7},{item.Tajawengine308b8}" +
$"{item.UmejiungaVVU309a},{item.NdioTaja309b},{item.MamaMwambata310a}," +
$"{item.Ushauri310b1},{item.Elimuafya310b2},{item.Ufuatiliaji},{item.Nyinginezo310b4}" +
$"{item.Rufaa},{item.TareheHudhurioLijalo},{item.Ufuatiliaji}," +
$"{item.JinaMtoHuduma},{item.CreatedByUser},{item.CreatedDate},{item.ModifiedByUser},{item.ModifiedDate}," +
$"{item.Edited}");
}
return(File(Encoding.UTF8.GetBytes(builder.ToString()), "text/csv", "Pmtct_follow_up.csv"));
}
public InitializeFiefQueryHandler(IFiefAppDbContext context, ICurrentUserService currentUser, IMapper mapper)
{
_context = context;
_mapper = mapper;
_currentUser = currentUser.GetCurrentUsername();
}
public Handler(IMediator mediator, IUserManagerService userManager, ICurrentUserService currentUser)
{
_mediator = mediator;
_userManager = userManager;
_userName = currentUser.GetCurrentUsername();
}
public async Task <ActionResult> CSV()
{
bool isSuperUser = User.IsInRole("admin") || User.IsInRole("analyst");
List <Pmtct.Models.PmtctData> pmtctDatas = new List <PmtctData>();
var builder = new StringBuilder();
if (isSuperUser)
{
pmtctDatas = await _context.Pmt.ToListAsync();
builder.AppendLine("ID,InitiatedART401,InitiatedARTDate401," +
"DeliveryFacility402,DeliveryFacilityDate402," +
"EarlyBirth403a,EarlyBirthDate403a,InfantHIVstatus403b,MotherResults403c," +
"MotherResultsDate403c,InfantBreastfeeding404a,InfantBreastfeedingDate404a," +
"RemarksName,NambaMshiriki01,Wilaya02,TareheMahojiano03," +
"Kituo04,JinaAnayehoji05,Ngazikituo06,Umri101,KiwangoElimu102,HaliNdoa103,KipatoMwezi104," +
"Kazi105,IdadiMimba106,WilayaUnayoishi107,MdaKuishiZanzibar109," +
"KilomitaKituo201,KilomitaUjazo202,HudumaUjauzito203,UgumuKliniki204a," +
"BasiMbaliAfya204b_1,UgumuUsafiriUmma204b_2,KukosaNauli204b_3,MsafaraMrefu204b_4," +
"AnaishiMbaliBasi204b_5,AnaishiMbaliAfya204b_6,Mengine204b_7,TajaMengine204b,HudumaHapa205" +
"UmepataHapaHuduma206,UmriMimba301,MwakaVVU302,MdaVVU303,DawaVVU304a,LiniDawaVVU304b,CTC304c");
foreach (var item in pmtctDatas)
{
builder.AppendLine($"{item.ID},{item.InitiatedART401},{item.InitiatedARTDate401}," +
$"{item.DeliveryFacility402},{item.DeliveryFacilityDate402},{item.EarlyBirth403a}," +
$"{item.EarlyBirthDate403a},{item.InfantHIVstatus403b}," +
$"{item.MotherResults403c},{item.MotherResultsDate403c}," +
$"{item.InfantBreastfeeding404a},{item.InfantBreastfeedingDate404a}," +
$"{item.RemarksName},{item.NambaMshiriki01},{item.Wilaya02},{item.TareheMahojiano03}," +
$"{item.Kituo04},{item.JinaAnayehoji05},{item.Ngazikituo06},{item.Umri101},{item.KiwangoElimu102}" +
$"{item.HaliNdoa103},{item.KipatoMwezi104},{item.Kazi105},{item.MdaKuishiZanzibar109},{item.IdadiMimba106}" +
$",{item.WilayaUnayoishi107},{item.KilomitaKituo201},{item.KilomitaUjazo202},{item.HudumaUjauzito203}," +
$"{item.UgumuKliniki204a},{item.HudumaHapa205},{item.BasiMbaliAfya204b_1},{item.UgumuUsafiriUmma204b_2}," +
$"{item.KukosaNauli204b_3},{item.MsafaraMrefu204b_4},{item.AnaishiMbaliBasi204b_5}," +
$"{item.AnaishiMbaliAfya204b_6},{item.Mengine204b_7},{item.TajaMengine204b}," +
$"{item.UmepataHapaHuduma206},{item.UmriMimba301},{item.MwakaVVU302},{item.MdaVVU303}," +
$"{item.DawaVVU304a},{item.LiniDawaVVU304b},{item.CTC304c}");
}
return(File(Encoding.UTF8.GetBytes(builder.ToString()), "text/csv", "Pmtct.csv"));
}
else
{
pmtctDatas = await _context.Pmt.Where(p => p.CreatedByUser == currentUserService.GetCurrentUsername()).ToListAsync();
}
builder.AppendLine("ID,InitiatedART401,InitiatedARTDate401," +
"DeliveryFacility402,DeliveryFacilityDate402," +
"EarlyBirth403a,EarlyBirthDate403a,InfantHIVstatus403b,MotherResults403c," +
"MotherResultsDate403c,InfantBreastfeeding404a,InfantBreastfeedingDate404a," +
"RemarksName,NambaMshiriki01,Wilaya02,TareheMahojiano03," +
"Kituo04,JinaAnayehoji05,Ngazikituo06,Umri101,KiwangoElimu102,HaliNdoa103,KipatoMwezi104," +
"Kazi105,IdadiMimba106,WilayaUnayoishi107,MdaKuishiZanzibar109," +
"KilomitaKituo201,KilomitaUjazo202,HudumaUjauzito203,UgumuKliniki204a," +
"BasiMbaliAfya204b_1,UgumuUsafiriUmma204b_2,KukosaNauli204b_3,MsafaraMrefu204b_4," +
"AnaishiMbaliBasi204b_5,AnaishiMbaliAfya204b_6,Mengine204b_7,TajaMengine204b,HudumaHapa205" +
"UmepataHapaHuduma206,UmriMimba301,MwakaVVU302,MdaVVU303,DawaVVU304a,LiniDawaVVU304b,CTC304c");
foreach (var item in pmtctDatas)
{
builder.AppendLine($"{item.ID},{item.InitiatedART401},{item.InitiatedARTDate401}," +
$"{item.DeliveryFacility402},{item.DeliveryFacilityDate402},{item.EarlyBirth403a}," +
$"{item.EarlyBirthDate403a},{item.InfantHIVstatus403b}," +
$"{item.MotherResults403c},{item.MotherResultsDate403c}," +
$"{item.InfantBreastfeeding404a},{item.InfantBreastfeedingDate404a}," +
$"{item.RemarksName},{item.NambaMshiriki01},{item.Wilaya02},{item.TareheMahojiano03}," +
$"{item.Kituo04},{item.JinaAnayehoji05},{item.Ngazikituo06},{item.Umri101},{item.KiwangoElimu102}" +
$"{item.HaliNdoa103},{item.KipatoMwezi104},{item.Kazi105},{item.MdaKuishiZanzibar109},{item.IdadiMimba106}" +
$",{item.WilayaUnayoishi107},{item.KilomitaKituo201},{item.KilomitaUjazo202},{item.HudumaUjauzito203}," +
$"{item.UgumuKliniki204a},{item.HudumaHapa205},{item.BasiMbaliAfya204b_1},{item.UgumuUsafiriUmma204b_2}," +
$"{item.KukosaNauli204b_3},{item.MsafaraMrefu204b_4},{item.AnaishiMbaliBasi204b_5}," +
$"{item.AnaishiMbaliAfya204b_6},{item.Mengine204b_7},{item.TajaMengine204b}," +
$"{item.UmepataHapaHuduma206},{item.UmriMimba301},{item.MwakaVVU302},{item.MdaVVU303}," +
$"{item.DawaVVU304a},{item.LiniDawaVVU304b},{item.CTC304c}");
}
return(File(Encoding.UTF8.GetBytes(builder.ToString()), "text/csv", "Pmtct.csv"));
}