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