public async Task <IActionResult> ProcessAfteBulkEntry()
{
var cards = _context.IdentityCards.ToList().Where(c => c.CardNumber == null);
var identitycardInfo = _context.IdentityCards.ToList().Where(c => c.CardNumber != null);
var lastcardNumber = identitycardInfo.LastOrDefault()?.CardNumber;
IdentityCardViewModel viewModel = new IdentityCardViewModel();
foreach (var card in cards)
{
card.CardNumber = viewModel.GetCardNumber(lastcardNumber);
card.CompanyName = "Interlink Technologies Ltd.";
card.CardInfo = "This card should be used by card holder only. If this card is found ownerless, please, return" +
"it to the issuing authority. This card is not transferable to anybody.";
card.CompanyAddress = "Office No. 801 (7th Floor) 1205, 185 Sonargaon Road, Dhaka";
card.CompanyLogoPath = "";
card.ImagePathOfAuthorizedSignature = "";
_context.Update(card);
var save = await _context.SaveChangesAsync();
lastcardNumber = viewModel.GetCardNumber(lastcardNumber);
ViewBag.Info = "Process Completed";
}
return(View("Excel"));
}
public async Task <IActionResult> ExpiredUserCards()
{
var identityCards = await _context.IdentityCards.Where(c => c.ValidationEndDate < DateTime.Now)
.Include(c => c.BloodGroup)
.Include(c => c.Designation).ToListAsync();
IdentityCardViewModel model = new IdentityCardViewModel();
model.IdentityCards = identityCards;
ViewBag.Title = "Expired Card Users";
return(View("ValidatedUsers", model));
}
public async Task <IActionResult> CardEdit(int id, [Bind("Id,CardCategoryId,Name,DesignationId,Department,BloodGroupId,CardNumber,DateOfBirth,ImagePathOfUser,ImagePathOfUserSignature,ImagePathOfAuthorizedSignature,CompanyName,CompanyAddress,CompanyLogoPath,CardInfo,ValidationStartDate,ValidationEndDate,IssueDate")] IdentityCardViewModel viewModel)
{
if (id != viewModel.IdentityCard.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
IdentityCard identityCard = new IdentityCard();
viewModel.IdentityCard.CardCategoryId = identityCard.CardCategoryId;
viewModel.IdentityCard.Name = identityCard.Name;
viewModel.IdentityCard.DesignationId = identityCard.DesignationId;
viewModel.IdentityCard.Department = identityCard.Department;
viewModel.IdentityCard.BloodGroupId = identityCard.BloodGroupId;
viewModel.IdentityCard.CardNumber = identityCard.CardNumber;
viewModel.IdentityCard.DateOfBirth = identityCard.DateOfBirth;
viewModel.IdentityCard.ImagePathOfUser = identityCard.ImagePathOfUser;
viewModel.IdentityCard.ImagePathOfUserSignature = identityCard.ImagePathOfUserSignature;
viewModel.IdentityCard.ImagePathOfAuthorizedSignature = identityCard.ImagePathOfAuthorizedSignature;
viewModel.IdentityCard.CompanyName = identityCard.CompanyName;
viewModel.IdentityCard.CompanyAddress = identityCard.CompanyAddress;
viewModel.IdentityCard.CompanyLogoPath = identityCard.CompanyLogoPath;
viewModel.IdentityCard.CardInfo = identityCard.CardInfo;
viewModel.IdentityCard.ValidationStartDate = identityCard.ValidationStartDate;
viewModel.IdentityCard.ValidationEndDate = identityCard.ValidationEndDate;
_context.Update(viewModel.IdentityCard);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IdentityCardExists(viewModel.IdentityCard.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CardCategoryId"] = new SelectList(_context.CardCategories, "Id", "Id", viewModel.IdentityCard.CardCategoryId);
ViewData["DesignationId"] = new SelectList(_context.Designations, "Id", "Id", viewModel.IdentityCard.DesignationId);
return(View(viewModel));
}
public async Task <IActionResult> UserRequestForCard()
{
var identityCards = await _context.IdentityCards.Where(c => c.ValidationEndDate == null)
.Include(c => c.BloodGroup)
.Include(c => c.Designation).ToListAsync();
IdentityCardViewModel model = new IdentityCardViewModel();
model.IdentityCards = identityCards;
ViewBag.Title = "Users Requested For Card ";
return(View("ValidatedUsers", model));
}
public async Task <IActionResult> Index()
{
var identityCards = await _context.IdentityCards
.Include(c => c.BloodGroup)
.Include(c => c.Designation).ToListAsync();
IdentityCardViewModel model = new IdentityCardViewModel
{
IdentityCards = identityCards
};
ViewBag.Message = TempData["Message"];
return(View(model));
}
public IActionResult Create()
{
IdentityCardViewModel model = new IdentityCardViewModel();
ViewData["BloodGroups"] = new SelectList(_context.BloodGroups, "Id", "Name");
ViewData["Designations"] = new SelectList(_context.Designations, "Id", "Title");
ViewData["Departments"] = new SelectList(_context.Departments, "Id", "Name");
ViewData["CardCategories"] = new SelectList(_context.CardCategories, "Id", "CategoryName");
var identitycardInfo = _context.IdentityCards.ToList();
var cardNumber = identitycardInfo.LastOrDefault()?.CardNumber;
model.CardNumber = model.GetCardNumber(cardNumber);
return(View(model));
}
public async Task <IActionResult> CardEdit(int?id)
{
if (id == null)
{
return(NotFound());
}
IdentityCardViewModel viewModel = new IdentityCardViewModel();
viewModel.IdentityCard = await _context.IdentityCards.FindAsync(id);
if (viewModel.IdentityCard == null)
{
return(NotFound());
}
ViewData["BloodGroupId"] = new SelectList(_context.BloodGroups, "Id", "Id", viewModel.IdentityCard.BloodGroupId);
ViewData["CardCategoryId"] = new SelectList(_context.CardCategories, "Id", "Id", viewModel.IdentityCard.CardCategoryId);
ViewData["DesignationId"] = new SelectList(_context.Designations, "Id", "Id", viewModel.IdentityCard.DesignationId);
return(View(viewModel));
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var identityCard = await _context.IdentityCards.Include(c => c.BloodGroup)
.Include(c => c.Designation)
.FirstOrDefaultAsync(m => m.Id == id);
IdentityCardViewModel model = new IdentityCardViewModel();
model.IdentityCard = identityCard;
if (identityCard == null)
{
return(NotFound());
}
return(View(model));
}
public async Task <IActionResult> Create(IdentityCardViewModel identityCardViewModel)
{
ViewData["BloodGroups"] = new SelectList(_context.BloodGroups, "Id", "Name");
ViewData["Designations"] = new SelectList(_context.Designations, "Id", "Title");
ViewData["Departments"] = new SelectList(_context.Departments, "Id", "Name");
ViewData["CardCategories"] = new SelectList(_context.CardCategories, "Id", "CategoryName");
if (identityCardViewModel.DateOfBirth > DateTime.Now)
{
ModelState.AddModelError("DateOfBirth", "Date of birth is not valid");
}
if (ModelState.IsValid)
{
//string uniqueFileName = null;
//string uniqueFileNameSignature = null;
//string uniqueFileNameAuthorizedSignature = null;
//string uniqueFileNameCompanyLogo = null;
//if (identityCardViewModel.ImagePathOfUser != null && identityCardViewModel.ImagePathOfUserSignature != null)
//{
// string uplaodsFolder = Path.Combine(_webHostEnvironment.WebRootPath, "image/user/");
// uniqueFileName = Guid.NewGuid().ToString() + "_" + identityCardViewModel.ImagePathOfUser.FileName;
// filePath = Path.Combine(uplaodsFolder, uniqueFileName);
// string uplaodsFolderSignature = Path.Combine(_webHostEnvironment.WebRootPath, "image/sig/");
// uniqueFileNameSignature = Guid.NewGuid().ToString() + "_" + identityCardViewModel.ImagePathOfUserSignature.FileName;
// filePathSignature = Path.Combine(uplaodsFolderSignature, uniqueFileNameSignature);
// string uplaodsFolderAuthSignature = Path.Combine(_webHostEnvironment.WebRootPath, "image/auth/");
// uniqueFileNameAuthorizedSignature = "9536f8a1-d3ad-41b6-8448-e748bb33f589_authsign.jpg";
// string uplaodsFolderLogo = Path.Combine(_webHostEnvironment.WebRootPath, "image/logo/");
// uniqueFileNameCompanyLogo = "68837796-1410-4966-a0bb-562e4b44c854_Logo.jpg";
// using (var stream = new FileStream(filePath, FileMode.Create))
// {
// identityCardViewModel.ImagePathOfUser.CopyTo(stream);
// }
// using (var stream = new FileStream(filePathSignature, FileMode.Create))
// {
// identityCardViewModel.ImagePathOfUserSignature.CopyTo(stream);
// }
//}
identityCardViewModel.IdentityCard.Name = identityCardViewModel.Name;
identityCardViewModel.IdentityCard.DesignationId = identityCardViewModel.DesignationId;
identityCardViewModel.IdentityCard.Department = identityCardViewModel.Department;
identityCardViewModel.IdentityCard.CardCategoryId = identityCardViewModel.CardCategoryId;
identityCardViewModel.IdentityCard.BloodGroupId = identityCardViewModel.BloodGroupId;
identityCardViewModel.IdentityCard.CardNumber = identityCardViewModel.CardNumber;
identityCardViewModel.IdentityCard.DateOfBirth = identityCardViewModel.DateOfBirth;
//identityCardViewModel.IdentityCard.ImagePathOfUser = uniqueFileName;
//identityCardViewModel.IdentityCard.ImagePathOfUserSignature = uniqueFileNameSignature;
//identityCardViewModel.IdentityCard.ImagePathOfAuthorizedSignature = uniqueFileNameAuthorizedSignature;
//identityCardViewModel.IdentityCard.CompanyLogoPath = uniqueFileNameCompanyLogo;
_context.Add(identityCardViewModel.IdentityCard);
var saved = await _context.SaveChangesAsync();
if (saved > 0)
{
TempData["Message"] = "Saved Successfully";
}
return(RedirectToAction(nameof(Index)));
}
return(View(identityCardViewModel));
}
