public bool CheckCreateValues(PersonViewModelSave model, ref string validationMsg)
{
bool validate = true;
if (model.PersonNummer != String.Empty && !String.IsNullOrEmpty(model.ForNamn) && !String.IsNullOrEmpty(model.EfterNamn))
{
if (model.PersonNummer.Length < 4)
{
validate = false;
validationMsg += "Not a valid PersonNummer:";
}
if (model.ForNamn.Length < 2)
{
validate = false;
validationMsg += " Not a valid ForNamn:";
}
if (model.EfterNamn.Length < 2)
{
validate = false;
validationMsg += " Not a valid EfterNamn:";
}
//ToDO add more check and move out msg in text file..
}
else
{
validate = false;
}
return(validate);
}
public bool CreatePerson(PersonViewModelSave model, ref string errorMsg)
{
Person p = new Person();
//context.Person.Add(p);
return(true);
}
public void CheckCreateValuesTestNotMissing()
{
ValueUtils vu = new ValueUtils();
PersonValidation pv = new PersonValidation(vu);
String str = "";
PersonViewModelSave PVmodel = new PersonViewModelSave();
PVmodel.PersonNummer = "12345";
PVmodel.ForNamn = "Per";
PVmodel.EfterNamn = "Nilsson";
Assert.True(pv.CheckCreateValues(PVmodel, ref str));
}
public Response <PersonAdressViewModel> Create([FromBody] PersonViewModelSave model)
{
Response <PersonAdressViewModel> result = new Response <PersonAdressViewModel>();
if (model.PersonNummer != String.Empty && !String.IsNullOrEmpty(model.ForNamn) && !String.IsNullOrEmpty(model.EfterNamn))
{
result = backend.CreatePerson(model);
}
else
{
result.success = "false";
result.message = "Missing parameters, check: Id, Persnr, Fname, Lname, Username";
result.errorcode = 600;
}
return(result);
}
public void CheckCreateValuesTestNotValidPersnr()
{
ValueUtils vu = new ValueUtils();
PersonValidation pv = new PersonValidation(vu);
String str = "";
PersonViewModelSave PVmodel = new PersonViewModelSave();
PVmodel.PersonNummer = "12";
PVmodel.ForNamn = "Per";
PVmodel.EfterNamn = "Nilsson";
Assert.True(pv.CheckCreateValues(PVmodel, ref str) == false);
Assert.True(str == "Not a valid PersonNummer:");
}
public void CreateTest()
{
var options = CreateNewContextOptions();
// Run the test against one instance of the context
using (var context = new ModelDbContext(options))
{
PersonViewModelSave PVmodel = new PersonViewModelSave();
PVmodel.PersonNummer = "12345";
PVmodel.ForNamn = "Per";
PVmodel.EfterNamn = "Nilsson";
PersonCode pc = new PersonCode(context);
PersonCreateUpdateDeleteFake crudFake = new PersonCreateUpdateDeleteFake();
PersonController controller = new PersonController(context, crudFake);
var response = controller.Create(PVmodel);
Assert.True(response.success == "true");
}
}
public Response <PersonAdressViewModel> UpdatePerson(PersonViewModelSave model)
{
Response <PersonAdressViewModel> r = new Response <PersonAdressViewModel>();
string errorMsg = String.Empty;
if (crud.UpdatePerson(model, ref errorMsg))
{
long PersonNummer = Convert.ToInt64(model.PersonNummer);
r.success = "true";
r.message = "Person {persnr} updated";
r.result = pc.GetPersonByPersnr(PersonNummer, false);
r.total = r.result.Count();
}
else
{
r.success = "false";
r.message = "Error: " + errorMsg;
r.errorcode = 600;
}
return(r);
}
public bool UpdatePerson(PersonViewModelSave model, ref string errorMsg)
{
throw new NotImplementedException();
}
public Response <PersonAdressViewModel> CreatePerson(PersonViewModelSave model)
{
Response <PersonAdressViewModel> r = new Response <PersonAdressViewModel>();
string validationMsg = String.Empty;
string errorMsg = String.Empty;
bool isValidateOk = true;
try
{
//1. Check all parameters are ok
if (validate.CheckCreateValues(model, ref validationMsg))
{
if (crud.AllreadyExist(model.PersonNummer, ref validationMsg))
{
isValidateOk = false;
}
}
else
{
isValidateOk = false;
}
//2. Send them back to the create class if all is ok
if (isValidateOk)
{
if (crud.CreatePerson(model, ref errorMsg))
{
long PersonNummer = Convert.ToInt64(model.PersonNummer);
//if all is ok return the newly created person in the response
r.success = "true";
r.message = "all ok";
r.result = pc.GetPersonByPersnr(persnr: PersonNummer, workInformationOnly: false);
r.total = r.result.Count();
}
else
{
r.success = "false";
r.message = errorMsg;
r.total = 0;
}
}
else
{
r.success = "false";
r.message = "CheckCreateValues or allready exist error: " + validationMsg;
r.errorcode = 600;
}
}
catch (Exception e)
{
//Handle failure
r.success = "false";
r.message = e.Message;
r.total = 0;
}
return(r);
}
public bool CreatePerson(PersonViewModelSave model, ref string errorMsg)
{
//var transaction = db.Database.BeginTransaction();
try
{
var allreadyExist = (from p in db.Person
where p.PersonNummer == model.PersonNummer
select p.PersonNummer).FirstOrDefault();
if (String.IsNullOrEmpty(allreadyExist))
{
Person newPerson = new Person();
newPerson.Id = dbUtils.GetNewDbId("Person");
newPerson.PersonNummer = model.PersonNummer;
newPerson.ForNamn = model.ForNamn;
newPerson.MellanNamn = model.MellanNamn;
newPerson.EfterNamn = model.EfterNamn;
newPerson.SkapadDatum = DateTime.Now;
newPerson.UppdateradAv = model.UppdateradAvAlias;
db.Person.Add(newPerson);
db.SaveChanges();
//Get id
var dbPersonId = newPerson.Id;
//Save person type
//if (model.PersonAnnanPerson)
//{
// PersonAnnanPerson newAnnanPerson = new PersonAnnanPerson();
// newAnnanPerson.Id = dbUtils.GetNewDbId("PersonAnnanPerson");
// newAnnanPerson.PersonFkid = newPerson.Id;
// newAnnanPerson.AnnanPersonFkid = 9999;
// newAnnanPerson.SkapadDatum = DateTime.Now;
// newAnnanPerson.UpdateradAv = "mah";
// db.PersonAnnanPerson.Add(newAnnanPerson);
// db.SaveChanges();
//}
//if (model.PersonAnstalld)
//{
// PersonAnstalld newPersonAnstalld = new PersonAnstalld();
// newPersonAnstalld.PersonFkid = newPerson.Id;
// newPersonAnstalld.Id = dbUtils.GetNewDbId("PersonAnstalld");
// newPersonAnstalld.AnstalldFkid = 9999;
// newPersonAnstalld.SkapadDatum = DateTime.Now;
// newPersonAnstalld.UpdateradAv = "mah";
// db.PersonAnstalld.Add(newPersonAnstalld);
// db.SaveChanges();
//}
//if (model.PersonKonsult)
//{
// PersonKonsult newPersonKonsult = new PersonKonsult();
// newPersonKonsult.PersonFkid = newPerson.Id;
// newPersonKonsult.Id = dbUtils.GetNewDbId("PersonKonsult");
// newPersonKonsult.KonsultFkid = 9999;
// newPersonKonsult.UpdateradAv = "mah";
// newPersonKonsult.SkapadDatum = DateTime.Now;
// newPersonKonsult.UpdateradDatum = DateTime.Now;
// db.PersonKonsult.Add(newPersonKonsult);
// db.SaveChanges();
//}
//if (model.PersonPatient)
//{
// PersonPatient newPersonPatient = new PersonPatient();
// newPersonPatient.PersonFkid = newPerson.Id;
// newPersonPatient.Id = dbUtils.GetNewDbId("PersonPatient");
// newPersonPatient.PatientFkid = 9999;
// newPersonPatient.UpdateradAv = "mah";
// newPersonPatient.SkapadDatum = DateTime.Now;
// db.PersonPatient.Add(newPersonPatient);
// db.SaveChanges();
//}
//if (model.PersonSjukHalsovardsPersonal)
//{
// PersonSjukHalsovardsPersonal newPersonSjukHalsovardsPersonal = new PersonSjukHalsovardsPersonal();
// newPersonSjukHalsovardsPersonal.PersonFkid = newPerson.Id;
// newPersonSjukHalsovardsPersonal.Id = dbUtils.GetNewDbId("PersonSjukHalsovardsPersonal");
// newPersonSjukHalsovardsPersonal.SjukHalsovardsPersonalFkid = 9999;
// newPersonSjukHalsovardsPersonal.UpdateradAv = "mah";
// newPersonSjukHalsovardsPersonal.SkapadDatum = DateTime.Now;
// newPersonSjukHalsovardsPersonal.UpdateradDatum = DateTime.Now;
// db.PersonSjukHalsovardsPersonal.Add(newPersonSjukHalsovardsPersonal);
// db.SaveChanges();
//}
}
//transaction.Commit();
return(true);
}
catch (Exception e)
{
errorMsg = e.Message;
return(false);
}
}
public bool UpdatePerson(PersonViewModelSave model, ref string errorMsg)
{
using (db)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var personDb = (from p in db.Person
where p.Id == model.Id
select p).FirstOrDefault();
if (personDb != null)
{
//Update old
personDb.UppdateradDatum = DateTime.Now;
db.SaveChanges();
//create new
//model.Person.Id = dbUtils.GetNewDbId("Person");
//model.Person.SkapadDatum = DateTime.Now;
//model.Person.UppdateradDatum = DateTime.Now;
//model.Person.UppdateradAv = "mah";
//db.Person.Add(model.Person);
//db.SaveChanges();
Person person = new Person();
person.Id = dbUtils.GetNewDbId("Person");
person.ForNamn = model.ForNamn;
person.EfterNamn = model.EfterNamn;
//person.Username = model.Person.Username;
person.PersonNummer = model.PersonNummer;
person.SkapadDatum = DateTime.Now;
db.Person.Add(person);
db.SaveChanges();
}
////Save person type
//if (model.PersonAnnanPerson != null)
//{
// //Hämta och uppdatera
// var annanPersonDb = (from p in db.PersonAnnanPerson
// where p.Id == model.PersonAnnanPerson.Id
// select p).FirstOrDefault();
// if (annanPersonDb != null)
// {
// //update old
// annanPersonDb.UpdateradDatum = DateTime.Now;
// db.SaveChanges();
// //create new
// PersonAnnanPerson annanPers = new PersonAnnanPerson();
// annanPers.Id = dbUtils.GetNewDbId("PersonAnnanPerson");
// //annanPers.PersonFk =
// }
//}
//else if (model.PersonAnstalld != null)
//{
// //Hämta och uppdatera
// var anstalldPersonDb = (from p in db.PersonAnstalld
// where p.Id == model.PersonAnstalld.Id
// select p).FirstOrDefault();
// anstalldPersonDb.UpdateradDatum = DateTime.Now;
// db.SaveChanges();
//}
//else if (model.PersonKonsult != null)
//{
// //Hämta och uppdatera
// var konsultPersonDb = (from p in db.PersonKonsult
// where p.Id == model.PersonKonsult.Id
// select p).FirstOrDefault();
// konsultPersonDb.UpdateradDatum = DateTime.Now;
// db.SaveChanges();
//}
//else if (model.PersonPatient != null)
//{
// //Hämta och uppdatera
// var patientPersonDb = (from p in db.PersonPatient
// where p.Id == model.PersonPatient.Id
// select p).FirstOrDefault();
// patientPersonDb.UpdateradDatum = DateTime.Now;
// db.SaveChanges();
//}
//else if (model.PersonSjukHalsovardsPersonal != null)
//{
// //Hämta och uppdatera
// var HKPersonalPersonDb = (from p in db.PersonSjukHalsovardsPersonal
// where p.Id == model.PersonSjukHalsovardsPersonal.Id
// select p).FirstOrDefault();
// HKPersonalPersonDb.UpdateradDatum = DateTime.Now;
// db.SaveChanges();
//}
// Commit transaction if all commands succeed, transaction will auto-rollback
// when disposed if either commands fails
transaction.Commit();
return(true);
}
catch (Exception e)
{
errorMsg = e.Message;
return(false);
}
}
}
}
