public ActionResult Create(int orgID)
{
try
{
OrganisationContactModel editModel = new OrganisationContactModel();
sw.Organisation member = swdb.Organisation.Where(x => x.Id == orgID).FirstOrDefault();
if (member == null)
{
return(HttpNotFound());
}
sw.ContactInfo memberBeneficiary = new sw.ContactInfo()
{
OrgID = member.Id
};
editModel.org = member;
editModel.contactInfo = memberBeneficiary;
//editModel.addressType = new SelectList(swdb.AddressType, "ID", "Name").ToList();
return(View(editModel));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", new { orgID = orgID }));
}
}
public ActionResult Edit(OrganisationContactModel editModel)
{
sw.ContactInfo memberBeneficiary = editModel.contactInfo;
try
{
if (ModelState.IsValid)
{
memberBeneficiary.ModifiedBy = User.Identity.Name;
memberBeneficiary.ModifiedDate = DateTime.Now;
swdb.ContactInfo.Attach(memberBeneficiary);
swdb.Entry(memberBeneficiary).State = EntityState.Modified;
//swdb.ObjectStateManager.ChangeObjectState(memberBeneficiary, EntityState.Modified);
swdb.SaveChanges();
TempData["message"] = "<b>" + memberBeneficiary.FirstName + "</b> was Successfully Updated";
return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID }));
}
// editModel.addressType = new SelectList(swdb.AddressType, "ID", "Name", memberBeneficiary.AddressTypeId).ToList();
return(View(editModel));
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID }));
}
}
public ActionResult Edit(int ID)
{
try
{
OrganisationContactModel editModel = new OrganisationContactModel();
sw.ContactInfo memberBeneficiary = swdb.ContactInfo.Where(x => x.Id == ID).FirstOrDefault();
if (memberBeneficiary == null)
{
return(HttpNotFound());
}
sw.Organisation member = swdb.Organisation.Where(x => x.Id == memberBeneficiary.OrgID).FirstOrDefault();
editModel.org = member;
editModel.contactInfo = memberBeneficiary;
return(View(editModel));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public ActionResult Create(OrganisationContactModel editModel)
{
sw.ContactInfo memberBeneficiary = editModel.contactInfo;
try
{
if (ModelState.IsValid)
{
memberBeneficiary.ModifiedBy = User.Identity.Name;
memberBeneficiary.ModifiedDate = DateTime.Now;
swdb.ContactInfo.Add(memberBeneficiary);
swdb.SaveChanges();
TempData["message"] = "<b>" + memberBeneficiary.FirstName + "</b> was Successfully Saved";
return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID }));
}
sw.Organisation member = swdb.Organisation.Where(x => x.Id == editModel.contactInfo.OrgID).FirstOrDefault();
editModel.org = member;
//editModel.addressType = new SelectList(swdb.AddressType, "ID", "Name").ToList();
return(View(editModel));
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID }));
}
}
public static void InsertRecord(OrganisationContactModel organisationContact)
{
var sql =
"INSERT INTO [dbo].[Contacts] ([Id],[DisplayName],[Email],[EndPointAssessorOrganisationId] ,[OrganisationId],[Status] ,[Username],[PhoneNumber], [CreatedAt])" +
" VALUES (@Id, @DisplayName, @Email, @EndPointAssessorOrganisationId, @organisationId, @Status, @Username, @PhoneNumber, getutcdate()); ";
DatabaseService.Execute(sql, organisationContact);
}
public ActionResult Index([DefaultValue(1)] int page, string keywords, [DefaultValue(12)] int pgsize, int orgID)
{
try
{
//var organisation = db.Organisation.Include("OrganisationType");
//return View(organisation.ToList());
sw.Organisation member = swdb.Organisation.Where(x => x.Id == orgID).FirstOrDefault();
if (member == null)
{
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home"));
}
List <sw.ContactInfo> rowsToShow = new List <sw.ContactInfo>();
int totalRecords = 0;
if (!string.IsNullOrEmpty(keywords))
{
rowsToShow = swdb.ContactInfo.Where(x => x.OrgID == orgID && (x.FirstName.ToUpper().Contains(keywords.Trim().ToUpper()) || x.LastName.ToUpper().Contains(keywords.Trim().ToUpper()))).OrderBy(x => x.Id).Skip((page - 1) * pgsize).Take(pgsize).ToList();
totalRecords = swdb.ContactInfo.Where(x => x.OrgID == orgID && (x.FirstName.ToUpper().Contains(keywords.Trim().ToUpper()) || x.LastName.ToUpper().Contains(keywords.Trim().ToUpper()))).Count();
}
else
{
rowsToShow = swdb.ContactInfo.Where(x => x.OrgID == orgID).OrderBy(x => x.Id).Skip((page - 1) * pgsize).Take(pgsize).ToList();
totalRecords = swdb.ContactInfo.Where(x => x.OrgID == orgID).Count();
}
OrganisationContactModel model = new OrganisationContactModel()
{
Rows = rowsToShow,
org = member,
PagingInfo = new PagingInfo
{
FirstItem = ((page - 1) * pgsize) + 1,
LastItem = page * pgsize,
CurrentPage = page,
ItemsPerPage = pgsize,
TotalItems = totalRecords
},
CurrentKeywords = keywords,
PageSize = pgsize
};
return(View(model));
}
catch (Exception ex)
{
// Log with Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
TempData["message"] = Settings.Default.GenericExceptionMessage;
return(RedirectToAction("Index", "Home", new { area = "Admin" }));
}
}
public void SetUpOrganisationTests()
{
_repository = new RegisterRepository(_databaseService.WebConfiguration, new Mock <ILogger <RegisterRepository> >().Object);
_validationRepository = new RegisterValidationRepository(_databaseService.WebConfiguration);
_organisationIdCreated = "EPA0987";
_organisationTypeId = 5;
OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
Id = _organisationTypeId, Status = "new", Type = "organisation type 1"
});
_id = Guid.NewGuid();
_organisation = new OrganisationModel
{
Id = _id,
CreatedAt = DateTime.Now,
EndPointAssessorName = "name 2",
EndPointAssessorOrganisationId = _organisationIdCreated,
PrimaryContact = null,
OrganisationTypeId = _organisationTypeId,
OrganisationData = null,
Status = OrganisationStatus.New
};
_username = "******";
OrganisationHandler.InsertRecord(_organisation);
_contactId = Guid.NewGuid();
_contactModel = new OrganisationContactModel
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
OrganisationId = _id,
Username = _username,
DisplayName = "Joe Cool",
Email = "*****@*****.**",
PhoneNumber = "555 55555",
Status = OrganisationStatus.Live
};
_contactBeforeChange = new EpaContact
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
Username = _username,
DisplayName = "Joe Cool",
Email = "*****@*****.**",
PhoneNumber = "555 55555",
Status = OrganisationStatus.Live
};
_contactUpdated = new EpaContact
{
Id = _contactId,
EndPointAssessorOrganisationId = _organisationIdCreated,
Username = _username,
DisplayName = "Joe Cool changes",
Email = "*****@*****.**",
PhoneNumber = "555 44444",
Status = OrganisationStatus.Live
};
OrganisationContactHandler.InsertRecord(_contactModel);
}
