public async Task <long> UpdateCaseInfo(Model.Case data)
{
var caseParam = new DynamicParameters();
caseParam.Add("@Ref", data.RefID);
caseParam.Add("@Source", data.Source);
caseParam.Add("@Status", data.Status);
caseParam.Add("@OldStatus", data.OldStatus);
caseParam.Add("@StatusMinor", data.MinorStatus);
caseParam.Add("@OtherStatus", data.OtherStatus);
caseParam.Add("@OtherStatusMinor", data.OtherStatusMinor);
caseParam.Add("@Type", data.Type);
caseParam.Add("@Occurrence", data.Occurrence);
caseParam.Add("@Background", data.Background);
caseParam.Add("@OffenderID", data.OffenderID);
caseParam.Add("@ManagedByID", data.ManagedByID);
caseParam.Add("@AssignedToID", data.AssignedToID);
caseParam.Add("@ReportedByID", data.ReportedByID);
caseParam.Add("@SuspendedFrom", data.SuspendedFrom);
caseParam.Add("@Title", data.Title);
caseParam.Add("@Sanction", data.Sanction);
caseParam.Add("@ID", data.ID);
await SqlMapper.ExecuteAsync(_unitOfWork.Connection,
"UpdateCaseInfo",
caseParam,
commandType : CommandType.StoredProcedure,
transaction : _unitOfWork.Transaction);
return(data.ID);
}
public async Task <long> InsertCase(Model.Case data)
{
return(await _requestProvider.BuildUpon(_url)
.Uri($"/api/case")
.Method(HttpMethod.Post)
.Content(new JsonContent(data))
.AddInterceptor(new JsonDeserializerInterceptor())
.Execute <long>());
}
public async Task <long> InsertCase(Model.Case data)
{
var caseParam = new DynamicParameters();
var offenceTypeTable = new DataTable();
offenceTypeTable.Columns.Add("Val", typeof(Guid));
if (data.Offences?.Any() ?? false)
{
foreach (var offenceType in data.Offences)
{
offenceTypeTable.Rows.Add(offenceType.ID);
}
}
caseParam.Add("@Ref", data.RefID);
caseParam.Add("@Source", data.Source);
caseParam.Add("@Type", data.Type);
caseParam.Add("@Title", data.Title);
caseParam.Add("@Background", data.Background);
caseParam.Add("@OffenderID", data.Offender?.ID ?? null);
caseParam.Add("@ReportedByID", data.ReportedBy?.ID ?? null);
caseParam.Add("@ManagedByID", data.ManagedBy.ID);
caseParam.Add("@CreatedByID", data.CreatedBy.ID);
caseParam.Add("@Out", dbType: DbType.Int64, direction: ParameterDirection.Output);
await SqlMapper.ExecuteAsync(_unitOfWork.Connection,
"InsertCase",
caseParam,
commandType : CommandType.StoredProcedure,
transaction : _unitOfWork.Transaction);
var caseID = caseParam.Get <long>("@Out");
foreach (var contact in data.ReportedBy.ContactInfos)
{
var contactParam = new DynamicParameters();
contactParam.Add("@CaseID", caseID);
contactParam.Add("@Type", contact.Type);
contactParam.Add("@Value", contact.Value);
await SqlMapper.ExecuteAsync(_unitOfWork.Connection,
"InsertReporterContactInfo",
contactParam,
commandType : CommandType.StoredProcedure,
transaction : _unitOfWork.Transaction);
}
return(caseID);
}
public async Task <long> InsertCase(Model.Case data)
{
if (data.Premises.Count > 0)
{
var certificates = await _apiClient.Certificate360.Query(
new Certificate360Options
{
PremiseIDs = data.Premises.Select(x => x.ID).ToArray()
});
data.Certificates = certificates.Where(x => x.ExpiresOn >= DateTime.UtcNow &&
x.CustomerID == data.Offender.ID).ToList();
}
var result = await _apiClient.CaseSdk.InsertCase(data);
return(result);
}
protected void createBtn_Click(object sender, EventArgs e)
{
if (IsValid)
{
Model.Case c = new Model.Case()
{
Branch_id = int.Parse(BranchDropList.SelectedItem.Value),
Title = TitleTB.Text,
Type_id = int.Parse(CaseTypeDD.SelectedItem.Value)
};
var uid = HttpContext.Current.User.Identity.GetUserId();
c.Process_id = staffLogic.getProcessFromUserID(uid);
if (caseLogic.CreateCase(c) > 0)
{
Server.Transfer("default.aspx");
}
}
}
public async Task <long> Post([FromBody] Model.Case data, Guid userID, string username)
{
return(await _caseService.InsertCase(data, new Officer(userID, username)));
}
public int CreateCase(Model.Case c)
{
return(caseTA.Insert(c.Title, c.Process_id, c.Branch_id, c.Type_id));
}
public Model.Case Map(Model.Case @case,
Offender offender = null,
ContactInfo offenderContact = null,
Officer managedBy = null,
Officer assignedTo = null,
Person reportedBy = null,
ContactInfo reporterContact = null,
Master breachCategories = null,
Master offences = null,
Attachment attachment = null,
Certificate certificate = null,
Premise premise = null,
SanctionInfo sanctionInfo = null)
{
if (!dict.TryGetValue(@case.ID, out Model.Case result))
{
dict[@case.ID] = @case;
_contactInfoCache.Clear();
_breachCategoriesCache.Clear();
_offencesCache.Clear();
_attachmentCache.Clear();
_certificatesCache.Clear();
_premiseCache.Clear();
_sanctionInfoCache.Clear();
_activityCache.Clear();
_offenderContactInfoCache.Clear();
if (!string.IsNullOrEmpty(offender?.Name))
{
@case.Offender = offender;
}
if (!string.IsNullOrEmpty(managedBy?.Name))
{
@case.ManagedBy = managedBy;
}
if (!string.IsNullOrEmpty(assignedTo?.Name))
{
@case.AssignedTo = assignedTo;
}
if (!string.IsNullOrEmpty(reportedBy?.Name))
{
@case.ReportedBy = reportedBy;
}
result = @case;
}
if ((reporterContact?.ID ?? 0) > 0 &&
!_contactInfoCache.ContainsKey(reporterContact.ID))
{
_contactInfoCache[reporterContact.ID] = reporterContact;
if (result.ReportedBy.ContactInfos == null)
{
result.ReportedBy.ContactInfos = new List <ContactInfo>();
}
result.ReportedBy.ContactInfos.Add(reporterContact);
}
if ((offenderContact?.ID ?? 0) > 0 &&
!_offenderContactInfoCache.ContainsKey(offenderContact.ID))
{
_offenderContactInfoCache[offenderContact.ID] = offenderContact;
if (result.Offender.ContactInfos == null)
{
result.Offender.ContactInfos = new List <ContactInfo>();
}
result.Offender.ContactInfos.Add(offenderContact);
}
if ((breachCategories?.ID ?? Guid.Empty) != Guid.Empty &&
!_breachCategoriesCache.ContainsKey(breachCategories.ID))
{
_breachCategoriesCache[breachCategories.ID] = breachCategories;
if (result.BreachCategories == null)
{
result.BreachCategories = new List <Master>();
}
result.BreachCategories.Add(breachCategories);
}
if ((offences?.ID ?? Guid.Empty) != Guid.Empty &&
!_offencesCache.ContainsKey(offences.ID))
{
_offencesCache[offences.ID] = offences;
if (result.Offences == null)
{
result.Offences = new List <Master>();
}
result.Offences.Add(offences);
}
if ((attachment?.ID ?? 0) > 0 &&
!_attachmentCache.ContainsKey(attachment.ID))
{
_attachmentCache[attachment.ID] = attachment;
if (result.Attachments == null)
{
result.Attachments = new List <Attachment>();
}
result.Attachments.Add(attachment);
}
if ((certificate?.ID ?? 0) > 0 &&
!_certificatesCache.ContainsKey(certificate.ID))
{
_certificatesCache[certificate.ID] = certificate;
if (result.Certificates == null)
{
result.Certificates = new List <Certificate>();
}
result.Certificates.Add(certificate);
}
if ((premise?.ID ?? 0) > 0 &&
!_premiseCache.ContainsKey(premise.ID))
{
_premiseCache[premise.ID] = premise;
if (result.Premises == null)
{
result.Premises = new List <Premise>();
}
result.Premises.Add(premise);
}
if ((sanctionInfo?.ID ?? 0) > 0 &&
!_sanctionInfoCache.ContainsKey(sanctionInfo.ID))
{
_sanctionInfoCache[sanctionInfo.ID] = sanctionInfo;
if (result.SanctionInfos == null)
{
result.SanctionInfos = new List <SanctionInfo>();
}
result.SanctionInfos.Add(sanctionInfo);
}
return(result);
}
public InsertCaseCommand(Model.Case data, Officer user)
{
_data = data;
_user = user;
}
public async Task <long> InsertCase(Model.Case data, Officer user)
{
return(await Execute(new InsertCaseCommand(data, user)));
}
