public JsonResult InsertInvestment(int caseId, int caseDetailId, DateTime?fechadecision, string payments, string comment, string caseNumber, int beneficiario) { DateTime workingDate = DateTime.Now; var currentCase = CaseService.FindCaseByNumber(caseNumber); var transaction = new Transaction { CaseDetailId = caseDetailId, TransactionTypeId = (int)TransactionTypeEnum.Inversion, TransactionDate = workingDate, TransactionAmount = decimal.Zero, Comment = comment }; TransactionService.CreateTransaction(transaction); var amount = decimal.Zero; var serializedPayments = JsonConvert.DeserializeObject <List <PaymentTransaction> >(payments); foreach (var serializedPayment in serializedPayments) { var entidad = new Entity { FullName = serializedPayment.Entidad, SourceId = 9 }; EntityService.CreateEntity(entidad); var payment = new Payment { CaseId = caseId, CaseDetailId = caseDetailId, TransactionId = transaction.TransactionId, CaseNumber = caseNumber, ConceptId = currentCase.ConceptId.Value, ClassId = 3, Amount = serializedPayment.Inversion, EntityId_RemitTo = entidad.EntityId, Remitter = entidad, ToDate = fechadecision, TransactionNum = transaction.TransactionId.ToString().PadLeft(9, '0'), CheckBk = 0, StatusId = 12, IssueDate = workingDate, StatusChangeDate = workingDate }; amount += serializedPayment.Inversion.Value; PaymentService.CreatePayment(payment); } transaction.TransactionAmount = amount; TransactionService.ModifyTransaction(transaction); return(Json(new BasicDataTablesResult(new { Status = "OK" }))); }
public JsonResult Post(string name) { if (string.IsNullOrWhiteSpace(name)) { return(new JsonResult("实体名称不能为空")); } entityService.CreateEntity(name, System.IO.Path.Combine(hostingEnvironment.ContentRootPath, "Models")); return(new JsonResult("生成成功")); }
public JsonResult CreateEntity(string entityName = null) { IEntity IEntity = new EntityService(); if (entityName == null) { return(Json("参数为空")); } string filePath = Directory.GetCurrentDirectory(); filePath = filePath.Substring(0, filePath.LastIndexOf('\\')) + "\\" + "Core.Entity"; return(Json(IEntity.CreateEntity(entityName, filePath))); }
/// <summary> /// 生成实体类 /// </summary> /// <param name="entityName"></param> /// <param name="filePath"></param> /// <returns></returns> public BizResult <string> CreateEntity(string entityName, string contentRootPath) { try { string[] arr = contentRootPath.Split('\\'); string baseFileProvider = ""; for (int i = 0; i < arr.Length - 1; i++) { baseFileProvider += arr[i]; baseFileProvider += "\\"; } string filePath = baseFileProvider + "NexChip.SignMessage.Entities"; try { if (iService.CreateEntity(entityName, filePath)) { return new BizResult <string> { Success = true, Msg = "生成成功" } } ; else { return new BizResult <string> { Success = false, Msg = "生成失败" } }; //var s = Db.Ado.GetDataTable("select * from Student"); //var s2 = Db.Queryable<Student>().ToSql(); //Db.DbFirst.IsCreateAttribute().Where(entityName).CreateClassFile(filePath); //return new BizResult<string> { Success = true, Msg = "生成成功" }; } catch (Exception ex) { return(new BizResult <string> { Success = false, Msg = ex.Message }); } //db.DbFirst.IsCreateAttribute().Where(entityName).CreateClassFile(filePath); //return true; } catch (Exception) { return(new BizResult <string> { Success = false }); } }
public void EntityCreateTest() { try { var NewEntityId = EntityService.CreateEntity(new ConfigModel { AccesTokenDeveloper = DeveloperAccessToken }, "test_entity_1", new Dictionary <string, string[]> { { "test1", new[] { "test 1", "test one" } }, { "test2", new[] { "test 2", "test second" } } }); } catch (ApiAiException ex) { // Use debug to check this "ex" value Assert.Fail(); } }
public JsonResult UpdateInvestments(UpdateInvestmentRequest model) { var transaction = TransactionService.FindTransactionById(model.TransactionId); var workingDate = DateTime.Now; var amount = decimal.Zero; var modelPayments = ConvertToPaymentModel(model); var paymentsToUpdate = BuildInvestmentPaymentSets(modelPayments, transaction.Payments); foreach (var newPayment in paymentsToUpdate["new"]) { var newEntity = new Entity { FullName = newPayment.Remitter.FullName, SourceId = 9 }; EntityService.CreateEntity(newEntity); var payment = new Payment { CaseId = model.CaseId, CaseDetailId = model.CaseDetailId, TransactionId = transaction.TransactionId, CaseNumber = model.CaseNumber, ConceptId = 2, ClassId = 3, Amount = newPayment.Amount, EntityId_RemitTo = newEntity.EntityId, Remitter = newEntity, ToDate = transaction.TransactionDate, TransactionNum = transaction.TransactionId.ToString().PadLeft(9, '0'), CheckBk = 0, StatusId = 2, IssueDate = workingDate, StatusChangeDate = workingDate }; PaymentService.CreatePayment(payment); amount += payment.Amount.GetValueOrDefault(decimal.Zero); } foreach (var changedPayment in paymentsToUpdate["changed"]) { if (changedPayment != null && changedPayment.EntityId_RemitTo == null) { continue; } if (changedPayment == null) { continue; } var existingEntity = EntityService.GetById(changedPayment.EntityId_RemitTo.Value); var payment = PaymentService.FindPaymentById(changedPayment.PaymentId); if (changedPayment.Remitter != null) { existingEntity.FullName = changedPayment.Remitter.FullName; } EntityService.ModifyEntity(existingEntity); payment.Amount = payment.Amount.GetValueOrDefault(decimal.Zero); PaymentService.ModifyPayment(payment); amount += payment.Amount.Value; } foreach (var removedPayment in paymentsToUpdate["removed"]) { if (removedPayment == null) { continue; } var transactionId = removedPayment.TransactionId; PaymentService.Delete(removedPayment.PaymentId); if (removedPayment.EntityId_RemitTo != null) { EntityService.Delete(removedPayment.EntityId_RemitTo); } if (transactionId != null) { TransactionService.Delete(transactionId.Value); } } transaction.TransactionAmount = amount; transaction.Comment = model.Comment; TransactionService.ModifyTransaction(transaction); return(Json(new BasicDataTablesResult(new { Status = "OK" }))); }
//Process client side data and updates demographic data in the database. public JsonResult Edit(DemographicViewModel demographic) { if (demographic.CaseDetail != null) { var caseDetail = CaseService.FindCaseDetailById(demographic.CaseDetailId); if (caseDetail != null) { if (caseDetail.CaseKey != "00") { var relationship = RelationshipTypeService.GetRelationshipTypes() .Where(x => x.RelationshipType1 == demographic.Relationship && x.WidowCertification == demographic.CaseDetail.Entity.HasWidowCertification) .FirstOrDefault(); caseDetail.RelationshipType = relationship; caseDetail.RelationshipTypeId = relationship.RelationshipTypeId; } #region Entity Information Entity entity = new Entity(); if (!demographic.InsertNewEntity) { entity = EntityService.GetById(Convert.ToInt32(caseDetail.EntityId_Sic)); } entity.FirstName = demographic.CaseDetail.Entity.FirstName.Trim(); entity.MiddleName = demographic.CaseDetail.Entity.MiddleName != null?demographic.CaseDetail.Entity.MiddleName.Trim() : null; entity.LastName = demographic.CaseDetail.Entity.LastName.Trim(); entity.SecondLastName = demographic.CaseDetail.Entity.SecondLastName != null?demographic.CaseDetail.Entity.SecondLastName.Trim() : null; entity.FullName = string.Concat( entity.FirstName + " ", entity.MiddleName.IsNullOrEmpty() ? String.Empty : entity.MiddleName + " ", entity.LastName + " ", entity.SecondLastName.IsNullOrEmpty() ? String.Empty : entity.SecondLastName + " "); entity.CaseNumber = demographic.CaseDetail.CaseNumber; entity.CaseKey = demographic.CaseDetail.CaseKey; entity.SSN = demographic.CaseDetail.Entity.SSN; entity.IDNumber = demographic.CaseDetail.Entity.IDNumber; entity.BirthDate = demographic.CaseDetail.Entity.BirthDate; entity.DeceaseDate = demographic.CaseDetail.Entity.DeceaseDate; entity.MarriageDate = demographic.CaseDetail.Entity.MarriageDate; entity.CivilStatusId = demographic.CaseDetail.Entity.CivilStatusId; entity.IsStudying = demographic.CaseDetail.Entity.IsStudying; entity.SchoolStartDate = demographic.CaseDetail.Entity.SchoolStartDate; entity.SchoolEndDate = demographic.CaseDetail.Entity.SchoolEndDate; entity.HasDisability = demographic.CaseDetail.Entity.HasDisability; entity.OccupationId = demographic.CaseDetail.Entity.OccupationId; entity.MonthlyIncome = demographic.CaseDetail.Entity.MonthlyIncome; entity.IsRehabilitated = demographic.CaseDetail.Entity.IsRehabilitated; entity.IsWorking = demographic.CaseDetail.Entity.IsWorking; entity.IsEmancipated = demographic.CaseDetail.Entity.IsEmancipated; entity.HasWidowCertification = demographic.CaseDetail.Entity.HasWidowCertification; entity.WidowCertificationDate = demographic.CaseDetail.Entity.WidowCertificationDate; entity.ModifiedReasonId = demographic.CaseDetail.Entity.ModifiedReasonId; entity.OtherModifiedReason = demographic.CaseDetail.Entity.OtherModifiedReason; entity.Comments = demographic.CaseDetail.Entity.Comments; entity.Email = demographic.CaseDetail.Entity.Email; entity.HomePhoneNumber = demographic.CaseDetail.Entity.HomePhoneNumber; entity.CellPhoneNumber = demographic.CaseDetail.Entity.CellPhoneNumber; entity.WorkPhoneNumber = demographic.CaseDetail.Entity.WorkPhoneNumber; entity.FaxPhoneNumber = demographic.CaseDetail.Entity.FaxPhoneNumber; entity.OtherPhoneNumber = demographic.CaseDetail.Entity.OtherPhoneNumber; entity.ModifiedBy = WebHelper.GetUserName(); entity.ModifiedDateTime = DateTime.Now; #endregion #region Address Information if (demographic.PostalAddress != null) { Address PostalAddress = demographic.PostalAddress; //Verificar una manera de traer toda la informaicon de coutry / state a traves de ciudad. var city = LocationService.GetAllCities().Where(x => x.CityId == demographic.PostalAddress.CityId).FirstOrDefault(); string state = ""; if (demographic.PostalAddress.StateId != null) { var state1 = LocationService.GetAllStates().Where(x => x.StateId == demographic.PostalAddress.StateId).FirstOrDefault(); state = state1.State1; } var country = LocationService.GetAllCountries().Where(x => x.CountryId == demographic.PostalAddress.CountryId).FirstOrDefault(); PostalAddress.FullAddress = demographic.PostalAddress.Line1 + (demographic.PostalAddress.Line2.IsNullOrEmpty() ? "" : " " + demographic.PostalAddress.Line2.Trim()) + (demographic.PostalAddress.CityId == null ? "" : city.City1 != "Otro" ? " " + city.City1 : " " + demographic.PostalAddress.OtherCity) + (demographic.PostalAddress.StateId == null ? "" : ", " + state) + (demographic.PostalAddress.CountryId == null ? "" : ", " + country.Country1) + (demographic.PostalAddress.ZipCode == null ? "" : " " + demographic.PostalAddress.ZipCode) + (demographic.PostalAddress.ZipCodeExt == null ? "" : "-" + demographic.PostalAddress.ZipCodeExt); PostalAddress.AddressTypeId = AddressTypeService.GetAddressTypes().Where(x => x.AddressType1 == "Postal").Select(x => x.AddressTypeId).FirstOrDefault(); PostalAddress.SourceId = 8; PostalAddress.ModifiedBy = WebHelper.GetUserName(); PostalAddress.ModifiedDateTime = DateTime.Now; if (!demographic.HasAddress) { PostalAddress.CreatedBy = WebHelper.GetUserName(); PostalAddress.CreatedDateTime = DateTime.Now; entity.Addresses.Add(PostalAddress); } else { foreach (var a in demographic.CaseDetail.Entity.Addresses) { if (a.AddressType.AddressType1 == "Postal" && a.AddressId == demographic.PostalAddress.AddressId) { a.Line1 = demographic.PostalAddress.Line1; a.Line2 = demographic.PostalAddress.Line2; a.CityId = demographic.PostalAddress.CityId; a.OtherCity = demographic.PostalAddress.OtherCity; a.StateId = demographic.PostalAddress.StateId; a.CountryId = demographic.PostalAddress.CountryId; a.ZipCode = demographic.PostalAddress.ZipCode; a.ZipCodeExt = demographic.PostalAddress.ZipCodeExt; a.FullAddress = demographic.PostalAddress.FullAddress; a.EntityId = demographic.PostalAddress.EntityId; } } } } #endregion //#region Phone Information //#endregion if (demographic.InsertNewEntity) { entity.SourceId = 8; //SourceId = Entity Sic Source entity.CreatedBy = WebHelper.GetUserName(); entity.CreatedDateTime = DateTime.Now; try { EntityService.CreateEntity(entity); } catch { throw new Exception(); } } else { try { EntityService.ModifyEntity(entity); } catch { throw new Exception(); } } caseDetail.Entity = entity; caseDetail.EntitySic = entity; caseDetail.EntityId = entity.EntityId; caseDetail.EntityId_Sic = entity.EntityId; try { CaseService.UpdateCaseDetail(caseDetail); } catch { EntityService.Delete(entity.EntityId); throw new Exception(); } return(Json(new { Data = demographic.CaseDetail })); } else { throw new Exception(); } } else { throw new Exception(); } }
/// <summary> /// Creates new participant entity /// </summary> /// <param name="entity">Entity Data</param> /// <param name="PostalAddress">Address Data</param> /// <returns></returns> public JsonResult CreateParticipant(Entity entity, Address PostalAddress) { if (entity != null) { entity.FullName = string.Concat( entity.FirstName + " ", entity.MiddleName.IsNullOrEmpty() ? String.Empty : entity.MiddleName + " ", entity.LastName + " ", entity.SecondLastName.IsNullOrEmpty() ? String.Empty : entity.SecondLastName + " "); if (PostalAddress != null) { //Address address = new Address(); //address.Line1 = PostalAddress.Line1; var city = LocationService.GetAllCities().Where(x => x.CityId == PostalAddress.CityId).FirstOrDefault(); string state = ""; if (PostalAddress.StateId != null) { var state1 = LocationService.GetAllStates().Where(x => x.StateId == PostalAddress.StateId).FirstOrDefault(); state = state1.State1; } var country = LocationService.GetAllCountries().Where(x => x.CountryId == PostalAddress.CountryId).FirstOrDefault(); PostalAddress.FullAddress = PostalAddress.Line1 + (PostalAddress.Line2.IsNullOrEmpty() ? "" : " " + PostalAddress.Line2.Trim()) + (PostalAddress.CityId == null ? "" : city.City1 != "Otro" ? " " + city.City1 : " " + PostalAddress.OtherCity) + (PostalAddress.StateId == null ? "" : ", " + state) + (PostalAddress.CountryId == null ? "" : ", " + country.Country1) + (PostalAddress.ZipCode == null ? "" : " " + PostalAddress.ZipCode) + (PostalAddress.ZipCodeExt == null ? "" : "-" + PostalAddress.ZipCodeExt); PostalAddress.AddressTypeId = AddressTypeService.GetAddressTypes().Where(x => x.AddressType1 == "Postal").Select(x => x.AddressTypeId).FirstOrDefault(); PostalAddress.SourceId = 8; PostalAddress.CreatedBy = WebHelper.GetUserName(); PostalAddress.CreatedDateTime = DateTime.Now; PostalAddress.ModifiedBy = WebHelper.GetUserName(); PostalAddress.ModifiedDateTime = DateTime.Now; entity.Addresses.Add(PostalAddress); } entity.SourceId = 8; entity.CreatedBy = WebHelper.GetUserName(); entity.CreatedDateTime = DateTime.Now; entity.ModifiedBy = WebHelper.GetUserName(); entity.ModifiedDateTime = DateTime.Now; try { EntityService.CreateEntity(entity); return(Json(entity)); } catch { throw new Exception(); } } else { throw new Exception(); } }
public JsonResult Insert(ThirdPartyPaymentModel model) { int?newEntityId = null; var entity = new Entity(); var address = new Address(); if (model.EntityTypeId == 1) { entity = new Entity { SourceId = 8, FirstName = model.CustodyFirstName, MiddleName = model.CustodySecondName, LastName = model.CustodyFirstLastName, SecondLastName = model.CustodySecondLastName, FullName = string.Format("{0} {1} {2} {3}", model.CustodyFirstName, model.CustodySecondName, model.CustodyFirstLastName, model.CustodySecondLastName) }; address = new Address { EntityId = entity.EntityId, SourceId = 8, FullAddress = string.Format("{0} {1}", model.CustodyAddressLine1, model.CustodyAddressLine2), Line1 = model.CustodyAddressLine1, Line2 = model.CustodyAddressLine2, CityId = model.CustodyCityId, ZipCode = model.CustodyPostalCode == null ? string.Empty : model.CustodyPostalCode.Trim().Replace('-', '\0').PadRight(9, '0').Substring(0, 5), ZipCodeExt = model.CustodyPostalCode == null ? string.Empty : model.CustodyPostalCode.Trim().Replace('-', '\0').PadRight(9, '0').Substring(5, 4) }; entity.Addresses.Add(address); EntityService.CreateEntity(entity); newEntityId = entity.EntityId; } else if (model.EntityTypeId == 2) { entity = new Entity { SourceId = 9, FullName = model.EntityName }; address = new Address { SourceId = 9, EntityId = entity.EntityId, FullAddress = string.Format("{0} {1}", model.EntityAddressLine1, model.EntityAddressLine2), Line1 = model.EntityAddressLine1, Line2 = model.EntityAddressLine2, CityId = model.EntityCityId, ZipCode = model.EntityPostalCode == null ? string.Empty : model.EntityPostalCode.Trim().Replace('-', '\0').PadRight(9, '0').Substring(0, 5), ZipCodeExt = model.EntityPostalCode == null ? string.Empty : model.EntityPostalCode.Trim().Replace('-', '\0').PadRight(9, '0').Substring(5, 4) }; entity.Addresses.Add(address); EntityService.CreateEntity(entity); newEntityId = entity.EntityId; } else if (model.EntityTypeId == 3) { newEntityId = model.CourtId; } decimal amount = decimal.Zero; if (model.SinglePaymentAmount.HasValue) { amount = model.SinglePaymentAmount.Value; } else { amount = model.FirstInstallmentAmount.GetValueOrDefault(decimal.Zero) + model.SecondInstallmentAmount.GetValueOrDefault(decimal.Zero); } var thirdPartySchedule = new ThirdPartySchedule { CaseId = model.CaseId, CaseDetailId = model.CaseDetailId, EntityId_RemitTo = model.EntityTypeId == 2 || model.EntityTypeId == 3 ? newEntityId : null, ClaimNumber = model.ClaimNumber, OrderIdentifier = model.OrderIdentifier, TerminationFlag = model.TerminationFlag, EffectiveDate = model.EffectiveDate, TerminationOrderNumber = model.TerminationOrderNumber, SinglePaymentAmount = model.SinglePaymentAmount, FirstInstallmentAmount = model.FirstInstallmentAmount, SecondInstallmentAmount = model.SecondInstallmentAmount, Comment = model.Comment, OrderAmount = model.OrderAmount, TerminationDate = model.TerminationDate, CreatedDateTime = System.DateTime.UtcNow, CreatedBy = WebHelper.GetUserName(), }; PaymentService.CreateThirdPayment(thirdPartySchedule); return(Json(new BasicDataTablesResult(new { Status = "OK" }))); }