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