public string IntiDatabase() { var conn = _sqlService.GetConnection(); try { conn.Open(); var sql = @"create table if not exists books( bid int unsigned auto_increment, class varchar(20), title varchar(20) not null, publish varchar(20), pubyear int, author varchar(20), price decimal(10, 2), total int not null, stock int not null, primary key(bid) ) default CHARSET=utf8;"; var cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); sql = @"create table if not exists cards( cid int unsigned auto_increment, name varchar(20) not null, company varchar(20), class varchar(20) not null, password varchar(20) not null, primary key(cid) ) default CHARSET=utf8;"; cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); sql = @"create table if not exists records( rid int unsigned auto_increment, cid int unsigned not null, bid int unsigned not null, borrow date, back date, primary key(rid), foreign key(cid) references cards(cid) on delete cascade , foreign key(bid) references books(bid) on delete cascade ) default CHARSET=utf8;"; cmd = new MySqlCommand(sql, conn); cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine(e); throw; } finally { conn.Close(); } return("Initialize Database"); }
public DatabaseService(ISqlService sqlService) { _connection = sqlService.GetConnection(); }
public Repository(ISqlService sqlService) { Connection = sqlService.GetConnection(); }