public void ImportData() { ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2013; Stream stream = System.IO.File.Open(System.IO.Directory.GetCurrentDirectory() + "\\App_Data\\Template\\HealthFacilities.xlsx", FileMode.OpenOrCreate); IWorkbook workbook = application.Workbooks.Open(stream); IWorksheet sheet = workbook.Worksheets[0]; int firstRow = sheet.UsedRange.Row; int lastRow = sheet.UsedRange.LastRow + 1; int rows = lastRow - firstRow; IList <TempFacility> data = ExportDataFromExcelSheet(sheet, 2, 1, rows); _context.AddRange(data); //Saving the updated file _context.SaveChanges(); workbook.Close(); excelEngine.Dispose(); }
public IActionResult Create(string nmrid) { int[] query = _context.TblMn.Where(m => m.Nmrid == nmrid).Select(m => m.Mnid).ToArray(); int [] mns = _context.TlkpMn.Where(m => m.Active.Equals(true) && !query.Contains(m.Mnid)).Select(m => m.Mnid).ToArray(); foreach (int a in mns) { TblMn item = new TblMn(); item.UserName = User.Identity.Name; item.Nmrid = nmrid; item.Mnid = a; _context.TblMn.Add(item); } _context.SaveChanges(); return(Ok()); }
public IActionResult Create(string nmrid) { if (nmrid == null) { return(NotFound()); } var nmr = _context.Nmr.SingleOrDefault(m => m.Nmrid == nmrid); if (nmr == null) { return(NotFound()); } var user = User.Identity.Name; if (nmr.UserName != user) { return(Unauthorized()); } int[] query = _context.TblOtp.Where(m => m.Nmrid == nmrid).Select(m => m.Otpid).ToArray(); // int[] model = _context.TlkpOtptfu.Where(m => m.Active.Equals(true) && !m.AgeGroup.ToLower().Trim().Replace(" ","").Contains("6month") && !m.AgeGroup.ToLower().Contains("total") && !query.Contains(m.Otptfuid)).Select(m=>m.Otptfuid).ToArray(); int[] model = _context.TlkpOtptfu.Where(m => m.Active.Equals(true) && !m.AgeGroup.ToLower().Contains("total") && !query.Contains(m.Otptfuid)).Select(m => m.Otptfuid).ToArray(); foreach (int id in model) { TblOtp Item = new TblOtp(); Item.Nmrid = nmrid; Item.UserName = user; Item.Otpid = id; _context.TblOtp.Add(Item); } int[] selectedItems = _context.TblStockOtp.Where(m => m.Nmrid == nmrid).Select(m => m.SstockotpId).ToArray(); int[] validItems = _context.TlkpSstock.Where(m => m.Active.Equals(true) && m.OPDSAMZarib > 0 && !selectedItems.Contains(m.SstockId)).Select(m => m.SstockId).ToArray(); foreach (int id in validItems) { TblStockOtp Item = new TblStockOtp(); Item.Nmrid = nmrid; Item.UserName = user; Item.SstockotpId = id; _context.TblStockOtp.Add(Item); } _context.SaveChanges(); return(Ok()); }
public IActionResult Create(string nmrid) { if (nmrid == null) { return(NotFound()); } var nmr = _context.Nmr.SingleOrDefault(m => m.Nmrid == nmrid); if (nmr == null) { return(NotFound()); } var user = User.Identity.Name; if (nmr.UserName != user) { return(Unauthorized()); } int[] selected = _context.TblMam.Where(m => m.Nmrid == nmrid).Select(m => m.Mamid).ToArray(); int[] valid = _context.TlkpSfp.Where(m => m.Active.Equals(true) && !m.AgeGroup.ToLower().Contains("total") && !selected.Contains(m.Sfpid)).Select(m => m.Sfpid).ToArray(); foreach (var id in valid) { TblMam item = new TblMam(); item.Nmrid = nmrid; item.Mamid = id; item.UserName = user; _context.TblMam.Add(item); } int[] query = _context.TblFstock.Where(m => m.Nmrid == nmrid).Select(m => m.StockId).ToArray(); int[] model = _context.TlkpFstock.Where(m => m.Active.Equals(true) && !query.Contains(m.StockId)).Select(m => m.StockId).ToArray(); foreach (var id in model) { TblFstock item = new TblFstock(); item.Nmrid = nmrid; item.StockId = id; item.UserName = user; _context.TblFstock.Add(item); } _context.SaveChanges(); return(Ok()); }
public IActionResult Create(string nmrid) { if (nmrid == null) { return(NotFound()); } var nmr = _context.Nmr.SingleOrDefault(m => m.Nmrid == nmrid); if (nmr == null) { return(NotFound()); } var user = User.Identity.Name; if (nmr.UserName != user) { return(Unauthorized()); } int[] query = _context.TblOtptfu.Where(m => m.Nmrid == nmrid).Select(m => m.Otptfuid).ToArray(); int[] model = _context.TlkpOtptfu.Where(m => m.Active.Equals(true) && !m.AgeGroup.ToLower().Contains("total") && !query.Contains(m.Otptfuid)).Select(m => m.Otptfuid).ToArray(); foreach (int a in model) { TblOtptfu Item = new TblOtptfu(); Item.Nmrid = nmrid; Item.Otptfuid = a; Item.UserName = user; _context.TblOtptfu.Add(Item); } int[] query2 = _context.TblStockIpt.Where(m => m.Nmrid == nmrid).Select(m => m.SstockId).ToArray(); int[] stock = _context.TlkpSstock.Where(m => m.Active.Equals(true) && m.IPDSAMZarib > 0 && !query2.Contains(m.SstockId)).Select(m => m.SstockId).ToArray(); foreach (int a in stock) { TblStockIpt Item = new TblStockIpt(); Item.Nmrid = nmrid; Item.SstockId = a; Item.UserName = user; _context.TblStockIpt.Add(Item); } _context.SaveChanges(); return(Ok()); }
public IActionResult Create(string nmrid) { if (nmrid == null) { return(BadRequest()); } int[] query = _context.TblIycf.Where(m => m.Nmrid == nmrid).Select(m => m.Iycfid).ToArray(); int[] model = _context.TlkpIycf.Where(m => m.Active.Equals(true) && !query.Contains(m.Iycfid)).Select(m => m.Iycfid).ToArray(); var user = User.Identity.Name; foreach (int id in model) { TblIycf item = new TblIycf(); item.UserName = user; item.Nmrid = nmrid; item.Iycfid = id; _context.TblIycf.Add(item); } _context.SaveChanges(); return(NoContent()); }
public async static void Initialize(WebNutContext db, RoleManager <IdentityRole> _roleManager, UserManager <ApplicationUser> _userManager) { db.Database.EnsureCreated(); // Look for any students. if (db.TblkpStatus.Any() || db.LkpHfstatus.Any() || _roleManager.Roles.Any() || _userManager.Users.Any()) { return; // DB has been seeded } var stats = new TblkpStatus[] { new TblkpStatus { StatusId = 1, StatusDescription = "Insert" }, new TblkpStatus { StatusId = 2, StatusDescription = "Update" }, new TblkpStatus { StatusId = 3, StatusDescription = "Accept" }, new TblkpStatus { StatusId = 4, StatusDescription = "Reject" }, }; foreach (TblkpStatus s in stats) { db.TblkpStatus.Add(s); } db.SaveChanges(); var hfstats = new LkpHfstatus[] { new LkpHfstatus { HfactiveStatusId = 1, HfstatusDescription = "Open" }, new LkpHfstatus { HfactiveStatusId = 2, HfstatusDescription = "Close" }, new LkpHfstatus { HfactiveStatusId = 3, HfstatusDescription = "Closed-no supply" }, new LkpHfstatus { HfactiveStatusId = 4, HfstatusDescription = "Closed-Security" }, }; foreach (LkpHfstatus s in hfstats) { db.LkpHfstatus.Add(s); } db.SaveChanges(); var AgeGroups = new TlkpOtptfu[] { new TlkpOtptfu { Active = true, AgeGroup = "<6 month" }, new TlkpOtptfu { Active = true, AgeGroup = "6-23 Months" }, new TlkpOtptfu { Active = true, AgeGroup = "24-59 Months" }, new TlkpOtptfu { Active = true, AgeGroup = "total" }, }; foreach (TlkpOtptfu s in AgeGroups) { db.TlkpOtptfu.Add(s); } db.SaveChanges(); var MamAgeGroups = new TlkpSfp[] { new TlkpSfp { Active = true, AgeGroup = "Children 6-23 months" }, new TlkpSfp { Active = true, AgeGroup = "Children 24-59 months" }, new TlkpSfp { Active = true, AgeGroup = "Lactating women" }, new TlkpSfp { Active = true, AgeGroup = "Pregnant women" }, new TlkpSfp { Active = true, AgeGroup = "total children" }, new TlkpSfp { Active = true, AgeGroup = "total women" }, }; foreach (TlkpSfp s in MamAgeGroups) { db.TlkpSfp.Add(s); } db.SaveChanges(); var mnItems = new TlkpMn[] { new TlkpMn { Mnid = 1, Active = true, Mnitems = "Vit A Capsule (200000,100000 or 50000IU)" }, new TlkpMn { Mnid = 2, Active = true, Mnitems = "IFA (60mg Iron, 400Micogram Folic) Tab" }, new TlkpMn { Mnid = 3, Active = true, Mnitems = "Ferrous Sulfate drop/syrop " }, new TlkpMn { Mnid = 4, Active = true, Mnitems = "Ferrous Sulfate 200mg(base 60mg)" }, new TlkpMn { Mnid = 5, Active = true, Mnitems = "Folic Acid 1 mg Tab" }, new TlkpMn { Mnid = 6, Active = true, Mnitems = "Multiple Micronutrients Tablet" }, new TlkpMn { Mnid = 7, Active = true, Mnitems = "Multiple Micronutrients Powder" }, new TlkpMn { Mnid = 8, Active = true, Mnitems = "Zinc Tab or Syrup/Drop + ORS" }, new TlkpMn { Mnid = 9, Active = true, Mnitems = "Mebendasol Tab" }, }; foreach (TlkpMn s in mnItems) { db.TlkpMn.Add(s); } db.SaveChanges(); IdentityRole Role = new IdentityRole(); Role.NormalizedName = "ADMINISTRATOR"; Role.Name = "administrator"; await _roleManager.CreateAsync(Role); IdentityRole Role2 = new IdentityRole(); Role2.NormalizedName = "DATAENTRY"; Role2.Name = "dataentry"; await _roleManager.CreateAsync(Role2); IdentityRole Role3 = new IdentityRole(); Role3.NormalizedName = "GUEST"; Role3.Name = "guest"; await _roleManager.CreateAsync(Role3); var user = new ApplicationUser { UserName = "******", PhoneNumber = "99999999", FirstName = "admin", LastName = "admin", Email = "*****@*****.**", Position = "admin", Active = true, TenantId = 1 }; var result = await _userManager.CreateAsync(user, "159*951-Aa"); if (result.Succeeded) { await _userManager.AddClaimAsync(user, new System.Security.Claims.Claim("super_admin", "1")); await _userManager.AddToRoleAsync(user, "administrator"); } }