public bool delete(loaidto loai)
{
string delete = string.Format("delete from LOAI where MALOAI= @maloai");
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@maloai", SqlDbType.NVarChar, 15);
sqlParameters[0].Value = loai.Maloai;
return(conn.executeDeleteQuery(delete, sqlParameters));
}
public bool update(loaidto loai)
{
string update = string.Format("update LOAI SET TENLOAI = @tenloai WHERE MALOAI = @maloai");
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@tenloai", SqlDbType.NVarChar, 50);
sqlParameters[0].Value = Convert.ToString(loai.Tenloai);
sqlParameters[1] = new SqlParameter("@maloai", SqlDbType.NVarChar, 15);
sqlParameters[1].Value = Convert.ToString(loai.Maloai);
return(conn.executeUpdateQuery(update, sqlParameters));
}
public bool add(loaidto loai)
{
string insert = string.Format("insert into LOAI (MALOAI,TENLOAI) values (@maloai,@tenloai)");
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter("@maloai", SqlDbType.NVarChar, 15);
sqlParameters[0].Value = Convert.ToString(loai.Maloai);
sqlParameters[1] = new SqlParameter("@tenloai", SqlDbType.NVarChar, 50);
sqlParameters[1].Value = Convert.ToString(loai.Tenloai);
return(conn.executeInsertQuery(insert, sqlParameters));
}
public bool delete(loaidto loai)
{
return(ld.delete(loai));
}
public bool update(loaidto loai)
{
return(ld.update(loai));
}
public bool add(loaidto loai)
{
return(ld.add(loai));
}
