public IActionResult CreateUser(User newUser)
{
try
{
if (ModelState.IsValid)
{
var obj = _context.User.Where(x => x.UserLogin == newUser.UserLogin).FirstOrDefault();
if (obj != null)
{
ViewBag.UserLogin = "******";
return(View("CreateUser"));
}
User user = new User();
user.UserLogin = newUser.UserLogin;
user.FirstName = newUser.FirstName;
user.LastName = newUser.LastName;
user.EmailAddress = newUser.EmailAddress;
var encryptedPassword = EncodePasswordToBase64(newUser.Password);
user.Password = encryptedPassword;
user.IsAdmin = newUser.IsAdmin;
user.IsDeleted = false;
user.IsInactive = newUser.IsInactive;
user.IsInactive = newUser.IsInactive;
user.CreatedBy = newUser.CreatedBy; // int.Parse(HttpContext.Session.GetString("UserID"));
user.ModifiedBy = newUser.ModifiedBy; //int.Parse(HttpContext.Session.GetString("UserID"));
_context.User.Add(user);
_context.SaveChanges();
return(RedirectToAction("GetAllUsers", "Account"));
}
else
{
return(View());
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Delete(int id)
{
try
{
_context = new VisitorManagementContext();
var deletedUser = _context.User.FirstOrDefault(x => x.UserID == id);
if (deletedUser != null)
{
deletedUser.IsDeleted = true;
_context.SaveChanges();
}
return(Json(deletedUser));
}
catch (Exception)
{
//throw ex;
return(Json(false));
}
}
//Delete
public bool DeleteVisitor(int visitDetailId)
{
context = new VisitorManagementContext();
try
{
//visitDetail = context.VisitDetail.Find(visitDetailId);
//if (visitDetail != null)
//{
// visitDetail.IsDeleted = true;
// context.VisitDetail.Update(visitDetail);
// context.SaveChanges();
context = new VisitorManagementContext();
var vd = context.VisitDetail.FirstOrDefault(x => x.VisitDetailId == visitDetailId);
if (vd != null)
{
vd.IsDeleted = true;
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public VisitViewModel UpdateVisitor(VisitViewModel updatedModel)
{
try
{
var visitor = context.Visitor.Where(c => c.VisitorId == updatedModel.visit.VisitorId).FirstOrDefault();
visitor.VisitorId = updatedModel.visit.VisitorId;
visitor.VisitorName = updatedModel.VisitorName;
visitor.Company = updatedModel.Company;
visitor.Designation = updatedModel.Designation;
visitor.EmailAddress = updatedModel.EmailAddress;
visitor.Phone = updatedModel.Phone;
//visitor.PhotoUrl = updatedModel.PhotoUrl.TrimStart().TrimEnd();
context.Visitor.Update(visitor);
context.SaveChanges();
var visitorDetails = context.VisitDetail.Where(c => c.VisitDetailId == updatedModel.visitDetails.VisitDetailId).FirstOrDefault();
visitorDetails.VisitorId = visitor.VisitorId;
DateTime visitDate = updatedModel.VisitingDate;
DateTime startTime = updatedModel.StartTime;
DateTime endTime = updatedModel.EndTime;
visitorDetails.StartTime = visitDate.Date.Add(startTime.TimeOfDay);
visitorDetails.EndTime = visitDate.Date.Add(endTime.TimeOfDay);
context.VisitDetail.Update(visitorDetails);
context.SaveChanges();
VisitParticipant participant = new VisitParticipant();
var visitoPrimaryParticipants = context.VisitParticipant.Where(c => c.VisitDetailId == visitorDetails.VisitDetailId && c.IsPrimary == true).FirstOrDefault();
if (visitoPrimaryParticipants == null)
{
visitoPrimaryParticipants = new VisitParticipant();
visitoPrimaryParticipants.VisitDetailId = visitorDetails.VisitDetailId;
visitoPrimaryParticipants.ParticipantId = updatedModel.PrimaryParticipant;
visitoPrimaryParticipants.IsPrimary = true;
context.VisitParticipant.Add(visitoPrimaryParticipants);
context.SaveChanges();
}
else
{
visitoPrimaryParticipants.VisitDetailId = visitorDetails.VisitDetailId;
visitoPrimaryParticipants.ParticipantId = updatedModel.PrimaryParticipant;
visitoPrimaryParticipants.IsPrimary = true;
context.VisitParticipant.Update(visitoPrimaryParticipants);
context.SaveChanges();
}
var visitorSecondaryParticipants = context.VisitParticipant.Where(c => c.VisitDetailId == visitorDetails.VisitDetailId && c.IsPrimary == false).ToList();
if (visitorSecondaryParticipants != null)
{
foreach (var item in visitorSecondaryParticipants)
{
context.VisitParticipant.Remove(item);
}
}
if (updatedModel.SecondaryParticipant != null)
{
foreach (var item in updatedModel.SecondaryParticipant)
{
participant = new VisitParticipant();
participant.VisitDetailId = visitorDetails.VisitDetailId;
participant.ParticipantId = item;
participant.IsPrimary = false;
context.VisitParticipant.Add(participant);
}
context.SaveChanges();
}
var existingarrangments = context.VisitArrangement.Where(m => m.VisitDetailId == visitorDetails.VisitDetailId).ToList();
foreach (var item in existingarrangments)
{
context.VisitArrangement.Remove(item);
}
context.SaveChanges();
foreach (var item in updatedModel.VisitArrangement.Where(r => r.IsSelected == true))
{
VisitViewModel visitViewModel = new VisitViewModel();
VisitArrangement visitArrangement = new VisitArrangement();
visitArrangement.ArrangementId = item.ArrangementId;
visitArrangement.VisitDetailId = visitorDetails.VisitDetailId;
visitArrangement.DelegateContactId = item.DelegateContactID;
visitArrangement.Description = item.Description;
context.VisitArrangement.Add(visitArrangement);
}
context.SaveChanges();
return(updatedModel);
}
catch (Exception ex)
{
throw ex;
}
}
public VisitViewModel AddVisitor(VisitViewModel vmodel)
{
context = new VisitorManagementContext();
try
{
Visitor visitor = new Visitor();
var existingvisitor = context.Visitor.Where(r => r.VisitorName.ToUpper() == vmodel.VisitorName.ToUpper() && r.Designation.ToUpper() == vmodel.Designation.ToUpper() && r.Company.ToUpper() == vmodel.Company.ToUpper() && r.EmailAddress.ToUpper() == vmodel.EmailAddress.ToUpper() && r.Phone.ToUpper() == vmodel.Phone.ToUpper());
if (existingvisitor.Count() > 0)
{
visitor.VisitorId = existingvisitor.LastOrDefault().VisitorId;
}
else
{
visitor.VisitorName = vmodel.VisitorName;
visitor.Designation = vmodel.Designation;
visitor.Company = vmodel.Company;
visitor.EmailAddress = vmodel.EmailAddress;
visitor.Phone = vmodel.Phone;
visitor.CreatedBy = vmodel.CreatedBy;
context.Visitor.Add(visitor);
context.SaveChanges();
}
VisitDetail visitDetail = new VisitDetail();
visitDetail.VisitorId = visitor.VisitorId;
DateTime visitDate = vmodel.VisitingDate;
DateTime startTime = vmodel.StartTime;
DateTime endTime = vmodel.EndTime;
visitDetail.StartTime = visitDate.Date.Add(startTime.TimeOfDay);
visitDetail.EndTime = visitDate.Date.Add(endTime.TimeOfDay);
visitDetail.CreatedBy = vmodel.CreatedBy;
context.VisitDetail.Add(visitDetail);
context.SaveChanges();
VisitParticipant participant = new VisitParticipant();
participant.VisitDetailId = visitDetail.VisitDetailId;
participant.ParticipantId = vmodel.PrimaryParticipant;
participant.IsPrimary = true;
context.VisitParticipant.Add(participant);
context.SaveChanges();
if (vmodel.SecondaryParticipant != null)
{
foreach (var item in vmodel.SecondaryParticipant)
{
participant = new VisitParticipant();
participant.VisitDetailId = visitDetail.VisitDetailId;
participant.ParticipantId = item;
participant.IsPrimary = false;
context.VisitParticipant.Add(participant);
}
context.SaveChanges();
}
//
foreach (var item in vmodel.VisitArrangement.Where(r => r.IsSelected == true))
{
VisitArrangement visitArrangement = new VisitArrangement();
visitArrangement.ArrangementId = item.ArrangementId;
visitArrangement.VisitDetailId = visitDetail.VisitDetailId;
visitArrangement.DelegateContactId = item.DelegateContactID;
visitArrangement.Description = item.Description;
context.VisitArrangement.Add(visitArrangement);
}
context.SaveChanges();
return(vmodel);
}
catch (Exception ex)
{
throw ex;
}
}
