public Guid InsertSource(SourceDto sourceAjaxDto)
{
var source = new Source
{
SourceDescription = sourceAjaxDto.SourceDesc,
OriginalLocation = sourceAjaxDto.OriginalLocation,
IsCopyHeld = sourceAjaxDto.IsCopyHeld,
IsViewed = sourceAjaxDto.IsViewed,
IsThackrayFound = sourceAjaxDto.IsThackrayFound,
UserId = 0,
SourceDate = sourceAjaxDto.SourceDateStr.ParseToValidYear(),
SourceDateTo = sourceAjaxDto.SourceDateStrTo.ParseToValidYear(),
SourceDateStr = sourceAjaxDto.SourceDateStr,
SourceDateStrTo = sourceAjaxDto.SourceDateStrTo,
SourceRef = sourceAjaxDto.SourceRef,
SourceFileCount = sourceAjaxDto.SourceFileCount,
SourceNotes = sourceAjaxDto.SourceNotes,
SourceId = (sourceAjaxDto.SourceId == Guid.Empty ? Guid.NewGuid() : sourceAjaxDto.SourceId ),
VirtualLocation = sourceAjaxDto.VirtualLocation,
DateAdded = DateTime.Today
};
using (var context = new GeneralModelContainer())
{
context.Sources.Add(source);
context.SaveChanges();
}
return source.SourceId;
}
public void UpdateSource(SourceDto sourceAjaxDto)
{
using (var context = new GeneralModelContainer())
{
var source = context.Sources.FirstOrDefault(o => o.SourceId == sourceAjaxDto.SourceId);
if (source == null) return;
source.SourceDescription = sourceAjaxDto.SourceDesc;
source.OriginalLocation = sourceAjaxDto.OriginalLocation;
source.IsCopyHeld = sourceAjaxDto.IsCopyHeld;
source.IsViewed = sourceAjaxDto.IsViewed;
source.IsThackrayFound = sourceAjaxDto.IsThackrayFound;
source.UserId = 1;
source.SourceDate = sourceAjaxDto.SourceDateStr.ParseToValidYear();
source.SourceDateTo = sourceAjaxDto.SourceDateStrTo.ParseToValidYear();
source.SourceDateStr = sourceAjaxDto.SourceDateStr;
source.SourceDateStrTo = sourceAjaxDto.SourceDateStrTo;
source.SourceRef = sourceAjaxDto.SourceRef;
source.SourceFileCount = sourceAjaxDto.SourceFileCount;
source.SourceNotes = sourceAjaxDto.SourceNotes;
source.VirtualLocation = (!string.IsNullOrEmpty(sourceAjaxDto.VirtualLocation)
? sourceAjaxDto.VirtualLocation
: source.VirtualLocation); // dont overwrite this unless we have a value
source.DateAdded = DateTime.Today;
context.SaveChanges();
}
}
public string AddSource(string sourceId,
string isCopyHeld,
string isThackrayFound,
string isViewed,
string originalLocation,
string sourceDesc,
string sourceRef,
string sourceNotes,
string sourceDateStr,
string sourceDateStrTo,
string sourceFileCount,
string parishs,
string sourceTypes,
string fileIds)
{
string retVal = "";
var jss = new JavaScriptSerializer();
var obj = jss.Deserialize<dynamic>(fileIds);
var tp = new List<ServiceFile>();
if (obj != null)
foreach (dynamic item in obj)
tp.Add(new ServiceFile(item["url"],item["desc"],item["id"]));
var ssobj = new SourceDto()
{
IsCopyHeld = isCopyHeld.ToBool(),
IsThackrayFound = isThackrayFound.ToBool(),
IsViewed = isViewed.ToBool(),
OriginalLocation = originalLocation,
SourceDateStr = sourceDateStr,
SourceDateStrTo = sourceDateStrTo,
SourceDesc = sourceDesc,
SourceRef = sourceRef,
SourceNotes = sourceNotes,
SourceFileCount = sourceFileCount.ToInt32(),
SourceId = sourceId.ToGuid() ,
Files = tp,
Parishs = parishs.ParseToGuidList(),
SourceTypes = sourceTypes.ParseToIntList()
};
var iModel = new SourceSearch(new Security(new WebUser()));
try
{
iModel.Update(ssobj, new SourceValidator(ssobj));
}
catch (Exception ex1)
{
retVal = ex1.Message;
}
return WebHelper.MakeReturn(ssobj.SourceId.ToString(), retVal);
}
public static string SourceDto(this CSVField self, SourceDto sourceDto)
{
switch (self)
{
case CSVField.SourceDate:
return sourceDto.SourceDateStr;
case CSVField.SourceDateTo:
return sourceDto.SourceDateStrTo;
case CSVField.SourceRef:
return sourceDto.SourceRef;
case CSVField.SourceParish:
return sourceDto.Parishs.ParseToCSV("|");
case CSVField.SourceType:
return sourceDto.SourceTypes.ParseToCSV("|");
case CSVField.SourceDesc:
return sourceDto.SourceDesc;
case CSVField.SourceOrigLocat:
return sourceDto.OriginalLocation;
case CSVField.IsCopyHeld:
return sourceDto.IsCopyHeld.ToString();
case CSVField.IsViewed:
return sourceDto.IsViewed.ToString();
case CSVField.IsThackrayFound:
return sourceDto.IsThackrayFound.ToString();
case CSVField.Notes:
return sourceDto.SourceNotes;
case CSVField.SourceId:
return sourceDto.SourceId.ToString();
case CSVField.VirtualLocation:
return sourceDto.VirtualLocation;
}
return "";
}
public IHttpActionResult GetSource(string sourceId)
{
var ssobj = new SourceDto();
var sourceSearch = new SourceSearch(new Security(new WebUser()));
string retVal = "";
try
{
ssobj = sourceSearch.Get(new SourceDto() { SourceId = sourceId.ToGuid() });
}
catch (Exception ex1)
{
retVal = "Exception: " + ex1.Message;
}
if (retVal != "")
{
return Content(HttpStatusCode.BadRequest, retVal);
}
return Ok(ssobj.ToSourceAjaxDto());
}
public SourceAjaxDto GetSource(string sourceId)
{
var ssobj = new SourceDto();
var iModel = new SourceSearch(new Security(new WebUser()));
string retVal = "";
try
{
ssobj = iModel.Get(new SourceDto(){SourceId = sourceId.ToGuid()});
}
catch (Exception ex1)
{
retVal = "Exception: " + ex1.Message;
}
finally
{
if (retVal != "") retVal += Environment.NewLine;
ssobj.ErrorStatus += retVal;
}
return ssobj.ToSourceAjaxDto();
}
public SourceDto Get(SourceDto sourceDto)
{
if (sourceDto == null)
sourceDto = new SourceDto();
if (!_security.IsvalidSelect()) throw new SecurityException("Missing select permission");
sourceDto = _sourceDal.GetSource(sourceDto.SourceId);
sourceDto.Files = _filesDal.GetFilesByParent(sourceDto.SourceId);
sourceDto.SourceTypes = _sourceTypesDal.GetSourceTypeIds(sourceDto.SourceId);
sourceDto.Parishs = _sourceMappingParishsDal.GetParishIds(sourceDto.SourceId);
return sourceDto;
}
public IHttpActionResult AddSource(ServiceSourceAdd serviceSourceAdd)
{
string retVal = "";
var jss = new JavaScriptSerializer();
var obj = jss.Deserialize<dynamic>(serviceSourceAdd.FileIds?? "");
var tp = new List<ServiceFile>();
if (obj != null)
foreach (dynamic item in obj)
tp.Add(new ServiceFile(item["url"], item["desc"], item["id"]));
var ssobj = new SourceDto()
{
IsCopyHeld = serviceSourceAdd.IsCopyHeld.ToBool(),
IsThackrayFound = serviceSourceAdd.IsThackrayFound.ToBool(),
IsViewed = serviceSourceAdd.IsViewed.ToBool(),
OriginalLocation = serviceSourceAdd.OriginalLocation,
SourceDateStr = serviceSourceAdd.SourceDateStr,
SourceDateStrTo = serviceSourceAdd.SourceDateStrTo,
SourceDesc = serviceSourceAdd.SourceDesc,
SourceRef = serviceSourceAdd.SourceRef,
SourceNotes = serviceSourceAdd.SourceNotes,
SourceFileCount = serviceSourceAdd.SourceFileCount.ToInt32(),
SourceId = serviceSourceAdd.SourceId.ToGuid(),
Files = tp,
Parishs = serviceSourceAdd.Parishs.ParseToGuidList(),
SourceTypes = serviceSourceAdd.SourceTypes.ParseToIntList()
};
var sourceSearch = new SourceSearch(new Security(new WebUser()));
try
{
sourceSearch.Update(ssobj, new SourceValidator(ssobj));
}
catch (Exception ex1)
{
retVal = ex1.Message;
}
if (retVal != "")
{
return Content(HttpStatusCode.BadRequest, retVal);
}
return Ok(ssobj.SourceId.ToString());
}
public void DeleteRecords(SourceDto sourceDto)
{
if (!_security.IsValidDelete()) throw new SecurityException("Missing delete permission");
_sourceDal.DeleteSource2(sourceDto.SourceId);
}
private void UpdateRelatedData(SourceDto sourceDto)
{
_smDal.WriteFilesToSource(sourceDto.SourceId, sourceDto.Files, sourceDto.UserId);
_smDal.WriteSourceTypesToSource(sourceDto.SourceId, sourceDto.SourceTypes, sourceDto.UserId);
_smDal.WriteParishsToSource(sourceDto.SourceId, sourceDto.Parishs, sourceDto.UserId);
}
private void Insert(SourceDto sourceDto)
{
if (!_security.IsValidInsert()) throw new SecurityException("Missing insert permission");
_sourceDal.InsertSource(sourceDto);
UpdateRelatedData(sourceDto);
}
public void Update(SourceDto sourceDto, IValidator validator = null)
{
if (validator == null)
validator = new Validator();
if (!validator.ValidEntry()) throw new InvalidDataException(validator.GetErrors());
if (sourceDto.SourceId == Guid.Empty)
{
Insert(sourceDto);
}
else
{
Edit(sourceDto);
}
}
public SourceValidator(SourceDto sourceAjaxDto)
{
_sourceAjaxDto = sourceAjaxDto;
Validate();
}