public async Task <IActionResult> Insert(BangKiemDetailViewModel obj, List <NoiDung1> objNoiDungs)
{
//var obj1 = obj.Select(m => m.NoiDungs).ToList();
try
{
obj.NoiDungs = objNoiDungs;
var kqResult = await _iBangKiemRepo.Insert(obj);
return(Content(kqResult.ToString()));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Content("0"));
}
}
//protected IDbConnection Connection
//{
// get
// {
// var connectionString = _config.GetSection("ConnectionStrings:Db06").Value;
// var conn = new OracleConnection(connectionString);
// return conn;
// }
//}
public async Task <int> Insert(BangKiemDetailViewModel obj)
{
int result = 0;
using (var conn = new OracleConnection(_connectionStrings.Db06))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
if (conn.State == ConnectionState.Open)
{
using (var tran = conn.BeginTransaction())
{
try
{
var idBn = Helper.GeneralMethods.CreateIdRandom();
var userName = Helper.GeneralMethods.GetUsername();
//Insert thông tin bệnh nhân
var sqlBnInfo =
$@"insert into bangkiem_ttbn
(
id,mabn,HOTENBN,NAMSINH,PHAI,mavaovien,maql
,MAICD,BENHCHINH,tenkhoaphong,username
)
values
(
{idBn},{obj.MaBn},N'{obj.HoTenBn}',{obj.NamSinh},N'{obj.Phai}',{obj.MaVaoVien},{obj.MaQl}
,'{obj.MaIcd}',N'{obj.BenhChinh}',N'{obj.TenKhoaPhong}','{userName}')";
await conn.ExecuteAsync(sqlBnInfo, obj, tran);
foreach (var item in obj.NoiDungs)
{
var sqlBangKiemCt =
$@"INSERT INTO BANGKIEM_CHITIET
(
IDNOIDUNG,IDTTBN,DIEM,STATUS
)
VALUES
(
{item.IdNoiDung}, {idBn},{item.Diem},{obj.Status}
)";
await conn.ExecuteAsync(sqlBangKiemCt, item, tran);
}
tran.Commit();
_logger.LogInformation("Lưu thành công: ID: " + idBn);
result = 1;
}
catch (Exception e)
{
_logger.LogInformation(e.Message);
tran.Rollback();
result = 0;
}
}
return(result);
}
}
return(result);
}
