public ActionResult Edit([Bind(Include = "ID,Title,Surname,Firstname,Middlename,Previousname,DateOfBirth,PlaceOfBirth,Nationality,CountryOfResidence,Address1,Address2,Address3")] cIndividual cIndividual)
{
if (ModelState.IsValid)
{
db.Entry(cIndividual).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID = new SelectList(db.CDD_Details, "ID", "CDDContact_Name", cIndividual.ID);
return(View(cIndividual));
}
public ActionResult Create([Bind(Include = "ID,Description,OfficeID,Team,ResponsiblePartner,MatterManager,Sec_PA,Advice_Provided_Without_CDD")] cMatter cMatter)
{
if (ModelState.IsValid)
{
db.Matters.Add(cMatter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OfficeID = new SelectList(db.Offices, "ID", "OfficeCode", cMatter.OfficeID);
return(View(cMatter));
}
public ActionResult Create([Bind(Include = "ID,registeredName,tradingName,keyClient,organisationType,Address1,Address2,Address3")] cOrganisation cOrganisation)
{
if (ModelState.IsValid)
{
db.Entities.Add(cOrganisation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID = new SelectList(db.CDD_Details, "ID", "CDDContact_Name", cOrganisation.ID);
return(View(cOrganisation));
}
public ActionResult Create([Bind(Include = "ID,eRelType,nEntityA_ID,nEntityB_ID")] EntityRelationshipViewModel vm)
{
cEntityRelationship e = new cEntityRelationship();
if (ModelState.IsValid)
{
e.entityA = db.Entities.Find(vm.nEntityA_ID);
e.entityB = db.Entities.Find(vm.nEntityB_ID);
e.relType = vm.eRelType;
db.Relationships.Add(e);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Create"));
//return View();
}
public ActionResult Create([Bind(Include = "ID,CDDContact_Name,CDDContact_TelNo,CDDContact_Email,ComplianceSignOff_Name,ComplianceSignOff_Date,CDDStatus")] cEntity cEntity)
{
try
{
if (ModelState.IsValid)
{
db.Entities.Add(cEntity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (RetryLimitExceededException /* dex */)
{
//Log the error (uncomment dex variable name and add a line here to write a log.)
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
}
return(View(cEntity));
}
public void CreateNewIndividual(cIndividual individualToCreate)
{
_db.Individuals.Add(individualToCreate);
_db.SaveChanges();
// return contactToCreate;
}
private void Seed(EntitiesDBContext dbContext)
{
if (dbContext.Set <Asset>().Count() == 0)
{
var timeseriesMetadata1 = new TimeseriesMetadata
{
Source = "Seed",
Id = "1",
Name = "ABC123",
Description = "Some tag",
Units = "Pa"
};
var timeseriesMetadata2 = new TimeseriesMetadata
{
Source = "Seed",
Id = "2",
Name = "ABC234",
Description = "Some other tag",
Units = "Pa"
};
dbContext.Set <TimeseriesMetadata>().Add(timeseriesMetadata1);
dbContext.Set <TimeseriesMetadata>().Add(timeseriesMetadata2);
dbContext.Set <TimeseriesMetadata>().Add(new TimeseriesMetadata
{
Source = "Seed",
Id = "3",
Name = "Orphan"
});
dbContext.Set <TimeseriesMetadata>().Add(new TimeseriesMetadata
{
Source = "Seed",
Id = "4",
Name = "Parent",
Children = new List <TimeseriesMetadata>
{
new TimeseriesMetadata
{
Source = "Seed",
Id = "5",
Name = "Child"
}
}
});
dbContext.Set <Entities.EventInfo>()
.Add(new Entities.EventInfo
{
Id = "1",
Source = "Seed",
Time = DateTime.Now,
Name = "Type"
});
dbContext.Set <Entities.EventInfo>()
.Add(new Entities.EventInfo
{
Id = "2",
Source = "Seed",
Time = DateTime.Now,
Name = "Type"
});
var file1 = new Entities.FileInfo
{
Source = "Seed",
Id = "1",
Format = "CSV",
Filename = "ABC123.CSV"
};
dbContext.Set <Entities.FileInfo>().Add(file1);
var file2 = new Entities.FileInfo
{
Source = "Seed",
Id = "2",
Format = "CSV",
Filename = "ABC124.CSV"
};
dbContext.Set <Entities.FileInfo>().Add(file2);
dbContext.Set <Asset>().Add(
new Asset
{
Source = "Seed",
Id = "1",
Tag = "Site 1",
Description = "Site 1",
Files = new List <Entities.FileInfo> {
file1
},
Tags = new List <AssetTag>
{
new AssetTag
{
Source = "Seed",
Id = "1",
Name = "key1",
Value = "value1"
},
new AssetTag
{
Source = "Seed",
Id = "2",
Name = "key2",
Value = "value3"
}
},
TimeSeries = new List <TimeseriesMetadata> {
timeseriesMetadata1
},
Children = new List <Asset>
{
new Asset
{
Source = "Seed",
Id = "2",
Description = "Drilling equipment and systems",
Tag = "3",
Children = new List <Asset>
{
new Asset
{
Source = "Seed",
Id = "3",
Description = "Mud supply",
Tag = "325",
Children = new List <Asset>
{
new Asset
{
Source = "Seed",
Id = "4",
Tag = "325-G1",
Description = "Mud pump no.1",
Manufacturer = "Some producer",
SerialNumber = "1234568790",
TimeSeries = new List <TimeseriesMetadata> {
timeseriesMetadata1
}
},
new Asset
{
Source = "Seed",
Id = "5",
Description = "Mud pump no.2",
Tag = "325-G2",
Manufacturer = "Some other producer",
SerialNumber = "0987654321",
TimeSeries = new List <TimeseriesMetadata> {
timeseriesMetadata2
},
}
}
}
}
}
}
});
}
dbContext.SaveChanges();
}