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");
}
}
