public async Task <bool> AddNoteAsync(CheckDupNote note) { string sql = $"insert into CustomerNote(CustomerId, Note,CreatedTime,CreatedBy) values (@customerId,@note,@createdTime,@createdBy)"; using (var con = GetConnection()) { await con.ExecuteAsync(sql, new { customerId = note.CustomerId, note = note.Note, createdTime = DateTime.Now, createdBy = note.CreatedBy }, commandType : CommandType.Text); return(true); } }
public async Task <int> CreateAsync(CheckDupAddModel model) { if (model == null) { return(ToResponse(0, Errors.invalid_data)); } if (model.PartnerId <= 0) { return(ToResponse(0, "Vui lòng chọn đối tác")); } if (!model.BirthDay.HasValue || (model.BirthDay.HasValue && model.BirthDay.Value == DateTime.MinValue)) { return(ToResponse(0, "Vui lòng chọn ngày sinh")); } var obj = _mapper.Map <CheckDupAddSql>(model); obj.CICStatus = (int)CheckDupCICStatus.NotDebt; obj.PartnerStatus = (int)CheckDupPartnerStatus.NotCheck; var response = await _rpCheckDup.CreateAsync(obj, _process.User.Id); if (response.data > 0) { if (!string.IsNullOrWhiteSpace(model.Note)) { var note = new CheckDupNote { Note = model.Note, CustomerId = response.data, CreatedBy = obj.CreatedBy }; _rpCheckDup.AddNoteAsync(note); } return(response.data); } return(ToResponse(0, response.error)); }
public async Task <bool> UpdateAsync(CheckDupEditModel model) { if (model == null) { return(ToResponse(false, "Dữ liệu không hợp lệ")); } if (!model.BirthDay.HasValue || (model.BirthDay.HasValue && model.BirthDay.Value == DateTime.MinValue)) { return(ToResponse(false, "Vui lòng chọn ngày sinh")); } if (model.PartnerId <= 0) { return(ToResponse(false, "Vui lòng chọn đối tác")); } var checkDup = _mapper.Map <CheckDupAddSql>(model); var result = await _rpCheckDup.UpdateAsync(checkDup, _process.User.Id); if (!result.success) { return(ToResponse(result)); } if (!string.IsNullOrWhiteSpace(model.Note)) { var note = new CheckDupNote { Note = model.Note, CustomerId = checkDup.Id, CreatedBy = _process.User.Id }; _rpCheckDup.AddNoteAsync(note); } return(true); }