public string UpdateArchiveElement(ArchiveEntities archiveItem, IEnumerable <Permissions> permissions)
{
bool existElement = _archiveEntityCrud.Exists(archiveItem.Barcode);
if (!existElement)
{
return(null);
}
StatusValuePair <ArchiveEntities> archiveElement = _archiveEntityCrud.UpdateByBarcode(archiveItem);
string result = archiveElement.HasValue ? archiveElement.Value.Barcode : null;
if (string.IsNullOrWhiteSpace(result))
{
return(result);
}
bool permissionsResult = CreateOrUpdatePermissions(permissions);
if (!permissionsResult)
{
Logger.ShowErrorOnPage("Не удалось создать уникальные права для этого элемента.",
"ArchiveElement.CreateOrUpdateDbRecord(SPItemEventProperties properties)");
}
return(result);
}
private ArchiveDataSource ToArchiveDataSource(ArchiveEntities archiveElement)
{
SPUser user = _spSite.RootWeb.SiteUsers.GetByID(archiveElement.CreatedBy);
ArchiveDataSource item = new ArchiveDataSource
{
Id = Convert.ToInt32(archiveElement.Id),
BarCode = archiveElement.Barcode,
SE = archiveElement.SE,
LP = archiveElement.LP,
DocumentDate = archiveElement.DocumentDate,
RegNumber = archiveElement.RegNumber,
Currency = archiveElement.Currency,
BPStatus = archiveElement.BPStatus,
Contractor = archiveElement.Contractor,
DocumentNumber = archiveElement.DocumentNumber,
SumPlusVAT = archiveElement.SumPlusVAT,
DocumentType = archiveElement.DocumentType,
Created = archiveElement.Created,
CreatedBy = user.Name,
Status = archiveElement.Status,
Description = archiveElement.Description,
Url = archiveElement.Url,
EditUrl = archiveElement.EditUrl,
ListID = archiveElement.ListID,
ItemID = archiveElement.ItemID,
FullId = archiveElement.FullId,
};
return(item);
}
public StatusValuePair <ArchiveEntities> Create(string url,
string editUrl,
int createById,
string listID = null,
string itemID = null,
DateTime?created = null,
bool isArchiveElement = false,
string documentType = null,
string description = null,
string status = null,
string barode = null
)
{
const string sql = "EXECUTE [dbo].[P_ArchiveEntity_Create] @Url, @EditUrl, @Created, @CreatedBy, @IsArchiveElement, @DocumentType, @Description, @Status, @ListID, @ItemID";
StatusValuePair <ArchiveEntities> procedureSingle = StoredProcedureSingle <ArchiveEntities>(sql,
new
{
Url = url,
EditUrl = editUrl,
Created = created ?? DateTime.Now,
CreatedBy = createById,
IsArchiveElement = isArchiveElement,
DocumentType = documentType,
Description = description,
Status = status,
ListID = listID,
ItemID = itemID
});
if (!procedureSingle.HasValue || procedureSingle.Value == null)
{
return(procedureSingle);
}
string barcodestring;
if (barode != null)
{
barcodestring = barode;
}
else
{
barcodestring = BarcodeFabric.Create(procedureSingle.Value.Id);
}
ArchiveEntities archiveEntities = procedureSingle.Value;
archiveEntities.Barcode = barcodestring;
procedureSingle.Value.FullId = Barcodes.FormatItemID(procedureSingle.Value.ItemID);
procedureSingle = Update(archiveEntities);
if (!procedureSingle.HasValue)
{
Delete(archiveEntities);
}
return(procedureSingle);
}
/// <summary>
/// GIPO: Retorna objeto arcArchive a partir de um ID
/// </summary>
public static Archive.arcArchive GetById(int id)
{
ArchiveEntities archive = new ArchiveEntities(Account.Context.GetConnectionStringEntity("Archive"));
IEnumerable <Archive.arcArchive> queryArchive;
queryArchive = from a in archive.arcArchives
where a.IdArchive == id
select a;
return(queryArchive.FirstOrDefault());
}
/// <summary>
/// GIPO: Retorna objeto arcArchive a partir de um nome
/// </summary>
public static Archive.arcArchive GetByName(string name)
{
ArchiveEntities archive = new ArchiveEntities(Account.Context.GetConnectionStringEntity("Archive"));
IEnumerable <Archive.arcArchive> queryArchive;
queryArchive = from a in archive.arcArchives
where a.Name.Equals(name)
select a;
return(queryArchive.FirstOrDefault());
}
public StatusValuePair <ArchiveEntities> UpdateByBarcode(ArchiveEntities archiveItem)
{
if (string.IsNullOrWhiteSpace(archiveItem.Barcode) || archiveItem.Barcode == default(int).ToString(CultureInfo.InvariantCulture))
{
return(new StatusValuePair <ArchiveEntities>(null, ErrorCode.UnknownError));
}
IFieldPredicate p = Predicates.Field <ArchiveEntities>(f => f.Barcode, Operator.Eq, archiveItem.Barcode);
StatusValuePair <ArchiveEntities> result = GetSingle <ArchiveEntities>(p);
if (!result.HasValue)
{
return(new ArchiveEntities());
}
result.Value.SE = archiveItem.SE;
result.Value.LP = archiveItem.LP;
result.Value.RegNumber = archiveItem.RegNumber;
result.Value.SumPlusVAT = archiveItem.SumPlusVAT;
result.Value.BPStatus = archiveItem.BPStatus;
result.Value.Contractor = archiveItem.Contractor;
result.Value.Currency = archiveItem.Currency;
result.Value.DocumentDate = archiveItem.DocumentDate;
result.Value.DocumentKind = archiveItem.DocumentKind;
result.Value.DocumentNumber = archiveItem.DocumentNumber;
result.Value.DocumentType = archiveItem.DocumentType;
result.Value.Description = archiveItem.Description;
result.Value.Status = archiveItem.Status;
result.Value.FullId = archiveItem.FullId;
result.Value.IsUpdated = true;
if (!string.IsNullOrWhiteSpace(archiveItem.Url))
{
result.Value.Url = archiveItem.Url;
}
StatusValuePair <ArchiveEntities> updated = Update(result.Value);
return(updated);
}
public ErrorCode Delete(ArchiveEntities entity)
{
StatusValuePair <ArchiveEntities> result = Delete <ArchiveEntities>(entity);
return(result.ErrorCode);
}
