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))); }