public async Task <int> Insert(NoiDung objNoiDung) { var obj = 0; using (var conn = new OracleConnection(_connectionStrings.Db06)) { if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var id = GeneralMethods.CreateIdRandom(); var userName = objNoiDung.Username ?? "null"; string query = @$ "insert into bangkiem_noidung(id,iddm,ten,stt,username) values({id},{objNoiDung.Iddm},N'{objNoiDung.Ten}',{objNoiDung.Stt},{userName})";
//public string CreateIdRandom() //{ // var rd = new Random(); // var id = DateTime.Now.ToString("yyMMddHHmmssfffff") + rd.Next(99999999); // return id; //} public async Task <int> Insert(DanhMuc objDanhMuc) { var obj = 0; using (var conn = new OracleConnection(_connectionStrings.Db06)) { if (conn.State == ConnectionState.Closed) { conn.Open(); } if (conn.State == ConnectionState.Open) { var id = GeneralMethods.CreateIdRandom(); string query = @$ "insert into bangkiem_danhmuc(id,ten) values({id},N'{objDanhMuc.Ten}')"; obj = await conn.ExecuteAsync(query); //return obj; } } return(obj); }