public async Task <BaseResponse <int> > CreateAsync(ProfileAddSql model, int createdBy)
{
var par = GetParams(model, new string[] {
nameof(model.UpdatedBy),
nameof(model.UpdatedTime),
nameof(model.CreatedTime),
nameof(model.CreatedBy),
nameof(model.Ma_Ho_So)
}, "id");
par.Add("CreatedBy", createdBy);
try
{
using (var _con = GetConnection())
{
await _con.ExecuteAsync("sp_HO_SO_Them_v2", par, commandType : CommandType.StoredProcedure);
var id = par.Get <int>("id");
return(BaseResponse <int> .Create(id));
}
}
catch (Exception e)
{
return(BaseResponse <int> .Create(0, GetException(e)));
}
}
public async Task <BaseResponse <bool> > UpdateAsync(ProfileAddSql model, int profileId, int updatedBy)
{
model.ID = profileId;
var par = GetParams(model, new string[] {
nameof(model.CreatedBy),
nameof(model.Ma_Ho_So),
nameof(model.UpdatedBy),
nameof(model.Ghi_Chu),
nameof(model.CreatedTime),
nameof(model.UpdatedTime),
nameof(model.IsDeleted)
});
par.Add("UpdatedBy", updatedBy);
try
{
using (var _con = GetConnection())
{
await _con.ExecuteAsync("sp_update_HO_SO_v2", par, commandType : CommandType.StoredProcedure);
return(BaseResponse <bool> .Create(true));
}
}
catch (Exception e)
{
return(BaseResponse <bool> .Create(false, GetException(e)));
}
}
